topic Re: java.sql.SQLException after a tFlowToIterate in Talend Studio

java.sql.SQLException after a tFlowToIterate

Anonymous — Sat, 16 Nov 2024 13:59:26 GMT

Hello,
I get a java.sql.SQLException in this simple job, after 2 minutes execution:

30924-18412260-47|0412271538448132|030924-17232804-69|Tue Apr 01 00:00:00 CEST 1997|Fri Dec 31 00:00:00 CET 2004|2F2AE994384D4D22BC2466E3988410B3|
Exception in component tJDBCInput_2
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at developpement.yyyy_0_1.yyyy.tJDBCInput_1Process(yyyy.java:2072)
at developpement.yyyy_0_1.yyyy.tFileInputDelimited_1Process(yyyy.java:718)
at developpement.yyyy_0_1.yyyy.runJobInTOS(yyyy.java:2536)
030924-18412337-48|0309241841240612|030924-17232917-73|Tue Nov 01 00:00:00 CET 1983|Tue Sep 30 00:00:00 CEST 2003|2F2AE994384D4D22BC2466E3988410B3|
030924-18412414-49|0706151004558174|030924-17232942-74|Tue Sep 01 00:00:00 CEST 1987|Wed Aug 01 00:00:00 CEST 2007|2F2AE994384D4D22BC2466E3988410B3|
030924-18412485-50|0309241841255914|030924-17232970-75|Wed Nov 01 00:00:00 CET 1989|Wed Sep 30 00:00:00 CEST 2009|2F2AE994384D4D22BC2466E3988410B3|
at developpement.yyyy_0_1.yyyy.main(yyyy.java:2420)
Job yyyy ended at 11:14 17/04/2009.

This job is a little part of a bigger job.
My question is:
Is the error caused by a timeout on my database or something else?
Thanks
bdunand.

Re: java.sql.SQLException after a tFlowToIterate

youssef2 — Fri, 17 Apr 2009 10:34:30 GMT

Hi,
This exception means that your database is no more accessible (Server down, network problems...). try to reconnect to your database after having this exception and tell us waht happens.
Regards
Youssef

Re: java.sql.SQLException after a tFlowToIterate

Anonymous — Fri, 17 Apr 2009 10:40:02 GMT

I can run the job again and again, just after this error, it works.... for 2 minutes, and then, the same error.
If I don't use the tFlowToIterate (see the job below), I can read the table (it takes more than 2 minutes) without problems.

Re: java.sql.SQLException after a tFlowToIterate

youssef2 — Fri, 17 Apr 2009 10:43:54 GMT

Hi,
I think that you're creating a new connection in every iteration. Try using tJDBCConnection or tOracleConnection.
Regards,

Re: java.sql.SQLException after a tFlowToIterate

Anonymous — Fri, 17 Apr 2009 11:00:54 GMT

Thanks a lot.
I use a tJDBCConnection and I don't get the error anymore.
Regards,
bdunand.