Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
DomainKey-Status: good
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=gDc8tVnrXLDfNgSV/wDRbE6gbreyrW70dHhxNfo6c6ZhoN4i4TRtSmlB85IDGlrFOqGYlVbUp+FUH5CHSHDkwO0dxAUxCm63krOxOCYc4IeLO7oTDmCDpnj+gGwk4bjtTM7au3d28LFFuEyu63/4Guoh2DUFxfGHU1eIPqsjyI0=
  ;
Message-ID: <20060920073505.16231.qmail@web52410.mail.yahoo.com>
Date: Wed, 20 Sep 2006 00:35:05 -0700 (PDT)
From: Sameer Acharya <acharya_sam@yahoo.com>
Subject: RE: Database connection pooling in Tomcat 5.5
To: Tomcat Users List <users@tomcat.apache.org>
In-Reply-To: <00da01c6db5a$ef0ec520$800101df@utrsch.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-937256652-1158737705=:15364"
Content-Transfer-Encoding: 8bit

--0-937256652-1158737705=:15364
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I have a datasource defined similar to yours I get this error when I try to use 

ds.getConnection("username", "password");

but if I just use ds.getConnection(); it works fine.

-Sameer

Darren Hall <dhall@utrs.com> wrote: Is there any other information I can supply to help people help me
understand why I'm getting this error (below)?

> I've made some progress on this. I'm now receiving a "SQLNestedException: 
> Cannot create PoolableConnectionFactory" error when calling getConnection 
> on the DataSource object retrieved from my connection pool. Here is the 
> stack trace:
>
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create 
> PoolableConnectionFactory (ORA-01017: invalid username/password; logon 
> denied)
> at 
>org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSourc
e.java:855)
> at 
>
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.ja
va:540)
> at 
>
org.federallabs.labs.LaboratorySearchAction.execute(LaboratorySearchAction.j
ava:99)
> 


> You are likely connecting to the wrong catalog.  Is the pool parameter
> defaultCatalog set?

That's specified in my Context, correct? If so, then no, I don't have my
defaultCatalog parameter set.

Here is my context.xml file (comments removed, as well as domain uname and
passwd)


        debug="5" reloadable="true" crossContext="true">

    
              type="javax.sql.DataSource" 
    driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@devdb1.(mydomain).com:1521:flcdb"
              username="(uname)" password="(passwd)" 
    maxActive="20" maxIdle="10"
              maxWait="-1" removeAbandoned="true" 
    moveAbandonedTimeout="180"
              logAbandoned="true"/> 


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


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


"All that is necessary for the triumph of evil is that good men do 
nothing." Edmund Burke

-Sameer
 		
---------------------------------
Stay in the know. Pulse on the new Yahoo.com.  Check it out. 
--0-937256652-1158737705=:15364--