On Wed, 16 Nov 2011 11:31:02 +0100, Philippe Makowski
<makowski@...> wrote:

> Hi,
>
> one customer have problem with jaybird glassfish
> connection pooling
> when they get an exception about UNIQUE KEY violation or NOT NULL
> constraint not satisfied, the pool don't accept anymore queries
> they have to restart GlassFish
> - Glassfish 3.1.1
> - Firebird 2.5
> - Jaybird 2.1.6
>
> any clue ?
> I saw : http://tracker.firebirdsql.org/browse/JDBC-93
> but Jaybird 2.2 is not available yet
> and not sure that it is the same problem
>
> they have a Netbeans test case here :
> ftp.cinematheque.fr/retrait/CineProg.zip

I will see if I am able to reproduce this in 2.1.6 and if I can confirm it
fixed in 2.2. Most likely it is caused by one of the range of problems that
triggered me to reimplement ConnectionPoolDataSource and XADataSource in
the first place (see http://tracker.firebirdsql.org/browse/JDBC-176 ). Do
they get any errors when they are retrieving a new connection, or try to
execute another query?

I am not sure when I will have time to a look at this (maybe this evening,
but it could also be Sunday or later). Could you also create a tracker
ticket?

Mark