cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (CAY-1462) Refreshing connections in DataPool after DB restart
Date Mon, 12 Jul 2010 08:13:50 GMT

    [ https://issues.apache.org/jira/browse/CAY-1462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887301#action_12887301
] 

Andrus Adamchik commented on CAY-1462:
--------------------------------------

Evgeny, I suggest using DBCP connection pool that has query validation feature. Cayenne's
own connection pool is intentionally very basic, as there are dozens of pool implementations
out there (mostly bundled with app servers, but also standalone like Apache commons DBCP).

> 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: 2.0 branch, 3.0
>         Environment: MS SQL
>            Reporter: Evgeny Ryabitskiy
>            Assignee: Evgeny Ryabitskiy
>             Fix For: 2.0.5, 3.1M1
>
>
> 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message