[jboss-user] [JBoss Seam] - 2 PersistenceUnits: Adding multiple last resources is disall
Hello,
i have a Seam app for Seam 1.2.1 and JBoss 4.0.5 GA which uses 2 persistent uinits. After
migrating this app to SEAM 2.0.0Beta1 and JBoss 4.2.0GA i get an exception when both
persistance units are used.
The experiment comes from one database and after that a query to the other db should be
executed, but raises this exception.
16:17:17,890 INFO [STDOUT] Hibernate: select experiment0_.ExperimentID as Experime1_76_,
experiment0_.Size as Size76_, experiment0_.SowingYear as SowingYear76_,
experiment0_.Description as Descript4_76_, experiment0_.HarvestYear as HarvestY5_76_,
experiment0_.SowingDate as SowingDate76_, experiment0_.AddressCode as AddressC7_76_,
experiment0_.AddressFAOCode as AddressF8_76_, experiment0_.PartnerCode as PartnerC9_76_,
experiment0_.ProjectCode as Project10_76_, experiment0_.ExperimentCode as Experim11_76_,
experiment0_.ExperimentName as Experim12_76_, experiment0_.SiteID as SiteID76_,
experiment0_.HarvestDate as Harvest14_76_, experiment0_.Design as Design76_,
experiment0_.Samples as Samples76_, experiment0_.Replications as Replica17_76_ from
EXPERIMENT experiment0_ limit ?
| 16:17:17,984 WARN [loggerI18N]
[com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow]
[com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] Adding multiple
last resources is disallowed. Current resource is
org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@1340091
| 16:17:18,000 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
| 16:17:18,000 ERROR [JDBCExceptionReporter] 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: -53e0d9e7:77e:469b7d96:41 status:
ActionStatus.ABORT_ONLY >); - nested throwable:
(org.jboss.resource.JBossResourceException: 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: -53e0d9e7:77e:469b7d96:41 status:
ActionStatus.ABORT_ONLY >))
| 16:17:18,000 FATAL [application] javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: Cannot open connection
| javax.faces.el.EvaluationException: javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: Cannot open connection
| at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:91)
| at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
| at javax.faces.component.UICommand.broadcast(UICommand.java:383)
|
Both connections are working. I can access each database in isolated state. But not the
two togehter.
It would be fine if someone has an idea what this error means. Any pointer (even it is a
pointer to the right forum to ask: hibernate,EJB3,JCA etc) are welcome.
Googling yield only this
link:http://lists.jboss.org/pipermail/jboss-svn-commits/2007-March/006849... and was not
helpful
Ciao,
Carsten
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064581#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...