Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Message-Id:From:To:In-Reply-To:Content-Type:Content-Transfer-Encoding:Mime-Version:Subject:Date:References:X-Mailer;
  b=t3rRx2UU4Hl3rdXeW32O9xO9HuXJCkTlC4JqEc2w+siZHzNlaG3fbkKbEgRhmZufHqY51c2eL1xBO1x/5vSfd+510l/PIpIor38lMcV7q8UZyD7y8XsvDVhWxeaGIC7pHr4GghB2ylppxeMLhohkK5RENMc31j/dn1E1QlW13xw=
  ;
Message-Id: <B98479E3-6B68-4DEB-953C-A74CCBF30F0D@yahoo.com>
From: David Jencks <david_jencks@yahoo.com>
To: user@geronimo.apache.org
In-Reply-To: <26532836.post@talk.nabble.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v936)
Subject: Re: Geronimo with openjpa (and DataSource lookups)
Date: Thu, 26 Nov 2009 13:09:25 -0800
References: <26532836.post@talk.nabble.com>

The datasource module needs to be listed as a dependency of the war  
module if they are deployed separately.  Single-valued component  
search in geronimo follows the directed acyclic graph of dependencies  
so you can deploy lots of datasources named "jdbc/db" in different  
modules yet still get the one you want in your app by specifying the  
module with the right one as a dependency.

thanks
david jencks

On Nov 26, 2009, at 9:44 AM, cumbers wrote:

>
> I am looking for someone to put me out of my geronimo/openpa misery.
>
> I have an application that I can deploy to Geronimo (2.1.1.3) that  
> uses
> openjpa where the properties inside the persistence.xml are explicitly
> defined like so:
>
> <properties>
>        <property name="openjpa.ConnectionDriverName"
> value="oracle.jdbc.driver.OracleDriver"></property>
>        <property name="openjpa.ConnectionURL"
> value="jdbc:oracle:thin:@localhost:1521:DB"></property>
>        <property name="openjpa.ConnectionUserName"
> value="dbuser"></property>
>        <property name="openjpa.ConnectionPassword"
> value="passw0rd"></property>
> </properties>
>
> However this app is going to be deployed by lots of users, and  
> ideally I
> would like to ship a war file, and direct users to create a JNDI  
> object that
> they define and then openjpa uses this.
>
> Simply defining the JNDI datasource connection within Geronimo, and  
> using
> the reference in the <jta-data-source>jdbc/db</jta-data-source> or
> <non-jta-data-source>jdbc/db</non-jta-data-source> does not appear  
> to work,
> and I get the following error message when I try and create an
> EntityManager:
>
> "<openjpa-1.2.1-r2180:4612 fatal user error>
> org.apache.openjpa.persistence.ArgumentException: A JDBC Driver or
> DataSource class name must be specified in the ConnectionDriverName
> property."
>
> After 3 days on google, I found this page:
> http://cwiki.apache.org/GMOxDOC21/datasource-connectionfactory-mdb-and-jpa.html
> which suggests that:
>
> "Although many other servers use jndi to define the meaning of the
> jta-data-source and non-jta-data-source geronimo does not. These are  
> not
> jndi names in any way but must match the name specified in the  
> connector
> plan."
>
> OK so using the jndi object name directly does not seem to be  
> supported.
> However the name in the resourceadapter of the plan.xml IS "jdbc/db"  
> and so
> I think this should work. Here is the relevant snippet from my  
> plan.xml as
> created when I define a JDBC datasource using Geronimo.
>
>    <resourceadapter>
>        <outbound-resourceadapter>
>            <connection-definition>
>
> <connectionfactory-interface>javax.sql.DataSource</connectionfactory- 
> interface>
>                <connectiondefinition-instance>
>                    <name>jdbc/db</name>
>
> I have run out of ideas on how I can make this work, and would be  
> massively
> appreciative if anyone can shed some light on why this is not  
> working. If
> you think you need more information please let me know!
>
> Cheers
>
> Rich
> -- 
> View this message in context: http://old.nabble.com/Geronimo-with-openjpa-%28and-DataSource-lookups%29-tp26532836s134p26532836.html
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>