XA Exception (Bundled JSQLConnect Example Service))
Hi - we are testing the example JSQLCOnnect XA service bundled with JBOSS 3.0.3 using the JBOSS transaction template project. We get the exception below. This does not occur with the non-XA service. Any ideas on where we need to look to figure this out please?
nested throwable: (java.sql.SQLException: Unable to get Connection: javax.resource.ResourceException:
Unable to get XAResource: java.sql.SQLException: java.lang.reflect.InvocationTargetException)
2002-11-05 18:15:05,453 INFO [org.jboss.ejb.EjbModule] Deploying bank/AccountSession
2002-11-05 18:15:05,468 INFO [org.jboss.ejb.EjbModule] Deploying bank/BankSession
2002-11-05 18:15:05,468 INFO [org.jboss.ejb.EjbModule] Deploying bank/CustomerSession
2002-11-05 18:15:05,484 INFO [org.jboss.ejb.EjbModule] Deploying bank/TellerSession
2002-11-05 18:15:05,562 INFO [org.jboss.ejb.EjbModule] Created
2002-11-05 18:15:05,562 INFO [org.jboss.ejb.EjbModule] Starting
2002-11-05 18:15:05,812 INFO [STDOUT] JSQLConnect.xaLog JSQLXADataSource.getXAConnection (getPooledConnection) user:dbUser
2002-11-05 18:15:05,890 INFO [STDOUT] JSQLConnect(3.2718)) Trial license - expires on:Fri Dec 06 17:05:02 MST 2002, unlimited connections
2002-11-05 18:15:05,890 INFO [STDOUT] JSQLConnect.xaLog XADataSource DtcEnabled:null
2002-11-05 18:15:05,937 WARN [org.jboss.system.ServiceController]
Problem starting service jboss.j2ee:jndiName=ejb/bank/Account,service=EJB
org.jboss.deployment.DeploymentException: Error while fixing table name; -
nested throwable: (java.sql.SQLException: Unable to get Connection: javax.resource.ResourceException:
Unable to get XAResource: java.sql.SQLException: java.lang.reflect.InvocationTargetException)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:67)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEntityBridge.java:103)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:397)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
at org.jboss.ejb.Container.invoke(Container.java:756)
at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
at $Proxy5.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:397)
at sun.reflect.GeneratedMethodAccessor6.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:517)
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy18.start(Unknown Source)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
at sun.reflect.GeneratedMethodAccessor14.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:517)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)