Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem connecting Oracle with Tomcat 5.0

3 views
Skip to first unread message

vishnu

unread,
Dec 19, 2003, 2:32:58 PM12/19/03
to
I am using Tomcat v5.0 and Oracle 9i. Can anyone tell me why I am getting the exception given below...

I have added this to server.xml :

<Resource name="jdbc/ConnectionPool" auth="Container" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/ConnectionPool">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@130.70.152.135:1521:ORCLDEV</value>
</parameter>
<parameter>
<name>username</name>
<value>vishnu</value>
</parameter>
<parameter>
<name>password</name>
<value>[my password]</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>

I am getting this exception:


org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.lang.NullPointerException
at oracle.jdbc.driver.OracleDriver.oracleAcceptsURL(OracleDriver.java:477)
at oracle.jdbc.driver.OracleDriver.acceptsURL(OracleDriver.java:525)
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at edu.louisiana.cbit.capture.util.DBConnection.getConnection(DBConnection.java:134)
at edu.louisiana.cbit.capture.util.DBConnection.startConnection(DBConnection.java:35)
at edu.louisiana.cbit.capture.action.LoginAction.execute(LoginAction.java:59)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:805)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:696)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
at java.lang.Thread.run(Unknown Source)

Dec 19, 2003 1:08:56 PM org.apache.struts.action.RequestProcessor processException

correro

unread,
Dec 22, 2003, 2:42:18 AM12/22/03
to
yeah, i have exactly the same problem (Cannot create JDBC driver of class '' for connect URL 'null'), except that my db is mysql

could it be something with Tomcat?

please kindly help us out!

Heinz Dittmann

unread,
Dec 30, 2003, 11:28:13 AM12/30/03
to
>org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
of >class '' for connect URL 'null', cause:
java.lang.NullPointerException

the error message points out that there are no values taken from the
server.xml file.

Adding JDBC Resource seems to be only valid in a <Context> subelement
of a
<service> or <DefaultContext> subelement of a <host> element in the
server.xml file.

Serpi...@hotmail.com

unread,
Jan 10, 2004, 9:16:55 PM1/10/04
to
heinz.d...@gmx.de (Heinz Dittmann) wrote in message news:<d629840e.03123...@posting.google.com>...


I have the same problem too with mysql and tomcat 4.1.29 .
not been able to find out what the problem is yet though :(

help out if any of you solved it .

0 new messages