Re: Hibernate not finding Oracle driver - despite straight JDBC working

From: IINET (mjinteractive_at_iinet.net.au)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 09:52:41 +0800

Sorry - heres my resource declareation in server.xml and the relavant
web.xml

SERVER.XML

<resource name="jdbc/webApps" auth="container" type="javax.sql.DataSource">
<resourceParams>

<paramter>
 <name>driverClassName</name>
 <value>oracle.jdbc.OracleDriver</value>
</paramter>

<paramter>
 <name>url</name>
 <value>jdbc:oracle:thin:@localhost:1521:ORCL</value>
</paramter>

<paramter>
 <name>store</name>
 <value></value>
</paramter>

<paramter>
 <name>store_password</name>
 <value></value>
</paramter>

<paramter>
 <name>maxActive</name>
 <value>20</value>
</paramter>

<paramter>
 <name>maxIdle</name>
 <value>30000</value>
</paramter>

<paramter>
 <name>maxWait</name>
 <value>100</value>
</paramter>

</resourceParams>

</resource>

WEB.XML

    <res-ref-name>jdbc/webApps</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

"IINET" <mjinteractive@iinet.net.au> wrote in message
news:41ca2459$0$7569$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> Here is my config, which is in my classpath.
>
> <hibernate-configuration>
>
> <session-factory>
>
> <property
> name="connection.datasource">java:comp/env/jdbc/webApps</property>
> <property name="show_sql">true</property>
> <property
> name="dialect">net.sf.hibernate.dialect.OracleDialect</property>
> <property
> name="connection.url">jdbc:oracle:thin:@localhost:1521:ORCL</property>
> <property
> name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
> <property name="connection.username">store</property>
> <property name="connection.password">******</property>
>
> <property
> name="transaction.factory_class">net.sf.hibernate.transaction.JDBCTransactionFactory</property>
>
>
> <!-- Mapping files -->
> <mapping resource="Person.hbm.xml"/>
>
> </session-factory>
>
> </hibernate-configuration>
>
> The only other thing I should add is that I am using Tomcat via JBuilder
> and that it is running in embedded mode -that should have nothing to do
> with the price of cheese in china, thought I should mention it anyway.
>
> I have made sure I have DBCP, my Oracle driver etc in the tomcat global
> classpath (common/lib) and have tried it just in the context classpath.
>
> Thanks for your help so far guys, really appreciated.
> "Murray" <parps@SMAFFoffSPAMMER.optusnet.SPAMMAGE.com.au> wrote in message
> news:aRnyd.85114$K7.69283@news-server.bigpond.net.au...
>>
>> "IINET" <mjinteractive@iinet.net.au> wrote in message
>> news:41c991e3$0$14973$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
>>> tomcat 5 / hibernate 2 / oracle 10g
>>>
>>> - Could not obtain connection metadata
>>> org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
>>> class '' for connect URL 'null'
>>>
>>>
>>> Been at this a few hours now - just cant get hibernate to work. I have
>>> my driver in the right place (web-inf/lib and also tried common/lib
>>> too), my config file and properties files all by the book. My tomcat
>>> JNDI resource is all set up right (its working with DBCP in its own
>>> right, so driver is working in a non hibernate situation)
>>>
>>> I have changed the sqlDialect property around a couple of time too - in
>>> case it had issue with the generic Oracle dialect and preffered the
>>> Oracle9 dialect.
>>>
>>> No luck - about to give up on Hibernate altogether (I am yet to see it
>>> work!)
>>> This issue seems to be suggesting my tomcat JNDI set up is
>>> incorrect -but its not! Its working just fine using straight JDBC
>>> lookups.
>>>
>>> Any help at all would be appreciated - even sympathy would do.
>>>
>>> Andles
>>
>> Can't really help you unless you provide your config files. I'm currently
>> running Hibernate with Oracle and have had no problems.
>>
>
>