java.sql.SQLException: Invalid state, the Connection object is closed.
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>