4:32 p.m.
Greetings.
In JBoss 3.0/3.2, I had Datasources being created programmatically (a
couple of hundred to a couple of thousand separate DBs, no WAY is
defining *-ds.xml files viable here). I had this working in 3.0/3.2,
but when I tried to upgrade to JBoss 4.2, the code in question died.
So, did some research, reviewed the web-console, did some digging, and
made some modifications (attached).
This method is based HEAVILY on the
org.jboss.test.jmx.test.DeployConnectionManagerUnitTestCase, a test case
which has since been deleted with no apparent replacement. The
attached code is creating all of the objects, and they seem to be
accessible. However, when I try to get a Connection from a newly
created ConnectionPool, I get the following exception. Any suggestions
as to what I am not setting, or not creating????
Regards,
Steve
Looking up: java:/jdbc/pool/sda
15:56:06,142 WARN
[com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:801)]
[com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror]
[com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror]
TransactionImple.enlistResource - XAResource.start returned:
XAException.XAER_PROTO for < 131075, 29, 27,
1--3f5704ff:3e11:46fc100e:11c-3f5704ff:3e11:46fc100e:11f >
15:56:06,145 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)]
org.jboss.resource.connectionmanager.JBossLocalXAException: Trying to
start a new tx when old is not complete! old: < 131075, 28, 26,
1--3f5704ff:3e11:46fc100e:2e-3f5704ff:3e11:46fc100e:32 >, new < 131075,
29, 27, 1--3f5704ff:3e11:46fc100e:11c-3f5704ff:3e11:46fc100e:11f >, flags 0
15:56:06,166 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:886)
15:56:06,168 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:774)
15:56:06,178 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:497)
15:56:06,181 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:773)
15:56:06,188 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:564)
15:56:06,191 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337)
15:56:06,198 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518)
15:56:06,200 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399)
15:56:06,203 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
15:56:06,206 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
15:56:06,208 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
com.hrnexus.common.ejb.DBConnection.getConnection(DBConnection.java)
15:56:06,229 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
com.hrnexus.security.ejb.UserEJB.ejbLoad(UserEJB.java)
15:56:06,232 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:56:06,235 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:56:06,239 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:56:06,242 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
java.lang.reflect.Method.invoke(Method.java:585)
15:56:06,245 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.BMPPersistenceManager.loadEntity(BMPPersistenceManager.java:435)
15:56:06,248 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:252)
15:56:06,251 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:243)
15:56:06,263 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
15:56:06,267 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:126)
15:56:06,271 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:278)
15:56:06,274 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:104)
15:56:06,277 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:76)
15:56:06,280 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
15:56:06,304 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
15:56:06,307 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
15:56:06,309 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
15:56:06,311 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
15:56:06,314 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
15:56:06,316 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
15:56:06,319 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:527)
15:56:06,321 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.ejb.Container.invoke(Container.java:960)
15:56:06,323 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:56:06,328 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:56:06,330 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:56:06,333 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
java.lang.reflect.Method.invoke(Method.java:585)
15:56:06,335 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
15:56:06,338 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
15:56:06,339 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
15:56:06,340 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
15:56:06,342 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
15:56:06,343 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
15:56:06,345 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
15:56:06,346 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
15:56:06,348 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
15:56:06,349 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
15:56:06,350 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
15:56:06,352 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.proxy.ejb.EntityInterceptor.invoke(EntityInterceptor.java:112)
15:56:06,358 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
15:56:06,360 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
$Proxy133.logOut(Unknown Source)
\15:56:06,363 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
com.hrnexus.security.UserProxy.valueUnbound(UserProxy.java)
15:56:06,364 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.servlet.AbstractSessionManager$Session.unbindValue(AbstractSessionManager.java:1118)
15:56:06,367 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.servlet.AbstractSessionManager$Session.setAttribute(AbstractSessionManager.java:1050)
15:56:06,369 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
com.hrnexus.security.servlet.LoginServlet.logIn(LoginServlet.java)
15:56:06,370 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
com.hrnexus.security.servlet.LoginServlet.doPost(LoginServlet.java)
15:56:06,373 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
15:56:06,376 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
15:56:06,385 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.servlet.jsr77.Jsr77ServletHolder.handle(Jsr77ServletHolder.java:74)
15:56:06,387 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
15:56:06,388 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
15:56:06,390 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
15:56:06,391 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
15:56:06,392 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
15:56:06,394 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
15:56:06,395 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
15:56:06,397 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
15:56:06,398 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.Server.handle(Server.java:313)
15:56:06,399 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
15:56:06,401 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:844)
15:56:06,402 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
15:56:06,404 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
15:56:06,405 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
15:56:06,406 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:227)
15:56:06,408 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.jetty.security.SslSocketConnector$SslConnection.run(SslSocketConnector.java:626)
15:56:06,409 ERROR
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)] at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
15:56:06,411 INFO
[org.jboss.logging.util.LoggerStream.write(LoggerStream.java:152)]
at
org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:126)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:278)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:104)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:76)
at
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at
org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:527)
at org.jboss.ejb.Container.invoke(Container.java:960)
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:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
at
org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
at
org.jboss.proxy.ejb.EntityInterceptor.invoke(EntityInterceptor.java:112)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
at $Proxy133.logIn(Unknown Source)
at com.hrnexus.security.UserProxy.logIn(UserProxy.java)
at
com.hrnexus.security.servlet.LoginServlet.doPost(LoginServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at
org.mortbay.jetty.servlet.jsr77.Jsr77ServletHolder.handle(Jsr77ServletHolder.java:74)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:227)
at
org.mortbay.jetty.security.SslSocketConnector$SslConnection.run(SslSocketConnector.java:626)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
org.jboss.util.NestedSQLException: Could not enlist in transaction on
entering meta-aware object!; - nested throwable:
(javax.transaction.SystemException: java.lang.Throwable: Unabled to
enlist resource, see the previous warnings. tx=TransactionImple < ac,
BasicAction: -3f5704ff:3e11:46fc100e:108 status: ActionStatus.ABORT_ONLY >)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
at
com.hrnexus.common.ejb.DBConnection.getConnection(DBConnection.java)
at com.hrnexus.security.ejb.UserEJB.ejbLoad(UserEJB.java)
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:585)
at
org.jboss.ejb.plugins.BMPPersistenceManager.loadEntity(BMPPersistenceManager.java:435)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:252)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:243)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at
org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:126)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:278)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:104)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:76)
at
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at
org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:527)
at org.jboss.ejb.Container.invoke(Container.java:960)
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:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
at
org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
at org.jboss.proxy.ejb.EntityI
private DataSource makeJBossDataSource42x(final String schema, final ResultSet rs)
throws Exception {
if (DEBUG_ENABLED) {
dumpConnectionInfo("makeJBossDataSource42x", schema, rs);
}
final String jndiURL = "jdbc/pool/" + schema;
//LocalTXCM
ObjectName cmName = new ObjectName("jboss.jca:service=LocalTxCM,name=" +
jndiURL);
// try to remove mbean if leftover...
if (server.isRegistered(cmName)) {
server.unregisterMBean(cmName);
}
Object cmBean =
server.createMBean("org.jboss.resource.connectionmanager.TxConnectionManager",
cmName);
assert cmBean != null : "Server never created TxConnectionManager for: "
+ schema;
assert server.isRegistered(cmName) : "Server never registered
ConnectionManager for: " + schema;
//ManagedConnection Factory
ObjectName mcfName = new
ObjectName("jboss.jca:service=ManagedConnectionFactory,name=" + jndiURL);
// try to remove mbean if leftover...
if (server.isRegistered(mcfName)) {
server.unregisterMBean(mcfName);
}
Object mbean =
server.createMBean("org.jboss.resource.connectionmanager.RARDeployment",
mcfName);
assert mbean != null : "Server never created ManagedConnectinoFactory for:
" + schema;
assert server.isRegistered(mcfName) : "Server never registered
ManagedConnectionFactory for: " + schema;
//ManagedConnectionPool
ObjectName mcpName = new
ObjectName("jboss.jca:service=ManagedConnectionPool,name=" + jndiURL);
// try to remove mbean if leftover...
if (server.isRegistered(mcpName)) {
server.unregisterMBean(mcpName);
}
Object pool =
server.createMBean("org.jboss.resource.connectionmanager.JBossManagedConnectionPool",
mcpName);
assert pool != null : "Server never created Connection Pool for: " +
schema;
assert server.isRegistered(mcpName) : "Server never registered Connection
Pool for: " + schema;
ObjectName serviceControllerName = new
ObjectName("jboss.system:service=ServiceController");
// anon block so I don't rename var al
{
AttributeList al = new AttributeList();
al.add(new Attribute("JndiName", jndiURL));
al.add(new Attribute("ManagedConnectionPool", mcpName));
al.add(new Attribute("CachedConnectionManager",
new ObjectName(
"jboss.jca:service=CachedConnectionManager")));
final ObjectName tmsName = new
ObjectName("jboss:service=TransactionManager");
al.add(new Attribute("TransactionManagerService", tmsName));
al.add(new Attribute("LocalTransactions", Boolean.TRUE));
al.add(new Attribute("TraceConnectionByTx", Boolean.TRUE));
// try to set the attributes on the bean
try {
server.setAttributes(cmName, al);
} catch (UndeclaredThrowableException e) {
if (e.getCause() instanceof MBeanException) {
LOGGER.error("Exception setting Attribute on Server handle:
" + e.getMessage(), e);
throw (MBeanException) e.getCause();
}
}
}
// RARDeployment
{
AttributeList al = new AttributeList();
al.add(new Attribute("ManagedConnectionFactoryClass",
"org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory"));
// try to set the attributes on the bean
server.setAttributes(mcfName, al);
}
// anon block so I don't rename vars
{
AttributeList al = new AttributeList();
al.add(new Attribute("PoolJndiName", jndiURL));
al.add(new Attribute("ManagedConnectionFactoryName", mcfName));
al.add(new Attribute("MinSize", new Integer(0)));
al.add(new Attribute("MaxSize", new Integer(50)));
al.add(new Attribute("BlockingTimeoutMillis", new Long(5000)));
al.add(new Attribute("IdleTimeoutMinutes", new Integer(7)));
al.add(new Attribute("Criteria", "ByNothing"));
// try to set the attributes on the bean
server.setAttributes(mcpName, al);
}
//DataSource
ObjectName dsName = new
ObjectName("jboss.jca:service=DataSourceBinding,name=" + jndiURL);
// try to remove mbean if leftover...
if (server.isRegistered(dsName)) {
server.unregisterMBean(dsName);
}
Object dsBean =
server.createMBean("org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService",
dsName);
assert dsBean != null : "Server never created DataSourceBinding for: " +
schema;
assert server.isRegistered(dsName) : "Server never registered
ConnectionManager for: " + schema;
{
AttributeList al = new AttributeList();
al.add(new Attribute("JndiName", jndiURL));
al.add(new Attribute("UseJavaContext", Boolean.TRUE));
al.add(new Attribute("ConnectionManager", cmName));
// try to set the attributes on the bean
server.setAttributes(dsName, al);
}// anon block so I don't rename var
// start the mbeans
// create and configure the ManagedConnectionFactory
/*
* //Service Controller should already be running!
* server.invoke(serviceControllerName, "create", new Object[]{mcfName},
new String[] {"javax.management.ObjectName"});
* server.invoke(serviceControllerName, "start", new Object[] {mcfName},
new String[] {"javax.management.ObjectName"});
*/
// assertTrue("State is not started",
"Started".equals(getServer().getAttribute(mcfName, "StateString")));
// Make the Connection URL
// Now set the important attributes:
final StringBuffer connectionURL = new StringBuffer("jdbc:");
final String sid = rs.getString(SID);
if (!rs.wasNull()) {
// Oracle DataBase
connectionURL.append("oracle:" + ORACLE_DRIVER_TYPE +
":@");
} else {
// There is a serious issue somewhere, or a new driver type
throw new HRNException(ApplicationConstants.BASE_RESOURCE,
"common.error.db.critical.sid", null);
}
connectionURL.append(rs.getString(MACHINE));
connectionURL.append(':');
connectionURL.append(rs.getString(PORT));
// TODO: Check to see if Oracle before adding following....
connectionURL.append(':');
connectionURL.append(sid);
// Now set the important attributes:
// create and configure the ManagedConnectionFactory
server.invoke(serviceControllerName, "create", new Object[] { mcfName
},
new String[] { "javax.management.ObjectName" });
server.invoke(serviceControllerName, "start", new Object[] { mcfName },
new String[] { "javax.management.ObjectName" });
assert "Started".equals(server.getAttribute(mcfName,
"StateString")) :
"State is not started for ManagedConnectionFactory: " + schema;
server.invoke(mcfName, "setManagedConnectionFactoryAttribute", new
Object[] { "ConnectionURL",
java.lang.String.class, connectionURL.toString() }, new String[] {
"java.lang.String",
"java.lang.Class", "java.lang.Object" });
// TODO: Verify that we are actually using Oracle, and select the appropriate
driver.
server.invoke(mcfName, "setManagedConnectionFactoryAttribute", new
Object[] { "DriverClass",
java.lang.String.class, "oracle.jdbc.driver.OracleDriver" }, new
String[] { "java.lang.String",
"java.lang.Class", "java.lang.Object" });
server.invoke(mcfName, "setManagedConnectionFactoryAttribute", new
Object[] { "UserName",
java.lang.String.class, schema }, new String[] {
"java.lang.String", "java.lang.Class",
"java.lang.Object" });
server.invoke(mcfName, "setManagedConnectionFactoryAttribute", new
Object[] { "Password",
java.lang.String.class, rs.getString(PASS) }, new String[] {
"java.lang.String", "java.lang.Class",
"java.lang.Object" });
// start the pool
server.invoke(serviceControllerName, "create", new Object[] { mcpName
},
new String[] { "javax.management.ObjectName" });
server.invoke(serviceControllerName, "start", new Object[] { mcpName },
new String[] { "javax.management.ObjectName" });
// assertTrue("State is not started",
"Started".equals(getServer().getAttribute(mcpName, "StateString")));
// start the ConnectionManager
server.invoke(serviceControllerName, "create", new Object[] { cmName },
new String[] { "javax.management.ObjectName" });
server.invoke(serviceControllerName, "start", new Object[] { cmName },
new String[] { "javax.management.ObjectName" });
//Start the DataSource.
server.invoke(serviceControllerName, "create", new Object[] { dsName },
new String[] { "javax.management.ObjectName" });
server.invoke(serviceControllerName, "start", new Object[] { dsName },
new String[] { "javax.management.ObjectName" });
// Despite having gone through all of the above, we still don't have a handle
// to the dataSource, so get one and return it.
return (getDataSource(schema, false));
// end makeJBossDataSource328
}