Java Type 4 connection gets Syntax error

Document ID : KB000046177
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: 

CA Datacom Server JAVA TYPE 4 connection is not working.

The execution fails with

java.sql.SQLException: ca.datacom.db.DBSQLException: ca.datacom.db.DBSQLException: BAD SYNTAX: <àá> in Session(Exception executeImmediate)in Query(prepare)

at ca.datacom.jdbc.DatacomJdbcObject.getSQLException(Unknown Source)

Datacom Server trace shows that the input stream is not being translated to EBCDIC from ASCII.

 

Environment:  

Windows

CA Datacom Server 14.0 using cadcjdbc.jar Driver Version: 14.0.0.18

Resolution:

1. At a minimum , use cadcjdbc.jar Version : 14.0.0.24 delivered via RO77711.

    It is recommended to install the latest available PTF .