Assuming it's not a typo, your "url" is broken. It should be
jdbc:oracle:thin:@myMachine:1521:myDBName not jdbc:oracle:thin:myMachine:1521:myDBName Note the '@' sign. I don't know if this would cause the error you are seeing. G. Wade Ben Anderson wrote: > > 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]
