the only thing might be that you can leave out tracks_adm from <value>jdbc:oracle:thin:[EMAIL PROTECTED]:1521:paso2d</value>
And if you do the lookup though:
Context ctx = new InitialContext();
Object datasource = ctx.lookup("java:/comp/env/jdbc/paso2d");
?
Greetz
Hans
ps and part of your server.xml was missing, but i assume you didn't paste all of it (the closing tags etc)
At 02:22 PM 6/17/2004 -0500, you wrote:
Hi Hans, yes seems like I've got all the I's dotted and the t's crossed...but still can't get the damn thing to load...I've got all the Jars in the tomcat/common/lib and in the classpath and the following are my 3 files. Let me know if you see anything I may have missed:
Server.xml:
<!-- Define the top level container in our container hierarchy --> <Engine name="Standalone" defaultHost="epdata02.elps.bna.boeing.com" debug="0">
<Context path="/examples" docBase="examples" debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/paso2d" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/paso2d"> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter>
<parameter> <name>url</name>
<value>jdbc:oracle:thin:[EMAIL PROTECTED]:1521:paso2d</value> </parameter> <parameter> <name>username</name> <value>tracks_adm</value> </parameter> <parameter> <name>password</name> <value>eporaadm</value> </parameter> <parameter> <name>maxActive</name> <value>20</value> </parameter> <parameter> <name>maxIdle</name> <value>30000</value>
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>
Java code:
# cat JDBCTest.jsp
<%@ page errorPage="errorpg.jsp" import="java.sql.*, javax.sql.*, oracle.jdbc.*, java.io.*, javax.naming.InitialContext, javax.servlet.*, javax.servlet.http.*, java.util.*, javax.naming.Context" %>
JDBC JNDI Resource Test
<% Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env"); DataSource ds = (DataSource) envContext.lookup("jdbc/paso2d"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery("select * from employee_info;"); %>
bems_id last_name
<% while (rset.next()) { %>
<%= rset.getString(1) %> <%= rset.getString(2) %>
<% } conn.close(); initContext.close(); %>
Chris Bliesner
Lead Oracle DBA/Unix admin
Wk Phone 915-834-1757
-----Original Message----- From: Hans Wichman [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:14 PM To: Tomcat Users List Subject: RE: DBCP pooling error
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-example s >-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(BasicDataSourc e >.java:523) > > at >org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.j a >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.j a >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(Applic a >tionFilterChain.java:247) > > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil t >erChain.java:193) > > at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal v >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(StandardContextVal v >e.java:191) > > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. i >nvokeNext(StandardPipeline.java:643) > > at >org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato r >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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]