aspose file tools
The moose likes JDBC and Relational Databases 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


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
Don't get me started about those stupid light bulbs.
 
subject: Retry logic in JDBC URL