Problem with DB2 Database at receiver side

[Former Member]

Helo,

Can anybody help in solving this exception which i am getting at receiver side when i am using DB2 to store some data.

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.

Thanks,

Soorya

[Former Member]

Hi Surya,

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.

Regards,

Shibani

*P.S : Reward with points if helpful*