users@glassfish.java.net

Re: SQLException does not drop JDBC connection from pool

From: Marina Vatkina <Marina.Vatkina_at_Sun.COM>
Date: Tue, 14 Oct 2008 09:42:04 -0700

Copy-and-paste from the domain.xml.

regards,
-marina

Markus Karg wrote:
> 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
>
>