Problem connecting Oracle with Tomcat 5.0
From: vishnu (vishy4u_2000_at_yahoo.com)
Date: 12/19/03
- Next message: Marvin: "Re: concurrent updates"
- Previous message: Ike: "Restructuring a table"
- Next in thread: correro: "Re: Problem connecting Oracle with Tomcat 5.0"
- Reply: correro: "Re: Problem connecting Oracle with Tomcat 5.0"
- Reply: Heinz Dittmann: "Re: Problem connecting Oracle with Tomcat 5.0"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 19 Dec 2003 13:32:58 -0600
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
- Next message: Marvin: "Re: concurrent updates"
- Previous message: Ike: "Restructuring a table"
- Next in thread: correro: "Re: Problem connecting Oracle with Tomcat 5.0"
- Reply: correro: "Re: Problem connecting Oracle with Tomcat 5.0"
- Reply: Heinz Dittmann: "Re: Problem connecting Oracle with Tomcat 5.0"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]