I don't see your comments about myDS and fsaDS. Can you echo them again. :)
Thanks, Robert Wynkoop -----Original Message----- From: Kevin Passey [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:55 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName' No the xml file should be called myapp.xml in webapps along with your war file Did you note my other comment about myDS and fsaDS that looks like it's more your problem. Leave it how you had it and just change that - stop and start tomcat and see if that flies. Regards Kevin -----Original Message----- From: Wynkoop, Robert M [mailto:[EMAIL PROTECTED] Sent: 11 September 2003 14:54 To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName' I thought about this and then went into the Tomcat admin. Under service/localhost/context<myapp> When I click Datasource(under my apps context) I get the error: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 54) in my browser window. My app is at p:.../somename/web/WEB-INF/. So are you telling me I need to create a file called web.xml. Can't do that. I already have my real web.xml there. Where can I find more information on this config file in the tomcat docs? Later, Robert Wynkoop -----Original Message----- From: Kevin Passey [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:26 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' 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] --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
