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@ejurka.com> schreef in bericht
news:Pine.BSO.4.56.0505011230450.1107@leary.csoft.net...
>
>
> 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@postgresql.org so that your
> message can get through to the mailing list cleanly
>