Re: executeQuery returns postgresql.stat.result

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
>