Return-Path: 
 <users-return-191734-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 86270 invoked from network); 13 Feb 2009 18:12:27 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 13 Feb 2009 18:12:27 -0000
Received: (qmail 14869 invoked by uid 500); 13 Feb 2009 18:12:15 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 14843 invoked by uid 500); 13 Feb 2009 18:12:15 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 14832 invoked by uid 99); 13 Feb 2009 18:12:15 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Feb 2009 10:12:15 -0800
X-ASF-Spam-Status: No, hits=-2.5 required=10.0
	tests=RCVD_IN_DNSWL_MED,SPF_HELO_SOFTFAIL,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of barry.l.propes@citi.com
 designates 199.67.179.103 as permitted sender)
Received: from [199.67.179.103] (HELO mail.citigroup.com) (199.67.179.103)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Feb 2009 18:12:05 +0000
Received: from imbarc-nj02.nj.ssmb.com (imbarc-nj02-2 [150.110.177.216])
	by imbaspam-ny03.ssmb.com (8.13.8/8.13.8/SSMB_EXT/ev: 22534 $) with ESMTP id
 n1DIBhaV029434
	for <users@tomcat.apache.org>; Fri, 13 Feb 2009 18:11:43 GMT
Received: from mailhub-ss01.nam.nsroot.net (mailhub-ss01.nam.nsroot.net
 [153.40.230.247])
	by imbarc-nj02.nj.ssmb.com (8.13.8/8.13.8/SSMB_QQQ_IN/1.1) with ESMTP id
 n1DIBfSo016997
	for <users@tomcat.apache.org>; Fri, 13 Feb 2009 18:11:41 GMT
Received: from exnjiht02.nam.nsroot.net (EXNJIHT02.nam.nsroot.net
 [150.110.165.228])
	by mailhub-ss01.nam.nsroot.net (8.13.8/8.13.8/CG_HUB) with ESMTP id
 n1DIBfhg003034
	for <users@tomcat.apache.org>; Fri, 13 Feb 2009 18:11:41 GMT
Received: from exnjht01.nam.nsroot.net (150.110.165.221) by
 exnjiht02.nam.nsroot.net (150.110.165.228) with Microsoft SMTP Server (TLS)
 id 8.1.311.2; Fri, 13 Feb 2009 13:11:40 -0500
Received: from exgtht03.nam.nsroot.net (169.171.98.132) by
 exnjht01.nam.nsroot.net (150.110.165.221) with Microsoft SMTP Server (TLS) id
 8.1.311.2; Fri, 13 Feb 2009 13:11:40 -0500
Received: from exgtmb06.nam.nsroot.net ([169.171.98.118]) by
 exgtht03.nam.nsroot.net ([169.171.98.132]) with mapi; Fri, 13 Feb 2009
 12:11:39 -0600
From: "Propes, Barry L " <barry.l.propes@citi.com>
To: "'Tomcat Users List'" <users@tomcat.apache.org>
Date: Fri, 13 Feb 2009 12:11:39 -0600
Subject: RE: Oracle connection pooling
Thread-Topic: Oracle connection pooling
Thread-Index: AcmNU7WIQ6ozUL6TQvGpRhMyKKRmAAACky6gAAC4YQAAJL0TYAAEnFCw
Message-ID: 
 <08382548D50D3049BD5599E1E3146B340D047927D3@exgtmb06.nam.nsroot.net>
References: 
 <F0677F10DF29E947962758EE5888EFFE025D3C959E@EXCHNG5.noam.gallup.com>
 <9DD36C99332AB7438F8D73C048D8C62C02096DCC@sneezy.ad.e-dialog.com>
 <08382548D50D3049BD5599E1E3146B340D047927BD@exgtmb06.nam.nsroot.net>
 <F0677F10DF29E947962758EE5888EFFE025D4719C9@EXCHNG5.noam.gallup.com>
In-Reply-To: 
 <F0677F10DF29E947962758EE5888EFFE025D4719C9@EXCHNG5.noam.gallup.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Scanned-By: MIMEDefang 2.52 on 199.67.177.41
X-Virus-Checked: Checked by ClamAV on apache.org

For factory,  I have

 <name>factory</name>
     <value>org.apache.commons.dbcp.BasicDataSourceFactory=20
 type=3D"javax.sql.DataSource"/>

I'd try taking out that line you have --

                type=3D"oracle.jdbc.pool.OracleDataSource"
                        factory=3D"oracle.jdbc.pool.OracleDataSourceFactory=
"

And switch up accordingly. See if that doesn't work.

-----Original Message-----
From: Hamacher, Eric [mailto:Eric_Hamacher@gallup.com]=20
Sent: Friday, February 13, 2009 11:45 AM
To: Tomcat Users List
Subject: RE: Oracle connection pooling

I was just putting some fake values there.

But I got around the problem (although I can't remember how)  Now I put:

<Resource name=3D"jdbc/GFDataSource" auth=3D"Container"
                type=3D"oracle.jdbc.pool.OracleDataSource"
                        factory=3D"oracle.jdbc.pool.OracleDataSourceFactory=
"
                        connectionCachingEnabled=3D"true"
                    maxActive=3D"30"
                    maxIdle=3D"2"
                    maxWait=3D"1000"
                    username=3D"username"
                    password=3D"password"
                    driverClassName=3D"oracle.jdbc.driver.OracleDriver"
                    url=3D"jdbc:oracle:thin:@server:port:SID"/>

into META-INF/context.xml.  The type "javax.sql.DataSource" didn't work.  N=
ow when I call getConnection() on the OracleDataSource I get:

java.sql.SQLException: User credentials doesn't match the existing ones
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError=
.java:138)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError=
.java:175)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError=
.java:240)
        at oracle.jdbc.pool.OracleImplicitConnectionCache.validateUser(Orac=
leImplicitConnectionCache.java:258)
        at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(Ora=
cleImplicitConnectionCache.java:314)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource=
.java:286)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource=
.java:179)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource=
.java:159)

This looks like an Oracle problem.

Thanks for all your help!!

J.  ERIC  HAMACHER
Software Application Developer
608.664.3859
8476 Greenway Boulevard
Suite 100
Middleton, WI  53562
USA
GALLUP Technology

Achiever | Learner | Restorative | Intellection | Deliberative

-----Original Message-----
From: Propes, Barry L [mailto:barry.l.propes@citi.com]
Sent: Thursday, February 12, 2009 4:27 PM
To: 'Tomcat Users List'
Subject: RE: Oracle connection pooling

Yeah -- 3333 looked like an odd port to me, too -- I've only seen 1521, 152=
6 and 1527 before.
I figured his SID was just a generic placeholder for his real SID.

-----Original Message-----
From: Jorge Medina [mailto:jmedina@e-dialog.com]
Sent: Thursday, February 12, 2009 4:12 PM
To: Tomcat Users List
Subject: RE: Oracle connection pooling


Is your Oracle database port 3333 and is the name of your SID "SID"?

We use Oracle jdbc driver with Oracle 10g.
I set the attributes on the resource to:
   type=3D"javax.sql.DataSource"
   driverClassName=3D"oracle.jdbc.OracleDriver"
and no factory


-----Original Message-----
From: Hamacher, Eric [mailto:Eric_Hamacher@gallup.com]
Sent: Thursday, February 12, 2009 3:52 PM
To: users@tomcat.apache.org
Subject: Oracle connection pooling

Hello:

I am in a bind.

I am getting:

javax.naming.NameNotFoundException: Name jdbc is not bound in this Context =
at
org.apache.naming.NamingContext.lookup(NamingContext.java:770)
      at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
      at
org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
      at javax.naming.InitialContext.lookup(InitialContext.java:351)
      at
survey.db.SurveyConnection.getConnection(SurveyConnection.java:66)
      at
util.LoadDropdownListener.loadAllCodes(LoadDropdownListener.java:137)
      at
util.LoadDropdownListener.contextInitialized(LoadDropdownListener.java:7
8)

when I add:

<Resource name=3D"jdbc/GFDataSource" auth=3D"Container"
                  type=3D"oracle.jdbc.pool.OracleDataSource"
                  factory=3D"oracle.jdbc.pool.OracleDataSourceFactory"
                  connectionCachingEnabled=3D"true"
                maxActive=3D"30"
                maxIdle=3D"2"
                maxWait=3D"1000"
                username=3D"GLP_S"
                password=3D"gideupstg"
                driverClassName=3D"oracle.jdbc.driver.OracleDriver"
                url=3D"jdbc:oracle:thin:@server:3333:SID"/>

to either server.xml (under <Server>), config/context.xml (under <Context>)=
, or in META-INF/context.xml.

Here's what these files look like when I place <Resource> in them:

********** SERVER.XML
***************************************************************

<Server port=3D"8005" shutdown=3D"SHUTDOWN">
  <Listener className=3D"org.apache.catalina.core.AprLifecycleListener"
SSLEngine=3D"on" />
  <Listener className=3D"org.apache.catalina.core.JasperListener" />
  <Listener
className=3D"org.apache.catalina.mbeans.ServerLifecycleListener" />
  <Listener
className=3D"org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
/>
  <GlobalNamingResources>
    <Resource name=3D"UserDatabase" auth=3D"Container"
              type=3D"org.apache.catalina.UserDatabase"
              description=3D"User database that can be updated and saved"

factory=3D"org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname=3D"conf/tomcat-users.xml" />

<Resource name=3D"jdbc/GFDataSource" auth=3D"Container"
                  type=3D"oracle.jdbc.pool.OracleDataSource"
                  factory=3D"oracle.jdbc.pool.OracleDataSourceFactory"
                  connectionCachingEnabled=3D"true"
                maxActive=3D"30"
                maxIdle=3D"2"
                maxWait=3D"1000"
                username=3D"username"
                password=3D"password"
                driverClassName=3D"oracle.jdbc.driver.OracleDriver"
                url=3D"jdbc:oracle:thin:@server:3333:SID"/>

  </GlobalNamingResources>
  <Service name=3D"Catalina">

    <Connector port=3D"8080" protocol=3D"HTTP/1.1"
               connectionTimeout=3D"20000"
               redirectPort=3D"8443" />
    <Connector port=3D"8009" protocol=3D"AJP/1.3" redirectPort=3D"8443" />

    <Engine name=3D"Catalina" defaultHost=3D"localhost">
      <Realm className=3D"org.apache.catalina.realm.UserDatabaseRealm"
             resourceName=3D"UserDatabase"/>
      <Host name=3D"localhost"  appBase=3D"webapps"
            unpackWARs=3D"true" autoDeploy=3D"true"
            xmlValidation=3D"false" xmlNamespaceAware=3D"false">
      </Host>
    </Engine>
  </Service>
</Server>

*************** CONFIG/CONTEXT.XML
*******************************************


<Context>
<Resource name=3D"jdbc/GFDataSource" auth=3D"Container"
                  type=3D"oracle.jdbc.pool.OracleDataSource"
                  factory=3D"oracle.jdbc.pool.OracleDataSourceFactory"
                  connectionCachingEnabled=3D"true"
                maxActive=3D"30"
                maxIdle=3D"2"
                maxWait=3D"1000"
                username=3D"username"
                password=3D"password"
                driverClassName=3D"oracle.jdbc.driver.OracleDriver"
                url=3D"jdbc:oracle:thin:@server:3333:SID"/>
    <WatchedResource>WEB-INF/web.xml</WatchedResource>

</Context>

*************** META-INF/CONTEXT.XML
*******************************************

<Context>

<Resource name=3D"jdbc/GFDataSource" auth=3D"Container"
                  type=3D"oracle.jdbc.pool.OracleDataSource"
                  factory=3D"oracle.jdbc.pool.OracleDataSourceFactory"
                  connectionCachingEnabled=3D"true"
                maxActive=3D"30"
                maxIdle=3D"2"
                maxWait=3D"1000"
                username=3D"username"
                password=3D"password"
                driverClassName=3D"oracle.jdbc.driver.OracleDriver"
                url=3D"jdbc:oracle:thin:@server:3333:SID"/>
</Context>



Here is the offending code:

           Context context =3D new InitialContext();
            DataSource pds =3D null;
            pds =3D (DataSource)context.lookup("jdbc/GFDataSource");
            Connection conn =3D pds.getConnection();
            context.close();


I have tried java:comp/env/jdbc/GFDataSource as well.  I am using ojdbc14dm=
s.jar and dms.jar.

J.  ERIC  HAMACHER
Software Application Developer
608.664.3859
8476 Greenway Boulevard
Suite 100
Middleton, WI  53562
USA
GALLUP Technology

Achiever | Learner | Restorative | Intellection | Deliberative


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


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


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


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