Retry logic in JDBC URL

[Anshul Jain]

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