Session.connection () not recommended in Hibernate?

Question

We need to be able to bind a java.sql.Connection a sleep session. No other connection will work, as this connection may be associated with the current transaction.

If session.connection () is now deprecated, how should I do this?

Answer 1

Now you need to use the Work API:

 session.doWork( new Work() { public void execute(Connection connection) throws SQLException { doSomething(connection); } } ); 

Or, in Java 8:

 session.doWork(connection -> doSomething(connection)); 

Answer 2

If session.connect() now deprecated, how should I do it?

You should use Session#doWork(Work) and the Work API, as stated in Javadoc:

connection()
Outdated. (scheduled for removal in 4.x). Replacement depends on need; to use direct JDBC material, use doWork(org.hibernate.jdbc.Work) ; to open the use of the "temporary session" (TBD).

You have time before Hibernate 4.x, but using an outdated API, it looks something like this:

:)

Update: According to RE: [hibernate-dev] Proxying a connection in the hibernate-dev list it seems that the original intention of the refusal was to refuse to use Session#connection() because it was / is considered a "bad" API, but it should have remained in that time. I think they changed their minds ...

Answer 3

There is another option, in which many tricks are involved, but at least it does not need reflection, which will give you the opportunity to check the compilation time:

 public Connection getConnection(final EntityManager em) { HibernateEntityManager hem = (HibernateEntityManager) em; SessionImplementor sim = (SessionImplementor) hem.getSession(); return sim.connection(); } 

You could even make it “prettier” with a few instanceof checks, but the version above works for me.

Answer 4

try it

 ((SessionImpl)getSession()).connection() 

Actuly getSession returns the type of session interface, you should see what is the source class for the session, enter cast in the source class, then get the connection.

LUCK!

Answer 5

Here is a way to do it in Hibernate 4.3, and it is not deprecated:

  Session session = entityManager.unwrap(Session.class); SessionImplementor sessionImplementor = (SessionImplementor) session; Connection conn = sessionImplementor.getJdbcConnectionAccess().obtainConnection(); 

Answer 6

connection() just deprecated on the interface. It is still available on SessionImpl . You can do what Spring does and just call it.

Here is the code from HibernateJpaDialect in Spring 3.1.1

 public Connection getConnection() { try { if (connectionMethod == null) { // reflective lookup to bridge between Hibernate 3.x and 4.x connectionMethod = this.session.getClass().getMethod("connection"); } return (Connection) ReflectionUtils.invokeMethod(connectionMethod, this.session); } catch (NoSuchMethodException ex) { throw new IllegalStateException("Cannot find connection() method on Hibernate session", ex); } } 

Answer 7

I found this article

 package com.varasofttech.client; import java.sql.Connection; import java.sql.SQLException; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.engine.jdbc.connections.spi.ConnectionProvider; import org.hibernate.engine.spi.SessionFactoryImplementor; import org.hibernate.internal.SessionImpl; import org.hibernate.jdbc.ReturningWork; import org.hibernate.jdbc.Work; import com.varasofttech.util.HibernateUtil; public class Application { public static void main(String[] args) { // Different ways to get the Connection object using Session SessionFactory sessionFactory = HibernateUtil.getSessionFactory(); Session session = sessionFactory.openSession(); // Way1 - using doWork method session.doWork(new Work() { @Override public void execute(Connection connection) throws SQLException { // do your work using connection } }); // Way2 - using doReturningWork method Connection connection = session.doReturningWork(new ReturningWork<Connection>() { @Override public Connection execute(Connection conn) throws SQLException { return conn; } }); // Way3 - using Session Impl SessionImpl sessionImpl = (SessionImpl) session; connection = sessionImpl.connection(); // do your work using connection // Way4 - using connection provider SessionFactoryImplementor sessionFactoryImplementation = (SessionFactoryImplementor) session.getSessionFactory(); ConnectionProvider connectionProvider = sessionFactoryImplementation.getConnectionProvider(); try { connection = connectionProvider.getConnection(); // do your work using connection } catch (SQLException e) { e.printStackTrace(); } } } 

It helped me.

Answer 8

This is what I use and work for me. Drag and drop the Session method into SessionImpl and easily get the connection object:

 SessionImpl sessionImpl = (SessionImpl) session; Connection conn = sessionImpl.connection(); 

where session is the name of your Hibernate session object.

Answer 9

With Hibernate > = 5.0, you can get Connection as follows:

 Connection c = sessionFactory. getSessionFactoryOptions().getServiceRegistry(). getService(ConnectionProvider.class).getConnection(); 

Answer 10

For hibenate 4.3, try the following:

 public static Connection getConnection() { EntityManager em = <code to create em>; Session ses = (Session) em.getDelegate(); SessionFactoryImpl sessionFactory = (SessionFactoryImpl) ses.getSessionFactory(); try{ connection = sessionFactory.getConnectionProvider().getConnection(); }catch(SQLException e){ ErrorMsgDialog.getInstance().setException(e); } return connection; } 

Answer 11

Try the following:

 public Connection getJavaSqlConnectionFromHibernateSession() { Session session = this.getSession(); SessionFactoryImplementor sessionFactoryImplementor = null; ConnectionProvider connectionProvider = null; java.sql.Connection connection = null; try { sessionFactoryImplementor = (SessionFactoryImplementor) session.getSessionFactory(); connectionProvider = (ConnectionProvider) sessionFactoryImplementor.getConnectionProvider().getConnection(); connection = connectionProvider.getConnection(); } catch (SQLException e) { e.printStackTrace(); } return connection; } 

Answer 12

  Connection conn = null; PreparedStatement preparedStatement = null; try { Session session = (org.hibernate.Session) em.getDelegate(); SessionFactoryImplementor sfi = (SessionFactoryImplementor) session.getSessionFactory(); ConnectionProvider cp = sfi.getConnectionProvider(); conn = cp.getConnection(); preparedStatement = conn.prepareStatement("Select id, name from Custumer"); ResultSet rs = preparedStatement.executeQuery(); while (rs.next()) { System.out.print(rs.getInt(1)); System.out.println(rs.getString(2)); } } catch (Exception e) { e.printStackTrace(); } finally { if (preparedStatement != null) { preparedStatement.close(); } if (conn != null) { conn.close(); } }