Meaningless Drivel is fun!
The moose likes Ant, Maven and Other Build Tools and the fly likes maven - dbunit - derby Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Engineering » Ant, Maven and Other Build Tools
Bookmark "maven - dbunit - derby" Watch "maven - dbunit - derby" New topic
Author

maven - dbunit - derby

peter cooke
Ranch Hand

Joined: Mar 16, 2004
Posts: 317
I am trying to set up dbunit to load tables in netbeans derby, am having problems.

can someone tell me what is wrong with my pom.xml or what "Embedded error: dss chained with same id at end of same id chain parse" is?



When I run maven I get

[dbunitperation]
------------------------------------------------------------------------
[ERROR]BUILD ERROR
------------------------------------------------------------------------
Error executing database operation: CLEAN_INSERT

Embedded error: dss chained with same id at end of same id chain parse
------------------------------------------------------------------------
Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Error executing database operation: CLEAN_INSERT
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: Error executing database operation: CLEAN_INSERT
at org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:109)
at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694)
... 17 more
Caused by: org.apache.derby.client.am.DisconnectException: dss chained with same id at end of same id chain parse
at org.apache.derby.client.net.Reply.zThrowSyntaxError(Unknown Source)
at org.apache.derby.client.net.Reply.endOfSameIdChainData(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at org.codehaus.mojo.dbunit.AbstractDbUnitMojo.createConnection(AbstractDbUnitMojo.java:185)
at org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:92)
... 19 more


CIAO Peter M. Cooke
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 17142
    
  27

As far as I can tell, your Derby database is corrupt. It's not a Maven error.

Of course, by "corrupt", that might mean that the plugin is looking in the wrong location for your database directory if you're running the standalone (non-server) mode of Derby. There's an environment variable you should be able to set on the Maven command line that I think will address that, but its name is buried in the Derby documentation somewhere.


An IDE is no substitute for an Intelligent Developer.
peter cooke
Ranch Hand

Joined: Mar 16, 2004
Posts: 317
I am running the default netbeans 6.8 (the "all" distribution)

derby came with netbeans. I can use netbeans to sign into the DB and add/remove/query data from netbeans.
peter cooke
Ranch Hand

Joined: Mar 16, 2004
Posts: 317
I could not find anything for this error.
Ended up installing mysql and problem did not occur.
I may revisit trying to get dbunit working with derby
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: maven - dbunit - derby
 
jQuery in Action, 3rd edition