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 10:35:15 +0800

Just an update:
I can get it going now using a Driver_class property, but NOT with a
datasource property. I want to use my datasource set up though.

I have to say. the documentation for this stuff is very misleading and not
at all clear. Even reading 'professional Hibernate" is very weak on set up.
(Actually that whole book is a bit of a joke -there isn't an ounce of source
code in there that would comiple and th etypos and grammar is the worst I
have ever seen - and I have read a LOT of tech books!)

Anyway, I am starting to see a few places I may be going wrong - for example
having a driver_class AND a datasource property was likely not a clever
thing to do!

Getting closer....
"IINET" <mjinteractive@iinet.net.au> wrote in message
news:41ca24e9$0$7593$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> 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.
>>>
>>
>>
>
>