Database connection pooling in Tomcat 5.5

["Parsons Technical Services" <parsonstechnical (at) earthlink.net>]

Try this:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm#05_03

Otherwise there is some differences in the parameter names. Others have used 
connectionUser and connectionPassword , I think it was.

You can search the archives for OracleDriver to see what I mean.

Sorry, I do not use oracle, so I cannot say what is right.

Doug


----- Original Message ----- 
From: "Darren Hall" <dhall (at) utrs.com>
To: "'Tomcat Users List'" <users (at) tomcat.apache.org>
Sent: Monday, September 18, 2006 4:38 PM
Subject: RE: Database connection pooling in Tomcat 5.5


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





---------------------------------------------------------------------
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