Error running tests when informix table has a boolean column

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Error running tests when informix table has a boolean column

Prachi Burathoki
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

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

John Hurst-2
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 <[hidden email]> 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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

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

Prachi Burathoki
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 <[hidden email]>
To:        [hidden email]
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

[hidden email]
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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

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

Prachi Burathoki
In reply to this post by John Hurst-2
Hi John,

Any update on this issue yet?

Thanks,
Prachi



From:        Prachi Burathoki/Princeton/IBM
To:        [hidden email]
Date:        10/17/2011 04:58 PM
Subject:        Re: [dbunit-user] 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 <[hidden email]>
To:        [hidden email]
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

[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user


------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user