EJB3 2 client apps and 2 different databases

[eve agostini]

Hi
is it possible to invoke the same EJB3 Session Bean from two different client applications (web application) but in such a way that each different app persists on a different database?
Thanks!

Eve

[Jeanne Boyarsky]

Eve,
You would have to deploy the EJB twice to make that happen. Each app could call a different ear that points to the two databases.

[eve agostini]

Thanks for your answer

I think I'm putting the persistence.xml file in the wrong place.

I've read I can:

define the unit by placing a JAR file in the lib directory of the EAR, the persistence unit will automatically be visible to all modules in the EAR

So, that's what I tried to do.

Here is the structure of my appplication:

eve:dist Eve$ jar -tf EnterpriseApplication3.ear
META-INF/
META-INF/MANIFEST.MF
DB2.jar
EJBModule1.jar
WebApplication1.war

and this is the structure of the DB2 jar file:

eve:dist Eve$ jar -tf DB2.jar 
META-INF/
META-INF/MANIFEST.MF
META-INF/persistence.xml
eve:dist Eve$ 

I get this exception:
java.lang.IllegalStateException: Unable to retrieve EntityManagerFactory for unitName provaPU


I also tried to put the persistence.xml file directly in the archive (without the META-INF directory) but in this case the application won't event start and I'm getting this exception:
Caused by: java.lang.RuntimeException: Could not resolve a persistence unit corresponding to the persistence-context-ref-name [prova.NewSessionBean/entityManager] in the scope of the module called [EnterpriseApplication3#EJBModule1.jar]. Please verify your application.

Here is also the persistence.xml file itself:
<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.0" 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_2_0.xsd"> <persistence-unit name="provaPU" transaction-type="JTA"> <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <jta-data-source>jdbc/provaejb2</jta-data-source> <exclude-unlisted-classes>false</exclude-unlisted-classes> <properties> <property name="eclipselink.ddl-generation" value="create-tables"/> </properties> </persistence-unit> </persistence>

Thanks for your help

Eve