Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a very simple job that is attempting to load a csv file into a SQL Server table. There is a tFilterow component between the tfileInputDelimited and the tMSSQLOutput components. When executing the job, I receive the following error:
xception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the PreparedStatement object is closed.
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.checkOpen(JtdsPreparedStatement.java:406)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.getParameter(JtdsPreparedStatement.java:558)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:630)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setInt(JtdsPreparedStatement.java:808)
at voyager.sqlservertest_0_1.SQLServerTest.tFileInputDelimited_1Process(SQLServerTest.java:3396)
at voyager.sqlservertest_0_1.SQLServerTest.tMSSqlConnection_1Process(SQLServerTest.java:2184)
at voyager.sqlservertest_0_1.SQLServerTest.runJobInTOS(SQLServerTest.java:7052)
at voyager.sqlservertest_0_1.SQLServerTest.main(SQLServerTest.java:6592)
The connection object for SQL Server appears fine and I am able to insert rows into this table via command line. Thank you!
I figured this one out. Had a tMSSQLCommit that was closing the connection
I figured this one out. Had a tMSSQLCommit that was closing the connection