Re: Error running tests when informix table has a boolean column

Hi John,

Thanks for getting back so quickly. I've a table which has a few boolean fields. I use following xml to create the dataset  using the method FlatXmlDataSet

<?xml version='1.0' encoding='UTF-8'?>
<dataset>
    <service_configuration SERVICE_ID="1" name="Undeployed Services"  version="0.0.0" repository_uri="blank" parent_id="-1" is_folder="0"/>
    <service_configuration SERVICE_ID="6" name="2009_05_06"  version="0.0.0"  repository_uri="blank" parent_id="0" is_folder="1"/>
    <service_configuration SERVICE_ID="5" name="Toms Service"  version="1.2.0" repository_uri="http://repo/Undeployed Service" parent_id="6" is_folder="1"/>
    <service_configuration SERVICE_ID="9" name="Jeffs Service"  version="1.2.0" repository_uri="http://repo/Undeployed Service" parent_id="6" is_folder="1"/>
        <service_configuration SERVICE_ID="2" name="Deployed Services"  version="0.0.0" repository_uri="blank" parent_id="-1" is_folder="1"/>        
        <service_configuration SERVICE_ID="3" name="Privacy Folder"  version="0.0.0" repository_uri="blank" parent_id="1" is_folder="1" />
        </dataset>

is_folder field is a boolean field. If I include it in the dataset above I get the error below.If I remove it from my dataset,the test runs fine,I googled on this error and
looks like similar issue was reported for  HSQLDB, but nothing is reported for informix.

org.dbunit.dataset.NoSuchColumnException: service_configuration.is_folder
        at org.dbunit.operation.AbstractOperation.getOperationMetaData(AbstractOperation.java:71)
        at org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:130)
        at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:67)
        at org.dbunit.AbstractDatabaseTester.executeOperation(AbstractDatabaseTester.java:132)
        at org.dbunit.AbstractDatabaseTester.onSetup(AbstractDatabaseTester.java:60)
        at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:120)
        at com.ibm.nex.console.dbtest.AbstractDatabaseTest.setUp(AbstractDatabaseTest.java:123)
        at junit.framework.TestCase.runBare(TestCase.java:128)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:120)
        at junit.framework.TestSuite.runTest(TestSuite.java:230)
        at junit.framework.TestSuite.run(TestSuite.java:225)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.pde.internal.junit.runtime.RemotePluginTestRunner.main(RemotePluginTestRunner.java:62)
        at org.eclipse.pde.internal.junit.runtime.UITestApplication$1.run(UITestApplication.java:114)
        at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
        at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:133)
        at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3817)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3442)
        at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2384)
        at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348)
        at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2200)
        at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:495)
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288)
        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:490)
        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
        at org.eclipse.pde.internal.junit.runtime.UITestApplication.start(UITestApplication.java:46)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
        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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
        at org.eclipse.equinox.launcher.Main.main(Main.java:1212)

Thanks,
Prachi




From:        John Hurst <john.b.hurst@...>
To:        dbunit-user@...
Date:        10/17/2011 03:18 PM
Subject:        Re: [dbunit-user] Error running tests when informix table has a boolean column

---

Hi,

I have no experience with Informix. However, you will have to provide more detail. Is there any other information in the stack trace? How are you setting up DbUnit?

What makes you think the boolean columns are the problem? Do tables without boolean columns work OK for you?

Regards

John Hurst

On Tue, Oct 18, 2011 at 7:55 AM, Prachi Burathoki <prachi@...> wrote:
Hello,

I am trying to run a test on the table which has a few boolean columns. When I run the test I get org.dbunit.dataset.NoSuchColumnException.
Can you please let me know how to get around this issue?

Thanks,
Prachi





------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user




--
Life is interfering with my game------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user