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

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

  • Next message: IINET: "Re: Hibernate not finding Oracle driver - despite straight JDBC working" 
    Date: Thu, 23 Dec 2004 09:50:18 +0800

    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.
    >

  • Next message: IINET: "Re: Hibernate not finding Oracle driver - despite straight JDBC working"

    Relevant Pages