Unanswered: SQLException: java.sql.Connection.close() requested while a transaction is in progres
I am trying to query (a SELECT) a dab3 database with JAVA JDBC API.
The select query works fine, but when i try to close the JDBC Connection that I opened processing Query, I get the above titled error.
The full stack trace is below:
com.ibm.db2.jcc.b.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.
Any one got an idea how to resolve this?
Thanks in advance,