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.getEstimationConnection(EstimationC onfigurator.java:193) at com.mot.iDEN.webapp.oes.factory.AdminFactory.getTestData(AdminFactory.java:3492) at com.mot.iDEN.webapp.oes.tags.GetCurrListTag.getTestData(GetCurrListTag.java:1268) at com.mot.iDEN.webapp.oes.tags.GetCurrListTag.doStartTag(GetCurrListTag.java: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.java: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(ApplicationFilterChain.j ava:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar dPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar dPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar dPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar dPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar dPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 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.invokeNext(Standar dPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 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:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11P rotocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) 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\mail.jar;C:\Tomcat\common\lib\activation.jar;C:\Tomcat\common\lib\jndi.jar;C:\Tomcat\common\lib\classes12.jar;C:\Tomcat\common\lib\commons-collections.jar;C:Tomcat\common\lib\commons-dbcp-1.1.jar;C:\Tomcat\common\lib\commons-pool-1.1.jar;C:\Tomcat\common\lib\jdbc2_0-stdext.jar;C:Tomcat\common\lib\ojdbc14.jar;C:\Tomcat\common\lib\classes111.jar;C:\Tomcat\common\lib\ocrs12.jar;