Oracle/Tomcat/CMAN

[stecal]

Has anyone successfully configured the web.xml file on Tomcat and have it use the format shown in the JDBC developer guide on page 18-19 (where the connection string is using a mini-tnsnames.ora address list)? This is what Oracle says to use for CMAN & firewall connections. What's shown below would be used as a local param.

Was just this:
jdbc-colon-oracle:thin:@host_name:1521:SID

And is now supposed to be like this:

jdbc-colon-oracle:thin:@(description=(address_list=
(address=(protocol=tcp)(port=1610)(host=webHost))
(address=(protocol=tcp)(port=1521)(host=oraHost)))
(connect_data=(INSTANCE_NAME=orcl))
(source_route=yes));

[Lily_Liu_2004]

Originally posted by stecal

And is now supposed to be like this:

jdbc-colon-oracle:thin:@(description=(address_list=
(address=(protocol=tcp)(port=1610)(host=webHost))
(address=(protocol=tcp)(port=1521)(host=oraHost)))
(connect_data=(INSTANCE_NAME=orcl))
(source_route=yes));

I used to configure jdbc oci driver in tomcat,
this worked.