Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to use db2 jdbc in Linux

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.
Labels (4)
2 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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.

0683p000009MBnv.png