Hi Scott,
Try doing this. Create a new file under \Tomcat
5.0\conf\Catalina\localhost\xyz.xml where xyz is the
name of your application under webapps (by default,
you will be having admin, balancer,.... etc). Content
of the file should like this...
<?xml version='1.0' encoding='utf-8'?>
<Context crossContext="true" debug="5"
displayName="XYZ Application" docBase="xyz"
path="/xyz" reloadable="true"
workDir="work\Catalina\localhost\xyz">
<Logger
className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBConnector_log." suffix=".txt"
timestamp="true"/>
<Resource auth="Container" name="jdbc/DBCPool"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/DBCPool">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/YourDBName?autoReconnect=true</value>
</parameter>
<parameter>
<name>password</name>
<value>PASSWORD</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>USERNAME</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
</ResourceParams>
</Context>
Try doing this... It doesn't make sense having the
samething at two different places, but thats how it
worked for me. Let me know if you get a better
solution.
Thanks
Sunjay
--- "BATCHELOR, SCOTT (CONTRACTOR)"
<[EMAIL PROTECTED]> wrote:
> Here is my web.xml...Thank you for your prompt
> response.
>
> <?xml version = '1.0' encoding = 'windows-1252'?>
> <!DOCTYPE web-app PUBLIC "-//Sun Microsystems,
> Inc.//DTD Web Application 2.3//EN"
> "http://java.sun.com/dtd/web-app_2_3.dtd";>
> <web-app>
> <description>web.xml file for TEST
> Application</description>
> <servlet>
> <servlet-name>controller</servlet-name>
>
>
<servlet-class>org.ncaa.TES.Servlets.TESControllerServlet</servlet-class>
> <init-param>
> <param-name>config</param-name>
>
> <param-value>/WEB-INF/app.xml</param-value>
> </init-param>
> <init-param>
> <param-name>properties</param-name>
>
> <param-value>/velocity.properties</param-value>
> </init-param>
> <init-param>
> <param-name>mail-session</param-name>
> <param-value>mail/Session</param-value>
> </init-param>
> <init-param>
> <param-name>datasource</param-name>
> <param-value>jdbc/iss_dev</param-value>
> </init-param>
> </servlet>
> <servlet-mapping>
> <servlet-name>controller</servlet-name>
> <url-pattern>/exec/*</url-pattern>
> </servlet-mapping>
> <session-config>
> <session-timeout>35</session-timeout>
> </session-config>
> <mime-mapping>
> <extension>html</extension>
> <mime-type>text/html</mime-type>
> </mime-mapping>
> <mime-mapping>
> <extension>txt</extension>
> <mime-type>text/plain</mime-type>
> </mime-mapping>
> <mime-mapping>
> <extension>xml</extension>
> <mime-type>text/xml</mime-type>
> </mime-mapping>
> <mime-mapping>
> <extension>pdf</extension>
> <mime-type>application/pdf</mime-type>
> </mime-mapping>
> <resource-ref>
> <description>Oracle Datasource
> example</description>
> <res-ref-name>jdbc/iss_dev</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
>
> </web-app>
>
> ======================
> Scott Batchelor
> Web Services Administrator
> [EMAIL PROTECTED]
> (317)510-7389
>
>
>
> -----Original Message-----
> From: Brian Cook [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 31, 2005 3:14 PM
> To: Tomcat Users List
> Subject: Re: JNDI resource error
>
>
>
> That error means that Tomcat could not find the JNDI
> resource requested
> in either the web.xml, and or context.xml files.
> What do they look like?
>
>
>
> BATCHELOR, SCOTT (CONTRACTOR) wrote:
> > Can anyone give me some insite on this???
> >
> > I am getting this error:
> >
> > 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
>
org.ncaa.TES.Servlets.TESControllerServlet.init(TESControllerServlet.java:46)
> > at
>
javax.servlet.GenericServlet.init(GenericServlet.java:211)
> > at
>
org.apache.velocity.servlet.VelocityServlet.init(VelocityServlet.java:193)
> > at
>
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1029)
> > at
>
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:687)
> > at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:144)
> > at
>
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> > at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> > at
>
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
> > at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
> > at
>
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> > at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> > at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
> > at
>
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> > at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
> > at
>
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
> > at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> > at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> > at
>
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> > at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> > at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
> > at
>
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
> > at
>
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
> > at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
> > at
>
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
> > at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
> > at java.lang.Thread.run(Unknown Source)
> >
> > Caused by: java.sql.SQLException: No suitable
> driver
> > at java.sql.DriverManager.getDriver(Unknown
> Source)
> > at
>
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
> >
> > And here is my server.xml:
> > <?xml version='1.0' encoding='utf-8'?>
> > <Server>
> > <Listener
>
className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
> > <Listener
>
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
> > <GlobalNamingResources>
> > <Environment name="simpleValue"
> type="java.lang.Integer" value="30"/>
> > <Resource auth="Container" description="User
> database that can be updated and saved"
> name="UserDatabase"
> type="org.apache.catalina.UserDatabase"/>
> > <Resource auth="Container" name="jdbc/iss_dev"
> type="javax.sql.DataSource"/>
> > <ResourceParams name="UserDatabase">
> > <parameter>
> > <name>factory</name>
> >
>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
> > </parameter>
> > <parameter>
> > <name>pathname</name>
> > <value>conf/tomcat-users.xml</value>
> > </parameter>
> > </ResourceParams>
> > <ResourceParams name="jdbc/iss_dev">
> > <parameter>
> > <name>driverClassName</name>
> >
> <value>oracle.jdbc.driver.OracleDriver</value>
> > </parameter>
> > <parameter>
> > <name>url</name>
> >
>
<value>jdbc:oracle:thin:@hostname:1521:database</value>
> > </parameter>
>
=== message truncated ===
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
