1 Reply Latest reply on Nov 6, 2002 11:33 AM by john ware

    Can't get connection jboss-3.0.2 mysql  3.23.53

    john ware Newbie

      Hi all,

      When my BMP entity bean calls .getConnection() I get the following exception(see below). My datasource is bound ok( apparently ).

      thanks for your time,
      john ware






      2002-11-05 16:11:41,883 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=jware//15, BranchQual=] errorCode=XA_UNKNOWN(0)

      javax.transaction.xa.XAException: Error trying to start local tx: javax.resource.ResourceException: SQLException

      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:688)

      at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1013)

      at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:569)

      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:415)

      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:313)

      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:602)

      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:892)

      at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:102)

      at org.jdware.shuttle.ejb.entity.ShuttleBean.getConnection(ShuttleBean.java:313)

      at org.jdware.shuttle.ejb.entity.ShuttleBean.selectAll(ShuttleBean.java:197)

      at org.jdware.shuttle.ejb.entity.ShuttleBean.ejbFindAll(ShuttleBean.java:158)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:28)

      at java.lang.reflect.Method.invoke(Method.java:313)

      at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:637)

      at org.jboss.ejb.plugins.BMPPersistenceManager.findEntities(BMPPersistenceManager.java:340)

      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:323)

      at org.jboss.ejb.EntityContainer.find(EntityContainer.java:655)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:28)

      at java.lang.reflect.Method.invoke(Method.java:313)

      at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1048)

      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:209)

      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)

      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:88)

      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)

      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)

      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:112)

      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:184)

      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:58)

      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)

      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:131)

      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:125)

      at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:475)

      at org.jboss.ejb.Container.invoke(Container.java:692)

      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1023)

      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)

      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)

      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)

      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)

      at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175)

      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)

      at $Proxy38.findAll(Unknown Source)

      at org.jdware.shuttle.servlets.ShuttleAdminServlet.doGet(ShuttleAdminServlet.java:148)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:362)

      at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:284)

      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:565)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)

      at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:544)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1614)

      at org.mortbay.http.HttpServer.service(HttpServer.java:875)

      at org.jboss.jetty.Jetty.service(Jetty.java:531)

      at org.mortbay.http.HttpConnection.service(HttpConnection.java:785)

      at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:935)

      at org.mortbay.http.HttpConnection.handle(HttpConnection.java:802)

      at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:200)

      at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:294)

      at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)

      at java.lang.Thread.run(Thread.java:539)

      2002-11-05 16:11:41,923 INFO [org.jboss.resource.connectionmanager.LocalTxConnectionManager] Could not enlist in transaction on entering meta-aware object!

      javax.transaction.SystemException: enlistResource failed

      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:428)

      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:313)

      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:602)

      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:892)

      at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:102)

      at org.jdware.shuttle.ejb.entity.ShuttleBean.getConnection(ShuttleBean.java:313)

      at org.jdware.shuttle.ejb.entity.ShuttleBean.selectAll(ShuttleBean.java:197)

      at org.jdware.shuttle.ejb.entity.ShuttleBean.ejbFindAll(ShuttleBean.java:158)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:28)

      at java.lang.reflect.Method.invoke(Method.java:313)

      at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:637)

      at org.jboss.ejb.plugins.BMPPersistenceManager.findEntities(BMPPersistenceManager.java:340)

      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:323)

      at org.jboss.ejb.EntityContainer.find(EntityContainer.java:655)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:28)

      at java.lang.reflect.Method.invoke(Method.java:313)

      at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1048)

      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:209)

      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)

      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:88)

      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)

      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)

      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:112)

      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:184)

      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:58)

      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)

      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:131)

      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:125)

      at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:475)

      at org.jboss.ejb.Container.invoke(Container.java:692)

      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1023)

      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)

      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)

      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)

      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)

      at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175)

      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)

      at $Proxy38.findAll(Unknown Source)

      at org.jdware.shuttle.servlets.ShuttleAdminServlet.doGet(ShuttleAdminServlet.java:148)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:362)

      at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:284)

      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:565)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)

      at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:544)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1614)

      at org.mortbay.http.HttpServer.service(HttpServer.java:875)

      at org.jboss.jetty.Jetty.service(Jetty.java:531)

      at org.mortbay.http.HttpConnection.service(HttpConnection.java:785)

      at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:935)

      at org.mortbay.http.HttpConnection.handle(HttpConnection.java:802)

      at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:200)

      at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:294)

      at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)

      at java.lang.Thread.run(Thread.java:539)

      2002-11-05 16:11:41,933 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true

      2002-11-05 16:11:41,933 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false

      2002-11-05 16:11:41,933 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true

      2002-11-05 16:11:41,933 INFO [STDOUT] selectAll.1.1
      org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed; - nested throwable: (javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed)

      2002-11-05 16:11:41,933 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=jware//15, BranchQual=] errorCode=XA_UNKNOWN(0)

      javax.transaction.xa.XAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=jware//15, BranchQual=1]

      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:813)

      at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1432)

      at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:407)

      at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:300)

      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:194)

      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:58)

      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)

      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:131)

      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:125)

      at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:475)

      at org.jboss.ejb.Container.invoke(Container.java:692)

      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1023)

      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)

      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)

      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)

      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)

      at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175)

      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)

      at $Proxy38.findAll(Unknown Source)

      at org.jdware.shuttle.servlets.ShuttleAdminServlet.doGet(ShuttleAdminServlet.java:148)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:362)

      at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:284)

      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:565)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)

      at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:544)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1614)

      at org.mortbay.http.HttpServer.service(HttpServer.java:875)

      at org.jboss.jetty.Jetty.service(Jetty.java:531)

      at org.mortbay.http.HttpConnection.service(HttpConnection.java:785)

      at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:935)

      at org.mortbay.http.HttpConnection.handle(HttpConnection.java:802)

      at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:200)

      at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:294)

      at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)

      at java.lang.Thread.run(Thread.java:539)

      2002-11-05 16:11:41,943 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException, causedBy:

      java.lang.NullPointerException

      at org.jdware.shuttle.ejb.entity.ShuttleBean.ejbFindAll(ShuttleBean.java:164)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:28)

      at java.lang.reflect.Method.invoke(Method.java:313)

      at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:637)

      at org.jboss.ejb.plugins.BMPPersistenceManager.findEntities(BMPPersistenceManager.java:340)

      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:323)

      at org.jboss.ejb.EntityContainer.find(EntityContainer.java:655)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:28)

      at java.lang.reflect.Method.invoke(Method.java:313)

      at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1048)

      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:209)

      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)

      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:88)

      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)

      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)

      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:112)

      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:184)

      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:58)

      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)

      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:131)

      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:125)

      at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:475)

      at org.jboss.ejb.Container.invoke(Container.java:692)

      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1023)

      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)

      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)

      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)

      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)

      at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175)

      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)

      at $Proxy38.findAll(Unknown Source)

      at org.jdware.shuttle.servlets.ShuttleAdminServlet.doGet(ShuttleAdminServlet.java:148)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:362)

      at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:284)

      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:565)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)

      at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:544)

      at org.mortbay.http.HttpContext.handle(HttpContext.java:1614)

      at org.mortbay.http.HttpServer.service(HttpServer.java:875)

      at org.jboss.jetty.Jetty.service(Jetty.java:531)

      at org.mortbay.http.HttpConnection.service(HttpConnection.java:785)

      at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:935)

      at org.mortbay.http.HttpConnection.handle(HttpConnection.java:802)

      at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:200)

      at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:294)

      at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)

      at java.lang.Thread.run(Thread.java:539)