Get Hibernate session from JDBC Connection object?

Question

I have a JDBC Connection object which I want to convert into Hibrenate Session.

Is there any way by which I can achieve this?

I am tried googling, but I'm getting result vice versa.

Got my answer http://stackoverflow.com/questions/10731266/sessionfactory-opensessionconnection-in-hibernate-4 — Sachin Mhetre, Aug 30 '16 at 06:26

score 0 · Answer 1 · answered Aug 26 '16 at 15:57

0

How about this?

Session session = getSessionFactory().openSession();

session.doSomethingWorthwhile(new Worthwhile() {
    @Override
    public void execute(Connection connection) {
    //Do something great with SQL here
    }
}

answered Aug 26 '16 at 15:57

James McGuigan

107
1
6

score 0 · Answer 2 · answered Aug 26 '16 at 16:02

You have to use the SessionFactory to create a session with the connection. Call SessionFactory.openSession(Connection)

As the javadoc says, it's better to provide a custom ConnectionProvider (but depends on your scenario).

I've used this in the past when I had to use a connection that was opened with the username/password of each user (good old days).

Get Hibernate session from JDBC Connection object?

2 Answers2