How to operate a xml, After delete a column from mysql

[mavenbabuk <ba...@gmail.com>]

    I have table "RT_DATA_BANK" with columns, ID, BANKNAME and
ASSIGNMENT_VALUE.

    Using "dbunit-maven-plugin", I operate the table values from xml,

	<table name="RT_DATA_BANK">
	    <column>ID</column>
	    <column>BANKNAME</column>
	    <column>ASSIGNMENT_VALUE</column>
	    <row>
	      <value>1</value>
	      <value>AAA</value>
	      <value>55</value>
	    </row>
	    <row>
	      <value>2</value>
	      <value>BBB</value>
	      <value>66</value>
	    </row>
	</table>

     This time executes.

    But,

      I delete column ASSIGNMENT_VALUE from mysql. Now, I operate the xml,
This time i getting error as,



	[INFO] Error executing database operation: MSSQL_CLEAN_INSERT

	Embedded error: RT_DATA_BANK.ASSIGNMENT_VALUE -  (Non-uppercase input
column: ASSIGNMENT_VALUE) in ColumnNameToIndexes cache map. Note that the
map's column names are NOT case sensitive.
	[INFO]
------------------------------------------------------------------------
	[INFO] Trace
	org.apache.maven.lifecycle.LifecycleExecutionException: Error executing
database operation: MSSQL_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:57)
		at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
		at java.lang.reflect.Method.invoke(Method.java:616)
		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: MSSQL_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.dbunit.dataset.NoSuchColumnException:
RT_DATA_BANK.ASSIGNMENT_VALUE -  (Non-uppercase input column:
ASSIGNMENT_VALUE) in ColumnNameToIndexes cache map. Note that the map's
column names are NOT case sensitive.



        I can understand the missing of column 'ASSIGNMENT_VALUE' in mysql.

        Is their any other way to execute the xml like, skip the missing
column/execute only matching column or any other suggestions..

--
View this message in context: http://maven.40175.n5.nabble.com/How-to-operate-a-xml-After-delete-a-column-from-mysql-tp5675960.html
Sent from the Maven - Users mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org