Unable to use db2 jdbc in Linux

One Star

Unable to use db2 jdbc in Linux

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

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.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=Column6, DRIVER=3.68.61

at com.ibm.db2.jcc.am.gd.a(gd.java:749)

at com.ibm.db2.jcc.am.gd.a(gd.java:66)

at com.ibm.db2.jcc.am.gd.a(gd.java:135)

at com.ibm.db2.jcc.am.uo.c(uo.java:2780)

at com.ibm.db2.jcc.am.uo.d(uo.java:2768)

at com.ibm.db2.jcc.am.uo.a(uo.java:2217)

at com.ibm.db2.jcc.am.vo.a(vo.java:7441)

at com.ibm.db2.jcc.t4.bb.h(bb.java:141)

at com.ibm.db2.jcc.t4.bb.b(bb.java:41)

at com.ibm.db2.jcc.t4.p.a(p.java:32)

at com.ibm.db2.jcc.t4.vb.i(vb.java:145)

at com.ibm.db2.jcc.am.uo.ib(uo.java:2186)

at com.ibm.db2.jcc.am.vo.uc(vo.java:3576)

at com.ibm.db2.jcc.am.vo.Ac(vo.java:3708)

at com.ibm.db2.jcc.am.vo.e(vo.java:881)

at com.ibm.db2.jcc.am.vo.setNull(vo.java:805)

at g.ddd_0_1.ddd.tFileInputDelimited_1Process(ddd.java:2573)

at g.ddd_0_1.ddd.runJobInTOS(ddd.java:3063)

at g.ddd_0_1.ddd.main(ddd.java:2921)


Job ddd ended at 23:01 07/12/2014.
Four Stars

Re: Unable to use db2 jdbc in Linux

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
One Star

Re: Unable to use db2 jdbc in Linux

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.