Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

Many to Many Multiply values by ae_kel29
tMomInput & JMS selector? by rhuiser
Discover Talend's new v5.3 big data developer tools on May, 29 2013 by pcoffre
Talend MDM Server log messages by erop
tNetezzaInput [...] by Davy.Huijgens
LDAP timeout? by fvalentim
General question about jobservers and runtimes ... by rbadev

Index
» Usage, Operation
» java.sql.SQLException after a tFlowToIterate

Post a reply

Write your message and submit

Name

E-mail

Message

[quote=bdunand_at_sopra]Hello,

I get a java.sql.SQLException in this simple job, after 2 minutes execution:
[quote]30924-18412260-47|0412271538448132|030924-17232804-69|Tue Apr 01 00:00:00 CEST 1997|Fri Dec 31 00:00:00 CET 2004|2F2AE994384D4D22BC2466E3988410B3|
[color=red]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)[/color]
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|

[color=red]	at developpement.yyyy_0_1.yyyy.main(yyyy.java:2420)[/color]
Job yyyy ended at 11:14 17/04/2009. [exit code=1][/quote]
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.[/quote]

Options

Never show smilies as icons for this post

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

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.

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

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:26:44

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.

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Board footer