Allow shutting down embedded derby from dbunit-maven-plugin

Hi
I use maven 2.1 this is myconfiguration for dbunit plugin
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>dbunit-maven-plugin</artifactId>

<!--jar file that has the jdbc driver -->
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.0.5</version>
</dependency>
</dependencies>

<!-- common configurations -->
<configuration>
<driver>org.gjt.mm.mysql.Driver</driver>
<url>jdbc:mysql://localhost:3306/mydb
</url>
<format>xml</format>
<username>myusername</username>
<password>mypassword</password>
<src>insert.xml</src>
</configuration>
<executions>
<execution>
<phase>compile</phase>
<goals>
<goal>operation</goal>
</goals>
<configuration>
<type>CLEAN_INSERT</type>
</configuration>
</execution>
</executions>
</plugin>

This is the error stack trace:
[INFO] ------------------------------------------------------------------------
[INFO] Error executing database operation: CLEAN_INSERT

[INFO] ------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Error executing database
operation: CLEAN_INSERT
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa
ultLifecycleExecutor.java:521)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLi
fecycle(DefaultLifecycleExecutor.java:437)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(Defau
ltLifecycleExecutor.java:416)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHan
dleFailures(DefaultLifecycleExecutor.java:268)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegmen
ts(DefaultLifecycleExecutor.java:235)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLi
fecycleExecutor.java:143)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:300)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:120)
at org.apache.maven.embedder.MavenEmbedder.execute(MavenEmbedder.java:68
1)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:343)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Laun
cher.java:289)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.jav
a:229)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(La
uncher.java:408)
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:
351)
Caused by: org.apache.maven.plugin.MojoExecutionException: Error executing datab
ase operation: CLEAN_INSERT
at org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:110
)
at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPlugi
nManager.java:618)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa
ultLifecycleExecutor.java:496)
... 17 more
Caused by: java.lang.NullPointerException
at org.dbunit.dataset.xml.XmlProducer.endElement(XmlProducer.java:246)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source
)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(
Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent
Dispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un
known Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.dbunit.dataset.xml.XmlProducer.produce(XmlProducer.java:112)
at org.dbunit.dataset.CachedDataSet.<init>(CachedDataSet.java:71)
at org.dbunit.ant.AbstractStep.getSrcDataSet(AbstractStep.java:148)
at org.dbunit.ant.Operation.execute(Operation.java:182)
at org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:101
)
... 19 more

Hi

the attached file contains a patch for Shutdown functionality. I added a ShutdownHandler interface which can be used to shutdown databases. I also implemented two implementations: DefaultShutdownHandler and DerbyShutdownHandler.

It can be configured via configuration element:

– 8< –

<executions>
...
<configuration
<shutdownHandlerName>org.codehaus.mojo.dbunit.shutdown.DerbyShutdownHandler</shutdownHandlerName>
</configuration>
</executions>

– 8< –

The Deafult Impl does nothing.

Kristian