Connection Pool (couldn't find datasource)

[Michael Houlo]

Dear,

I'm trying to use my application server connection pool trought Hibernate.

When i use hibernate without a connection pool, it works.
When i use my connection pool without hibernate, it works.
When i use my connection pool with hibernate, i've got the following error :

cause mère 

java.lang.ExceptionInInitializerError
	HibernateUtil.<clinit>(HibernateUtil.java:26)
	MyConnection.doPost(MyConnection.java:53)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:713)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:806)


cause mère 

org.hibernate.HibernateException: Could not find datasource
	org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:56)
	org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
	org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
	org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414)
	org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
	org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
	org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
	HibernateUtil.<clinit>(HibernateUtil.java:20)
	MyConnection.doPost(MyConnection.java:53)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:713)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:806)


cause mère 

javax.naming.NotContextException: java:comp:env/jdbc/oracleJNDI
	org.apache.xbean.naming.context.AbstractContext.lookup(AbstractContext.java:171)
	org.apache.xbean.naming.context.AbstractContext.lookup(AbstractContext.java:611)
	javax.naming.InitialContext.lookup(Unknown Source)
	org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
	org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
	org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
	org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414)
	org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
	org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
	org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
	HibernateUtil.<clinit>(HibernateUtil.java:20)

my web.xml :

  <resource-ref>
	   	<res-ref-name>jdbc/oracleJNDI</res-ref-name>
	   	<res-type>javax.sql.DataSource</res-type>
	   	<res-auth>Container</res-auth>
	   	<res-sharing-scope>Shareable</res-sharing-scope>
	</resource-ref> 

my geronimo.xml

    <dep:environment>
        <dep:moduleId>
            <dep:groupId>default</dep:groupId>
            <dep:artifactId>YPOOL</dep:artifactId>
            <dep:version>1.0</dep:version>
            <dep:type>car</dep:type>
        </dep:moduleId>
        <dep:dependencies>
        	<dep:dependency>
        		<dep:groupId>console.dbpool</dep:groupId>
        		<dep:artifactId>jdbc_oracleJNDI</dep:artifactId>
        	</dep:dependency>
        </dep:dependencies>
    </dep:environment>
    <web:context-root>/YPOOL</web:context-root>
    <name:resource-ref>
        <name:ref-name>jdbc/oracleJNDI</name:ref-name>
        <name:resource-link>jdbc/oracleJNDI</name:resource-link>
    </name:resource-ref>

my hibernate.cfg.xml

  <session-factory>
       <!-- <property name="hibernate.connection.datasource">java:/comp/env/jdbc/oracleJNDI</property>
        <property name="hibernate.transaction.factory_class"> org.hibernate.transaction.CMTTransactionFactory</property>
        <property name="hibernate.transaction.manager_lookup_class"> org.hibernate.transaction.websphereExtendedJTATransactionLookup </property>
         --> 
        <property name="connection.datasource">java:comp:env/jdbc/oracleJNDI</property>
       
      <!-- <property name="jndi.url">t3://localhost:8080</property>
        <property name="jndi.class">weblogic.jndi.WLInitialContextFactory</property>
       -->  
        <property name="show_sql"> true </property>
        <property name="dialect"> org.hibernate.dialect.Oracle10gDialect </property>
    </session-factory>

I use a "HibernateUtil" class, the error appears at the following code line :

   // Create the SessionFactory
            sessionFactory = new Configuration().configure().buildSessionFactory();

Could you please tell me what am I missing ?
I tryed X different configurations, always the same problem..
Thanks a lot !

[Arun Kumarr]

1. You might want to check JNDI naming conventions (in general and for geronimo).
2. Use Geronimo's Admin Interface to actually check under what name the JNDI object is bound. You can use that for looking up.

This Link might be helpful.

[Michael Houlo]

I fixed it, thanks a lot anyway

[David O'Meara]

Can you post the solution please?
I'm guessing your JNDI URL was incorrect.

[Michael Houlo]

David O'Meara wrote:Can you post the solution please?
I'm guessing your JNDI URL was incorrect.

You're right.
I had to specify a new dependency in my geronimo-web.xml using this synthax : <dep:artifactId>jdbc_oracleJndi</dep:artifact>
and then link it this way :

<name:resource-ref>
<name:ref-name>whateveryouwant</name:ref-name> (This is the logical name you'll use in your app)
<name:resource-link>jdbc/oracleJndi</name:resource-link> (This is the name you defined in your app server)
</name:resource-ref>

Hope it helps.