tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sameer Acharya <acharya_...@yahoo.com>
Subject RE: Database connection pooling in Tomcat 5.5
Date Wed, 20 Sep 2006 07:35:05 GMT
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. 
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message