> Table based validation will do a
> select count(*) from table. Yes, its the jdbc-driver that is not doing
> fetch from database.
> * What database and driver do you use ?
Sybase SQL Anywhere 11.0, iAnywhere driver
> There are two other modes, auto-commit and meta-data. Now a days, these
> are cached by several jdbc drivers and the reliable mode is 'table'.
> http://blogs.sun.com/JagadishPrasath/entry/connection_validation_in_gla
> ssfish_jdbc
Well, as it seems it is *not* reliable since the JDBC driver does not do a FETCH. I assume that the driver has no fault but instead GlassFish is not really asking it to do a fetch?
> * Probably, you can try these other modes and see whether the issue is
> resolved.
Unfortunately due to technical reasons I really need to check exactly for that specific table -- it is a proxy forwarding to another server, so it is my only chance. All the other modes do not help me.
So my question is: WHY is GlassFish not really fetching data from the driver in the table mode?
Thanks
Markus
>
> Thanks,
> -Jagadish
>
>
> On Tue, 2008-10-28 at 08:15 +0100, Markus Karg wrote:
> > Dear Community,
> >
> >
> >
> > it seems as if the "table" method for JDBC Connection Validation just
> > checks whether the SQL is correct, but not really tries to fetch any
> > data from that table. The problem is that this is completely answered
> > by the JDBC driver of my dbms, even if the connection is broken! How
> > can I tell GlassFish that it really must fetch data?
> >
> >
> >
> > 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