The checkSQL target fails for Oracle 12c and Java 1.8

 

 

                 Merative ™ Social Program Management is now Cúram ™ by  Merative™

 

 

Merative™ Social Program Management 'checkSQL' target fails for Oracle 12c and Java 1.8

 

 

Question & Answer

 

 

Question

 

Why do I see an error when I execute the 'checkSQL' target against an Oracle 12c database using Java 1.8 with Merative Social Program Management?

 

 

Cause

 

This error is caused because the Oracle 12c database driver does not support Java 1.8.

 

Error details:

ERROR: Exception in thread "main" java.lang.NoClassDefFoundError: sun/io/CharToByteConverter [sqlcheck] at sqlj.util.io.OracleOutputStreamWriter.<init>(OracleOutputStreamWriter.java:82) [sqlcheck] at sqlj.util.io.OracleOutputStreamWriter.<init>(OracleOutputStreamWriter.java:52) [sqlcheck] at sqlj.tools.Sqlj.initializeErrors(Sqlj.java:922) …......[sqlcheck] [sqlcheck] [sqlcheck] Exception in thread "main" java.lang.RuntimeException: ERROR: Please correct the above errors and re-run. [sqlcheck] at curam.util.tools.sqlcheck.SQLCheck.handleError(SQLCheck.java:222) [sqlcheck] at curam.util.tools.sqlcheck.SQLCheck.main(SQLCheck.java:209)

 

 

Answer

 

The problem is related to the Oracle 12c database driver (translator.jar) which is used by the 'checkSQL' target and currently does not support Java 1.8. The 'checkSQL' target continues to function against the Oracle 12c database driver using Java 1.6 and 1.7.

Document Information

 

More support for:
Merative Social Program Management

 

 

Software version:
7.0.0

 

 

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows, z/OS

 

 

Modified date:
17 June 2018