Re: unable to load oracle driver

[Erik Bruchez]

Did you put your Oracle driver in Tomcat's common/lib directory?

-Erik

Tony Tay wrote:

hi,

What did i do wrong for Oracle driver setup ?
I get this message when i execute a sql statement to a oracle database (the xpl 
snippet is listed after the error messages):
======  start of error message ================

Thread-5 INFO  servlet.ProcessorService - /examples/sql-populate - Received request
Thread-5 ERROR servlet.ProcessorService - Exception at oxf:/sql/populate.xpl, line 20, 
column 37
java.sql.SQLException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529)
 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
============== end of error message ==========
<p:input name="config">
            <sql:config>
                <sql:connection>
                    <sql:datasource>db</sql:datasource>
                    <sql:execute>
                        <sql:update>drop table friends</sql:update>
                    </sql:execute>                    
                    <dummy/>
                </sql:connection>
            </sql:config>
        </p:input>

The server.xml is also attached below:

----- START server.xml --------

<Server port="8005" shutdown="SHUTDOWN" debug="0">

    <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" 
debug="0"/>
    <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" 
debug="0"/>
    <GlobalNamingResources>
        <Resource name="UserDatabase" auth="Container"
            type="org.apache.catalina.UserDatabase"
            description="User database that can be updated and saved">
        </Resource>
        <ResourceParams name="UserDatabase">
            <parameter>
                <name>factory</name>
                <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
            </parameter>
            <parameter>
                <name>pathname</name>
                <value>conf/tomcat-users.xml</value>
            </parameter>
        </ResourceParams>
    </GlobalNamingResources>
    <Service name="Tomcat-Standalone">
        <Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
            port="8080" minProcessors="5" maxProcessors="75"
            enableLookups="true" redirectPort="8443"
            acceptCount="100" debug="0" connectionTimeout="20000"
            useURIValidationHack="false" disableUploadTimeout="true" />
        <Engine name="Standalone" defaultHost="localhost" debug="0">
            <Logger className="org.apache.catalina.logger.FileLogger"
                prefix="catalina_log." suffix=".txt"
                timestamp="true"/>
            <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
                debug="0" resourceName="UserDatabase"/>
            <Host name="localhost" debug="0" appBase="webapps"
                unpackWARs="true" autoDeploy="true">
                <Logger className="org.apache.catalina.logger.FileLogger"
                    directory="logs"  prefix="localhost_log." suffix=".txt"
                    timestamp="true"/>
                <Context path="/oxf" docBase="../../oxf-2.2" debug="10" reloadable="true" 
checkInterval="1">
                    <Resource name="jdbc/db" auth="Container" 
type="javax.sql.DataSource"/>
     <ResourceParams name="jdbc/db">
                        <parameter>
                            <name>driverClassName</name>
                            <value>oracle.jdbc.driver.OracleDriver</value>
                        </parameter>
                        <parameter>
                            <name>url</name>
                            <value>jdbc:oracle:oci:@192.168.10.147</value>
                        </parameter>
                        <parameter>
                            <name>username</name>
                            <value>test</value>
                        </parameter>
                        <parameter>
                            <name>password</name>
                            <value>test</value>
                        </parameter>
                    </ResourceParams>
                </Context>
            </Host>
        </Engine>
    </Service>
</Server>
=========================  END of server.xml ========================
Regards,
Tony
_______________________________________________
oxf-users mailing list
[EMAIL PROTECTED]
http://mail.orbeon.com/mailman/listinfo/oxf-users