Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (4)
4 Replies
youssef2
Contributor
Contributor

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
Anonymous
Not applicable
Author

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

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

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