Talend community forum / java.sql.SQLException after a tFlowToIterate

bdunand_at_sopra · 2009-04-17 11:26:44

Tags: [connection, exception, 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. [exit code=1]

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.

Uploaded Images

Last edited by bdunand_at_sopra (2009-04-17 11:27:31)

youssef · 2009-04-17 11:34:30

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

bdunand_at_sopra · 2009-04-17 11:40:02

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.

Uploaded Images

youssef · 2009-04-17 11:43:54

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

Regards,

bdunand_at_sopra · 2009-04-17 12:00:54

Thanks a lot.

I use a tJDBCConnection and I don't get the error anymore.

Regards,
bdunand.

Uploaded Images

Last edited by bdunand_at_sopra (2009-04-17 12:01:19)

Announcement

Unanswered posts

#1 2009-04-17 11:26:44

java.sql.SQLException after a tFlowToIterate

#2 2009-04-17 11:34:30

Re: java.sql.SQLException after a tFlowToIterate

#3 2009-04-17 11:40:02

Re: java.sql.SQLException after a tFlowToIterate

#4 2009-04-17 11:43:54

Re: java.sql.SQLException after a tFlowToIterate

#5 2009-04-17 12:00:54

Re: java.sql.SQLException after a tFlowToIterate

Board footer