andre_mangatal
7 years agoNew Contributor
ERROR - JDBC Connector to connect to DB2 on iSeries (AS400)
High Priority
Good day SnapLogic Community
I am trying to connect to DB2 on an iSeries(AS400) using JDBC but I am getting the following error,
Failed to validate account: Failed to retrieve a database connection. Cause: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>. (Reason: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>.; Resolution: Please address the reported issue.)
It worked before but is not working now even though i made no changes to the pipeline. I am using the class “com.ibm.as400.access.AS400JDBCDriver” in the jt400-6.4.jar file which I am referencing.
Thank you very much in advance for your help!
Regards
Andre