1. Taro L. Saito
  2. sqlite-jdbc
Issue #17 resolved

Unable to use sqlite-jdbc driver in Ant tasks

Grace Batumbya
created an issue

From http://code.google.com/p/sqlite-jdbc/issues/detail?id=3

Reported by joel.car...@gmail.com, Jun 7, 2011 Ant projects with sql task fail when used with the sqlite-jdbc driver. Attached build script fails with following error:

C:\Users\jec\build.xml:9: java.sql.SQLException: not implemented by SQLite JDBC driver at org.sqlite.Unused.unused(Unused.java:29) at org.sqlite.Unused.setEscapeProcessing(Unused.java:36) at org.apache.tools.ant.taskdefs.SQLExec.getStatement(SQLExec.java:962) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:775) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:751) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1043) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:985) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:653)

Problem here is that SQLExec ant task calls setEscapeProcessing() on PreparedStatement, which always fails. Ideally it should be implemented, but at least should only fail if you change it from the default value.