tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wynkoop, Robert M" <robert.m.wynk...@citigroup.com>
Subject RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName'
Date Thu, 11 Sep 2003 14:06:12 GMT
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

Mime
View raw message