How to get jdbc connection from hibernate session?

Question

I want to get jdbc connection from hibernate session.There is method inside hibernate session i.e session.connection(); but it has been deprecated. i know this works still but i dont want to use deprecated method as i am sure they must have provide some alternative for this? At http://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/Session.html connection method api says using org.hibernate.jdbc.Work for this purpose but i dont find any example for that?

If anyone marks a question as a duplicate please include a link to one of the other questions that already has an answer, — Lars Juel Jensen, Oct 01 '15 at 09:15

score 96 · Accepted Answer · answered Feb 28 '12 at 13:30

96

Here is how you can use it:

session.doWork(new Work() {
    @Override
    public void execute(Connection connection) throws SQLException {
        //connection, finally!
    }
});

answered Feb 28 '12 at 13:30

Tomasz Nurkiewicz

334,321
69
703
674

Question: I get `doWork is not valid without active transaction` with this code, how to I start a transaction? – OscarRyz Dec 06 '12 at 20:52
2

@OscarRyz: if you are using Spring, `@Transactional` or `TransactionTemplate` is enough. In raw Hibernate you must [run `session.beginTransaction()` manually](http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/transactions.html#transactions-basics). – Tomasz Nurkiewicz Dec 06 '12 at 20:55
Hi Buddy.. Nice answer but doWork() is also deprecated now. – Logicalj Jan 09 '13 at 10:33
2

@Logicalj: can you provide some reference? It's [still valid in 4.1](http://docs.jboss.org/hibernate/orm/4.1/javadocs/org/hibernate/Session.html#doWork(org.hibernate.jdbc.Work))... – Tomasz Nurkiewicz Jan 09 '13 at 11:14
5

also worth to mention, there is a doReturningWork(...) method if you want to return a result. – Chris Apr 30 '14 at 16:55
@Chris, really worth, I think you should post it as an answer. – Nikita Bosik Jul 13 '16 at 16:55
In Java 8 you can do ```session.doWork(connection -> yourMethodInsideDoWork(connection))``` or even ```session.doWork(this::yourMethodInsideDoWork)``` – Optio Jun 14 '17 at 09:12
Hi everyone. This video has more information: https://www.youtube.com/watch?v=cCcfZ4QQAiM – Eder Armando Anillo Lora Mar 01 '23 at 20:35

score 29 · Answer 2 · edited May 04 '13 at 05:37

29

Try this:

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

edited May 04 '13 at 05:37

Anthon

69,918
32
186
246

answered May 04 '13 at 02:12

Mohammad Hosseini

443
5
3

11

To anyone who gets here unwarned (just like me): the [`Session.connection`](http://docs.jboss.org/hibernate/core/3.5/api/org/hibernate/Session.html#connection%28%29) method is currently deprecated. – Dinei Jun 13 '15 at 21:20
5

never cast to an Impl! its internal! (org.hibernate.internal.SessionImpl). And you cannot test this code with a mock anymore. This is bad for many reasons. – Rainer Jun 27 '16 at 17:16

score 12 · Answer 3 · edited Aug 21 '15 at 07:43

12

I had a similar Problem and I used the ConnectionProvider class to get the connection. See my solution:

Session session = entityManager.unwrap(Session.class);
SessionFactoryImplementor sessionFactoryImplementation = (SessionFactoryImplementor) session.getSessionFactory();
ConnectionProvider connectionProvider = sessionFactoryImplementation.getConnectionProvider();
try {
       connection = connectionProvider.getConnection();
       ...
}

edited Aug 21 '15 at 07:43

awesoon

32,469
11
74
99

answered Apr 26 '13 at 11:03

OldFabiotta

121
1
4

1

Can you add a brief explanation of how this solves the problem? – Ren Apr 26 '13 at 11:23
8

sessionFactoryImplementation.getConnectionProvider() is depricated – vels4j Feb 18 '15 at 17:41
I cannot see that method in Hibernate 5.2.9 – luca.vercelli Jun 16 '20 at 08:26

How to get jdbc connection from hibernate session?

3 Answers3

Linked