Well, I'm getting some new errors at least..
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 17 in the jsp file: /jsp/JDBCTest.jsp
Generated servlet error:
[javac] Compiling 1 source file
/usr/local/jakarta-tomcat-4.1.12/work/Standalone/epdata02.elps.bna.boein
g.com/examples/jsp/JDBCTest_jsp.java:58: cannot resolve symbol
symbol : class Datasource
location: class org.apache.jsp.JDBCTest_jsp
Datasource ds =
(Datasource)initCtx.lookup("java:/comp/env/jdbc/paso2d");
^
An error occurred at line: 17 in the jsp file: /jsp/JDBCTest.jsp
Generated servlet error:
/usr/local/jakarta-tomcat-4.1.12/work/Standalone/epdata02.elps.bna.boein
g.com/examples/jsp/JDBCTest_jsp.java:58: cannot resolve symbol
symbol : class Datasource
location: class org.apache.jsp.JDBCTest_jsp
Datasource ds =
(Datasource)initCtx.lookup("java:/comp/env/jdbc/paso2d");
^
2 errors
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>password</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]
