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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download