0 Replies Latest reply on May 4, 2006 2:34 PM by Aaron Menchions

    Problems with jboss and DB2 UDB

    Aaron Menchions Newbie

      Sorry if this has been answered, but I couldn't find it using the search (feel free to direct me)

      We're using jboss 3.2.3 to run a jsp app that uses DB2/UDB as the database. Both Jboss and UDB are running on the same Unix box.

      We sometimes run into problems where JBoss just appears to "lose" the connection to the DB2 server, and we don't know why. We shut down our app in jboss and restart it, and that usually fixes the problem.

      I was wondering if anyone else has experienced this and what causes it?

      here's the error:

      006-05-04 08:57:50,274 DEBUG [ca.gc.cra.rhpl.psl] Request: /psl/login.jsp?null From: wh0eace517a.rc.gc.ca(7.28.168.155)
      2006-05-04 08:57:52,921 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection:
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019
      )
      
      followed by a bunch of "at" statements, then

      Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019
      


      Our database guy says nothing shows up on the DB2 logs, plus the fact that a reboot of jboss seems to cure the problem leads me to believe the problem is within Jboss.

      Anyone have any ideas?