Problem with the input file format to be stored in database

[Former Member]

Hi,

I am facing some problem with the input format. I am using the table name as data.employee. But i could not able to process the message forward. I am getting this error,

com.ibm.db2.jcc.c.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.

Can you please help me prposing a solution for this format.

Thanks,

SOorya

[Former Member · Accepted solution]

Hi,

According to me its not the problem of not supporting data format. It is because of Connection problem with Database. You have to handle transaction properly. You are closing connection before the transaction.

Thanks,

RamuV

[Former Member · Accepted solution]

Hi Ramu,

We went deeper into the traces of jdbc and anlysed that some code in JDBC receiver side causing this problem.

Its not taking the schema name into consideration. rather than it is taking it as null

So can you please concentrate on this way?

Thanks,

Soorya

[Former Member · Accepted solution]

I think you are missing out the COMMIT operation.

At the DB2 end before closing the connection if you do a 'COMMIT' then this may remove your error.

i.e. after you close the Resultset>close the statement object> perform 'COMMIT' operation--> then close the connection.

Also refer :-

http://www.dbforums.com/archive/index.php/t-976407.html

http://www.dbforums.com/showthread.php?t=1628183

I hope this will help you.

Thanks,

Vijaya