Return-Path: 
 <tomcat-dev-return-50076-apmail-jakarta-tomcat-dev-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-dev-archive@www.apache.org
Received: (qmail 6771 invoked from network); 6 Sep 2004 19:31:37 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 6 Sep 2004 19:31:37 -0000
Received: (qmail 34516 invoked by uid 500); 6 Sep 2004 19:31:30 -0000
Delivered-To: apmail-jakarta-tomcat-dev-archive@jakarta.apache.org
Received: (qmail 33910 invoked by uid 500); 6 Sep 2004 19:31:26 -0000
Mailing-List: contact tomcat-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-dev-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-dev-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-dev-help@jakarta.apache.org>
List-Post: <mailto:tomcat-dev@jakarta.apache.org>
List-Id: "Tomcat Developers List" <tomcat-dev.jakarta.apache.org>
Reply-To: "Tomcat Developers List" <tomcat-dev@jakarta.apache.org>
Delivered-To: mailing list tomcat-dev@jakarta.apache.org
Received: (qmail 33897 invoked by uid 99); 6 Sep 2004 19:31:25 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of jmrengifo@gmail.com
 designates 64.233.170.199 as permitted sender)
Received: from [64.233.170.199] (HELO mproxy.gmail.com) (64.233.170.199)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 06 Sep 2004 12:31:24 -0700
Received: by mproxy.gmail.com with SMTP id 78so177256rnl
        for <tomcat-dev@jakarta.apache.org>;
 Mon, 06 Sep 2004 12:31:22 -0700 (PDT)
Received: by 10.38.78.70 with SMTP id a70mr1559316rnb;
        Mon, 06 Sep 2004 12:31:22 -0700 (PDT)
Received: by 10.38.15.39 with HTTP; Mon, 6 Sep 2004 12:31:22 -0700 (PDT)
Message-ID: <6e44abd40409061231a6bc42@mail.gmail.com>
Date: Mon, 6 Sep 2004 15:31:22 -0400
From: Jonathan Rengifo <jmrengifo@gmail.com>
Reply-To: Jonathan Rengifo <jmrengifo@gmail.com>
To: tomcat-dev@jakarta.apache.org
Subject: Problem upgrading to Tomcat 5
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi all...

I am preparing a new production web sever configured with Apache 2
serving static content and Tomcat 5.0.27 serving dynamic content via
TCP JK2 connector.

In Tomcat, I am trying to configure one database Resource element for
various Context, so I decide to configure one Resource element into
the GlobalNamingResources element, and then  link it via ResourceLink
element on the Context I need to have; this configuration don=B4t work,
it throws me an exception on tomcat start up:

java.lang.RuntimeException: com.MyCompany.db.ManagerException:
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver
class 'oracle.jdbc.driver.OracleDriver'

This happens although the driver is locate on my lib application, and
I try to cut an pasted on $TOMCAT_HOME/shared/lib and still get the
same output result.

That configuration used to work on Tomcat 4, but don't know what
happened or change on new releases. I've read the "Server
Configuration Reference" documentation from
"http://manuals.thexdershome.com/tomcat-5.0/config/context.html" with
no success (There are examples using my server.xml configuration). So,
after all I just copy the Resource element on each Context and it
works, but believe this is not simple the best way to do this...

Here is an example of what I've done:

....
....
 <GlobalNamingResources>
       =20
<Environment name=3D"simpleValue" override=3D"true"
type=3D"java.lang.Integer" value=3D"30"/>
              =20
<Resource name=3D"jdbc/app" auth=3D"Container" scope=3D"Shareable"
type=3D"javax.sql.DataSource"/>
        <ResourceParams name=3D"jdbc/app">
            <parameter>
                <name>factory</name>
                <value>org.apache.commons.dbcp.BasicDataSourceFactory</valu=
e>
            </parameter>
            <parameter>
                <name>url</name>
                <value>jdbc:oracle:thin:@myDatabaseServer:port:user</value>
            </parameter>
            <parameter>
                <name>password</name>
                <value>myPassword</value>
            </parameter>
            <parameter>
                <name>maxActive</name>
                <value>20</value>
            </parameter>
            <parameter>
                <name>maxWait</name>
                <value>-1</value>
            </parameter>
            <parameter>
                <name>driverClassName</name>
                <value>oracle.jdbc.driver.OracleDriver</value>
            </parameter>
            <parameter>
                <name>username</name>
                <value>myUser</value>
            </parameter>
            <parameter>
                <name>maxIdle</name>
                <value>10</value>
            </parameter>
        </ResourceParams>        =20
</GlobalNamingResources>

...
...
...

<Host className=3D"org.apache.catalina.core.StandardHost"=20
           appBase=3D"webapps"
           autoDeploy=3D"true"=20
           configClass=3D"org.apache.catalina.startup.ContextConfig"
           contextClass=3D"org.apache.catalina.core.StandardContext"=20
           debug=3D"0"=20
           deployXML=3D"true"
           errorReportValveClass=3D"org.apache.catalina.valves.ErrorReportV=
alve"
           liveDeploy=3D"true"
mapperClass=3D"org.apache.catalina.core.StandardHostMapper"
           name=3D"mySubDomain.myDomain.com"=20
           unpackWARs=3D"true">
               =20
           <Valve  className=3D"org.apache.catalina.valves.AccessLogValve"=
=20
                       pattern=3D"combined"
                       resolveHosts=3D"false"=20
                       directory=3D"/appPath"/>
               =20
                        =20
          <Context =20
className=3D"org.apache.catalina.core.StandardContext"               =20
cachingAllowed=3D"true"
                  =20
charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"=20
cookies=3D"true"
                                        crossContext=3D"false"=20
                                        debug=3D"0"=20
                                        displayName=3D"myApp"
                                        docBase=3D"/appPath/root"
                                      =20
mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
                                        path=3D""
                                        privileged=3D"false"
reloadable=3D"false" swallowOutput=3D"false"
                                        useNaming=3D"true"
                                      =20
wrapperClass=3D"org.apache.catalina.core.StandardWrapper"
                                        allowLinking=3D"true">
                           =20
                            <ResourceLink name=3D"jdbc/app"
global=3D"jdbc/app" type=3D"javax.sql.DataSource"/>
                        </Context>
            </Host>

.....
.....
.....

I was thinking too on move to Tomcat 5.0.28 relesed few days ago, to
see if problem solves, but don=B4t know what are the advantages and
bugfixes it has regarding 5.0.27 release I am using, can you please
tell me some or where to read them?

Any help or comments you have would be very appreciated...

Regards

Jonathan

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