I have a datasource defined similar to yours I get this error when I try to use
ds.getConnection("username", "password");
but if I just use ds.getConnection(); it works fine.
-Sameer
Darren Hall <[EMAIL PROTECTED]> wrote: Is there any other information I can
supply to help people help me
understand why I'm getting this error (below)?
> I've made some progress on this. I'm now receiving a "SQLNestedException:
> Cannot create PoolableConnectionFactory" error when calling getConnection
> on the DataSource object retrieved from my connection pool. Here is the
> stack trace:
>
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (ORA-01017: invalid username/password; logon
> denied)
> at
>org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSourc
e.java:855)
> at
>
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.ja
va:540)
> at
>
org.federallabs.labs.LaboratorySearchAction.execute(LaboratorySearchAction.j
ava:99)
>
> 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: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
"All that is necessary for the triumph of evil is that good men do
nothing." Edmund Burke
-Sameer
---------------------------------
Stay in the know. Pulse on the new Yahoo.com. Check it out.
