Re: [long][dbunit/mysql] org.dbunit.dataset.NoSuchColumnException

From: Gluon (No.Spam_at_cnil.fr)
Date: 01/14/05

  • Next message: jodetek: "How to do a local connection with JDBC ?" 
    Date: Fri, 14 Jan 2005 10:15:44 +0100

    Heya there, i finaly found that the unsigned are not supported by
    dbUnit, her eis the new schema and everythings works like a charms

    #
    # weibulldataset
    #
    CREATE TABLE `weibulldataset` (
       `id` bigint(20) NOT NULL auto_increment,
       `name` varchar(128) NOT NULL default '',
       `alpha` double NOT NULL default '0',
       `beta` double NOT NULL default '0',
       `gamma` double NOT NULL default '0',
       PRIMARY KEY (`id`,`name`)
    ) TYPE=InnoDB COMMENT='Weibull data Knowledge Base';

    cheers

    Gluon wrote:
    > Heya there,
    > I'm trying to setup some database related tests using dbunit and get
    > this error.
    >
    > Regarding the console msg i first thoughts this was a dbunit
    > DatabaseFactory issue. I used the MySqlDataTypeFactory with no success.
    >
    >
    > org.dbunit.dataset.NoSuchColumnException: weibulldataset.id
    > at
    > org.dbunit.operation.AbstractOperation.getOperationMetaData(AbstractOperation.java:71)
    >
    > at
    > org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:129)
    >
    > at
    > org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:67)
    > at
    > org.dbunit.DatabaseTestCase.executeOperation(DatabaseTestCase.java:87)
    > at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:104)
    > at junit.framework.TestCase.runBare(TestCase.java:125)
    > 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:118)
    > at junit.framework.TestSuite.runTest(TestSuite.java:208)
    > at junit.framework.TestSuite.run(TestSuite.java:203)
    > at
    > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421)
    >
    > at
    > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
    >
    > at
    > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
    >
    >
    > Any help really appreciate:!
    >
    > Console:
    > WARNING - weibulldataset.id data type (1111, ‘int unsigned’) not
    > recognized and will be ignored. See FAQ for more information.
    > WARNING - weibulldataset.alpha data type (1111, ‘double unsigned
    > zerofill unsigned’) not recognized and will be ignored. See FAQ for more
    > information.
    > WARNING - weibulldataset.beta data type (1111, ‘double unsigned zerofill
    > unsigned’) not recognized and will be ignored. See FAQ for more
    > information.
    > WARNING - weibulldataset.gamma data type (1111, ‘double unsigned
    > zerofill unsigned’) not recognized and will be ignored. See FAQ for more
    > information.
    >
    >
    >
    >
    > config:
    > Win 2000 pro
    > junit 3.8.1
    > dbunit 2.1
    > mysql 4.0.20a-net-max
    > jvm 1.4.2
    >
    > database schema:
    > #
    > # weibulldataset
    > #
    > CREATE TABLE `weibulldataset` (
    > `id` int(7) unsigned NOT NULL auto_increment,
    > `name` varchar(128) NOT NULL default '',
    > `alpha` double unsigned zerofill NOT NULL default
    > '0000000000000000000000',
    > `beta` double unsigned zerofill NOT NULL default
    > '0000000000000000000000',
    > `gamma` double unsigned zerofill NOT NULL default
    > '0000000000000000000000',
    > PRIMARY KEY (`id`,`name`)
    > ) TYPE=InnoDB COMMENT='Weibull data set storage space';
    >
    > testcase code:
    > public class WeibullSampleTest extends DatabaseTestCase {
    >
    > private WeiBullDataSetService s = WeiBullDataSetService.getInstance();
    >
    > public WeibullSampleTest(String name){
    > super(name);
    > }
    >
    > /* (non-Javadoc)
    > * @see org.dbunit.DatabaseTestCase#getConnection()
    > */
    > protected IDatabaseConnection getConnection() throws Exception {
    >
    > Class driverClass =
    > Class.forName(Messages.getString("hibernate.connection.driver_class"));
    > //$NON-NLS-1$
    > Connection jdbcConnection =
    > DriverManager.getConnection(Messages.getString("hibernate.connection.url"),
    > Messages.getString("hibernate.connection.username"),
    > Messages.getString("hibernate.connection.password")); //$NON-NLS-1$
    > //$NON-NLS-2$ //$NON-NLS-3$
    >
    > IDatabaseConnection conn= new DatabaseConnection(jdbcConnection);
    > DatabaseConfig config = conn.getConfig();
    >
    > config.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new
    > MySqlDataTypeFactory()); // here i specify MySql
    > config.setFeature(DatabaseConfig.FEATURE_BATCHED_STATEMENTS,
    > false);
    >
    > return conn;
    > }
    >
    > /* (non-Javadoc)
    > * @see org.dbunit.DatabaseTestCase#getDataSet()
    > */
    > protected IDataSet getDataSet() throws Exception {
    > return new FlatXmlDataSet(new
    > FileInputStream(DbUnitMessages.getString("dbunit.weibull.dataset.ref")));
    > //$NON-NLS-1$
    > }
    >
    > the file used here
    > FileInputStream(DbUnitMessages.getString("dbunit.weibull.dataset.ref")));
    > is :
    > <?xml version='1.0' encoding='UTF-8'?>
    > <dataset>
    > <weibulldataset id="1" name="test1" alpha="10.0" beta="12.0"
    > gamma="14.0"/>
    > <weibulldataset id="2" name="test2" alpha="20.0" beta="22.0"
    > gamma="24.0"/>
    > <weibulldataset id="3" name="test3" alpha="30.0" beta="32.0"
    > gamma="34.0"/>
    > </dataset>
    >
    >
    >
    >
    >
    >
    >
    >

  • Next message: jodetek: "How to do a local connection with JDBC ?"