Eclipse Community Forums: Newcomers » Need connection object used by EntityManager

Help

Home

Home » Newcomers » Newcomers » Need connection object used by EntityManager(Help)

Show: Today's Messages :: Show Polls :: Message Navigator

Need connection object used by EntityManager [message #1012600]

Thu, 21 February 2013 21:32

Jason Jones

Messages: 1
Registered: February 2013

Junior Member

I am using EclipseLink under WebLogic 12c. I need to get access to the underlying java.sql.Connection object being used by the EntityManager in an EJB. I'm not going to waste time going into the reasons for this, I know most people will think it's not necessary, but I need that connection. I found the following example at http://wiki.eclipse.org/EclipseLink/Examples/JPA/EMAPI#Getting_a_JDBC_Connection_from_an_EntityManager

entityManager.getTransaction().begin();
java.sql.Connection connection = entityManager.unwrap(java.sql.Connection.class);
...
entityManager.getTransaction().commit();

But this does not work, I get null returned from the call to entityManager.unwrap(java.sql.Connection.class);

Is there another way to get the connection?

Thanks for any help!

Report message to a moderator

Re: Need connection object used by EntityManager [message #1012948 is a reply to message #1012600]

Fri, 22 February 2013 14:00

Russell Bateman

Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

On 02/22/2013 04:33 AM, Jason Jones wrote:
> I am using EclipseLink under WebLogic 12c. I need to get access to the
> underlying java.sql.Connection object being used by the EntityManager in
> an EJB. I'm not going to waste time going into the reasons for this, I
> know most people will think it's not necessary, but I need that
> connection. I found the following example at
> http://wiki.eclipse.org/EclipseLink/Examples/JPA/EMAPI#Getting_a_JDBC_Connection_from_an_EntityManager
>
> entityManager.getTransaction().begin();
> java.sql.Connection connection =
> entityManager.unwrap(java.sql.Connection.class);
> ..
> entityManager.getTransaction().commit();
>
> But this does not work, I get null returned from the call to
> entityManager.unwrap(java.sql.Connection.class);
>
> Is there another way to get the connection?
> Thanks for any help!

It appears EclipseLink is supported in and by a different forum. You
might not get much help here. Check out:

http://www.eclipse.org/forums/index.php/f/111/

and/or

http://www.eclipse.org/eclipselink/

Report message to a moderator

Previous Topic:	Error: java.lang.NullPointerException
Next Topic:	eclipse plugin error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 06:22:10 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter