Menu ▾ ▴

#348 aliases not picked up when querying against MySQL database

v2.4.*
closed-fixed
Jeff Jensen
mysql (1)
2.5.1
5
2014-11-30
2013-10-17
Tim
No

When querying tables using aliases, DBUnit does not pick up column aliases.

Having found this StackOverflow post
http://stackoverflow.com/questions/15159085/dbunit-ignores-column-aliases-when-creating-dataset-from-query

The underlying cause seems to be a change in the MySQL connector required by a change in the JDBC spec.

Have attached example test case demonstrating the failure.

1 Attachments
mysql-alias-test-case.tar

Discussion

  • Tim

    Tim - 2013-10-17

    Have attached a patch against the current trunk.

    Changed to use getLabel() rather than getName() as per the suggestion in the linked MySql discussion attached to the SO post.

    With the patch included, existing unit tests passed ok, but am having trouble getting the integration tests running.

    Getting stacktrace:
    org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
    at org.dbunit.ant.DbUnitTask.execute(DbUnitTask.java:385)
    at org.apache.tools.ant.Task.perform(Task.java:341)
    at org.apache.tools.ant.Target.execute(Target.java:309)
    at org.apache.tools.ant.Target.performTasks(Target.java:336)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
    at org.apache.tools.ant.BuildFileTest.executeTarget(BuildFileTest.java:276)
    at org.dbunit.ant.DbUnitTaskIT.getFirstTargetTask(DbUnitTaskIT.java:600)
    at org.dbunit.ant.DbUnitTaskIT.getStepFromTarget(DbUnitTaskIT.java:588)
    at org.dbunit.ant.DbUnitTaskIT.getFirstStepFromTarget(DbUnitTaskIT.java:583)
    at org.dbunit.ant.DbUnitTaskIT.testExportQueryMixed(DbUnitTaskIT.java:384)
    Caused by: org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
    at org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:288)
    at org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:109)
    at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:79)
    at org.dbunit.ant.Operation.execute(Operation.java:192)
    at org.dbunit.ant.DbUnitTask.execute(DbUnitTask.java:380)

    but the tables seem to exist in my test DB.

     
    mysql-alias-test-case-patch.txt

  • Jeff Jensen

    Jeff Jensen - 2014-06-03

    Hi, Thanks for the patch. I'm wondering a few things on the test failures:

    Which integration tests are failing for your build?

    How are you running the build/tests? (what is the command line you ran)

    Which profiles pass/fail?

     

  • Tim

    Tim - 2014-06-12

    Hi jeff,

    erm... A lot of them!

    I'm running:
    mvn clean verify -Pmysql,oracle-default

    I've set up the mysql dbunit database based on the instructions.

    I've included an example output (heavily snipped to give you a flavour) at the bottom of my reply (it's pretty large!)

    However, I haven't performed an svn update since I did the original checkout, which was from trunk/ so it's possible I just got it in a bad state. I also had to comment out some unit tests under TimestampDataTypeTest to get the build further.

    Here's my current svn info:

    $ svn info
Path: .
Working Copy Root Path: /path/to/dbunit-all
URL: https://svn.code.sf.net/p/dbunit/svn/trunk
Relative URL: ^/trunk
Repository Root: https://svn.code.sf.net/p/dbunit/svn
Repository UUID: e3c2a97d-80a1-4612-8f6e-f37f52e78a4a
Revision: 1263
Node Kind: directory
Schedule: normal
Last Changed Author: jeffjensen
Last Changed Rev: 1263
Last Changed Date: 2012-10-21 04:59:38 +0800 (Sun, 21 Oct 2012)

    I'll perform a revert/update and re-test and let you know how I get on.

    Failed tests:   testIterator(org.dbunit.database.DatabaseDataSetIT): minimal names subset expected contains:<[test_table, second_table, empty_table, pk_table, only_pk_table, empty_multitype_table]> but was:<[account_, address, announcementsdelivery, announcementsentry, announcementsflag, assetcategory, assetcategoryproperty, assetentries_assetcategories, assetentries_assettags, assetentry, assetlink, assettag, assettagproperty, assettagstats, assetvocabulary, backgroundtask, blogsentry, blogsstatsuser, bookmarksentry, bookmarksfolder, browsertracker, calevent, calendar, calendarbooking, calendarnotificationtemplate, calendarresource, classname_, clustergroup, company, contact_, counter, country, cyrususer, cyrusvirtual, ddlrecord, ddlrecordset, ddlrecordversion, ddmcontent, ddmstoragelink, ddmstructure, ddmstructurelink, ddmtemplate, dlcontent, dlfileentry, dlfileentrymetadata, dlfileentrytype, dlfileentrytypes_ddmstructures, dlfileentrytypes_dlfolders, dlfilerank, dlfileshortcut, dlfileversion, dlfolder, dlsyncevent, empty_multiengine_table, empty_table, emailaddress, expandocolumn, expandorow, expandotable, expandovalue, group_, groups_orgs, groups_roles, groups_usergroups, image, journalarticle, journalarticleimage, journalarticleresource, journalcontentsearch, journalfeed, journalfolder, kaleoaction, kaleocondition, kaleodefinition, kaleodraftdefinition, kaleoinstance, kaleoinstancetoken, kaleolog, kaleonode, kaleonotification, kaleonotificationrecipient, kaleoprocess, kaleoprocesslink, kaleotask, kaleotaskassignment, kaleotaskassignmentinstance, kaleotaskinstancetoken, kaleotimer, kaleotimerinstancetoken, kaleotransition, layout, layoutbranch, layoutfriendlyurl, layoutprototype, layoutrevision, layoutset, layoutsetbranch, layoutsetprototype, listtype, lock_, mbban, mbcategory, mbdiscussion, mbmailinglist, mbmessage, mbstatsuser, mbthread, mbthreadflag, mdraction, mdrrule, mdrrulegroup, mdrrulegroupinstance, marketplace_app, marketplace_module, membershiprequest, only_pk_table, opensocial_gadget, opensocial_oauthconsumer, opensocial_oauthtoken, orggrouprole, orglabor, organization_, pk_table, passwordpolicy, passwordpolicyrel, passwordtracker, phone, pluginsetting, pollschoice, pollsquestion, pollsvote, portalpreferences, portlet, portletitem, portletpreferences, quartz_blob_triggers, quartz_calendars, quartz_cron_triggers, quartz_fired_triggers, quartz_job_details, quartz_locks, quartz_paused_trigger_grps, quartz_scheduler_state, quartz_simple_triggers, quartz_simprop_triggers, quartz_triggers, ratingsentry, ratingsstats, region, release_, repository, repositoryentry, resourceaction, resourceblock, resourceblockpermission, resourcepermission, resourcetypepermission, role_, scframeworkversi_scproductvers, scframeworkversion, sclicense, sclicenses_scproductentries, scproductentry, scproductscreenshot, scproductversion, second_table, servicecomponent, shard, shoppingcart, shoppingcategory, shoppingcoupon, shoppingitem, shoppingitemfield, shoppingitemprice, shoppingorder, shoppingorderitem, socialactivity, socialactivityachievement, socialactivitycounter, socialactivitylimit, socialactivityset, socialactivitysetting, socialrelation, socialrequest, subscription, syncdlobject, systemevent, test_table, team, ticket, trashentry, trashversion, usergroup, usergroupgrouprole, usergrouprole, usergroups_teams, useridmapper, usernotificationdelivery, usernotificationevent, usertracker, usertrackerpath, user_, users_groups, users_orgs, users_roles, users_teams, users_usergroups, virtualhost, webdavprops, website, wikinode, wikipage, wikipageresource, workflowdefinitionlink, workflowinstancelink]>
  testReverseIterator(org.dbunit.database.DatabaseDataSetIT): minimal names subset expected contains:<[test_table, second_table, empty_table, pk_table, only_pk_table, empty_multitype_table]> but was:<[workflowinstancelink, workflowdefinitionlink, wikipageresource, wikipage, wikinode, website, webdavprops, virtualhost, users_usergroups, users_teams, users_roles, users_orgs, users_groups, user_, usertrackerpath, usertracker, usernotificationevent, usernotificationdelivery, useridmapper, usergroups_teams, usergrouprole, usergroupgrouprole, usergroup, trashversion, trashentry, ticket, team, test_table, systemevent, syncdlobject, subscription, socialrequest, socialrelation, socialactivitysetting, socialactivityset, socialactivitylimit, socialactivitycounter, socialactivityachievement, socialactivity, shoppingorderitem, shoppingorder, shoppingitemprice, shoppingitemfield, shoppingitem, shoppingcoupon, shoppingcategory, shoppingcart, shard, servicecomponent, second_table, scproductversion, scproductscreenshot, scproductentry, sclicenses_scproductentries, sclicense, scframeworkversion, scframeworkversi_scproductvers, role_, resourcetypepermission, resourcepermission, resourceblockpermission, resourceblock, resourceaction, repositoryentry, repository, release_, region, ratingsstats, ratingsentry, quartz_triggers, quartz_simprop_triggers, quartz_simple_triggers, quartz_scheduler_state, quartz_paused_trigger_grps, quartz_locks, quartz_job_details, quartz_fired_triggers, quartz_cron_triggers, quartz_calendars, quartz_blob_triggers, portletpreferences, portletitem, portlet, portalpreferences, pollsvote, pollsquestion, pollschoice, pluginsetting, phone, passwordtracker, passwordpolicyrel, passwordpolicy, pk_table, organization_, orglabor, orggrouprole, opensocial_oauthtoken, opensocial_oauthconsumer, opensocial_gadget, only_pk_table, membershiprequest, marketplace_module, marketplace_app, mdrrulegroupinstance, mdrrulegroup, mdrrule, mdraction, mbthreadflag, mbthread, mbstatsuser, mbmessage, mbmailinglist, mbdiscussion, mbcategory, mbban, lock_, listtype, layoutsetprototype, layoutsetbranch, layoutset, layoutrevision, layoutprototype, layoutfriendlyurl, layoutbranch, layout, kaleotransition, kaleotimerinstancetoken, kaleotimer, kaleotaskinstancetoken, kaleotaskassignmentinstance, kaleotaskassignment, kaleotask, kaleoprocesslink, kaleoprocess, kaleonotificationrecipient, kaleonotification, kaleonode, kaleolog, kaleoinstancetoken, kaleoinstance, kaleodraftdefinition, kaleodefinition, kaleocondition, kaleoaction, journalfolder, journalfeed, journalcontentsearch, journalarticleresource, journalarticleimage, journalarticle, image, groups_usergroups, groups_roles, groups_orgs, group_, expandovalue, expandotable, expandorow, expandocolumn, emailaddress, empty_table, empty_multiengine_table, dlsyncevent, dlfolder, dlfileversion, dlfileshortcut, dlfilerank, dlfileentrytypes_dlfolders, dlfileentrytypes_ddmstructures, dlfileentrytype, dlfileentrymetadata, dlfileentry, dlcontent, ddmtemplate, ddmstructurelink, ddmstructure, ddmstoragelink, ddmcontent, ddlrecordversion, ddlrecordset, ddlrecord, cyrusvirtual, cyrususer, country, counter, contact_, company, clustergroup, classname_, calendarresource, calendarnotificationtemplate, calendarbooking, calendar, calevent, browsertracker, bookmarksfolder, bookmarksentry, blogsstatsuser, blogsentry, backgroundtask, assetvocabulary, assettagstats, assettagproperty, assettag, assetlink, assetentry, assetentries_assettags, assetentries_assetcategories, assetcategoryproperty, assetcategory, announcementsflag, announcementsentry, announcementsdelivery, address, account_]>
  testGetTableNames(org.dbunit.database.DatabaseDataSetIT): minimal names subset expected contains:<[test_table, second_table, empty_table, pk_table, only_pk_table, empty_multitype_table]> but was:<[account_, address, announcementsdelivery, announcementsentry, announcementsflag, assetcategory, assetcategoryproperty, assetentries_assetcategories, assetentries_assettags, assetentry, assetlink, assettag, assettagproperty, assettagstats, assetvocabulary, backgroundtask, blogsentry, blogsstatsuser, bookmarksentry, bookmarksfolder, browsertracker, calevent, calendar, calendarbooking, calendarnotificationtemplate, calendarresource, classname_, clustergroup, company, contact_, counter, country, cyrususer, cyrusvirtual, ddlrecord, ddlrecordset, ddlrecordversion, ddmcontent, ddmstoragelink, ddmstructure, ddmstructurelink, ddmtemplate, dlcontent, dlfileentry, dlfileentrymetadata, dlfileentrytype, dlfileentrytypes_ddmstructures, dlfileentrytypes_dlfolders, dlfilerank, dlfileshortcut, dlfileversion, dlfolder, dlsyncevent, empty_multiengine_table, empty_table, emailaddress, expandocolumn, expandorow, expandotable, expandovalue, group_, groups_orgs, groups_roles, groups_usergroups, image, journalarticle, journalarticleimage, journalarticleresource, journalcontentsearch, journalfeed, journalfolder, kaleoaction, kaleocondition, kaleodefinition, kaleodraftdefinition, kaleoinstance, kaleoinstancetoken, kaleolog, kaleonode, kaleonotification, kaleonotificationrecipient, kaleoprocess, kaleoprocesslink, kaleotask, kaleotaskassignment, kaleotaskassignmentinstance, kaleotaskinstancetoken, kaleotimer, kaleotimerinstancetoken, kaleotransition, layout, layoutbranch, layoutfriendlyurl, layoutprototype, layoutrevision, layoutset, layoutsetbranch, layoutsetprototype, listtype, lock_, mbban, mbcategory, mbdiscussion, mbmailinglist, mbmessage, mbstatsuser, mbthread, mbthreadflag, mdraction, mdrrule, mdrrulegroup, mdrrulegroupinstance, marketplace_app, marketplace_module, membershiprequest, only_pk_table, opensocial_gadget, opensocial_oauthconsumer, opensocial_oauthtoken, orggrouprole, orglabor, organization_, pk_table, passwordpolicy, passwordpolicyrel, passwordtracker, phone, pluginsetting, pollschoice, pollsquestion, pollsvote, portalpreferences, portlet, portletitem, portletpreferences, quartz_blob_triggers, quartz_calendars, quartz_cron_triggers, quartz_fired_triggers, quartz_job_details, quartz_locks, quartz_paused_trigger_grps, quartz_scheduler_state, quartz_simple_triggers, quartz_simprop_triggers, quartz_triggers, ratingsentry, ratingsstats, region, release_, repository, repositoryentry, resourceaction, resourceblock, resourceblockpermission, resourcepermission, resourcetypepermission, role_, scframeworkversi_scproductvers, scframeworkversion, sclicense, sclicenses_scproductentries, scproductentry, scproductscreenshot, scproductversion, second_table, servicecomponent, shard, shoppingcart, shoppingcategory, shoppingcoupon, shoppingitem, shoppingitemfield, shoppingitemprice, shoppingorder, shoppingorderitem, socialactivity, socialactivityachievement, socialactivitycounter, socialactivitylimit, socialactivityset, socialactivitysetting, socialrelation, socialrequest, subscription, syncdlobject, systemevent, test_table, team, ticket, trashentry, trashversion, usergroup, usergroupgrouprole, usergrouprole, usergroups_teams, useridmapper, usernotificationdelivery, usernotificationevent, usertracker, usertrackerpath, user_, users_groups, users_orgs, users_roles, users_teams, users_usergroups, virtualhost, webdavprops, website, wikinode, wikipage, wikipageresource, workflowdefinitionlink, workflowinstancelink]>
  testGetTables(org.dbunit.database.DatabaseDataSetIT): minimal names subset expected contains:<[test_table, second_table, empty_table, pk_table, only_pk_table, empty_multitype_table]> but was:<[account_, address, announcementsdelivery, announcementsentry, announcementsflag, assetcategory, assetcategoryproperty, assetentries_assetcategories, assetentries_assettags, assetentry, assetlink, assettag, assettagproperty, assettagstats, assetvocabulary, backgroundtask, blogsentry, blogsstatsuser, bookmarksentry, bookmarksfolder, browsertracker, calevent, calendar, calendarbooking, calendarnotificationtemplate, calendarresource, classname_, clustergroup, company, contact_, counter, country, cyrususer, cyrusvirtual, ddlrecord, ddlrecordset, ddlrecordversion, ddmcontent, ddmstoragelink, ddmstructure, ddmstructurelink, ddmtemplate, dlcontent, dlfileentry, dlfileentrymetadata, dlfileentrytype, dlfileentrytypes_ddmstructures, dlfileentrytypes_dlfolders, dlfilerank, dlfileshortcut, dlfileversion, dlfolder, dlsyncevent, empty_multiengine_table, empty_table, emailaddress, expandocolumn, expandorow, expandotable, expandovalue, group_, groups_orgs, groups_roles, groups_usergroups, image, journalarticle, journalarticleimage, journalarticleresource, journalcontentsearch, journalfeed, journalfolder, kaleoaction, kaleocondition, kaleodefinition, kaleodraftdefinition, kaleoinstance, kaleoinstancetoken, kaleolog, kaleonode, kaleonotification, kaleonotificationrecipient, kaleoprocess, kaleoprocesslink, kaleotask, kaleotaskassignment, kaleotaskassignmentinstance, kaleotaskinstancetoken, kaleotimer, kaleotimerinstancetoken, kaleotransition, layout, layoutbranch, layoutfriendlyurl, layoutprototype, layoutrevision, layoutset, layoutsetbranch, layoutsetprototype, listtype, lock_, mbban, mbcategory, mbdiscussion, mbmailinglist, mbmessage, mbstatsuser, mbthread, mbthreadflag, mdraction, mdrrule, mdrrulegroup, mdrrulegroupinstance, marketplace_app, marketplace_module, membershiprequest, only_pk_table, opensocial_gadget, opensocial_oauthconsumer, opensocial_oauthtoken, orggrouprole, orglabor, organization_, pk_table, passwordpolicy, passwordpolicyrel, passwordtracker, phone, pluginsetting, pollschoice, pollsquestion, pollsvote, portalpreferences, portlet, portletitem, portletpreferences, quartz_blob_triggers, quartz_calendars, quartz_cron_triggers, quartz_fired_triggers, quartz_job_details, quartz_locks, quartz_paused_trigger_grps, quartz_scheduler_state, quartz_simple_triggers, quartz_simprop_triggers, quartz_triggers, ratingsentry, ratingsstats, region, release_, repository, repositoryentry, resourceaction, resourceblock, resourceblockpermission, resourcepermission, resourcetypepermission, role_, scframeworkversi_scproductvers, scframeworkversion, sclicense, sclicenses_scproductentries, scproductentry, scproductscreenshot, scproductversion, second_table, servicecomponent, shard, shoppingcart, shoppingcategory, shoppingcoupon, shoppingitem, shoppingitemfield, shoppingitemprice, shoppingorder, shoppingorderitem, socialactivity, socialactivityachievement, socialactivitycounter, socialactivitylimit, socialactivityset, socialactivitysetting, socialrelation, socialrequest, subscription, syncdlobject, systemevent, test_table, team, ticket, trashentry, trashversion, usergroup, usergroupgrouprole, usergrouprole, usergroups_teams, useridmapper, usernotificationdelivery, usernotificationevent, usertracker, usertrackerpath, user_, users_groups, users_orgs, users_roles, users_teams, users_usergroups, virtualhost, webdavprops, website, wikinode, wikipage, wikipageresource, workflowdefinitionlink, workflowinstancelink]>
  testWriteFromDatabase(org.dbunit.dataset.xml.FlatDtdDataSetIT): at line 5 there was a mismatch.  Expected:(..)
  testExportAndCompareFormatMismatch(org.dbunit.ant.DbUnitTaskIT): expected:<[Did not find table in source file '/data/tim.myerscough/workspaces/LDS/workspace/dbunit-all/dbunit/target/xml/antExportDataSet.xml' using format 'xml']> but was:<[EMPTY_MULTITYPE_TABLE]>

Tests in error: 
  testSuccessRun(org.dbunit.DefaultPrepAndExpectedTestCaseDiIT): EMPTY_MULTITYPE_TABLE
  testFailRun(org.dbunit.DefaultPrepAndExpectedTestCaseDiIT): EMPTY_MULTITYPE_TABLE
  testSuccessRun(org.dbunit.DefaultPrepAndExpectedTestCaseExtIT): EMPTY_MULTITYPE_TABLE
  testFailRun(org.dbunit.DefaultPrepAndExpectedTestCaseExtIT): EMPTY_MULTITYPE_TABLE
  testGetNoPrimaryKeys(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testCreation_UnknownTable(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testGetNoColumns(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testColumnIsNullable(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testUnsupportedColumnDataType(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testColumnDataType(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testCaseInsensitiveAndI18n(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testGetColumnsForTablesMatchingSamePattern(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testCaseSensitive(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testFullyQualifiedTableName(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testDbStoresUpperCaseTableNames(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testDbStoresLowerCaseTableNames(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testGetPrimaryKeys(org.dbunit.database.DatabaseTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testGetRowCount(org.dbunit.database.DefaultDatabaseTesterConnectionIT): EMPTY_MULTITYPE_TABLE
  testGetValueRowBounds(org.dbunit.database.ForwardOnlyResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetValueIterateBackward(org.dbunit.database.ForwardOnlyResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetRowCount(org.dbunit.database.ForwardOnlyResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testTableMetaData(org.dbunit.database.ForwardOnlyResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetValue(org.dbunit.database.ForwardOnlyResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetValueCaseInsensitive(org.dbunit.database.ForwardOnlyResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetValueAndNoSuchColumn(org.dbunit.database.ForwardOnlyResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetRowCount(org.dbunit.database.JdbcDatabaseTesterConnectionIT): EMPTY_MULTITYPE_TABLE
  testGetColumnsForTablesMatchingSamePattern(org.dbunit.database.ResultSetTableMetaDataIT): EMPTY_MULTITYPE_TABLE
  testGetSelectPartialData(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetAllColumnsWithStar(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetAllRowsSingleColumn(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testOnlySpecifiedColumnsReturned(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetSelectPartialData2(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testCombinedWhere(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testMultipleTables(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testMultipleTablesWithMissingWhere(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testIterator(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testReverseIterator(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetTableNames(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetTableNamesDefensiveCopy(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetTable(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetUnknownTable(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetTableMetaData(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetUnknownTableMetaData(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetTables(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetTablesDefensiveCopy(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testCreateDuplicateDataSet(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testCreateMultipleCaseDuplicateDataSet(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetCaseInsensitiveTable(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetCaseInsensitiveTableMetaData(org.dbunit.database.QueryDataSetIT): EMPTY_MULTITYPE_TABLE
  testGetValueRowBounds(org.dbunit.database.CachedResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testTableMetaData(org.dbunit.database.CachedResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetValue(org.dbunit.database.CachedResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetValueCaseInsensitive(org.dbunit.database.CachedResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetValueAndNoSuchColumn(org.dbunit.database.CachedResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testGetRowCount(org.dbunit.database.CachedResultSetTableIT): EMPTY_MULTITYPE_TABLE
  testCreateNullConnection(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testCreateConnectionWithNonExistingSchemaAndStrictValidation(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testCreateConnectionWithNonExistingSchemaAndLenientValidation(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testCreateConnectionWithSchemaDbStoresUpperCaseIdentifiers(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testCreateConnectionWithSchemaDbStoresLowerCaseIdentifiers(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testCreateQueryWithPreparedStatement(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testGetRowCount(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testGetRowCount_NonexistingSchema(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testGetRowCount_NoSchemaSpecified(org.dbunit.database.DatabaseConnectionIT): EMPTY_MULTITYPE_TABLE
  testGetCaseInsensitiveTable(org.dbunit.database.DatabaseDataSetIT): empty_multitype_table
  testGetCaseInsensitiveTableMetaData(org.dbunit.database.DatabaseDataSetIT): empty_multitype_table
  testExecuteSetUpTearDown(org.dbunit.DBTestCaseIT): EMPTY_MULTITYPE_TABLE
  testExclusiveTransaction(org.dbunit.operation.TransactionOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteRollback(org.dbunit.operation.TransactionOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteCommit(org.dbunit.operation.TransactionOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEscapedNames(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEmptyTable(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testInsertClob(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testInsertBlob(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testInsertSdoGeometry(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testMissingColumns(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testExecute(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteCaseInsensitive(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteForwardOnly(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteUnknownColumn(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteIgnoreNone(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testMockExecute(org.dbunit.operation.InsertOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEmptyTable(org.dbunit.operation.RefreshOperationIT): EMPTY_MULTITYPE_TABLE
  testExecute(org.dbunit.operation.RefreshOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteCaseInsensitive(org.dbunit.operation.RefreshOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteForwardOnly(org.dbunit.operation.RefreshOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteAndNoPrimaryKeys(org.dbunit.operation.RefreshOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteUnknownColumn(org.dbunit.operation.RefreshOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEmptyTable(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testExecute(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteCaseInsensitive(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteForwardOnly(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEscapedName(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testUpdateClob(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteAndNoPrimaryKeys(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testMockExecute(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testUpdateBlob(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testUpdateSdoGeometry(org.dbunit.operation.UpdateOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEscapedNames(org.dbunit.operation.DeleteOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEmptyTable(org.dbunit.operation.DeleteOperationIT): EMPTY_MULTITYPE_TABLE
  testExecute(org.dbunit.operation.DeleteOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteCaseInsensitive(org.dbunit.operation.DeleteOperationIT): EMPTY_MULTITYPE_TABLE
  testMockExecute(org.dbunit.operation.DeleteOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteAndNoPrimaryKey(org.dbunit.operation.DeleteOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEscapedNames(org.dbunit.operation.TruncateTableOperationIT): EMPTY_MULTITYPE_TABLE
  testExecute(org.dbunit.operation.TruncateTableOperationIT): EMPTY_MULTITYPE_TABLE
  testMockExecute(org.dbunit.operation.TruncateTableOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteEmpty(org.dbunit.operation.TruncateTableOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteCaseInsentive(org.dbunit.operation.TruncateTableOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEmptyDataset(org.dbunit.operation.TruncateTableOperationIT): EMPTY_MULTITYPE_TABLE
  testExecute(org.dbunit.operation.CompositeOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEscapedNames(org.dbunit.operation.DeleteAllOperationIT): EMPTY_MULTITYPE_TABLE
  testExecute(org.dbunit.operation.DeleteAllOperationIT): EMPTY_MULTITYPE_TABLE
  testMockExecute(org.dbunit.operation.DeleteAllOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteEmpty(org.dbunit.operation.DeleteAllOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteCaseInsentive(org.dbunit.operation.DeleteAllOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteWithEmptyDataset(org.dbunit.operation.DeleteAllOperationIT): EMPTY_MULTITYPE_TABLE
  testMockExecute(org.dbunit.operation.CloseConnectionOperationIT): EMPTY_MULTITYPE_TABLE
  testGetOperationMetaDataAndUnknownColumns(org.dbunit.operation.AbstractBatchOperationIT): EMPTY_MULTITYPE_TABLE
  testGetOperationMetaDataAndMissingColumns(org.dbunit.operation.AbstractBatchOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteForwardOnly(org.dbunit.ext.mssql.InsertIdentityOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteXML(org.dbunit.ext.mssql.InsertIdentityOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteFlatXML(org.dbunit.ext.mssql.InsertIdentityOperationIT): EMPTY_MULTITYPE_TABLE
  testExecuteLowerCase(org.dbunit.ext.mssql.InsertIdentityOperationIT): EMPTY_MULTITYPE_TABLE
  testIdentityInsertNoPK(org.dbunit.ext.mssql.InsertIdentityOperationIT): EMPTY_MULTITYPE_TABLE
  testSetCustomIdentityColumnFilter(org.dbunit.ext.mssql.InsertIdentityOperationIT): EMPTY_MULTITYPE_TABLE
  testResolveOperationTypes(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportFull(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportPartial(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportFlat(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportFlatWithDocytpe(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportFlatWithEncoding(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportXml(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportCsv(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportXmlOrdered(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportQuery(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportWithQuerySet(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE
  testExportQueryMixed(org.dbunit.ant.DbUnitTaskIT): org.dbunit.dataset.NoSuchTableException: EMPTY_MULTITYPE_TABLE

Tests run: 232, Failures: 6, Errors: 138, Skipped: 0
     

    Last edit: Tim 2014-06-12

  • Jeff Jensen

    Jeff Jensen - 2014-06-16

    First, please switch to the git repo; svn is no longer used. Release 2.5.0 is from git, not svn, and those changes are not in svn. Please let me know how the build works with your changes in the git codeline.

    Does building with the "offical" profile work for you or still fail?
    mvn clean install -Pofficial

    Also, only run one profile at a time.

     

  • Jeff Jensen

    Jeff Jensen - 2014-06-16
    • assigned_to: Jeff Jensen
    • Fixed Release: --> (not fixed)
     

  • Tim

    Tim - 2014-07-21

    Hi sorry it's taken a while to get back onto this.

    Having checked out a fresh copy, I'm getting Unit test failures:

    mvn clean install -Pofficial

    Output:

    ...
Results :

Failed tests: 
  TimestampDataTypeTest.testTypeCast:153 typecast 13 expected:<2008-11-27 14:52:38.0> but was:<2008-11-27 13:52:38.0>

Tests in error: 
  TimestampDataTypeTest.testCompareDifferent:273 » TypeCast Unable to typecast v...

Tests run: 1051, Failures: 1, Errors: 1, Skipped: 0

[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO] 
[INFO] dbUnit Extension .................................. FAILURE [ 15.632 s]
[INFO] DbUnit Maven Plugin ............................... SKIPPED
[INFO] DbUnit All ........................................ SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.892 s
[INFO] Finished at: 2014-07-21T12:24:20+08:00
[INFO] Final Memory: 11M/246M
[INFO] ------------------------------------------------------------------------

    I haven't performed any further analysis so far.

    Thanks

     

  • Jeff Jensen

    Jeff Jensen - 2014-11-30

    I recently encountered that too, and it is an issue with Java 7. Java 6 did not have that problem.

    Please pull latest and see if the tests all pass for you... they do for me.

     

  • Jeff Jensen

    Jeff Jensen - 2014-11-30
    • status: open --> closed-fixed
     

  • Jeff Jensen

    Jeff Jensen - 2014-11-30
    • Fixed Release: (not fixed) --> 2.5.1
     

Log in to post a comment.