users@glassfish.java.net

RE: RE: Re: SQLException does not drop JDBC connection from pool

From: Markus Karg <karg_at_quipsy.de>
Date: Tue, 14 Oct 2008 18:38:50 +0200

Sure, but in what form do you want to get the config? I only know how to use admin GUI. Shall I sent all the single values, or do you want a file?

> -----Original Message-----
> From: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> Sent: Dienstag, 14. Oktober 2008 18:35
> To: users_at_glassfish.dev.java.net
> Subject: RE: Re: SQLException does not drop JDBC connection from pool
>
> Yes, relevant server.log & pool configuration (to see DB properties
> also) content should be fine.
>
> Thanks,
> -Jagadish
>
>
> On Tue, 2008-10-14 at 17:41 +0200, Markus Karg wrote:
> > Well, I wil do but... I don't think that you want me to send all the
> megabytes of server.log plus screenshots from the admin GUI. So what
> part of the server.log do you want, just the exception plus the minutes
> after it? And how to send the config? The config in fact is completely
> default plus "table check" enabled (including a table name).
> >
> > Regards
> > Markus
> >
> > > -----Original Message-----
> > > From: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> > > Sent: Dienstag, 14. Oktober 2008 16:57
> > > To: users_at_glassfish.dev.java.net
> > > Subject: Re: SQLException does not drop JDBC connection from pool
> > >
> > > Hi Markus,
> > > Could you post your pool configuration and the server.log ?
> > >
> > > Thanks,
> > > -Jagadish
> > >
> > >
> > > On Tue, 2008-10-14 at 16:13 +0200, Markus Karg wrote:
> > > > Dear Community,
> > > >
> > > >
> > > >
> > > > I have enabled "table" type connection check and added an
> existing
> > > > table. "DROP ALL" is DISABLED, so the failing connection only
> should
> > > > be dropped. Minimum pool size is 8, maximum is 32. Due to IDLE
> > > > settings, the DBMS drops the connections, so they result in
> > > exceptions
> > > > when trying to use them. The exceptions are shown in server.log
> from
> > > > GlassFish.
> > > >
> > > >
> > > >
> > > > But: I can try hundreds of times and never get a new connection,
> but
> > > > always get SQLException in the calling client. Neither are
> > > connections
> > > > dropped nor are new connections opened.
> > > >
> > > >
> > > >
> > > > What am I doing wroing? Or is that a bug?
> > > >
> > > >
> > > >
> > > > Thanks
> > > >
> > > > Markus
> > > >
> > > >
> > > >
> > > > QUIPSY QUALITY GmbH & Co. KG
> > > >
> > > > Ein Unternehmen der MES-Gruppe
> > > >
> > > > Stuttgarter Strasse 23
> > > >
> > > > D-75179 Pforzheim
> > > >
> > > > Tel: 07231-9189-52
> > > >
> > > > Fax: 07231-9189-59
> > > >
> > > > www.quipsy.de
> > > >
> > > > karg_at_quipsy.de
> > > >
> > > > Registergericht Mannheim HRA 701214
> > > >
> > > > Geschäftsführer: Nils Schroeder
> > > >
> > > >
> > > >
> > > > Diese E-Mail enthält persönliche, vertrauliche und vor Weitergabe
> > > > geschützte Informationen und ist ausschließlich für den
> vorgesehenen
> > > > o.g. Empfänger (Adressaten) bestimmt. Falls Sie diese E-Mail
> > > > versehentlich erhalten haben und nicht der vorgesehene Empfänger
> > > sind,
> > > > bitten wir Sie, die E-Mail und deren Anhänge nicht aufzubewahren,
> > > > nicht zu vervielfältigen, nicht zu nutzen und nicht
> weiterzugeben.
> > > > Bitte informieren Sie uns als Absender über diesen
> Zustellungsfehler
> > > > und löschen Sie die E-Mail.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > -----------------------------------------------------------------
> ----
> > > > To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > > > For additional commands, e-mail: users-
> help_at_glassfish.dev.java.net
> > >
> > >
> > > -------------------------------------------------------------------
> --
> > > To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > > For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net