Take care: Oracle advises you to use their proprietary OracleDataSource, and to import oracle.jdbc.pool.*. Once you got the code working, it might be a good exercise to see how you can switch to the standard java interfaces.
Regards, Jan [ July 03, 2007: Message edited by: Jan Cumps ]
OCUP UML fundamental and ITIL foundation
Joined: Jul 15, 2006
Unfortunately, this is not a programmatic call. I'm trying to configure Tomcat 5.5 to use an Oracle RAC database for session replication and the configuration tags provide only one attribute on the tag. That attribute is connectionURL.
I need to be able to specify everything about that database in that one URL. I know I can specify the long winded RAC url, but not sure how to fit in the username and password.
Apparently, in the mysql, postgress world putting username, passwords in JDBC urls is very common, probably why Tomcat developers didn't see the need to provide username/password.