Re: Intermittent JDBC connection

From:

"Mike Schilling" <mscottschilling@hotmail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 25 May 2010 07:46:58 -0700

Message-ID:

<htgnt4$d4n$1@news.eternal-september.org>

Tom Anderson wrote:

On Mon, 24 May 2010, Mike Schilling wrote:

teser3@hotmail.com wrote:

I am connecting to Oracle 10g RAC using JDBC in Tomcat 6.0.20.
It works around 50% of the time. When it doesnt work it shows this
error message:
IO exception: The Network Adapter could not establish the
connection. Here is my JDBC String:
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)
(HOST=170.11.5.111) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)
(HOST=170.11.5.112)
(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service) (FAILOVER_MODE
=
(TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY
= 5) )))

The above Description parameters I use in my tnsnames.ora and can
successfully connect to the Oracle RAC using SQL Plus with no
issues. I can also successfully ping to the IP addresses with no
issues. I also played around with the JDBC string and added
(FAILOVER=ON)
but still have same issues.

You're connecting to one of two ports, and it works 50% of the time.
What happens if you connect to only one of the ports?

By 'port' do you mean 'address'?

Two TCP ports: Both 1521 on 170.11.5.111 and 1521 on 170.11.5.112. I'm
wondering if only one of themn is answering.