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