RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException:

[Ben Anderson <st...@hotmail.com>]

whoops - the myDS and fsaDS was a copy and paste error on my part.  
Attempting to not include "private" info, I try to change everything to 
mySomething.  This is not my problem - sorry about the mixup.  I will try 
the myApp.xml solution.
Thanks,
Ben


>From: "Wynkoop, Robert M" <ro...@citigroup.com>
>Reply-To: "Tomcat Users List" <to...@jakarta.apache.org>
>To: "'Tomcat Users List'" <to...@jakarta.apache.org>
>Subject: RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja 
>sperException: Exception retrieving attribute 'driverClassName'
>Date: Thu, 11 Sep 2003 10:06:12 -0400
>
>I don't see your comments about myDS and fsaDS.  Can you echo them again.
>:)
>
>Thanks,
>
>
>Robert Wynkoop
>
>-----Original Message-----
>From: Kevin Passey [mailto:kpassey@kdpsoftware.co.uk]
>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:robert.m.wynkoop@citigroup.com]
>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:kpassey@kdpsoftware.co.uk]
>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:stuts_andersonbd1@hotmail.com]
>Sent: 11 September 2003 13:17
>To: tomcat-user@jakarta.apache.org
>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: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>

_________________________________________________________________
Compare Cable, DSL or Satellite plans: As low as $29.95.  
https://broadband.msn.com