 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | - 2 PersistenceUnits: Adding multiple last resources is | - 2 PersistenceUnits: Adding multiple last resources is 2007-07-16 - By baz
Back
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.
I tried to declare both persistenceunits within one jar-file:
<?xml version="1.0" encoding="UTF-8 (See http://UTF-8.ora-code.com)"?>
|
| <!-- Persistence deployment descriptor for dev profile -->
| <persistence xmlns="http://java.sun.com/xml/ns/persistence"
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
| xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun
.com/xml/ns/persistence/persistence_1_0.xsd"
| version="1.0">
|
|
|
| <persistence-unit name="aveqtest">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <jta-data-source>java:/aveqtestDatasource</jta-data-source>
| <class>de.bafz.aveqtest.model.AccessionEvaluation</class>
|
| <class>de.bafz.aveqtest.model.AddresscodechangeClient</class>
|
| [...] <exclude-unlisted-classes />
|
| <properties>
| <property name="hibernate.hbm2ddl.auto" value="validate" />
| <property name="hibernate.cache.use_query_cache" value="true" />
| <property name="hibernate.show_sql" value="true" />
| <property name="hibernate.dialect" value="org.hibernate.dialect
.MySQLInnoDBDialect"/>
|
| <property name="jboss.entity.manager.jndi.name" value="java:
/entityManager" />
|
| <property name="jboss.entity.manager.factory.jndi.name" value="java:
/aveqtestEntityManagerFactory" />
|
| </properties>
| </persistence-unit>
|
| <persistence-unit name="oracleDB">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <jta-data-source>java:/oracleDatasource</jta-data-source>
| <class>de.bafz.aveqtest.model.oracle.Address</class>
| [...] <exclude-unlisted-classes />
| <properties>
| <property name="hibernate.hbm2ddl.auto" value="validate" />
| <property name="hibernate.cache.use_query_cache"
| value="true" />
| <property name="hibernate.show_sql" value="true" />
| <property name="hibernate.dialect" value="org.hibernate.dialect
.Oracle9Dialect"/>
| <property name="jboss.entity.manager.jndi.name"
| value="java:/oracleEntityManager" />
| <property name="jboss.entity.manager.factory.jndi.name"
| value="java:/oracleEntityManagerFactory" />
| </properties>
| </persistence-unit>
| </persistence>
|
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_, experiment
| 0_.Size as Size76_, experiment0_.SowingYear as SowingYear76_, experiment0_
.Description as Descript4_
| 76_, experiment0_.HarvestYear as HarvestY5_76_, experiment0_.SowingDate as
SowingDate76_, experiment
| 0_.AddressCode as AddressC7_76_, experiment0_.AddressFAOCode as AddressF8
_76_, experiment0_.PartnerC
| ode as PartnerC9_76_, experiment0_.ProjectCode as Project10_76_,
experiment0_.ExperimentCode as Expe
| rim11_76_, experiment0_.ExperimentName as Experim12_76_, experiment0_
.SiteID as SiteID76_, experimen
| t0_.HarvestDate as Harvest14_76_, experiment0_.Design as Design76_,
experiment0_.Samples as Samples7
| 6_, experiment0_.Replications as Replica17_76_ from EXPERIMENT experiment0_
limit ?
| 16:17:17,984 WARN [loggerI18N] [com.arjuna.ats.internal.jta.transaction
.arjunacore.lastResource.dis
| allow] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource
.disallow] Adding multiple la
| st resources is disallowed. Current resource is org.jboss.resource
.connectionmanager.TxConnectionMan
| ager$LocalXAResource@(protected)
| 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 ob
| ject!; - nested throwable: (javax.transaction.SystemException  : java.lang
.Throwable: Unabled to enlis
| t 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 o
| n entering meta-aware object!; - nested throwable: (javax.transaction
.SystemException: java.lang.Thr
| owable: 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.Gen
| ericJDBCException: Cannot open connection
| javax.faces.el.EvaluationException : javax.persistence.PersistenceException:
org.hibernate.exception.
| GenericJDBCException: Cannot open connection
| at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke
(MethodBindingMethodExpressionA
| dapter.java:91)
| at com.sun.faces.application.ActionListenerImpl.processAction
(ActionListenerImpl.java:91)
| at javax.faces.component.UICommand (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.
In the SEAM forum, gavin said to use XA DataSources.Are they really nessecary.
My apps runs with JBoss 4.0.5GA but not with 4.2.0GA.
Here are my Datasources:
<datasources>
|
| <local-tx-datasource>
| <jndi-name>aveqtestDatasource</jndi-name>
| <connection-url>jdbc:mysql://localhost/aveq</connection-url>
| <driver-class>com.mysql.jdbc.Driver </driver-class>
| <user-name>aaaa</user-name>
| <password>pppp</password>
|
| </local-tx-datasource>
|
| <local-tx-datasource>
| <jndi-name>oracleDatasource</jndi-name>
| <connection-url>
| jdbc:oracle:thin:@(protected):xe
| </connection-url>
| <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
| <user-name>eeee</user-name>
| <password>ooooo</password>
| <metadata>
| <type-mapping>Oracle</type-mapping>
| </metadata>
| </local-tx-datasource>
| </datasources>
|
Googling yield only this link:http://lists.jboss.org/pipermail/jboss-svn
-commits/2007-March/006849.html and was not helpful.
If XA DS are the solution, can someone tell me how to define them? It would be
great
Ciao,
Carsten
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic
&p=4064622#4064622
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode
=reply&p=4064622
__ ____ ____ ____ ____ ____ ____ ____ ____ ____
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user
|
|
|