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" <[EMAIL PROTECTED]>
To: "'Tomcat Users List'" <users@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:[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)
<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:@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@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]