cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

ERROR - JDBC Connector to connect to DB2 on iSeries (AS400)

andre_mangatal
New Contributor

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

4 REPLIES 4

Schevus
New Contributor III

Can you share your account configuration screen?

blank testing

Schevus
New Contributor III

Looks like you have not populated a username?

I left out the user name when I posted it here.