[CAY-1462] Refreshing connections in DataPool after DB restart

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1M1
• Fix Version/s: Undefined future
• Environment: MS SQL
• Assignee: Evgeny Ryabitskiy
• Reporter: Evgeny Ryabitskiy
• Created: 12/Jul/10 07:58
• Updated: 29/Sep/14 19:52

Description

Problem can be simulated after restart of SQL Server.

So connection in my pool become "dead". Only thing that helps: restart my appllication.

I wold like to have some mechanism to validate pooled connections and refresh them.

Possible solutions:
1) validate before give connection from pool
2) asynchronous thread for validation.
3) Generate event for pool on such exceptions (to validate and refresh connections)

1- is more reliable but not sure how it will influence on performance...
2 - at least something... but can look like some not understandable magic...
3 - need some code investigation...