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 <[EMAIL PROTECTED]> wrote: 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"
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:[EMAIL PROTECTED]
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:@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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
