Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Message-Id: <E2BE797D-D454-4957-985E-95CD7DD786AF@oracle.com>
From: Craig L Russell <craig.russell@oracle.com>
To: users@openjpa.apache.org
In-Reply-To: <AANLkTimZmCzaq6HXybxfSBwlIVGGuvV9BUkAlK_3Tcdy@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Subject: Re: Can entity manager join jdbc transaction?
Mime-Version: 1.0 (Apple Message framework v936)
Date: Wed, 2 Jun 2010 12:49:15 -0700
References: <AANLkTimZmCzaq6HXybxfSBwlIVGGuvV9BUkAlK_3Tcdy@mail.gmail.com>

Hi,

You might consider turning this upside down and first starting a JPA  
transaction and then get the connection from OpenJPA to do your JDBC  
work. Then both JPA and your JDBC code would be working with the same  
connection.

Craig

On Jun 2, 2010, at 8:43 AM, Daryl Stultz wrote:

> Hello, my project has a lot of work done direct to JDBC and some new  
> work
> done through OpenJPA. I'm using 1.2.1 on Tomcat (non-container). I  
> have a
> situation where a JDBC connection is obtained and a transaction is  
> started.
> Then some OpenJPA querying is done. The Entity Manager obtains an
> independent connection which means it doesn't read the state with  
> respect to
> the JDBC transaction. Is there any way to get an Entity Manager to  
> join a
> JDBC transaction? My setup uses a DataSource to supply a connection  
> to the
> Entity Manager. It seems I could modify this to return the JDBC  
> connection,
> but I'm guessing the EM would close it before my JDBC operation is  
> done.
>
> Thanks.
>
> -- 
> Daryl Stultz
> _____________________________________
> 6 Degrees Software and Consulting, Inc.
> http://www.6degrees.com
> http://www.opentempo.com
> mailto:daryl.stultz@opentempo.com

Craig L Russell
Architect, Oracle
http://db.apache.org/jdo
408 276-5638 mailto:Craig.Russell@oracle.com
P.S. A good JDO? O, Gasp!