This discussion is archived
0 Replies Latest reply: Sep 21, 2012 8:00 AM by phaeus RSS

Glassfish in a Dataguard Environment

phaeus Pro
Currently Being Moderated
Hello,
i am not sure if this is the right place to post, if not please forgive me.
I am searching for some sample of jdbc connection pool Parameter when i also use a Standby Database in the backend.

I use "is-connection-validation-required" with checking dual table. The Problem is when my primary database (which is first in the connect descripter) fails (network outage) my database session needing a long time for reconnect. I have also change some network parameter (at TCP Level) to reduce the time where time JDBC Driver waits for the SYN_SENT event. But when we have over 100 Session to the Database and i must wait 2 Minutes for one session to close its to long.

I only want some ideas or example like use or not use "associate-with-thread" parameter or someone else has fixed this thing. I have also observed that setting the "ENABLE=BROKEN" Parameter is not getting the things better to work.

OS OEL 5 64Bit
Glassfish 3.2
JDBC (one of the latest version)
Using JDBC Thin (required)

regards
Peter

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points