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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Invalid state, the statement object is closed

Hi,

 

I am running my Talend job since 2 years on monthly basis but suddenly from last week I started getting exception saying java.sql.SQLException: Invalid state, the statement object is closed. last month it worked absolutely fine but this month it failed and it keeps failing. I don't understand, what could be the reason. Though I have tried to increase and decrease the batch size also it failing.

 

my initial batch was 10000 till date laster I did batch size 1000 and 100 still it is failing.

you can find the screenshot of design from below picture where it is failing. kindly suggest  snapshot design.JPG

Labels (4)
0 Replies