My mistake--It wasn't the CLASSPATH that was the problem but a semicolon that I had in my select statement. That was causing the dBCP to fail. Thx all for the help! :)
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:55 PM To: Tomcat Users List Subject: RE: DBCP pooling error Hi, seems to be ok, i do seem to have an additional nesting, engine-host-context but I do not know if it matters. If you do a Class.forName from your jsp page, can you load the class ok? I'm grasping at straws here as well ;-) grtz Hans At 02:41 PM 6/17/2004 -0500, you wrote: >I'll check those things...how is the location in the Server.xml? Is it >in the right place? > >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:39 PM >To: Tomcat Users List >Subject: RE: DBCP pooling error > >Hmm, >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] > >--------------------------------------------------------------------- >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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
