JNDI jdbc resource

[John Reynolds <Jo...@esfrs.org>]

I am trying to configure JNDI resources on tomcat 5, i used the admin
tool to setup the resource, and checked the server.xml with
documentation on the tomcat site, i have copied the mysql jdbc driver
jar into commons/lib.


when i deploy an application that uses this resource, the following
exption is thrown 

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null'
	at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
	at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at
com.storbit.helpdesk.config.HelpdeskConfig.<init>(HelpdeskConfig.java:25)
	at
com.storbit.helpdesk.servlets.SignonFilter.init(SignonFilter.java:31)
	at
org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)
	at
org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:308)
	at
org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:79)
	at
org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3698)
	at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4349)
	at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
	at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
	at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
	at
org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer.java:903)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
	at
org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)
	at org.apache.commons.digester.Rule.end(Rule.java:276)
	at
org.apache.commons.digester.Digester.endElement(Digester.java:1058)
	at
org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76)
	at
org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
	at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown
Source)
	at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
Source)
	at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown
Source)
	at
org.apache.commons.digester.Digester.parse(Digester.java:1567)
	at
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488)
	at
org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
	at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483)
	at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
	at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
	at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
	at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
	at
org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
	at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
	at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
	at
org.apache.catalina.core.StandardService.start(StandardService.java:480)
	at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
	at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:243)
	at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
	... 50 more


any help would be appreciated
John


John Reynolds CNE CDE
ICT Network Services Manager
East Sussex Fire & Rescue Service

20 Upperton Road
Eastbourne
East Sussex
BN21 1EU

Tel: 01323 462239
Fax: 01323 462041

E-mail:john.reynolds@esfrs.org
Web: www.esfrs.org

This message is intended for the use of
the addressee(s) only and may contain
confidential or privileged information.
Any views or opinions expressed in this
e-mail or any files attached are those of
the sender and may not represent the views of 
East Sussex Fire & Rescue Service. 
If you have received it in error please notify
the sender and destroy it.
You may not use it or copy it to anyone else.
E-mail is not a secure communications medium,
please be aware of this when replying.
Although East Sussex Fire & Rescue Service
has taken steps to ensure that this e-mail
and any attachments are virus free,
we can take no responsibility if a virus is
actually present and you are advised to
ensure that the appropriate checks are made.