As400 connection problem

[Anonymous]

hi,
i have a problem with my AS400 connection, it is not possible to be connected with talend.
I use jt400 in other app (/ex ireport) and it's work fine but i get an SQL error with Talend.
it's SQL901 error, this mean that connection is done but not a correct "communication"
i don't know where i can found log for this error in my AS400.
i don't understand why it's working with ireport and not with talend.
i need help
thanks

[Anonymous]

Which version of AS400 you use ?
It seems there was some problems before with the version V5R3, but it was ok for the version V5R4.

[Anonymous]

it's a V5R3 version
is there a way to bypass the problem or am i obliged to migrate to V5R4 ?

[Anonymous]

In fact it seems there is a problem either in the V5R3 or in the jt400 driver with the V5R3 with the option "libraries". (this option should be the same it seems for R3 & R4 version)
To keep the compatiblity with the V5R3, we "must" remove the option "libraries" used in the connection or sql builder.
The problem is that if we do that, when you will list all the tables from the connection, it will list all the tables from all the libraries.
So instead of have for example 10 tables listed in the selected library, you will see maybe 500.. 1000 tables maybe (or far more depends your system), so of course it's not really convenient to select the table you want.
So either:
- We add a "flag" to be able to keep the compatibility with R3 version (remove the option libraries for connection/sqlbuilder).
- We "force" to use the R4 version. (difficult to know if there is the same problems in R2 or lower versions)
The problem you had is described here in fact: http://talendforge.org/bugs/view.php?id=1996
jsleeper had the same problem before, but after he changed to version R4 it works.

[Anonymous]

hi,
it's me again.
i'm now on V5R4, and i still have the same problem

[Anonymous]

up

[Anonymous]

RESOLVED
The problem is a bad SQL package on QGPL.
if you got the same error ask for your ibm support.

[_AnonymousUser]

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