Thread: Connection Excption
03-11-08, 01:38 #1Registered User
- Join Date
- Mar 2008
Unanswered: Connection Excption
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
sql code : -204 , sql state : 42704 , sql errmc B2 Admin.user_auth.
Error : Error while closing connection [ibm][db2][jcc] 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
03-11-08, 02:54 #2Registered User
- Join Date
- Jan 2007
- Jena, Germany
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.Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development