0 Replies Latest reply on Sep 24, 2004 6:16 AM by surajmundada

    Could not resolve uncommited transactions

    surajmundada Newbie

      Hi,

      I am using JBoss_3.2.0_Tomcat_4.1.24 with Postgres 7.3.2.

      Earlier it would run fine. But after adding some new JAR and WAR components to my EAR file, I am getting following error:

      00:27:07,722 INFO [PersistenceManager] Starting
      00:27:13,926 ERROR [PersistenceManager] Starting failed
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Connection is broken: Connection refused); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Connection is broken: Connection refused)))
       at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:276)
       at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1299)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
       at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
       at $Proxy11.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:392)
       at org.jboss.system.ServiceController.start(ServiceController.java:408)
       at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
       at $Proxy5.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:824)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
       at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)
      


      Before this, JBoss is also throwing following log statemensts:

      00:26:06,203 INFO [MainDeployer] Starting deployment of package: file:/opt/jboss-3.2.1_tomcat-4.1.24/server/default/deploy/jmx-console.war/
      00:26:06,462 INFO [STDOUT] Server.run/init: java.sql.SQLException: Unexpected token: Unexpected token: in statement [CONNECT ]
      00:26:06,463 ERROR [STDERR] java.sql.SQLException: Unexpected token: Unexpected token: in statement [CONNECT ]
      00:26:06,465 ERROR [STDERR] at org.hsqldb.Trace.getError(Unknown Source)
      00:26:06,465 ERROR [STDERR] at org.hsqldb.Log.runScript(Unknown Source)
      00:26:06,465 ERROR [STDERR] at org.hsqldb.Log.open(Unknown Source)
      00:26:06,466 ERROR [STDERR] at org.hsqldb.Database$Logger.openLog(Unknown Source)
      00:26:06,466 ERROR [STDERR] at org.hsqldb.Database.open(Unknown Source)
      00:26:06,467 ERROR [STDERR] at org.hsqldb.Database.<init>(Unknown Source)
      00:26:06,467 ERROR [STDERR] at org.hsqldb.Server.openDB(Unknown Source)
      00:26:06,467 ERROR [STDERR] at org.hsqldb.Server.run(Unknown Source)
      00:26:06,468 ERROR [STDERR] at org.hsqldb.Server.main(Unknown Source)
      00:26:06,469 ERROR [STDERR] at org.jboss.jdbc.HypersonicDatabase$2.run(HypersonicDatabase.java:250)
      00:26:06,769 INFO [EmbeddedCatalinaService41] deploy, ctxPath=/jmx-console, warUrl=file:/opt/jboss-3.2.1_tomcat-4.1.24/server/default/deploy/jmx-console.war/
      


      My standardjbosscmp-jdbc.xml file shows following:

      <defaults>
       <datasource>java:/DefaultDS</datasource>
       <datasource-mapping>Hypersonic SQL</datasource-mapping>
      
       <create-table>true</create-table>
      

      and standardjaws.xml shows following:

      <jaws>
       <datasource>java:/DefaultDS</datasource>
       <type-mapping>Hypersonic SQL</type-mapping>
       <debug>false</debug>
      


      According to some links on forums, changing this to mapping java:DefaultDS to PostgresSQL should solve the problem. But my JBoss was running perfectly before deploying some additions to already existing EAR.

      In new additions, I am using many new stored procedures. Does that anything to do with this ?

      Regards,

      Suraj