Hello All,
I am using Talend 5.6
I have a scenario where I read an input file, transform with tMap then load a work table. Every time the load should truncate then load the table.
I am choosing the Action on Table as "Truncate Table/Clear Table"
And action on Data as "Insert"
When there is row job runs fine. When there is no data in the input file that is 0 record, my job is failing.
When I choose Action on Table as "Default" same job is running fine. But issue is I have to delete the work table before I load the data. Could you please suggest what to do?
Error Message
===========
connecting to socket on port 3391
connected
failed to close the connection in tDB2Output_1 : java.sql.Connection.close() requested while a transaction is in progress on the connection.
The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
Exception in component tDB2Output_1
com.ibm.db2.jcc.am.SqlException: java.sql.Connection.close() requested while a transaction is in progress on the connection.
The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
at com.ibm.db2.jcc.am.fd.a(fd.java:663)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:120)
at com.ibm.db2.jcc.am.ib.u(ib.java:1293)
at com.ibm.db2.jcc.am.ib.x(ib.java:1315)
at com.ibm.db2.jcc.am.ib.v(ib.java:1301)
at com.ibm.db2.jcc.am.ib.close(ib.java:1283)
at myproj.tblld_test_0_1.tblld_test.tFileInputDelimited_1Process(tblld_test.java:2979)
at myproj.tblld_test_0_1.tblld_test.runJobInTOS(tblld_test.java:3461)
at myproj.tblld_test_0_1.tblld_test.main(tblld_test.java:3198)
disconnected
Job tblld_test ended at 14:44 08/07/2015.
