tMSSqlSP_1 - Invalid state, the CallableStatement object is closed

Anonymous — Tue, 04 Apr 2017 22:47:49 GMT

Hi,
I have a tMSSqlSP job setup properly and all 5 records display in tLogRow perfectly. When I changed the output to tMSSqlOutput, it only inserted 1 record and give me the following errors:
Exception in component tMSSqlSP_1
java.sql.SQLException: Invalid state, the CallableStatement object is closed.
      at net.sourceforge.jtds.jdbc.JtdsCallableStatement.checkOpen(JtdsCallableStatement.java:137)
      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.setString(JtdsPreparedStatement.java:933)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.tJavaFlex_1Process(bright_append_parcel_040417.java:35458)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.tLibraryLoad_1Process(bright_append_parcel_040417.java:42513)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.tMSSqlConnection_2Process(bright_append_parcel_040417.java:42728)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.runJobInTOS(bright_append_parcel_040417.java:48879)
[FATAL]: bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417 - tMSSqlSP_1 Invalid state, the CallableStatement object is closed.
[statistics] disconnected
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.main(bright_append_parcel_040417.java:48646)
Job bright_append_parcel_040417 ended at 16:00 04/04/2017. [exit code=1]

Can someone please explain what are the errors referring to?
Thanks
Andy

Re: tMSSqlSP_1 - Invalid state, the CallableStatement object is closed

Anonymous — Wed, 05 Apr 2017 17:05:06 GMT

Maybe someone can help me figure out if this is the correct setting in sp? it's related to my previous post.

Re: tMSSqlSP_1 - Invalid state, the CallableStatement object is closed

vapukov — Wed, 05 Apr 2017 21:49:36 GMT

You can use walk around way
tFixedFlowInput -> tFlowToIterate -> tMSSQLInput (and exec sp_ as SQL query with parameters from variables)
it will work

topic Re: tMSSqlSP_1 - Invalid state, the CallableStatement object is closed in Talend Studio

tMSSqlSP_1 - Invalid state, the CallableStatement object is closed

Re: tMSSqlSP_1 - Invalid state, the CallableStatement object is closed

Re: tMSSqlSP_1 - Invalid state, the CallableStatement object is closed