scottklement.com

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,

We got it working. I have a solution that I will be posting here later today/tomorrow.

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.