Java Type 4 connection gets Syntax error

Products

• Datacom
• DATACOM - AD

Issue/Introduction

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

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

Resolution

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

    It is recommended to install the latest available PTF .