Thread: isValid availability

isValid availability

From
Luis Flores
Date:
Hello,

The method isValid is implemented and committed since 2012-01-19 by
Dave Cramer, however, it isn't available on the driver version 901 and
902.

Any reason why?

On the same subject, the implementation is using SELECT 1; because it
was the simplest query returning a value, simply issuing an "" won't
guarantee to go to the back-end (it may go for now, but it depends on
the driver bottom layer to issue it to the back-end. And the is no
real performance advantage from "" to "SELECT 1" since no one is going
to call isValid hundreds of times a second.

I also noted that the driver release dates on the site are incorrect
(http://jdbc.postgresql.org/changes.html) for driver 901 and 902
(copy/paste is evil).

Thank you all,

Luis Flores


Re: isValid availability

From
Dave Cramer
Date:
Luis,

Other than my mistakes, there is no reason.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Thu, Sep 27, 2012 at 7:33 AM, Luis Flores <luiscamposflores@gmail.com> wrote:
> Hello,
>
> The method isValid is implemented and committed since 2012-01-19 by
> Dave Cramer, however, it isn't available on the driver version 901 and
> 902.
>
> Any reason why?
>
> On the same subject, the implementation is using SELECT 1; because it
> was the simplest query returning a value, simply issuing an "" won't
> guarantee to go to the back-end (it may go for now, but it depends on
> the driver bottom layer to issue it to the back-end. And the is no
> real performance advantage from "" to "SELECT 1" since no one is going
> to call isValid hundreds of times a second.
>
> I also noted that the driver release dates on the site are incorrect
> (http://jdbc.postgresql.org/changes.html) for driver 901 and 902
> (copy/paste is evil).
>
> Thank you all,
>
> Luis Flores
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc