That seems correct to me.
Can you try adding the property localDataSource=true
to the following realm definition ?
<Realm
className="org.apache.catalina.realm.DataSourceRealm"
dataSourceName="MyDataSource"
userTable="userTable"
userNameCol="user"
userCredCol="pass"
userRoleTable="rolTable"
roleNameCol="rol"/>
That should hopefully do the trick as Tomcat will lookup to the right
context.
The only issue that may happen is the order. I mean, may be Tomcat gonna
lookup the resource before TomEE fully initialize and register the
datasource.
Anyway, let's proceed with the property. We can continue investigating
after.
Jean-Louis
2012/5/14 José Luis Cetina <[email protected]>
> Hi my web app use openJPA for database CRUD, i configure like this:
>
> tomee.xml:
>
> <Resource id="MyDataSource" type="DataSource">
> JdbcDriver com.mysql.jdbc.Driver
> JdbcUrl jdbc:mysql://localhost:3306/mydatabase?autoReconnect=true
> UserName myuser
> Password mypass
> JtaManaged true
> </Resource>
>
> <Resource id="MyUnmanagedDataSource" type="DataSource">
> JdbcDriver com.mysql.jdbc.Driver
> JdbcUrl jdbc:mysql://localhost:3306/mydatabase?autoReconnect=true
> UserName myuser
> Password mypass
> JtaManaged false
> </Resource>
>
>
> my persistence.xml:
>
> <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="testPU" transaction-type="JTA">
>
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
> <jta-data-source>MyDataSource</jta-data-source>
> <non-jta-data-source>MyUnmanagedDataSource</non-jta-data-source>
> .
> .
> .
> </persistence>
>
>
> MyEJB.java
>
> @Stateless
> public class MyEJB {
>
> @PersistenceContext(name="testPU")
> private EntityManager em;
>
> public void test(){
> .....
> em.createQuery("SELECT o FROM Table o").getResultList();
> ........
> }
> }
>
>
> And all of this works without any trouble. :)
>
>
> Now im trying to use DataSourceRealm with the same Datasource (tomee.xml)
> but doesnt work
>
> context.xml
>
> <Realm
> className="org.apache.catalina.realm.DataSourceRealm"
> dataSourceName="MyDataSource"
> userTable="userTable"
> userNameCol="user"
> userCredCol="pass"
> userRoleTable="rolTable"
> roleNameCol="rol"/>
>
> I expect the realm take the same DataSource from tomee.xml but this doesnt
> happend:
>
> Severe: ........
> The MyDataSource name is not associated to this context.
>
>
> Is there a way to use the same datasource (tomee.xml)
>
> If i use JDBCRealm it works, but i want to reuse the same datasource
> config.
>
>
> Any?
>
>
>
> --
> -------------------------------------------------------------------
> SCJA. José Luis Cetina
> -------------------------------------------------------------------
>
>
> --
> -------------------------------------------------------------------
> *SCJA. José Luis Cetina*
> -------------------------------------------------------------------
>
