Hi
Im trying to import data from a CSV file to Db2. I have installed the jar files, and the Connection to db2 Works. But when I run the jobb I get an error bellow. Any tips on troubleshoting this? Im running DB2 10.5 FP4 on REHL 7
Br
Petter
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
Hi,
Can you show the job screenshot, it seems that the job is trying to close the connection before the completion of your data read-write operations. Do you have a connection close component, if it is there, move it to tPostJob-->tconnectionClose
Vaibhav
Hi
Thanks for reply, It's a verry easy job, just pull out data from a csv file and add it to a database. The database is empty, but I suppose the tabel will be created.