2 Replies Latest reply on Mar 21, 2004 10:27 PM by arbalu

Getting message on JBoss4.0.0 : Could not resolve uncommited

arbalu Mar 19, 2004 12:14 AM

Hi,
I m getting this message while i configure my database to ms-sql server 2000. I have included the mssql-ds.xml file in the deploy directory of my jboss installation and I am using Sprinta200 as my database driver. Is there anything i m missing here to be configured.... any one help me out of this...

a glimpse of the error message i got on the server is below....

2004-03-19 10:07:39,609 WARN [org.jboss.system.ServiceController] Problem starting service jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: [PEGASUS]Invalid object name 'JMS_MESSAGES'.)
 at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:267)
 at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1235)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:233)
 at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1036)
 at $Proxy13.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:401)
 at org.jboss.system.ServiceController.start(ServiceController.java:426)
 at org.jboss.system.ServiceController.start(ServiceController.java:426)
 at org.jboss.system.ServiceController.start(ServiceController.java:426)
 at org.jboss.system.ServiceController.start(ServiceController.java:426)
 at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172)
 at $Proxy6.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:224)
 at org.jboss.deployment.DeploymentInfo.start(DeploymentInfo.java:254)
 at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1036)
 at $Proxy13.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:401)
 at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:798)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:594)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:558)
 at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172)
 at $Proxy9.deploy(Unknown Source)
 at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
 at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:529)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:200)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:273)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:233)
 at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1036)
 at $Proxy1.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:401)
 at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172)
 at $Proxy6.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:224)
 at org.jboss.deployment.DeploymentInfo.start(DeploymentInfo.java:254)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1036)
 at $Proxy1.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:401)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:798)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:594)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:558)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:542)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:45)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:70)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:155)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:544)
 at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:172)
 at $Proxy7.deploy(Unknown Source)
 at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:330)
 at org.jboss.system.server.ServerImpl.start(ServerImpl.java:238)
 at org.jboss.Main.boot(Main.java:165)
 at org.jboss.Main$1.run(Main.java:403)
 at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: [PEGASUS]Invalid object name 'JMS_MESSAGES'.
 at com.inet.tds.e.a(Unknown Source)
 at com.inet.tds.b.do(Unknown Source)
 at com.inet.tds.b.executeUpdate(Unknown Source)
 at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:308)
 at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:240)
 ... 130 more

1. Re: Getting message on JBoss4.0.0 : Could not resolve uncomm

darranl Mar 19, 2004 5:17 AM (in response to arbalu)

Are you trying to replace the DefaultDS with your MS SQL Server configuration or are you setting up a datasource in addition to the DefaultDS datasource?
Actions

2. Re: Getting message on JBoss4.0.0 : Could not resolve uncomm

arbalu Mar 21, 2004 10:27 PM (in response to arbalu)

I am replacing the DefaultDS with my MSSqlServer configuration. My mssql-ds.xml looks something like this

<datasources>
 <local-tx-datasource>
 <jndi-name>SQLServerPool</jndi-name>
 <connection-url>jdbc:inetdae7://localhost:1433?database=latest_release</connection-url>
 <driver-class>com.inet.tds.TdsDriver</driver-class>
 <user-name>test</user-name>
 <password>test</password>
 <!-- sql to call when connection is created
 <new-connection-sql>some arbitrary sql</new-connection-sql>
 -->

 <!-- sql to call on an existing pooled connection when it is obtained from pool
 <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
 -->

 </local-tx-datasource>

</datasources>

hav i got to do anything with any other files so that i shall put them in par with this file????
I think i m missing something very small here... please lemme know...

Thanx,
balu.

Go to original post