my dog learned polymorphism*
The moose likes JDBC and the fly likes Retry logic in JDBC URL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Retry logic in JDBC URL" Watch "Retry logic in JDBC URL" New topic
Author

Retry logic in JDBC URL

Anshul Jain
Greenhorn

Joined: May 10, 2006
Posts: 12
Hi All,

I am facing problem of StaleConnection in my WebSphere6. Somebody recomanded that if I use retry logic in JDBC URL this problem can be solved without any performance overhead.

I did it like below and changed the same in WAS datasource settings:
Before
jdbcracle:thin:@uat1:1521:lduat

After
jdbcracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=uat1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=lduat)(FAILOVER_MODE=(TYPE=select)(METHOD=BASIC)(RETRIES=50)(DELAY=10))))

But here RETRIES is not woring. I am still getting StaleConnection. Please let me know if any other change required. if somebody has test conditions then please help me with taht also.

Waiting for you Quick response.
Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Retry logic in JDBC URL
 
Similar Threads
Multi datasource in websphere
could not connect to oracle database from struts application
websphere JMS question
Oracle RAC intermittent connection
Unable to extraxt StaleConnectionException from DataAceessException