Hi,

I want to introduce Hibernate to an existing project that uses plain JDBC connections for DB access so far. I may not replace all existing JDBC code, but I could use Hibernate functionality for all new modules.

The existing application uses real database accounts where a new JDBC connection is created for each user during login. It is a mandatory requirement for me to keep this architecture. Another requirement is to reuse the existing JDBC connection.

Is this possible with Hibernate? How can this be done? How do I have to configure Hibernate to achieve such a solution?

Best regards,
Ralf.

Configure your SessionFactory with out database properties like URL, username and pasword.

Then whenever you call openSession method on SessionFactory, supply your current Connection.



So this way, session always uses your connection. But you will lose some benefits that hibernate offers when you use your own connection. One of them is Second Level Cache will be disabled.

Other options to use existing project JDBC Connection is configure the ConnectionProvider with SessionFactory. And then make this ConnectionProvider to use your database properties to make connections.