Skip site navigation (1) Skip section navigation (2)

question about AbstractJdbc2Statement

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: question about AbstractJdbc2Statement
Date: 2007-05-24 06:24:48
Message-ID: 200705240824.48717.fluca1978@infinito.it (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi all,
in the org.postgresql.jdbc2.AsbtractJdbc2Statement#executeQuery there's:

  if (result.getNext() != null)
            throw new PSQLException(GT.tr("Multiple ResultSets were returned 
by the query."), PSQLState.TOO_MANY_RESULTS);

It is not clear to me when an executeQuery could have multiple result sets as 
result, since the execution of the query thru the queryexecutor seems to me 
to exploit the SendOneQuery method. Is this related to the batch processing 
or something I'm missing from SQL? Can somebody explain me when multiple 
resultset can be returned from a query?

Thanks,
Luca

Responses

pgsql-jdbc by date

Next:From: Mamoon RashidDate: 2007-05-24 11:45:06
Subject: setting CLASSPATH of the jdbc jar file
Previous:From: Kris JurkaDate: 2007-05-21 16:27:48
Subject: Re: Insert (or update) to a partitioned table returns 0 rows updated

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group