java.sql.SQLException: Invalid state, the Connection object is closed.

Anonymous — Sat, 16 Nov 2024 13:06:07 GMT

Hello,
I have a job which runs absolutely fine when run from TOS. However, when I export and run the batch job I generally see this exception being thrown.
I have looked through the forums and seen a few people having reported this issue, but I am not sure why it works fine from TOS, but not when running the exported code.
Does anyone have any suggestions as to what might cause this ?
Environment is:
Windows XP(64 bit)
MS Sql Server 2008 (Express)
It seems to be related to the size of the xml file being parsed. The export job works fine when tMSSqlOutput_2 is processing < 2000 rows, but not when handling 12,000 rows.
Any help appreciated. Thanks.
The screen shot shows the result of running from TOS

C:\xmlPosition_0.1\xmlPosition>xmlPosition_run
C:\xmlPosition_0.1\xmlPosition>C:
C:\xmlPosition_0.1\xmlPosition>cd C:\xmlPosition_0.1\xmlPosition\
C:\xmlPosition_0.1\xmlPosition>java -Xms256M -Xmx1024M -cp classpath.jar; dwh.xm
lposition_0_1.xmlPosition --context=dev
I/O Error: Connection reset by peer: socket write error
Exception in component tMSSqlOutput_2
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:452)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:727
)
at net.sourceforge.jtds.jdbc.JtdsStatement.initialize(JtdsStatement.java
:645)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:908)
at dwh.xmlposition_0_1.xmlPosition.tFileInputXML_4Process(xmlPosition.ja
va:23012)
at dwh.xmlposition_0_1.xmlPosition.tFileInputXML_5Process(xmlPosition.ja
va:14246)
at dwh.xmlposition_0_1.xmlPosition.tFileInputXML_2Process(xmlPosition.ja
va:7318)
at dwh.xmlposition_0_1.xmlPosition.tFixedFlowInput_1Process(xmlPosition.
java:2502)
at dwh.xmlposition_0_1.xmlPosition.tMSSqlConnection_1Process(xmlPosition
.java:682)
at dwh.xmlposition_0_1.xmlPosition.runJobInTOS(xmlPosition.java:24148)
at dwh.xmlposition_0_1.xmlPosition.main(xmlPosition.java:23916)
C:\xmlPosition_0.1\xmlPosition>

Re: java.sql.SQLException: Invalid state, the Connection object is closed.

Anonymous — Thu, 10 Feb 2011 14:36:38 GMT

Can you try with lesser number of rows?

topic Re: java.sql.SQLException: Invalid state, the Connection object is closed. in Talend Studio

java.sql.SQLException: Invalid state, the Connection object is closed.

Re: java.sql.SQLException: Invalid state, the Connection object is closed.