You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Kumar Abhay-CAK203C <CA...@motorola.com> on 2004/02/03 16:46:22 UTC
No Suitable Driver Error -- Still No Success
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;
RE: No Suitable Driver Error -- Still No Success
Posted by Mike Curwen <mi...@gb-im.com>.
What does your web.xml look like? Read step 3 on this page:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples
-howto.html
> -----Original Message-----
> From: Kumar Abhay-CAK203C [mailto:CAK203C@motorola.com]
> Sent: Tuesday, February 03, 2004 9:46 AM
> To: tomcat-user@jakarta.apache.org
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org