DataSource without JNDI

dford · **Joined:** Wed Sep 03, 2003 10:40 am **Posts:** 6

Is there a way to configure Hibernate to use an existing DataSource instance without first putting the dataSource in JNDI?

I am already using a dataSource in the app and I don't like to duplicate information.

For example, it would be convenient if there was something like this:

hibConfig.setDataSource(myDataSource)

simonwillnauer · **Posted:** Sat Mar 11, 2006 12:19 pm

Hey,

do you use a kind of a "HibernateSessionFactory" where you get your Sessions from a SessionFactory? So you could use the following Code...

Code:

DataSourc dataSource = new DataSource(); // get it from somewhere
Session retVal = sessionFactory.openSession(dataSource.getConnection());

simon

drooler · **Joined:** Tue Jun 29, 2004 12:35 pm **Posts:** 21

simonwillnauer wrote:

Code:

DataSourc dataSource = new DataSource(); // get it from somewhere
Session retVal = sessionFactory.openSession(dataSource.getConnection());

From Javadoc sessionFactory.openSession(dataSource.getConnection()):

Note that the second-level cache will be disabled if you supply a JDBC connection. Hibernate will not be able to track any statements you might have executed in the same transaction. Consider implementing your own ConnectionProvider.

But if you don't need second-level caching...

simonwillnauer · **Posted:** Mon Mar 13, 2006 4:51 am

In you app server you have a jndi datasource but for local testing or something similar you don't need to supply jndi datasource.....

that won't be a problem without the 2nd level cache...

simon