Re: JDBC-94: "Multiple resultsets were returned by query" in query end with "; "

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Dang Minh Huong <kakalot49(at)gmail(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC-94: "Multiple resultsets were returned by query" in query end with "; "
Date: 2015-10-07 12:11:07
Message-ID: CADK3HHJ7a0LGY9XzEA6_8ejf5jp_QfUDK4d_kLv697Q--XH_hA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

This is likely a result of the parser getting some more work and not
noticing this is an empty query. I have a personal note to look at this

Dave Cramer

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

On 7 October 2015 at 07:51, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:

> On 29 September 2015 at 21:56, Dang Minh Huong <kakalot49(at)gmail(dot)com>
> wrote:
> > Hi,
> >
> > I'm using postgresql-jdbc94 and have found that,
> > string in executeQuery() end with "; " (the last character is a space)
> > is considered as multiple queries and return with
> > "Multiple resultsets were returned by query" error.
> > I think it is not a bug, but is there any related change in jdbc94. I
> could
> > not reproduce in jdbc93.
>
> This is a follow-up from a Stack Overflow post, right? I'm pretty sure
> I saw this but I can't find the post now. If I'm remembering
> correctly, got a link so I can cross-reference?
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2015-10-07 12:30:57 Re: JDBC-94: "Multiple resultsets were returned by query" in query end with "; "
Previous Message Craig Ringer 2015-10-07 11:51:10 Re: JDBC-94: "Multiple resultsets were returned by query" in query end with "; "