Return-Path: 
 <tomcat-user-return-121947-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 79261 invoked from network); 22 Feb 2005 12:20:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 22 Feb 2005 12:20:16 -0000
Received: (qmail 72124 invoked by uid 500); 22 Feb 2005 12:19:45 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 72054 invoked by uid 500); 22 Feb 2005 12:19:45 -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 72001 invoked by uid 99); 22 Feb 2005 12:19:44 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from pcsbom.patni.com (HELO pcsbom.patni.com) (203.124.139.208)
  by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 22 Feb 2005 04:19:42 -0800
Received: from rakshak.patni.com (rakshak.patni.com [203.124.139.54])
	by pcsbom.patni.com (8.12.11/8.12.11) with SMTP id j1MCIZUR024136
	for <tomcat-user@jakarta.apache.org>; Tue, 22 Feb 2005 17:50:37 +0530
Received: from spzha1.patni.com ([192.168.0.6])
 by rakshak.patni.com (SMSSMTP 4.0.0.59) with SMTP id M2005022217491604733
 for <tomcat-user@jakarta.apache.org>; Tue, 22 Feb 2005 17:49:16 +0530
Received: from pcp4904 ([192.168.7.242])
	(authenticated bits=0)
	by spzha1.patni.com (8.12.11/8.12.9) with ESMTP id j1MCK2QN012562
	for <tomcat-user@jakarta.apache.org>; Tue, 22 Feb 2005 17:50:02 +0530
Reply-To: <reshma.bhatia@patni.com>
From: "Reshma Bhatia" <reshma.bhatia@patni.com>
To: <tomcat-user@jakarta.apache.org>
Subject: Re: JDBC connection - Please help
Date: Tue, 22 Feb 2005 17:49:06 +0530
Message-ID: <003d01c518d8$b4da38d0$f207a8c0@patni.com>
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="----=_NextPart_000_003E_01C51906.CE9274D0"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Importance: Normal
X-Scanned-By: MIMEDefang 2.43
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

------=_NextPart_000_003E_01C51906.CE9274D0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

Looks like you are using the Tomcat Connection pool.
Refer to the attached Readme.txt file and verify that you have done these
steps.
I think it should solve your problem.

Have also attached the server.xml & web.xml files which worked fine for us.
let me know whether ur problem gets solved by this.

-----Original Message-----
From: deepak suldhal [mailto:deepakatfre@yahoo.com]
Sent: Monday, February 21, 2005 11:53 AM
To: tomcat users
Subject: JDBC connection - Please help


Please help me make my first JDBC connection
My web.xml

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
    version="2.4">
  <description>MySQL Test App</description>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/TestDB</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>
</web-app>
----------------------------------------------------------------------------
---
In server.xml I have the following context ( trying to connect to Sybase
database)
<Context path="/DBTest" docBase="DBTest" debug="5" reloadable="true"
crossContext="true">
    <Resource name="jdbc/TestDB" auth="Container"
                    type="javax.sql.DataSource"
                maxActive="100" maxIdle="30" maxWait="10000"
                username="javauser" password="javadude"
                driverClassName="com.sybase.jdbc2.jdbc.SybDriver"
                url="jdbc:sybase:Tds:re2unx188:2025"/>
</Context>
----------------------------------------------------------------------------
---
I have copied the JDCB drive Jar under
commons/lib
I have a test.jsp as follows
----------------------------------------------------------------------------
---
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<sql:query var="rs" dataSource="jdbc/TestDB">
select id, foo, bar from testdata
</sql:query>
<html>
  <head>
    <title>DB Test</title>
  </head>
  <body>
  <h2>Results</h2>

<c:forEach var="row" items="${rs.rows}">
    Foo ${row.foo}<br/>
    Bar ${row.bar}<br/>
</c:forEach>
  </body>
</html>
----------------------------------------------------------------------------
---
My directory structue is as follows
webapps/DBTest/WEB-INF/web.mxl
              /DBTest/test.jsp
----------------------------------------------------------------------------
---
And when I try the url
http://localhost:8080/DBTest/test.jsp
I am getting the following errors
description The server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'"

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextI
mpl.java:825)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:758)
                org.apache.jsp.test_jsp._jspService(test_jsp.java:82)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
24)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'"

org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unk
nown Source)

org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknow
n Source)

org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:101)
                org.apache.jsp.test_jsp._jspService(test_jsp.java:58)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
24)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802

----------------------------------------------------------------------------
---
My console server display is as follows
eb 20, 2005 10:31:08 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Feb 20, 2005 10:31:08 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1422 ms
Feb 20, 2005 10:31:09 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Feb 20, 2005 10:31:09 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.0.28
Feb 20, 2005 10:31:09 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Feb 20, 2005 10:31:10 PM org.apache.catalina.core.StandardHost getDeployer
INFO: Create Host deployer for direct deployment ( non-jmx )
Feb 20, 2005 10:31:10 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\admin.xml
Feb 20, 2005 10:31:10 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings',
returnNull=true
Feb 20, 2005 10:31:10 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.action.ActionResources',
returnNull=true
Feb 20, 2005 10:31:11 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources',
returnNull=true
Feb 20, 2005 10:31:13 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\balancer.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\CurrencyConverter.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\expressionLanguage.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Fin46.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Fupload.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Hangman.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\helloworld.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Interactivehelloworld.
xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\jstltest.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\manager.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\ServletExamples.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\store.xml
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /sample from URL
file:C:/jakarta-tomcat-5.0.28/webapps/sample
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /jsp-examples from URL
file:C:\jakarta-tomcat-5.0.28\webapps\jsp-examples
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path  from URL
file:C:\jakarta-tomcat-5.0.28\webapps\ROOT
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /servlets-examples from URL
file:C:\jakarta-tomcat-5.0.28\webapps\servlets-examples
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /tomcat-docs from URL
file:C:\jakarta-tomcat-5.0.28\webapps\tomcat-docs
Feb 20, 2005 10:31:17 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /webdav from URL
file:C:\jakarta-tomcat-5.0.28\webapps\webdav
Feb 20, 2005 10:31:17 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Feb 20, 2005 10:31:17 PM org.apache.jk.common.ChannelSocket init
INFO: JK2: ajp13 listening on /0.0.0.0:8009
Feb 20, 2005 10:31:17 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=10/40
config=C:\jakarta-tomcat-5.0.28\conf\jk2.properties
Feb 20, 2005 10:31:17 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 8835 ms


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

http://www.patni.com
World-Wide Partnerships. World-Class Solutions.
_____________________________________________________________________

This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to
whom this message was originally addressed. Any review, e-transmission
dissemination or other use of or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this e-mail in error
kindly delete  this e-mail from your records. If it appears that this
mail has been forwarded to you without proper authority, please notify
us immediately at netadmin@patni.com and delete this mail. 
_____________________________________________________________________

------=_NextPart_000_003E_01C51906.CE9274D0
Content-Type: text/xml;
	name="server.xml"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="server.xml"

<!-- Example Server Configuration File -->
<!-- Note that component elements are nested corresponding to their
     parent-child relationships with each other -->

<!-- A "Server" is a singleton element that represents the entire JVM,
     which may contain one or more "Service" instances.  The Server
     listens for a shutdown command on the indicated port.

     Note:  A "Server" is not itself a "Container", so you may not
     define subcomponents such as "Valves" or "Loggers" at this level.
 -->

<Server port=3D"8005" shutdown=3D"SHUTDOWN" debug=3D"0">


  <!-- Comment these entries out to disable JMX MBeans support -->
  <!-- You may also configure custom components (e.g. Valves/Realms) by=20
       including your own mbean-descriptor file(s), and setting the=20
       "descriptors" attribute to point to a ';' seperated list of paths
       (in the ClassLoader sense) of files to add to the default list.
       e.g. descriptors=3D"/com/myfirm/mypackage/mbean-descriptor.xml"
  -->
  <Listener className=3D"org.apache.catalina.mbeans.ServerLifecycleListener"
            debug=3D"0"/>
  <Listener className=3D"org.apache.catalina.mbeans.GlobalResourcesLifecycl=
eListener"
            debug=3D"0"/>

  <!-- Global JNDI resources -->
  <GlobalNamingResources>

    <!-- Test entry for demonstration purposes -->
    <Environment name=3D"simpleValue" type=3D"java.lang.Integer" value=3D"3=
0"/>

    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
    <Resource name=3D"UserDatabase" auth=3D"Container"
              type=3D"org.apache.catalina.UserDatabase"
       description=3D"User database that can be updated and saved">
    </Resource>
    <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>

<!-- Defining the DataSource to be used for Tomcat connectionPooling -->
  </GlobalNamingResources>

  <!-- A "Service" is a collection of one or more "Connectors" that share
       a single "Container" (and therefore the web applications visible
       within that Container).  Normally, that Container is an "Engine",
       but this is not required.

       Note:  A "Service" is not itself a "Container", so you may not
       define subcomponents such as "Valves" or "Loggers" at this level.
   -->

  <!-- Define the Tomcat Stand-Alone Service -->
  <Service name=3D"Catalina">

    <!-- A "Connector" represents an endpoint by which requests are received
         and responses are returned.  Each Connector passes requests on to =
the
         associated "Container" (normally an Engine) for processing.

         By default, a non-SSL HTTP/1.1 Connector is established on port 80=
80.
         You can also enable an SSL HTTP/1.1 Connector on port 8443 by
         following the instructions below and uncommenting the second Conne=
ctor
         entry.  SSL support requires the following steps (see the SSL Conf=
ig
         HOWTO in the Tomcat 5 documentation bundle for more detailed
         instructions):
         * If your JDK version 1.3 or prior, download and install JSSE 1.0.=
2 or
           later, and put the JAR files into "$JAVA_HOME/jre/lib/ext".
         * Execute:
             %JAVA_HOME%\bin\keytool -genkey -alias tomcat -keyalg RSA (Win=
dows)
             $JAVA_HOME/bin/keytool -genkey -alias tomcat -keyalg RSA  (Uni=
x)
           with a password value of "changeit" for both the certificate and
           the keystore itself.

         By default, DNS lookups are enabled when a web application calls
         request.getRemoteHost().  This can have an adverse impact on
         performance, so you can disable it by setting the
         "enableLookups" attribute to "false".  When DNS lookups are disabl=
ed,
         request.getRemoteHost() will return the String version of the
         IP address of the remote client.
    -->

    <!-- Define a non-SSL Coyote HTTP/1.1 Connector on port 8080 -->
    <Connector port=3D"8000"
               maxThreads=3D"150" minSpareThreads=3D"25" maxSpareThreads=3D=
"75"
               enableLookups=3D"false" redirectPort=3D"8443" acceptCount=3D=
"100"
               debug=3D"0" connectionTimeout=3D"20000"=20
               disableUploadTimeout=3D"true" />
    <!-- Note : To disable connection timeouts, set connectionTimeout value
     to 0 -->
=09
	<!-- Note : To use gzip compression you could set the following properties=
 :
=09
			   compression=3D"on"=20
			   compressionMinSize=3D"2048"=20
			   noCompressionUserAgents=3D"gozilla, traviata"=20
			   compressableMimeType=3D"text/html,text/xml"
	-->

    <!-- Define a SSL Coyote HTTP/1.1 Connector on port 8443 -->
    <!--
    <Connector port=3D"8443"=20
               maxThreads=3D"150" minSpareThreads=3D"25" maxSpareThreads=3D=
"75"
               enableLookups=3D"false" disableUploadTimeout=3D"true"
               acceptCount=3D"100" debug=3D"0" scheme=3D"https" secure=3D"t=
rue"
               clientAuth=3D"false" sslProtocol=3D"TLS" />
    -->

    <!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
    <Connector port=3D"8009"=20
               enableLookups=3D"false" redirectPort=3D"8443" debug=3D"0"
               protocol=3D"AJP/1.3" />

    <!-- Define a Proxied HTTP/1.1 Connector on port 8082 -->
    <!-- See proxy documentation for more information about using this. -->
    <!--
    <Connector port=3D"8082"=20
               maxThreads=3D"150" minSpareThreads=3D"25" maxSpareThreads=3D=
"75"
               enableLookups=3D"false"
               acceptCount=3D"100" debug=3D"0" connectionTimeout=3D"20000"
               proxyPort=3D"80" disableUploadTimeout=3D"true" />
    -->

    <!-- An Engine represents the entry point (within Catalina) that proces=
ses
         every request.  The Engine implementation for Tomcat stand alone
         analyzes the HTTP headers included with the request, and passes th=
em
         on to the appropriate Host (virtual host). -->

    <!-- You should set jvmRoute to support load-balancing via JK/JK2 ie :
    <Engine name=3D"Standalone" defaultHost=3D"localhost" debug=3D"0" jvmRo=
ute=3D"jvm1">=20=20=20=20=20=20=20=20=20
    -->=20
=20=20=20=20=20=20=20=20=20
    <!-- Define the top level container in our container hierarchy -->
    <Engine name=3D"Catalina" defaultHost=3D"localhost" debug=3D"0">

      <!-- The request dumper valve dumps useful debugging information about
           the request headers and cookies that were received, and the resp=
onse
           headers and cookies that were sent, for all requests received by
           this instance of Tomcat.  If you care only about requests to a
           particular virtual host, or a particular application, nest this
           element inside the corresponding <Host> or <Context> entry inste=
ad.

           For a similar mechanism that is portable to all Servlet 2.4
           containers, check out the "RequestDumperFilter" Filter in the
           example application (the source for this filter may be found in
           "$CATALINA_HOME/webapps/examples/WEB-INF/classes/filters").

           Request dumping is disabled by default.  Uncomment the following
           element to enable it. -->
      <!--
      <Valve className=3D"org.apache.catalina.valves.RequestDumperValve"/>
      -->

      <!-- Global logger unless overridden at lower levels -->
      <Logger className=3D"org.apache.catalina.logger.FileLogger"
              prefix=3D"catalina_log." suffix=3D".txt"
              timestamp=3D"true"/>

      <!-- Because this Realm is here, an instance will be shared globally =
-->

      <!-- This Realm uses the UserDatabase configured in the global JNDI
           resources under the key "UserDatabase".  Any edits
           that are performed against this UserDatabase are immediately
           available for use by the Realm.  -->
      <Realm className=3D"org.apache.catalina.realm.UserDatabaseRealm"
                 debug=3D"0" resourceName=3D"UserDatabase"/>

<!--      <Realm className=3D"wrappers.catalina.SlideRealm" name=3D"Slide D=
AV Server" namespace=3D"slide" /> -->

      <!-- Comment out the old realm but leave here for now in case we
           need to go back quickly -->
      <!--
      <Realm className=3D"org.apache.catalina.realm.MemoryRealm" />
      -->

      <!-- Replace the above Realm with one of the following to get a Realm
           stored in a database and accessed via JDBC -->

      <!--
      <Realm  className=3D"org.apache.catalina.realm.JDBCRealm" debug=3D"99"
             driverName=3D"org.gjt.mm.mysql.Driver"
          connectionURL=3D"jdbc:mysql://localhost/authority"
         connectionName=3D"test" connectionPassword=3D"test"
              userTable=3D"users" userNameCol=3D"user_name" userCredCol=3D"=
user_pass"
          userRoleTable=3D"user_roles" roleNameCol=3D"role_name" />
      -->

      <!--
      <Realm  className=3D"org.apache.catalina.realm.JDBCRealm" debug=3D"99"
             driverName=3D"oracle.jdbc.driver.OracleDriver"
          connectionURL=3D"jdbc:oracle:thin:@ntserver:1521:ORCL"
         connectionName=3D"scott" connectionPassword=3D"tiger"
              userTable=3D"users" userNameCol=3D"user_name" userCredCol=3D"=
user_pass"
          userRoleTable=3D"user_roles" roleNameCol=3D"role_name" />
      -->

      <!--
      <Realm  className=3D"org.apache.catalina.realm.JDBCRealm" debug=3D"99"
             driverName=3D"sun.jdbc.odbc.JdbcOdbcDriver"
          connectionURL=3D"jdbc:odbc:CATALINA"
              userTable=3D"users" userNameCol=3D"user_name" userCredCol=3D"=
user_pass"
          userRoleTable=3D"user_roles" roleNameCol=3D"role_name" />
      -->

      <!-- Define the default virtual host
           Note: XML Schema validation will not work with Xerces 2.2.
       -->
      <Host name=3D"localhost" debug=3D"0" appBase=3D"webapps"
       unpackWARs=3D"true" autoDeploy=3D"true"
       xmlValidation=3D"false" xmlNamespaceAware=3D"false">

        <!-- Defines a cluster for this node,
             By defining this element, means that every manager will be cha=
nged.
             So when running a cluster, only make sure that you have webapp=
s in there
             that need to be clustered and remove the other ones.
             A cluster has the following parameters:

             className =3D the fully qualified name of the cluster class

             name =3D a descriptive name for your cluster, can be anything

             debug =3D the debug level, higher means more output

             mcastAddr =3D the multicast address, has to be the same for al=
l the nodes

             mcastPort =3D the multicast port, has to be the same for all t=
he nodes

             mcastFrequency =3D the number of milliseconds in between sendi=
ng a "I'm alive" heartbeat

             mcastDropTime =3D the number a milliseconds before a node is c=
onsidered "dead" if no heartbeat is received

             tcpThreadCount =3D the number of threads to handle incoming re=
plication requests, optimal would be the same amount of threads as nodes=20

             tcpListenAddress =3D the listen address (bind address) for TCP=
 cluster request on this host,=20
                                in case of multiple ethernet cards.
                                auto means that address becomes
                                InetAddress.getLocalHost().getHostAddress()

             tcpListenPort =3D the tcp listen port

             tcpSelectorTimeout =3D the timeout (ms) for the Selector.selec=
t() method in case the OS
                                  has a wakup bug in java.nio. Set to 0 for=
 no timeout

             printToScreen =3D true means that managers will also print to =
std.out

             expireSessionsOnShutdown =3D true means that=20

             useDirtyFlag =3D true means that we only replicate a session a=
fter setAttribute,removeAttribute has been called.
                            false means to replicate the session after each=
 request.
                            false means that replication would work for the=
 following piece of code:
                            <%
                            HashMap map =3D (HashMap)session.getAttribute("=
map");
                            map.put("key","value");
                            %>
             replicationMode =3D can be either 'pooled', 'synchronous' or '=
asynchronous'.
                               * Pooled means that the replication happens =
using several sockets in a synchronous way. Ie, the data gets replicated, t=
hen the request return. This is the same as the 'synchronous' setting excep=
t it uses a pool of sockets, hence it is multithreaded. This is the fastest=
 and safest configuration. To use this, also increase the nr of tcp threads=
 that you have dealing with replication.
                               * Synchronous means that the thread that exe=
cutes the request, is also the
                               thread the replicates the data to the other =
nodes, and will not return until all
                               nodes have received the information.
                               * Asynchronous means that there is a specifi=
c 'sender' thread for each cluster node,
                               so the request thread will queue the replica=
tion request into a "smart" queue,
                               and then return to the client.
                               The "smart" queue is a queue where when a se=
ssion is added to the queue, and the same session
                               already exists in the queue from a previous =
request, that session will be replaced
                               in the queue instead of replicating two requ=
ests. This almost never happens, unless there is a=20
                               large network delay.
        -->=20=20=20=20=20=20=20=20=20=20=20=20=20
        <!--
            When configuring for clustering, you also add in a valve to cat=
ch all the requests
            coming in, at the end of the request, the session may or may no=
t be replicated.
            A session is replicated if and only if all the conditions are m=
et:
            1. useDirtyFlag is true or setAttribute or removeAttribute has =
been called AND
            2. a session exists (has been created)
            3. the request is not trapped by the "filter" attribute

            The filter attribute is to filter out requests that could not m=
odify the session,
            hence we don't replicate the session after the end of this requ=
est.
            The filter is negative, ie, anything you put in the filter, you=
 mean to filter out,
            ie, no replication will be done on requests that match one of t=
he filters.
            The filter attribute is delimited by ;, so you can't escape out=
 ; even if you wanted to.

            filter=3D".*\.gif;.*\.js;" means that we will not replicate the=
 session after requests with the URI
            ending with .gif and .js are intercepted.
        -->
=20=20=20=20=20=20=20=20
        <!--
        <Cluster className=3D"org.apache.catalina.cluster.tcp.SimpleTcpClus=
ter"
                 managerClassName=3D"org.apache.catalina.cluster.session.De=
ltaManager"
                 expireSessionsOnShutdown=3D"false"
                 useDirtyFlag=3D"true">

            <Membership=20
                className=3D"org.apache.catalina.cluster.mcast.McastService"
                mcastAddr=3D"228.0.0.4"
                mcastPort=3D"45564"
                mcastFrequency=3D"500"
                mcastDropTime=3D"3000"/>

            <Receiver=20
                className=3D"org.apache.catalina.cluster.tcp.ReplicationLis=
tener"
                tcpListenAddress=3D"auto"
                tcpListenPort=3D"4001"
                tcpSelectorTimeout=3D"100"
                tcpThreadCount=3D"6"/>

            <Sender
                className=3D"org.apache.catalina.cluster.tcp.ReplicationTra=
nsmitter"
                replicationMode=3D"pooled"/>

            <Valve className=3D"org.apache.catalina.cluster.tcp.Replication=
Valve"
                   filter=3D".*\.gif;.*\.js;.*\.jpg;.*\.htm;.*\.html;.*\.tx=
t;"/>
        </Cluster>
        -->=20=20=20=20=20=20=20=20



        <!-- Normally, users must authenticate themselves to each web app
             individually.  Uncomment the following entry if you would like
             a user to be authenticated the first time they encounter a
             resource protected by a security constraint, and then have that
             user identity maintained across *all* web applications contain=
ed
             in this virtual host. -->
        <!--
        <Valve className=3D"org.apache.catalina.authenticator.SingleSignOn"
                   debug=3D"0"/>
        -->

        <!-- Access log processes all requests for this virtual host.  By
             default, log files are created in the "logs" directory relativ=
e to
             $CATALINA_HOME.  If you wish, you can specify a different
             directory with the "directory" attribute.  Specify either a re=
lative
             (to $CATALINA_HOME) or absolute path to the desired directory.
        -->
        <!--
        <Valve className=3D"org.apache.catalina.valves.AccessLogValve"
                 directory=3D"logs"  prefix=3D"localhost_access_log." suffi=
x=3D".txt"
                 pattern=3D"common" resolveHosts=3D"false"/>
        -->

        <!-- Logger shared by all Contexts related to this virtual host.  By
             default (when using FileLogger), log files are created in the =
"logs"
             directory relative to $CATALINA_HOME.  If you wish, you can sp=
ecify
             a different directory with the "directory" attribute.  Specify=
 either a
             relative (to $CATALINA_HOME) or absolute path to the desired
             directory.-->
        <Logger className=3D"org.apache.catalina.logger.FileLogger"
                 directory=3D"logs"  prefix=3D"localhost_log." suffix=3D".t=
xt"
            timestamp=3D"true"/>

<DefaultContext>
<Resource name=3D"jdbc/myOracle" type=3D"javax.sql.DataSource"/>=20

<ResourceParams name=3D"jdbc/myOracle">
  <parameter>
  <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
<!--    <value>oracle.jdbc.pool.OracleDataSource</value> -->
  </parameter>
  <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:PSWTOSHIBA@pc-p4254:1521:PKGSFT</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>pswtoshiba</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>pswtoshiba</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>50</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>10</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>30000</value>
  </parameter>
  <parameter>
    <name>removeAbandoned</name>
    <value>true</value>
  </parameter>
<parameter>
    <name>removeAbandonedTimeout</name>
    <value>300</value>
</parameter>
<parameter>
    <name>logAbandoned</name>
    <value>true</value>
</parameter>

</ResourceParams>
</DefaultContext>

      </Host>

    </Engine>

  </Service>

</Server>

------=_NextPart_000_003E_01C51906.CE9274D0
Content-Type: text/plain;
	name="Readme.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="Readme.txt"


Settings for Tomcat Connection Pool
***************************************
1) Put classes12.jar file in path =3D> CATALINA_HOME\common\lib
2) Add the Tag given below into server.xml file

<DefaultContext>
<Resource name=3D"jdbc/myOracle" type=3D"javax.sql.DataSource"/>=20

<ResourceParams name=3D"jdbc/myOracle">
  <parameter>
  <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
  </parameter>
  <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:PSWTOSHIBA@pc-p4254:1521:PKGSFT</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>pswtoshiba</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>pswtoshiba</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>50</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>10</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>30000</value>
  </parameter>
  <parameter>
    <name>removeAbandoned</name>
    <value>true</value>
  </parameter>
<parameter>
    <name>removeAbandonedTimeout</name>
    <value>300</value>
</parameter>
<parameter>
    <name>logAbandoned</name>
    <value>true</value>
</parameter>

</ResourceParams>
</DefaultContext>

3) Change the values of url, username, password as per the environment setu=
p at Toshiba side.

4) Significance of following tags:
maxActive : Maximum number of dB connections in pool. Make sure the max_con=
nections of DB are large enough to handle
this limit. Set to 0 for no limit.

maxIdle : Maximum number of idle dB connections to retain in pool. Set to 0=
 for no limit.

maxWait : Maximum time to wait for a dB connection to become available in m=
s, in this example 10 seconds. An Exception is thrown if this timeout is ex=
ceeded. Set to -1 to wait indefinitely.

removeAbandoned : Abandoned dB connections are removed and recycled based o=
n this paramater to the ResourceParams configuration for the DBCP DataSourc=
e Resource.

removeAbandonedTimeout : Sets the number of seconds a dB connection is left=
 idle before it is considered abandoned.=20
logAbandoned : The logAbandoned parameter can be set to true if you want DB=
CP to log a stack trace of the code which abandoned the dB connection resou=
rces.=20

5) Add the following tag in web.xml to ensure default session timeout.
<session-config>
    <session-timeout>5</session-timeout>
</session-config>

Value specified is the minutes after which session timeout would occur.

------=_NextPart_000_003E_01C51906.CE9274D0
Content-Type: text/xml;
	name="web.xml"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="web.xml"

<?xml version=3D"1.0" encoding=3D"ISO-8859-1"?>

<web-app xmlns=3D"http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation=3D"http://java.sun.com/xml/ns/j2ee http://java.sun.c=
om/xml/ns/j2ee/web-app_2_4.xsd"
    version=3D"2.4">

<listener>
    <listener-class>jp.co.toshiba.RDC.PSW.common.PSWSessionListener</listen=
er-class>
</listener>
=09
<servlet>
	<servlet-name>PSWUserAuthServlet</servlet-name>
	<display-name>PSWUserAuthServlet</display-name>
	<servlet-class>jp.co.toshiba.RDC.PSW.common.PSWUserAuthServlet</servlet-cl=
ass>

	<init-param>
		<param-name>driver</param-name>
		<param-value>oracle.jdbc.driver.OracleDriver</param-value>
	</init-param>=20=20=20=20=20=20
	<init-param>
		<param-name>url</param-name>
		<param-value>jdbc:oracle:thin:@pc-p4254:1521:PKGSFT</param-value>
	</init-param>=20=20=20=20=20=20
	<init-param>
		<param-name>DBuser</param-name>
		<param-value>pswtoshiba</param-value>
	</init-param>=20=20=20=20=20=20
	<init-param>
		<param-name>DBpassword</param-name>
		<param-value>pswtoshiba</param-value>
	</init-param>=20=20=20=20=20=20
	<init-param>
		<param-name>initial_increment</param-name>
		<param-value>1</param-value>
	</init-param>=20=20=20=20=20=20
	<init-param>
		<param-name>increment</param-name>
		<param-value>1</param-value>
	</init-param>=20=20=20=20=20=20

	<init-param>
		<param-name>sessiontimeout</param-name>
	        <param-value>300</param-value>
	</init-param>=20=20=20=20=20=20

</servlet>

<servlet>
	<servlet-name>PSWCSVServlet</servlet-name>
	<display-name>PSWCSVServlet</display-name>
	<servlet-class>jp.co.toshiba.RDC.PSW.common.PSWCSVServlet</servlet-class>
</servlet>

<servlet>
	<servlet-name>PSWLogoutServlet</servlet-name>
	<display-name>PSWLogoutServlet</display-name>
	<servlet-class>jp.co.toshiba.RDC.PSW.common.PSWLogoutServlet</servlet-clas=
s>
</servlet>

<servlet-mapping>
<servlet-name>PSWUserAuthServlet</servlet-name>
<url-pattern>/servlet/PSWUserAuthServlet</url-pattern>
</servlet-mapping>

<servlet-mapping>
<servlet-name>PSWCSVServlet</servlet-name>
<url-pattern>/servlet/PSWCSVServlet</url-pattern>
</servlet-mapping>

<servlet-mapping>
<servlet-name>PSWLogoutServlet</servlet-name>
<url-pattern>/servlet/PSWLogoutServlet</url-pattern>
</servlet-mapping>

<session-config>
        <session-timeout>5</session-timeout>
</session-config>

</web-app >



------=_NextPart_000_003E_01C51906.CE9274D0
Content-Type: text/plain; charset=us-ascii

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