Having just gone through a similar issue last week, I can recommend searching the archives (and maybe the bug database). You'll probably find your solution.
If you're getting this error when you start up Tomcat, then it's probably fixable (you may have a JAR in the wrong place, etc.) If you're getting this error after doing a hot redeploy, then you may not get it to work TC4. At least, that's the conclusion I've reached. Note that two responses to my issue said that their problems went away with TC5, but after making the switch yesterday, I still don't have Tomcat re-recognizing the resource after a hot redeploy. I'm still working on it... Jay -----Original Message----- From: Kumar Abhay-CAK203C [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 9:46 AM To: [EMAIL PROTECTED] Subject: No Suitable Driver Error -- Still No Success Importance: High Hi , I am getting the following error in JDBC connection pooling. Error log and other details are as follows: Please help !! Regards Abhay ------------------------------------------------------------------------ ------------------------------------- I am using :== Apache Tomcat/4.1.29 SQL*Plus: Release 9.0.1.4.0 - Production on Mon Feb 2 09:39:33 2004 Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production j2sdk1.4.2_03 ojdbc14.jar -----------------------ERROR-------------------------------------------- --------------------------------- Feb 3, 2004 9:36:40 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true Looking up jdbc/estimation Found Feb 3, 2004 9:36:52 AM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on port 80 Feb 3, 2004 9:36:53 AM org.apache.jk.common.ChannelSocket init INFO: JK2: ajp13 listening on /0.0.0.0:8009 Feb 3, 2004 9:36:53 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=40/270 config=C:\Tomcat\bin\..\conf\jk2.properties 2004-02-03 09:37:29,921 [http80-Processor4] DEBUG (class com.mot.iDEN.webapp.oes.tags.GetCurrListTag ) - -->-->GetCurrListTag.doStartTag() 2004-02-03 09:37:29,941 [http80-Processor4] DEBUG (class com.mot.iDEN.webapp.oes.tags.GetCurrListTag ) - -->-->GetCurrListTag.getTestData() 2004-02-03 09:37:30,081 [http80-Processor4] DEBUG (class com.mot.iDEN.webapp.oes.factory.AdminFactor y) - -->-->AdminFactory.getTestData() **1** **2** **3** Caught while creating a connection in EPP dB:=org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: No suitable driver 2004-02-03 09:37:30,161 [http80-Processor4] ERROR (class com.mot.iDEN.webapp.oes.factory.AdminFactor y) - AdminFactory.getTestData java.lang.NullPointerException at com.mot.iDEN.webapp.oes.config.EstimationConfigurator.getEstimationConne ction(EstimationC onfigurator.java:193) at com.mot.iDEN.webapp.oes.factory.AdminFactory.getTestData(AdminFactory.ja va:3492) at com.mot.iDEN.webapp.oes.tags.GetCurrListTag.getTestData(GetCurrListTag.j ava:1268) at com.mot.iDEN.webapp.oes.tags.GetCurrListTag.doStartTag(GetCurrListTag.ja va:745) at org.apache.jsp.oes_db_test_jsp._jspService(oes_db_test_jsp.java:73) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:210) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.j ava:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(Standar dPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(Standar dPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241 7) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(Standar dPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(Standar dPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(Standar dPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(Standar dPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:78 1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11P rotocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:58 9) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:666) at java.lang.Thread.run(Thread.java:534) 2004-02-03 09:37:30,241 [http80-Processor4] ERROR (class com.mot.iDEN.webapp.oes.factory.AdminFactor y) - Database is down 2004-02-03 09:37:30,251 [http80-Processor4] ERROR (class com.mot.iDEN.webapp.oes.tags.GetCurrListTag ) - java.sql.SQLException: 20439#0 -----------------------------------------------------SERVER>XML file------------------------- <Resource name="jdbc/estimation" scope="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/estimation"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>validationQuery</name> <value>select sysdate from dual</value> </parameter> <parameter> <name>maxWait</name> <value>-1</value> </parameter> <parameter> <name>maxActive</name> <value>10</value> </parameter> <parameter> <name>password</name> <value>eppsys</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:@oswego.comm.mot.com:1521:remedydb</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>5</value> </parameter> <parameter> <name>username</name> <value>eppsys</value> </parameter> </ResourceParams> -----------------------------------------------CODE--------------------- ------------------------------------- String lookup = "java:comp/env/jdbc/estimation"; System.out.println("**1**"); Context context = new InitialContext(); System.out.println("**2**"); estimationConDS = (DataSource)context.lookup(lookup); System.out.println("**3**"); conn = estimationConDS.getConnection(); System.out.println("**4**"); context.close(); System.out.println("**5**"); } catch(Exception ex) { System.out.println("Caught while creating a connection in EPP dB:="+ex); } --------------------------------------------------CLASSPATH------------- ------------------------------------------ C:\Estimation\src>set classpath=.;C:\j2sdk1.4.2_03\lib\tools.jar;..\web-inf\classes;..\web-inf \lib\cos.jar;..\web-inf\lib\jnlp.jar;..\web-inf\lib\log4j.jar;..\web-inf \lib\xml4j.jar;..\web-inf\lib\ldapjdk.jar;..\web-inf\lib\ldapsearch.jar; .;C:\Estimation;C:\Tomcat\common\lib\servlet.jar;C:\Tomcat\common\lib\ma il.jar;C:\Tomcat\common\lib\activation.jar;C:\Tomcat\common\lib\jndi.jar ;C:\Tomcat\common\lib\classes12.jar;C:\Tomcat\common\lib\commons-collect ions.jar;C:Tomcat\common\lib\commons-dbcp-1.1.jar;C:\Tomcat\common\lib\c ommons-pool-1.1.jar;C:\Tomcat\common\lib\jdbc2_0-stdext.jar;C:Tomcat\com mon\lib\ojdbc14.jar;C:\Tomcat\common\lib\classes111.jar;C:\Tomcat\common \lib\ocrs12.jar; --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
