Eclipse Community Forums: EclipseLink » Getting a JDBC Connection from an EntityManager returns null in EclipseLink 2.0.2

Home » Eclipse Projects » EclipseLink » Getting a JDBC Connection from an EntityManager returns null in EclipseLink 2.0.2(Attempting to obtain a JDBC Connection from an EntityManager using JPA 1.0 returns null)

Getting a JDBC Connection from an EntityManager returns null in EclipseLink 2.0.2 [message #649824]

Thu, 20 January 2011 11:35

Eclipse User

Hello,

We are using JPA 1.0 with the EclipseLink 2.0.2 distribution and finding that :

UnitOfWorkImpl unitOfWork = (UnitOfWorkImpl)((JpaEntityManager)em.getDelegate()).getActi veSession();
unitOfWork.beginEarlyTransaction();
return unitOfWork.getAccessor().getConnection();

as described here ( http://wiki.eclipse.org/EclipseLink/Examples/JPA/EMAPI#Getti ng_a_JDBC_Connection_from_an_EntityManager) is unexpectedly returning null.

Prior to the above code being executed, we obtain an EntityManager reference, obtain a Transaction reference against it, begin the transaction modify an instance of a JPA mapped class, then attempt to obtain the JDBC Connection from the EntityManager which is returning null.

The transaction that was started otherwise commits fine.

Has anyone experienced this problem and has found a suitable workaround?

Thank you,

Doug Gschwind

Re: Getting a JDBC Connection from an EntityManager returns null in EclipseLink 2.0.2 [message #650361 is a reply to message #649824]

Mon, 24 January 2011 10:57

Eclipse User

I think the issue is that your are using an external transaction controller, i.e. a JTA DataSource.

I updated the code in the example to handle this,

entityManager.getTransaction().begin();
UnitOfWork unitOfWork = (UnitOfWork)((JpaEntityManager)entityManager.getDelegate()).getActiveSession();
unitOfWork.beginEarlyTransaction();
Accessor accessor = unitOfWork.getAccessor();
accessor.incrementCallCount(unitOfWork.getParent());
accessor.decrementCallCount();
java.sql.Connection connection = accessor.getConnection();
...
entityManager.getTransaction().commit();

You could also acquire the connection directly from the JTA DataSource.

Re: Getting a JDBC Connection from an EntityManager returns null in EclipseLink 2.0.2 [message #650407 is a reply to message #649824]

Mon, 24 January 2011 13:07

Eclipse User

Thanks for your response James, that code change appears to be working for us.

A follow on question though. Is that technique that you describe also appropriate when the datasource is a non-JTA datasource or when simply JTA is not available?

Thank you,

Doug

Re: Getting a JDBC Connection from an EntityManager returns null in EclipseLink 2.0.2 [message #650410 is a reply to message #649824]

Mon, 24 January 2011 13:13

Eclipse User

The code will work with either.

Previous Topic:	Querying ManyToMany relationship
Next Topic:	eclipselink.ddl-generation - best practice

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 19:42:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter