Database connection pooling in Tomcat 5.5

[Serlet Jean-Claude <jean-claude.serlet (at) insee.fr>]

Have you tried
username="myuserid" password="mypassword"
instead  username="(myuserid)" password="(mypassword)"


Jean-Claude

-----Message d'origine-----
De : Sameer Acharya [mailto:acharya_sam (at) yahoo.com] 
Envoyé : mardi 19 septembre 2006 08:49
À : Tomcat Users List
Objet : Re: Database connection pooling in Tomcat 5.5

Instead of defining the username and password as attributes have you tried
defining them as resource parameters  ? just a hunch ..

<parameter>
     <name>username</name>
     <value>myoracleuser</value>
    </parameter>

-Sameer

Parsons Technical Services <parsonstechnical (at) earthlink.net> wrote: Try this:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm#0
5_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" 
To: "'Tomcat Users List'" 
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)


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

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



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



 		
---------------------------------
How low will we go? Check out Yahoo! Messenger's low  PC-to-Phone call
rates.

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