How to get jdbc connection in Hibernate 4

[ohmygod]

In Hibernate 3, we can get jdbc connection with following code

ConnectionProvider connectionProvider = ConnectionProviderFactory.newConnectionProvider(properties);
Connection connection = connectionProvider.getConnection();

These classes and apis have been duplicated in Hibernate 4. So the question is how to get the connection in Hibernate 4.

[ohmygod]

Does somebody know how to get a jdbc connection using the properties to replace this line?

ConnectionProvider connectionProvider = ConnectionProviderFactory.newConnectionProvider(properties);

[ohmygod]

No one has a clue for this problem?

Another similar question is how to get a jdbc connection by a given session? In Hibernate 3, it is easy to get a connection by session.connection() method. I know there is a session.doWork() method but it only does things in the execute() method. How can I get the connection and use it outside of the execute() method?

[jaikiran]

Questions related to Hibernate specific API are better answered in the Hibernate forums https://forum.hibernate.org/viewforum.php?f=1&start=0