Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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
Labels (4)
2 Replies
Anonymous
Not applicable

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

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