AS400 Connection error - missing libraries

_AnonymousUser — Wed, 20 Aug 2014 04:55:16 GMT

Hello -I'm trying to connect to an AS400 database but I'm running into the following error (using TOS 5.3.1):
connecting to socket on port 3550
connected
Exception in component tAS400Connection_1
java.sql.SQLException: library(s) not added to the library list.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at com.ibm.as400.access.AS400JDBCConnection.setServerAttributes(AS400JDBCConnection.java:4031)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3273)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3160)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3153)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1360)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1211)
at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:352)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at billsletters.as400test_0_1.as400test.tAS400Connection_1Process(as400test.java:286)
at billsletters.as400test_0_1.as400test.runJobInTOS(as400test.java:517)
disconnected
at billsletters.as400test_0_1.as400test.main(as400test.java:383)
Job as400test ended at 23:28 19/08/2014.
I'm currently installing all missing modules (jars) into my instance of Talend. But I'd like to know if I should expect to have this resolved by downloading these jars - or would I have to resort to some 3rd party jar like JT400?
Thank you

Re: AS400 Connection error - missing libraries

Anonymous — Thu, 21 Aug 2014 16:24:37 GMT

Are you sure about the number of necessary libraries and they can all freely be downloaded? Hard to belief!

Re: AS400 Connection error - missing libraries

Anonymous — Fri, 22 Aug 2014 09:49:21 GMT

Hi B Cole,
Are you able to connect to AS400 database successfully without using Talend tool?
Best regards
Sabrina

topic Re: AS400 Connection error - missing libraries in Talend Studio

AS400 Connection error - missing libraries

Re: AS400 Connection error - missing libraries

Re: AS400 Connection error - missing libraries