Java Type 4 connection gets Syntax error

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


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.




CA Datacom Server 14.0 using cadcjdbc.jar Driver Version:


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

    It is recommended to install the latest available PTF .