AS400 Connection error - missing libraries

One Star

AS400 Connection error - missing libraries

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
Seventeen Stars

Re: AS400 Connection error - missing libraries

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

Re: AS400 Connection error - missing libraries

Hi B Cole,
Are you able to connect to AS400 database successfully without using Talend tool?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.