pool config. seems fine.
Can you post the exceptions from server.log too?
Thanks,
-Jagadish
On Wed, 2008-10-15 at 08:45 +0200, Markus Karg wrote:
> I think this is the part of domain.xml that you are interested in, corret?
>
> <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="table" datasource-classname="ianywhere.ml.jdbcodbc.jdbc3.ASADataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="true" is-isolation-level-guaranteed="false" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="QUIPSY4" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" validation-table-name="VBFert" wrap-jdbc-objects="false">
> <property name="URL" value="jdbc:ianywhere:DSN=QUIPSY 4 Network"/>
> <property name="Password" value="mypassword"/>
> <property name="UserName" value="myusername"/>
> </jdbc-connection-pool>
>
> Regards
> Markus
>
> > -----Original Message-----
> > From: Marina.Vatkina_at_Sun.COM [mailto:Marina.Vatkina_at_Sun.COM]
> > Sent: Dienstag, 14. Oktober 2008 18:42
> > To: users_at_glassfish.dev.java.net
> > Subject: Re: SQLException does not drop JDBC connection from pool
> >
> > 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
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>