Hi, there are 4 parts to this, a pool definition in your server.xml a resource ref in your web.xml a snippet of java code to get the datasource. a bunch of drivers (probably something like classes12.jar)
Did you specify the first three of them and included the last one?
grtz Hans
At 11:23 AM 6/17/2004 -0500, you wrote:
Still having trouble with getting the DBCP working with Oracle. I have seemingly followed the link below but I am still getting that NULL error below. Any ideas?
Chris Bliesner
Lead Oracle DBA/Unix admin
Wk Phone 915-834-1757
-----Original Message----- From: David Short [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 2:52 PM To: Bliesner, Christopher P Subject: RE: DBCP pooling error
Try this:
Web.xml
<resource-ref>
<res-ref-name>jdbc/paso2d</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Check this link out: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples -howto.html
-----Original Message----- From: Bliesner, Christopher P [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 12:46 PM To: [EMAIL PROTECTED] Subject: RE: DBCP pooling error
Well...good news is were getting a new error:
Name paso2d is not bound in this Context
Chris Bliesner
Lead Oracle DBA/Unix admin
Wk Phone 915-834-1757
-----Original Message----- From: David Short [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 12:52 PM To: Bliesner, Christopher P Subject: RE: DBCP pooling error
Try this:
DataSource ds = (DataSource) initContext.lookup("java:comp/env/jdbc/paso2d");
-----Original Message----- From: Bliesner, Christopher P [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 11:45 AM To: [EMAIL PROTECTED] Subject: RE: DBCP pooling error
Shouldn't need the Factory Tyrex stuff for the 4.12 version but didn't work anyway...but here is what the logs are saying in Catalina.out:
Cannot load JDBC driver class 'null'
java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:115)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource .java:523)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.ja va:312)
at org.apache.jsp.JDBCTest_jsp._jspService(JDBCTest_jsp.java:57)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:204)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.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(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator Base.java:471)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.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.StandardContext.invoke(St
Chris Bliesner
Lead Oracle DBA/Unix admin
Wk Phone 915-834-1757
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
