Rather than changing your server XML create an xml file in your webapps directory with the same name as your app directory.
Here is an example:- - <Context className="org.apache.catalina.core.StandardContext" crossContext="false" reloadable="false" mapperClass="org.apache.catalina.core.StandardContextMapper" useNaming="true" debug="0" swallowOutput="false" privileged="false" displayName="Shilton" wrapperClass="org.apache.catalina.core.StandardWrapper" docBase="C:/Tomcat4.1/webapps/shilton" cookies="true" path="/shilton" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper"> <Resource name="mail/Session" scope="Shareable" type="javax.mail.Session" auth="Container" description="Resource reference to a factory for javax.mail.Session instances that may be used for sending electronic mail messages, preconfigured to connect to the appropriate SMTP server." /> <Resource name="jdbc/shiltonDB" auth="Container" type="javax.sql.DataSource" /> - <ResourceParams name="jdbc/shiltonDB"> - <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> - <parameter> <name>maxActive</name> <value>100</value> </parameter> - <parameter> <name>maxIdle</name> <value>5</value> </parameter> - <parameter> <name>maxWait</name> <value>100</value> </parameter> - <parameter> <name>username</name> <value>INTERNET</value> </parameter> - <parameter> <name>password</name> <value>**********</value> </parameter> - <parameter> <name>driverClassName</name> <value>com.ibm.as400.access.AS400JDBCDriver</value> </parameter> - <parameter> <name>url</name> <value>jdbc:as400://REX</value> </parameter> </ResourceParams> </Context> Stop and re-start Tomcat and hey presto!! OK I mine is for DB2 on an iSeries - by hey it works !! Anyway shouldn't your Web XML file have myDS not fsaDS. Good luck Kevin -----Original Message----- From: Ben Anderson [mailto:[EMAIL PROTECTED] Sent: 11 September 2003 13:17 To: [EMAIL PROTECTED] Subject: Cannot load JDBC driver class 'null' Ok, I know this topic has been posted many times, but I can't find anything to help. I have OracleDriver in [$CATALINA_HOME]/common/lib here's my server.xml <GlobalNamingResources> ...................... <Resource name="myDS" scope="Shareable" type="javax.sql.DataSource" auth="Container"/> <ResourceParams name="myDS"> <parameter> <name>validationQuery</name> <value>select user from dual;</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:myMachine:1521:myDBName</value> </parameter> <parameter> <name>username</name> <value>hris</value> </parameter> <parameter> <name>password</name> <value>****</value> </parameter> <parameter> <name>maxActive</name> <value>4</value> </parameter> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>2</value> </parameter> </ResourceParams> </GlobalNamingResources> and my web.xml: <resource-ref> <res-ref-name>jdbc/fsaDS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref> in the administrative tool: the top level Resources->DataSources looks ok as MyDS is listed there but the /my_context->Resources->Datasources gives: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' and the localhost_log.xxx.txt (when it tries to use myDS): java.sql.SQLException: Cannot load JDBC driver class 'null Any help would be great - I've been trying everything - reloading with different configurations about 50 times - looking through books, mailing lists/archives. Thanks, Ben _________________________________________________________________ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
