Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

JNDI resource error

BATCHELOR, SCOTT (CONTRACTOR)

2005-08-31

Replies:

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:@(protected)>
   </parameter>
   <parameter>
    <name>username</name>
    <value>uname</value>
   </parameter>
   <parameter>
    <name>password</name>
    <value>pword</value>
   </parameter>
   <parameter>
    <name>validationQuery</name>
    <value>select sysdate from dual</value>
   </parameter>
   <parameter>
    <name>maxIdle</name>
    <value>2</value>
   </parameter>
   <parameter>
    <name>maxActive</name>
    <value>20</value>
   </parameter>
   <parameter>
    <name>maxWait</name>
    <value>5000</value>
   </parameter>
   <parameter>
    <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
   </parameter>  
  </ResourceParams>
</GlobalNamingResources>
<Service name="Catalina">
  <Connector acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" port="8080" redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25">
  </Connector>
  <Connector port="8009" protocol="AJP/1.3" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443">
  </Connector>
  <Engine defaultHost="localhost" name="Catalina">
   <Host appBase="webapps" name="localhost">
    <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_log." suffix=".txt" timestamp="true"/>
   </Host>
   <Logger className="org.apache.catalina.logger.FileLogger" prefix="catalina_log." suffix=".txt" timestamp="true"/>
   <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
  </Engine>
</Service>
</Server>




Tomcat 5.0 and I do have the ojdbc drive in commons/lib with the proper permissions

Any help would be greatly, greatly apprecaited!

-Batch  



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)

©2008 junlu.com - Jax Systems, LLC, U.S.A.