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