Postgres problem, could not resolve uncommited transactions.
jbrosenberg May 30, 2003 2:39 PMOk,
I'm getting thsi now when trying to startup with jms....It was all working ok against Oracle, but something is wrong with Postgres config....
On Oracle, it automatically created the tables
it needs, but on postgres that isn't happening,
and so it looks like it's trying to read tables that
haven't been created yet....Ideas?
I have 2 identical db's on the same postgres
server....One for ejb's and one for jms...
The ejb's deploy and talk to the db just fine...
But jms fails to initialize....
I've determined a have Postgres version 7.2.1...
I wonder if I have some sort of driver mismatch?
Or do I need to have a custom Postgres setting
for the SqlProperties in jbossmq-service.xml, like
I needed for Oracle (which was undocumented, only found out about it via this forum)....I have the advanced documentation, but jms config info is very light.....
14:21:45,502 INFO [TxConnectionManager] Started
14:21:45,522 INFO [JMSProviderLoader] Starting
14:21:45,552 INFO [JMSProviderLoader] Bound adapter to java:/DefaultJMSProvider
14:21:45,552 INFO [JMSProviderLoader] Started
14:21:45,552 INFO [ServerSessionPoolLoader] Starting
14:21:45,562 INFO [ServerSessionPoolLoader] pool factory StdJMSPool bound to java:/StdJMSPool
14:21:45,562 INFO [ServerSessionPoolLoader] Started
14:21:45,632 INFO [MessageCache] Starting
14:21:45,632 INFO [MessageCache] Started
14:21:45,632 INFO [PersistenceManager] Starting
14:21:45,752 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping
14:21:45,762 ERROR [PersistenceManager] Starting failed
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (No resu
lts were returned by the query.)
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.GeneratedMethodAccessor33.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)