Unable to use db2 jdbc in Linux

Anonymous — Sat, 16 Nov 2024 11:23:45 GMT

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

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)

disconnected

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

Re: Unable to use db2 jdbc in Linux

Anonymous — Mon, 08 Dec 2014 05:21:16 GMT

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

Re: Unable to use db2 jdbc in Linux

Anonymous — Tue, 09 Dec 2014 17:53:22 GMT

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.

topic Re: Unable to use db2 jdbc in Linux in Talend Studio

Unable to use db2 jdbc in Linux

Re: Unable to use db2 jdbc in Linux

Re: Unable to use db2 jdbc in Linux