How to get java.sql.Connection object from Hibernate Session

Question

I have requirement where I need java.sql.Connection. But I am using Hibernate here. Somehow I researched and I found below alternative but that's not working.

import org.hibernate.connection.ProxoolConnectionProvider;
public class ConnectionDB{
    //I have imported below class 
    ProxoolConnectionProvider proxoolProvider = new ProxoolConnectionProvider();
    org.hibernate.cfg.Configuration cfg = HibernateUtil.getConfiguration();//this method will return configuration 
    java.util.Properties props =  cfg.getProperties();//This will return Properties Object
    //Using properties object I just tried to get The Connection Object by following method
    proxoolConn.configure(props);// I just configured the Porperties object 
    proxoolConn.getConnection();
}

But no luck I just end-up with no exception in console .. I am using Struts 2, Hibernate and JasperReports.

Can any one help me to get the connection object from Hibernate?

What version of Hibernate are you using?

Muel
– Muel

2014-06-11 00:44:36 +00:00
Commented Jun 11, 2014 at 0:44 — Muel
– Muel, Commented Jun 11, 2014 at 0:44
@Muel hibernate3.jar I can see in my library..

Rookie007
– Rookie007

2014-06-11 00:49:02 +00:00
Commented Jun 11, 2014 at 0:49 — Rookie007
– Rookie007, Commented Jun 11, 2014 at 0:49

Muel · Accepted Answer · 2014-06-11 00:52:33Z

7

The following code assumes you have an existing and open Hibernate org.hibernate.Session:

public void doWorkOnConnection(Session session) {
  session.doWork(new Work() {
    public void execute(Connection connection) throws SQLException {
      //use the connection here...
    }
  });
}

Should you need information on how to use the above classes, please read the Hibernate 3.5 Javadoc. Specifically, read Session and then Work.

answered Jun 11, 2014 at 0:52

Muel

4,4532 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Optio Over a year ago

In Java 8 you can do session.doWork(connection -> yourMethodInsideDoWork(connection)) or even session.doWork(this::yourMethodInsideDoWork)

Simon Mbatia · Accepted Answer · 2015-05-17 09:48:50Z

1

You can also downcast the Session method into a SessionImpl and get the connection object easily:

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

answered May 17, 2015 at 9:48

Simon Mbatia

3011 gold badge3 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to get java.sql.Connection object from Hibernate Session

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related