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