You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2014/09/29 21:52:36 UTC
[jira] [Updated] (CAY-1462) Refreshing connections in DataPool
after DB restart
[ https://issues.apache.org/jira/browse/CAY-1462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik updated CAY-1462:
---------------------------------
Fix Version/s: (was: 3.1)
Undefined future
> Refreshing connections in DataPool after DB restart
> ---------------------------------------------------
>
> Key: CAY-1462
> URL: https://issues.apache.org/jira/browse/CAY-1462
> Project: Cayenne
> Issue Type: Improvement
> Affects Versions: 3.1M1
> Environment: MS SQL
> Reporter: Evgeny Ryabitskiy
> Assignee: Evgeny Ryabitskiy
> Fix For: Undefined future
>
>
> 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...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)