Could not resolve uncommited transactions
surajmundada Sep 24, 2004 6:16 AMHi,
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