Extract JDBC Connection from Entitymanager using JTA

Question

In an environment Javaee, there is the possibility to extract the JDBC connection(java.sql.Connection) using JTA?

I have a datasource in Wildfly, where I inject in the following way:

@PersistenceContext
private EntityManager entityManager;

Have any way to extract the JDBC connection from this Entitymanager?

I found a way (but it didn’t work):

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

The following error has been released:

javax.persistence.Persistenceexception: Hibernate cannot unwrap java.sql.Connection interface

Answer 1

Hibernate and JPA 2.0

 @PersistenceContext
 private EntityManager entityManager;   

 session session = entityManager.unwrap(Session.class);

 SessionFactoryImplementor sfi = (SessionFactoryImplementor) 
 session.getSessionFactory();

 ConnectionProvider cp = sfi.getConnectionProvider();

 Connection conn = cp.getConnection();

Eclipselink JPA 2.0

 @PersistenceContext
 private EntityManager entityManager; 

 java.sql.Connection connection  entityManager.unwrap(java.sql.Connection.class);

http://wiki.eclipse.org/EclipseLink/Examples/JPA/EMAPI#Getting_a_JDBC_Connection_from_an_EntityManager

Answer 2

The way I did it was this:

Session hibernateSession = this.entityManager.unwrap(Session.class);
return ((SessionImpl) hibernateSession).connection();