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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MZein
Contributor III
Contributor III

tOracleRow

Hi friend

I hope I can find a solution to this persistance error.

I am using tOracleRow component with sql query and it throw the following excepion

java.sql.SQLRecoverableException: Closed Connection

why this exception and how to resolve it 

Best regards 

Labels (2)
3 Replies
Anonymous
Not applicable

This could either be a timeout issue, a firewall issue or maybe a connection pool issue (are you using a connection pool?). What exactly are you doing with the tOracleRow component? Are you selecting, inserting or updating? Has this ever worked? How long did it take (if it has worked)? Have you tried adding an extended timeout to the additional settings?

MZein
Contributor III
Contributor III
Author

Hi rhall_2

Thank you very much for your replay and I highly appreciate your interaction. I found the error. It is raised because i use tConnection component and I did some processing (read from csv file check data ) then I use the component tOracleRow. but When I use tconnection then tOracleRow the job run smoothly without error

Regards

Anonymous
Not applicable

Hmmm this sounds like it could be a DB timeout issue. Moving when you open the connection looks like it is giving you a window of time to complete your CSV read before starting your DB access. Interesting.