Re: executeQuery returns postgresql.stat.result - Mailing list pgsql-jdbc

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