Re: TomEE - DataSource error report

2012-11-03 Thread Romain Manni-Bucau
Hi, Transaction isolation in 1.5.0 should have been an integer (using tomcat jdbc). Le 3 nov. 2012 20:01, "Pete Keyes" a écrit : > Error asked that it be reported ... here the stack trace as requested. > Running TomEE 1.5.0 > > Nov 3, 2012 10:56:44 AM org.apache.openejb.util.OpenEJBErrorHandler

TomEE - DataSource error report

2012-11-03 Thread Pete Keyes
Error asked that it be reported ... here the stack trace as requested. Running TomEE 1.5.0 Nov 3, 2012 10:56:44 AM org.apache.openejb.util.OpenEJBErrorHandler handleUnknownError SEVERE: FATAL ERROR: Unknown error in Assembler. Please send the following stack trace and this message to users@op

Re: Tomee Datasource

2012-05-15 Thread José Luis Cetina
Here is the configuration: MyDataSourceRealm.java: package test.myrealm; import java.sql.Connection; import javax.naming.InitialContext; import javax.sql.DataSource; public class MyDataSourceRealm extends org.apache.catalina.realm.DataSourceRealm{ @Override protected Connection open()

Re: Tomee Datasource

2012-05-15 Thread Romain Manni-Bucau
((DataSource) new InitialContext().lookup("openejb:Resource/myDataSource")).getConnection() sorry i pasted the bad path last time - Romain 2012/5/15 Romain Manni-Bucau > it seems fine, any luck you share this part of the project? > > - Romain > > > 2012/5/15 José Luis Cetina > >> Ok i add my

Re: Tomee Datasource

2012-05-15 Thread Romain Manni-Bucau
it seems fine, any luck you share this part of the project? - Romain 2012/5/15 José Luis Cetina > Ok i add my class in a jar file, but im getting: > > javax.naming.NameNotFoundException:The name openejb/Resource/MyDataSource > does not exist in the current context. > > is openejb/Resource/MyD

Re: Tomee Datasource

2012-05-15 Thread José Luis Cetina
Ok i add my class in a jar file, but im getting: javax.naming.NameNotFoundException:The name openejb/Resource/MyDataSource does not exist in the current context. is openejb/Resource/MyDataSource the correct directory for use the datasource? 2012/5/15 Romain Manni-Bucau > it should be in tome

Re: Tomee Datasource

2012-05-15 Thread Romain Manni-Bucau
it should be in tomee libs, not your project. (another solution is to use the snapshot ;) and use the default datasource realm) - Romain 2012/5/15 José Luis Cetina > I did this: > > context.mxl > > > > dataSourceName="MyDataSource" > userTable="usertable" > userNameCol="usercol" > userC

Re: Tomee Datasource

2012-05-15 Thread José Luis Cetina
I did this: context.mxl MyDataSourceRealm.java: package realm.test; import java.sql.Connection; import javax.naming.InitialContext; import javax.sql.DataSource; public class MyDataSourceRealm extends org.apache.catalina.realm.DataSourceRealm{ @Override protected Connection op

Re: Tomee Datasource

2012-05-14 Thread Romain Manni-Bucau
here the issue https://issues.apache.org/jira/browse/TOMEE-191 here a sample http://openejb.apache.org/examples-trunk/realm-in-tomee/README.html - Romain 2012/5/15 Romain Manni-Bucau > seems using org.apache.catalina.realm.DataSourceRealm doesn't work out of > the box (currently hacking on it

Re: Tomee Datasource

2012-05-14 Thread Romain Manni-Bucau
seems using org.apache.catalina.realm.DataSourceRealm doesn't work out of the box (currently hacking on it). extending it and overriding org.apache.catalina.realm.DataSourceRealm#open() to make: DataSource dataSource = (DataSource)new InitialContext().lookup("java:openejb/Resource/" + dataSourceNa

Re: Tomee Datasource

2012-05-14 Thread Jean-Louis MONTEIRO
That seems correct to me. Can you try adding the property localDataSource=true to the following realm definition ? 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 To

Re: Tomee Datasource

2012-05-14 Thread Romain Manni-Bucau
Hi, Yes using the complete name openejb:Resource/Mydatasource (maybe a s is missing to resource) Romain Le 14 mai 2012 22:12, "José Luis Cetina" a écrit : > Hi my web app use openJPA for database CRUD, i configure like this: > > tomee.xml: > > > JdbcDriver com.mysql.jdbc.Driver > JdbcUrl jdb

Tomee Datasource

2012-05-14 Thread José Luis Cetina
Hi my web app use openJPA for database CRUD, i configure like this: tomee.xml: JdbcDriver com.mysql.jdbc.Driver JdbcUrl jdbc:mysql://localhost:3306/mydatabase?autoReconnect=true UserName myuser Password mypass JtaManaged true JdbcDriver com.mysql.jdbc.Driver JdbcUrl jdbc:mysql:/