Frank W. Zammetti wrote:
Yep, I had a coworker suggest using the OCI driver as well...
And you have to use the right JDBC driver as well.
At least up to the 9.* timeframe, Oracle used to release two JDBC
drivers: one was a thin-only driver with its JDBC distribution, and
one was the full
Does anyone have any experience configuring Tomcat to connect to an Oracle
RAC cluster?
I have an application that currently works in a test environment, where it
connects to a single Oracle server. Now I'm moving it to a QA
environment, where there is a 3-node Oracle cluster using RAC. I'm
Hi Frank,
With the caveat that I don't use RAC, it looks like you're doing
things right from a JDBC/Tomcat perspective, but I thought I'd bring
one point just to clarify for you and any lurkers: JDBC doesn't use
TNS at all; it only cares about the host, port and SID as specified in
the connection
Yep, I had a coworker suggest using the OCI driver as well... seems you
can just drop the TNS string into the URL parameter in server.xml... I
couldn't get it to work, but I suspect it was just a minor typo or
something, the theory seems dead-on.
I would up just writing the connection string to