Re: TAF and JDBC connections

Take the entry from (DESCRIPTION to the end and taek all whitespace and carriage returns out. Then use that as your JDBC URL

On Thu, Jul 10, 2008 at 10:12 AM, Dba DBA <oracledbaquestions_at_gmail.com> wrote:

> I have developers connecting to my RAC database with jdbc. I want them to
> use nodes 3 and 4. I have a TAF tnsnames set up for them as follows:
> This is the tnsnames on the server. However, JDBC does not use tnsnames.
> How do I get them to take advantage of this ?
> I can use this locally on my RAC boxes.
>
> so what do I do with jdbc guys?
>
> JAVAGUYS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = node4-vip)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = JAVAGUYS)
> )
> )
>

-- 
Bradd Piontek
Twitter: http://www.twitter.com/piontekdd
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
Last.fm: http://www.last.fm/user/piontekdd/

--
http://www.freelists.org/webpage/oracle-l