Return-Path: 
 <tomcat-user-return-67723-qmlist-jakarta-archive-tomcat-user=nagoya.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 63584 invoked from network); 12 Jun 2003 17:10:55 -0000
Received: from exchange.sun.com (192.18.33.10)
  by daedalus.apache.org with SMTP; 12 Jun 2003 17:10:55 -0000
Received: (qmail 1074 invoked by uid 97); 12 Jun 2003 17:13:12 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org
Received: (qmail 1067 invoked from network); 12 Jun 2003 17:13:12 -0000
Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12)
  by nagoya.betaversion.org with SMTP; 12 Jun 2003 17:13:12 -0000
Received: (qmail 61698 invoked by uid 500); 12 Jun 2003 17:10:25 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 61525 invoked from network); 12 Jun 2003 17:10:21 -0000
Received: from unknown (HELO AppSrvr.itworx.com) (212.12.241.20)
  by daedalus.apache.org with SMTP; 12 Jun 2003 17:10:21 -0000
content-class: urn:content-classes:message
Subject: JNDI DataSource
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Thu, 12 Jun 2003 20:08:59 +0300
X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3
Message-ID: <4A1408BCB4072B498DCFAF1644ECF259111731@appsrvr.itworx.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: JNDI DataSource
Thread-Index: AcMxBVCibqm4NpFES++AhYb0hc5tiQ==
From: "Tarek M. Nabil" <Tarek.Nabil@itworx.com>
To: "'Tomcat Users List' (E-mail)" <tomcat-user@jakarta.apache.org>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi,

I'm trying to setup a JDBC DataSource on Tomcat 4.1.24.

I performed the steps in the documentation:

1- Added this part to the GlobalNamingResources section of the =
server.xml

    <Resource name=3D"jdbc/as400" scope=3D"Shareable" =
type=3D"javax.sql.DataSource" auth=3D"Container"/>
    <Resource name=3D"UserDatabase" scope=3D"Shareable" =
type=3D"org.apache.catalina.UserDatabase" auth=3D"Container" =
description=3D"User database that can be updated and saved"/>
    <ResourceParams name=3D"jdbc/as400">
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>8</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:as400:AS400</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>access2k</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>com.ibm.as400.access.AS400JDBCDriver</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>DBA</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name=3D"UserDatabase">
      <parameter>
        <name>factory</name>
        =
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>

2- I added this to my web.xml

	<resource-ref>
		<description>
		    Resource reference to a factory for java.sql.Connection
			instances that talk to an AS400 database
		</description>
		<res-ref-name>
			jdbc/as400
		</res-ref-name>
		<res-type>
			javax.sql.DataSource
		</res-type>
		<res-auth>
			Container
		</res-auth>
	</resource-ref>

3- I put this in a JSP

<%@ page import=3D"javax.naming.*, java.sql.*, javax.sql.*" %>=20
<%
Context initCtx =3D new InitialContext();
Context envCtx =3D (Context) initCtx.lookup("java:comp/env");
DataSource ds =3D (DataSource)
  envCtx.lookup("jdbc/as400");

Connection conn =3D ds.getConnection();
conn.close();

%>


And Still, I get the following error when accessing the JSP

type Exception report

message=20

description The server encountered an internal error () that prevented =
it from fulfilling this request.

exception=20

org.apache.jasper.JasperException: Cannot load JDBC driver class 'null'
	at =
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav=
a:254)
	at =
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at =
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat=
ionFilterChain.java:247)
	at =
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte=
rChain.java:193)
	at =
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve=
.java:256)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve=
.java:191)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415=
)
	at =
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:=
180)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVal=
ve.java:171)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:641)
	at =
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:=
172)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:641)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j=
ava:174)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at =
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594=
)
	at =
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo=
nnection(Http11Protocol.java:392)
	at =
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565=
)
	at =
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
	at java.lang.Thread.run(Thread.java:484)


root cause=20

javax.servlet.ServletException: Cannot load JDBC driver class 'null'
	at =
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContext=
Impl.java:536)
	at org.apache.jsp.test_jsp._jspService(test_jsp.java:61)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at =
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav=
a:210)
	at =
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at =
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat=
ionFilterChain.java:247)
	at =
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte=
rChain.java:193)
	at =
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve=
.java:256)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve=
.java:191)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415=
)
	at =
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:=
180)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVal=
ve.java:171)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:641)
	at =
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:=
172)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:641)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j=
ava:174)
	at =
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(StandardPipeline.java:643)
	at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:48=
0)
	at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at =
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at =
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594=
)
	at =
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo=
nnection(Http11Protocol.java:392)
	at =
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565=
)
	at =
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
	at java.lang.Thread.run(Thread.java:484)



-------------------------------------------------------------------------=
-------

Any help is appreciated.

Thanks,
Tarek M. Nabil

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org