Can you post the exception and associated call stack for the error? Since this TranQL driver seems to be a Geronimo plugin, have you touched base with the Geronimo team and their forums?
>From an OpenJPA perspective, we're just doing the jndi lookup of the datasource. We're assuming the configuration for this datasource is accurate for the app server under use. Thanks, Kevin On Wed, Feb 10, 2010 at 10:20 AM, sbedoll <[email protected]> wrote: > > I have created multiple persistence units/data sources in the > persistence.xml: > > transaction mode="local" : > <non-jta-data-source>jdbc/fpa_datasource</non-jta-data-source> > > transaction mode="managed" > <jta-data-source>jdbc/fpa_jtadatasource</jta-data-source> > <non-jta-data-source>jdbc/fpa_datasource</non-jta-data-source> > > transaction mode="local" : > <jta-data-source>jdbc/wfdss_datasource</jta-data-source> > > transaction mode="local" : > <jta-data-source>jdbc/wims_datasource</jta-data-source> > > > I configured Database Pools for each one with the same name and they > connect > ok using the Geronimo (WAS CE) Admin Console. > > > I added the following to the deployment plan of the EAR. Note the > artifactId > I got from the JNDI viewer: > > <sys:dependency> > <groupId>console.dbpool</groupId> > <artifactId>jdbc_fpa_datasource</artifactId> > </sys:dependency> > <sys:dependency> > <groupId>console.dbpool</groupId> > <artifactId>jdbc_fpa_jtadatasource</artifactId> > </sys:dependency> > <sys:dependency> > <groupId>console.dbpool</groupId> > <artifactId>jdbc_wfdss_datasource</artifactId> > </sys:dependency> > <sys:dependency> > <groupId>console.dbpool</groupId> > <artifactId>jdbc_wims_datasource</artifactId> > </sys:dependency> > > From JNDI viewer: > > jca:/console.dbpool/jdbc_fpa_datasource/JCAManagedConnectionFactory/jdbc/fpa_datasource > > jca:/console.dbpool/jdbc_fpa_jtadatasource/JCAManagedConnectionFactory/jdbc/fpa_jtadatasource > > jca:/console.dbpool/jdbc_wfdss_datasource/JCAManagedConnectionFactory/jdbc/wfdss_datasource > > jca:/console.dbpool/jdbc_wims_datasource/JCAManagedConnectionFactory/jdbc/wims_datasource > > > The EAR deploys OK but I get an Exception that the URL is "null" when a JPA > call is made from the EAR. My Database pools use the TranQL XA Resource > Adapter for Oracle following this pattern and test ok from the console: > Database name: <db name> > • User Name: <user name> > • Password: <user password> > • Server Name: <host name> > • Driver Type: thin > • Description: <text> > • Login Timeout: default > • Port Number: 1521 > • Service Name: <db name> > • Data Source Name:oracle.jdbc.xa.client.OracleXADataSource > • TNS Entry Name: > o (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host =kpnatsp6)(Port = > 1521))(CONNECT_DATA = (SID = <db name>))) > • Max Statements: default > • Network Protocol: TCP > • Pool Size (min and Max): default > • Blocking Timeout: default > • Idle Timeout: default > Should the TranQL XA Resource Adapter for Oracle be used only for JPA > "managed" persistence units and > TranQL Generic JDBC Resource Adapter use for "local" persistence units ? > > I will try this change but some helpfull pointers will be appreciated ... > -- > View this message in context: > http://n2.nabble.com/Geronimo-WAS-CE-Oracle-OpenJPA-configuration-problem-tp4548923p4548923.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. >
