[mojo-dev] [jira] (MSQL-84) Failure if JDBC Driver does not implement statement.setEscapeProcessing (e.g. SQLite)

Tue, 07 Aug 2012 02:03:26 -0700

Issue Type: Bug Bug
Affects Versions: 1.5, 1.4
Assignee: Unassigned
Created: 07/Aug/12 4:02 AM
Description:

Using this plugin with the sqlite-jdbc driver results in an exception because the sqlite jdbc driver does not support setEscapeProcessing method on Statements:

org.apache.maven.lifecycle.LifecycleExecutionException: not implemented by SQLite JDBC driver
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:719)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:556)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:535)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:387)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:348)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:180)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
        at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
        at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
        at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
        at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: org.apache.maven.plugin.MojoExecutionException: not implemented by SQLite JDBC driver
        at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:681)
        at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694)
        ... 17 more
Caused by: 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.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:630)
        ... 19 more






<plugin>
  <groupId>org.codehaus.mojo</groupId>
  <artifactId>sql-maven-plugin</artifactId>
  <version>1.5</version>

  <dependencies>
    <dependency>
      <groupId>org.xerial</groupId>
      <artifactId>sqlite-jdbc</artifactId>
      <version>3.6.16</version>
    </dependency>
  </dependencies>

  <configuration>
    <driver>org.sqlite.JDBC</driver>
    <url>jdbc:sqlite::memory:</url>
  </configuration>

  <executions>
    <execution>
      <id>validate-sqlite-db</id>
      <phase>install</phase>
      <goals>
        <goal>execute</goal>
      </goals>
      <configuration>
        <sqlCommand>create table person (id integer, name string)</sqlCommand>
      </configuration>
    </execution>
  </executions>
</plugin>
Environment: Mac OSX 10.6.8
SQLite JDBC driver 3.6.16 (org.xerial:sqlite-jdbc:3.6.16)
Project: Maven 2.x SQL Plugin
Priority: Major Major
Reporter: Clayton Kovar
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira
--------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email

Reply via email to