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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
The batch statement is ONLY used in case of an update, insert or delete 
When a select command is used, there is no batch used, as you can see in my 


"Kris Jurka" <books(at)ejurka(dot)com> schreef in bericht 
> 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


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-2017 The PostgreSQL Global Development Group