aspose file tools*
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Retry logic in JDBC URL