Dear Techies,

For our project we are using 4 Database which includes oracle,SQLserver, MySQL and DB2. For getting connection we are using XML in which just has to be mention the url and class of any database, and for authorization purpose we are using JOSSO.

while conection the DB2 im getting the following exception

com.ibm.db2.jcc.c.sqlException
sql code : -204 , sql state : 42704 , sql errmc B2 Admin.user_auth.

Error : Error while closing connection [ibm][db2][jcc][10251][10308] java.sql.connection.Close() , requested while a transaction is in the progress on the connection , The transaction remains active , and the connection cannot be closed.


Plz reply ....

Thanks in advance

Regards,

Thangavel.L

SQLCODE -204 equates to message SQL0204, which says that a database object could not be found. In your case, the object "DB2 Admin.user_auth" could not be found. The object name is rather suspicious - do you know where this comes from?

Also, I it would be a good idea to collect a JDBC trace to figure out what exactly is going on under the covers between DB2 and your application. That should help you to track down the problem - or at least narrow it down.