Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Connection Excption

    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
    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



  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts