Hello,
We have been using your JDBCR4 open source for several years to connect to SQL Server/Database and everything works fine on V7R3 but when we try to run it on V7R4 we get the following:
Error: Java Runtime Environment (JRE) version 1.8 is not supported by this driver.
The driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
V7R3 installed: JAVA SE 7 32 and 64
V7R3 installed: JAVA SE 8 32 and 64
V7R4 installed: JAVA SE 8 32 and 64
We are wondering if there is a solution to getting JDBCR4 working on V7R4 with Java SE 8. Is there a different driver that we need to download or point to? Any help would be appreciated!
Thanks for your time,
V7R4 - JDBCR4 - JRE 1.8 is not supported by this driver
Re: V7R4 - JDBCR4 - JRE 1.8 is not supported by this driver
We got it working. I have a solution that I will be posting here later today/tomorrow.
Re: V7R4 - JDBCR4 - JRE 1.8 is not supported by this driver
This is how we got Scott Klement JDBC4 tool to work on V7R4.
1. Install the the following MS SQL JDBC driver in:
/QIBM/UserData/Java400/ext/mssql-jdbc-12.2.0.jre8.jar
2. Remove all of the old jdbc drivers from /QIBM/UserData/Java400/ext
Sqljdbc.jar
Sqljdbc4.jar
Sqljdbc42.jar
Jtds-1.3.1.jar
3. Set the CLASSPATH in your program CL.
ADDENVVAR VAR(CLASSPATH) VALUE(‘/QIBM/UserData/Java400/ext/mssql-jdbc-12.2.0.jre8.jar’)
REPLACE(*YES)
4. Include the following 3 parms on the SQL Server URL in your program.
;TrustServerCertificate=true;integratedSecurity=false;authenticationScheme=NTLM'
5. Restart your server and test.
1. Install the the following MS SQL JDBC driver in:
/QIBM/UserData/Java400/ext/mssql-jdbc-12.2.0.jre8.jar
2. Remove all of the old jdbc drivers from /QIBM/UserData/Java400/ext
Sqljdbc.jar
Sqljdbc4.jar
Sqljdbc42.jar
Jtds-1.3.1.jar
3. Set the CLASSPATH in your program CL.
ADDENVVAR VAR(CLASSPATH) VALUE(‘/QIBM/UserData/Java400/ext/mssql-jdbc-12.2.0.jre8.jar’)
REPLACE(*YES)
4. Include the following 3 parms on the SQL Server URL in your program.
;TrustServerCertificate=true;integratedSecurity=false;authenticationScheme=NTLM'
5. Restart your server and test.