Database connection pooling in Tomcat 5.5

["Darren Hall" <dhall (at) utrs.com>]

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)

<Context path="/flc" docBase="flc"
        debug="5" reloadable="true" crossContext="true">

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


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



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