Hibernate Datasource Connection

rajesh_css · October 6th, 2009, 10:29 PM

Hi,
I am using Spring +hibernate+oracle 11g+websphere AS

for connecting to database which is the best way of doing from hibernate

directly configuring

Code:

 <property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
      <property name="hibernate.connection.url">jdbc:oracle:thin:@MYSYSTEM:1521:ORCL</property>
      <property name="hibernate.connection.username">SYSTEM</property>
      <property name="hibernate.connection.password">password</property>
      <property name="hibernate.connection.pool_size">30</property>
      <property name="dialect">org.hibernate.dialect.OracleDialect</property>

or
JNDI lookup

Code:

<property name="hibernate.connection.datasource">java:comp/env/iam</property>
      <property name="dialect">org.hibernate.dialect.OracleDialect</property>

when i am using jndi lookup from Websphere AS i am getting java out of memory error some times..

suggest me which is good approach..

iamrakesh22 · October 9th, 2009, 06:11 AM

As far as i know, Its always best to let the app/web server handle Connection pool.