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

Re: executeQuery returns postgresql.stat.result

From: "Nico" <nicohmail-postgresql(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: executeQuery returns postgresql.stat.result
Date: 2005-05-01 17:59:09
Message-ID: d535e9$a56$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
The batch statement is ONLY used in case of an update, insert or delete 
command.
When a select command is used, there is no batch used, as you can see in my 
code.

Nico.

"Kris Jurka" <books(at)ejurka(dot)com> schreef in bericht 
news:Pine(dot)BSO(dot)4(dot)56(dot)0505011230450(dot)1107(at)leary(dot)csoft(dot)net(dot)(dot)(dot)
>
>
> On Sun, 1 May 2005, Nico wrote:
>
>>             sql="select * from \"qryMonthsYears\"";
>>...
>>         if(strstatement.startsWith("SELECT"))
>>...
>>         else
>>         {
>>             connection.setAutoCommit(false);
>>             String [] sql=strstatement.split(";");
>>             for(int teller=0;teller<sql.length;teller++)
>>                 statement.addBatch(sql[teller]+";");
>>             statement.executeBatch();
>
> Your own parsing logic is busted and is trying to execute a select in a
> batch statement, which is not legal.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly
> 



In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-05-01 18:04:14
Subject: Re: executeQuery returns postgresql.stat.result
Previous:From: Kris JurkaDate: 2005-05-01 17:32:26
Subject: Re: executeQuery returns postgresql.stat.result

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