Intermittent JDBC connection

Discussion in 'Java' started by teser3@hotmail.com, May 25, 2010.

  1. Guest

    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:
    view plaincopy to clipboardprint?
    jdbc:eek:racle:thin:mad:(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) )))
    jdbc:eek:racle:thin:mad:(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.

    Please advise.
     
    , May 25, 2010
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Keith Wansbrough

    Re: jdbc help:sun.jdbc.odbc.JdbcOdbcDriver

    Keith Wansbrough, Aug 16, 2004, in forum: Java
    Replies:
    0
    Views:
    769
    Keith Wansbrough
    Aug 16, 2004
  2. Betty
    Replies:
    1
    Views:
    9,889
    Juha Laiho
    May 21, 2005
  3. Replies:
    4
    Views:
    2,074
    Tom Anderson
    May 26, 2010
  4. Ben Clackson

    Intermittent "Underlying Connection Was Closed"

    Ben Clackson, Dec 5, 2003, in forum: ASP .Net Web Services
    Replies:
    0
    Views:
    137
    Ben Clackson
    Dec 5, 2003
  5. Dan
    Replies:
    9
    Views:
    261
    Bob Barrows [MVP]
    Apr 13, 2007
Loading...

Share This Page