java.sql.SQLException after a tFlowToIterate

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.
4 REPLIES
One Star

Re: java.sql.SQLException after a tFlowToIterate

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

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.
One Star

Re: java.sql.SQLException after a tFlowToIterate

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

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