Hi which usage is corrupted: the jta one or the non jta one? if last one maybe just configure non jta datasource if not can you share your logs? something should be written there.
Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber <http://www.tomitribe.com> 2016-01-11 11:41 GMT+01:00 tschuler <thomas.schu...@opentext.com>: > Hi! > > We use two Oracle database instances (user1 & user2) running on same > database server available through same service name: > > <Resource id="myDatabase1" type="DataSource"> > JdbcDriver oracle.jdbc.OracleDriver > JdbcUrl jdbc:oracle:thin://localhost:1521/ServiceName > UserName user1 > Password password1 > </Resource> > <Resource id="myDatabase2" type="DataSource"> > JdbcDriver oracle.jdbc.OracleDriver > JdbcUrl jdbc:oracle:thin:@//localhost:1521/ServiceName > UserName user2 > Password password2 > </Resource> > > In persistence.xml we define two persistence units: > > <persistence xmlns="http://java.sun.com/xml/ns/persistence"; version="1.0"> > <persistence-unit name="my-unit1"> > <jta-data-source>myDatabase1</jta-data-source> > </persistence-unit> > <persistence-unit name="my-unit2"> > <jta-data-source>myDatabase2</jta-data-source> > </persistence-unit> > </persistence> > > What we observe is that an EntityManager for the second persistence unit > (my-unit2) uses a database connection from the first data source > myDatabase1 > (instead of myDatabase2 as defined). > All works fine if different jdbc urls are used within tomee.xml (e.g. > different service names or different database server). > > Does anyone know of a special setting that enforces usage of correct > datasource for configuration described above? > > Best regards, > Thomas > > > > -- > View this message in context: > http://tomee-openejb.979440.n4.nabble.com/Multiple-EntityManager-using-wrong-Oracle-DataSource-tp4677399.html > Sent from the TomEE Dev mailing list archive at Nabble.com. >
