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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849409#3849409 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849409 ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
