Inidcations are from the exception, the config on your end is working
and it's actually attempting to get a connection, but the login fails.
Have you tried using the client software from the machine tomcat is on,
using the same tcp/ip url and parameters tomcat is using? Are there any
logs on the database that might help from that end?
--David
Darren Hall 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)
<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]
