Maison
we cannot blame GF AppServer when we dont know what ConnectionPool implementation you are using Kindly detail for us: Which ConnectionPool Technology and Version you are implementing
ConnectionPool Configuration parameters (such as what is described in Configuration.xml)
Bon Chance,
Martin
______________________________________________
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
Date: Sat, 22 Dec 2012 19:16:50 +0100
From: momaison_at_yahoo.fr
To: users_at_glassfish.java.net
Subject: Re: XA transaction errors on non-XA connection pools?
Le 22/12/2012 00:32, Marina Vatkina a écrit :
On 12/21/12 3:03 PM, Laird Nelson wrote:
Since flushing the connection pool is a known
bug (i.e. there's no way from the admin console to flush a
pool without causing an error; see
http://java.net/jira/browse/GLASSFISH-14130
for an example; this is true even of our initialized pools
on 3.1.2.2), can I somehow tell GlassFish to dump and
refill the pool at the first sign of connection trouble?
I didn't see anything obvious in
http://docs.oracle.com/cd/E26576_01/doc.312/e24928/jdbc.htm#gharo.
Hmmmm ... connection validation should be documented...
I would also appreciate such a documentation : have the same exact
problem
where a restart of the database server (this is very unlikely but
hey : it may
happen in HA environments in case of master/slave switch for
example)
generates domain connections errors looong after the DB server is
up.
I presume these are caused by staled pooled connections.
I tried to tweak some validations parameters (validation by a SQL
query
for example), but could not get to something to work.
Any advice ?
Regards,
M. Maison