Database connection pooling in Tomcat 5.5
- From: "Darren Hall" <dhall (at) utrs.com>
- Date: Mon, 18 Sep 2006 16:38:04 -0400
Further progress...
When I connect to the database directly (not using a connection pool) and
specify the same username and password below, the code executes fine. When I
try to do the context lookup and connect to the database via the connection
pool, I get the "invalid username/password; logon denied" error. This leads
me to believe the error is in my configuration (or my code).
What am I doing wrong here??
Thanks,
Darren
-----Original Message-----
From: Darren Hall [mailto:dhall (at) utrs.com]
Sent: Monday, September 18, 2006 2:45 PM
To: 'Tomcat Users List'
Subject: RE: Database connection pooling in Tomcat 5.5
> 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