Re: A prepared statement ERROR due to EMPTY_QUERY is defined as a static Instance.

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: A prepared statement ERROR due to EMPTY_QUERY is defined as a static Instance.
Date: 2014-03-11 01:22:47
Message-ID: 1394500967424-5795476.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Naoya Anzai wrote
> Hi Dave,
>
> Thanks for your response.
>
>> Thanks for the patch! Curious how would you ever come across this ?
>
> This incident was reported by one of our customers.
> So I don't know why their application executes EMPTY_QUERY frequently...
>
> Regards,

The most obvious reason would be as a keep-alive query...I have no idea
whether that is a wise decision compared to "SELECT 1;" or something that
actually causes the server to perform work (i.e., what does the server do
when it see the empty-string as input?).

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/A-prepared-statement-ERROR-due-to-EMPTY-QUERY-is-defined-as-a-static-Instance-tp5795067p5795476.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Moran, William 2014-03-11 15:25:18 Re: JDBC/TIMESTAMP/infnity question
Previous Message Naoya Anzai 2014-03-11 00:30:04 Re: A prepared statement ERROR due to EMPTY_QUERY is defined as a static Instance.