tMSSQLOutput issue

Anonymous — Sat, 16 Nov 2024 08:10:24 GMT

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!

Re: tMSSQLOutput issue

Anonymous — Thu, 31 May 2018 20:04:53 GMT

I figured this one out. Had a tMSSQLCommit that was closing the connection

topic tMSSQLOutput issue in Talend Studio

tMSSQLOutput issue

Re: tMSSQLOutput issue