StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSpring test DBUnit : table comparison fails even in simplest test
primarykey
Id
12740092
data
AcceptedAnswerId
12792282
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-10-05T05:35:16.987
FavoriteCount
0
LastActivityDate
2012-10-09T03:03:29.427
LastEditDate
2012-10-09T01:13:37.627
LastEditorUserId
934287
OwnerUserId
934287
ParentId
0
PostTypeId
1
Score
3
ViewCount
1971
LastEditorDisplayName
text
Body
I use Spring test DBUnit to test my DB Service and Hibernate. I wrote a simplest test possible: <pre><code>@Test @DatabaseSetup("dumbDataSample_DBAccount.xml") @DatabaseTearDown("dumbDataSample_DBAccount.xml") @ExpectedDatabase(assertionMode=DatabaseAssertionMode.NON_STRICT, value ="dumbDataSample_DBAccount.xml") public void testBasic() { } </code></pre> And it fails! Why? It did work before I modified the table (removed some fields, added other, reassigned primary key ) It seem that DBunit compares companyName columns from different records dumbDataSample_DBAccount.xml <pre><code> <?xml version="1.0" encoding="UTF-8"?> <dataset> <adminaccounts username="naruto" forcePassChange="true" companyName="Konoha" email="naruto@konoha.jp"/> <adminaccounts username="sephiroth" forcePassChange="false" companyName="Shinra" email="sephi@shinra.com"/> <adminaccounts username="geralt" forcePassChange="false" companyName="no"/> </dataset> </code></pre> Any ideas? Here is the trace <pre><code>junit.framework.ComparisonFailure: value (table=adminaccounts, row=0, col=companyName) expected:<[Konoha]> but was:<[no]> at org.dbunit.assertion.JUnitFailureFactory.createFailure(JUnitFailureFactory.java:39) at org.dbunit.assertion.DefaultFailureHandler.createFailure(DefaultFailureHandler.java:105) at org.dbunit.assertion.DefaultFailureHandler.handle(DefaultFailureHandler.java:208) at org.dbunit.assertion.DbUnitAssert.compareData(DbUnitAssert.java:524) at org.dbunit.assertion.DbUnitAssert.assertEquals(DbUnitAssert.java:409) at org.dbunit.assertion.DbUnitAssert.assertEquals(DbUnitAssert.java:312) at org.dbunit.assertion.DbUnitAssert.assertEquals(DbUnitAssert.java:274) at org.dbunit.assertion.DbUnitAssert.assertEqualsIgnoreCols(DbUnitAssert.java:122) at org.dbunit.Assertion.assertEqualsIgnoreCols(Assertion.java:74) at com.github.springtestdbunit.assertion.NonStrictDatabaseAssertion.assertEquals(NonStrictDatabaseAssertion.java:44) at com.github.springtestdbunit.DbUnitRunner.verifyExpected(DbUnitRunner.java:128) at com.github.springtestdbunit.DbUnitRunner.afterTestMethod(DbUnitRunner.java:80) at com.github.springtestdbunit.DbUnitTestExecutionListener.afterTestMethod(DbUnitTestExecutionListener.java:141) at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:406) at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:91) at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71) at org.junit.runners.ParentRunner.run(ParentRunner.java:236) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174) at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:53) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:123) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:104) 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:601) at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164) at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110) at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:175) at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:107) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:68) </code></pre> Here is the table's script: <pre><code>CREATE TABLE `adminaccounts` ( `username` varchar(50) NOT NULL, `companyName` varchar(50) NOT NULL DEFAULT 'Unknown', `email` varchar(50) DEFAULT NULL, `forcePassChange` bit(1) NOT NULL DEFAULT b'1', PRIMARY KEY (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 </code></pre> Here is my Entity class: <pre><code>import java.io.Serializable; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="adminaccounts") public class DBAccount implements Serializable { private static final long serialVersionUID = 1L; /** Account name */ @Id @Column(name="username") private String username; public void setUsername(String n) { this.username = n; } public String getUsername() { return this.username; } /** Force password change flag */ @Column(name="forcePassChange") private boolean forceChange; public void setForceChange(boolean f) { this.forceChange = f; } public boolean getForceChange() { return this.forceChange; } /** Company name */ @Column(name="companyName") private String company; public void setCompany(String c) { this.company = c; } public String getCompany() { return this.company; } /** email */ @Column(name="email") private String email; public void setEmail(String e) { this.email = e; } public String getEmail() { return this.email; } public String toString() { String s = this.username + " " + this.company + " " + this.email + " " + (this.forceChange ? "Force" : "No force"); return s; } } </code></pre> hibernate config: <pre><code><?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <mapping class="jp.co.rns.model.DBAccount" /> </session-factory> </hibernate-configuration> </code></pre> I use annotations so no persistence.xml file Here is test context <pre><code><?xml version="1.0" encoding="UTF-8"?> <beans:beans xmlns="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:util="http://www.springframework.org/schema/util" xmlns:beans="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.1.xsd">   <annotation-driven />  <resources mapping="/resources/**" location="/resources/" />  <util:properties id="appProperties" location="classpath:application.properties"> </util:properties> <beans:bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" p:location="classpath:jdbc.properties" />  <beans:bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <beans:property name="dataSource" ref="dataSource" /> <beans:property name="configLocation"> <beans:value>classpath:hibernate.cfg.xml</beans:value> </beans:property> <beans:property name="configurationClass"> <beans:value>org.hibernate.cfg.AnnotationConfiguration</beans:value> </beans:property> <beans:property name="hibernateProperties"> <beans:props> <beans:prop key="hibernate.dialect">${jdbc.dialect}</beans:prop> <beans:prop key="hibernate.show_sql">true</beans:prop> </beans:props> </beans:property> </beans:bean> <tx:annotation-driven /> <beans:bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <beans:property name="sessionFactory" ref="sessionFactory" /> </beans:bean>  <beans:bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" p:url="${jdbc.databaseurl}" p:username="${jdbc.username}" p:password="${jdbc.password}" > <beans:property name="driverClassName"> <beans:value>${jdbc.driverClassName}</beans:value> </beans:property> </beans:bean>  <beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <beans:property name="prefix" value="/WEB-INF/views/" /> <beans:property name="suffix" value=".jsp" /> </beans:bean> <context:component-scan base-package="jp.co.rns" /> <mvc:interceptors> <beans:bean class="org.springframework.web.servlet.i18n.LocaleChangeInterceptor"> <beans:property name="paramName" value="lang" /> </beans:bean> <beans:bean class="org.springframework.web.servlet.theme.ThemeChangeInterceptor"> <beans:property name="paramName" value="lang" /> </beans:bean> </mvc:interceptors> <beans:bean id="messageSource" class="org.springframework.context.support.ReloadableResourceBundleMessageSource"> <beans:property name="basename" value="classpath:static" /> <beans:property name="defaultEncoding" value="UTF-8"/> </beans:bean> <beans:bean id="localeChangeInterceptor" class="org.springframework.web.servlet.i18n.LocaleChangeInterceptor"> <beans:property name="paramName" value="lang" /> </beans:bean> <beans:bean id="localeResolver" class="org.springframework.web.servlet.i18n.CookieLocaleResolver"> <beans:property name="defaultLocale" value="en"/> </beans:bean>  <beans:bean id="themeSource" class="org.springframework.ui.context.support.ResourceBundleThemeSource"> <beans:property name="basenamePrefix" value="theme_" /> </beans:bean>  <beans:bean id="themeChangeInterceptor" class="org.springframework.web.servlet.theme.ThemeChangeInterceptor"> <beans:property name="paramName" value="lang" /> </beans:bean> <beans:bean id="themeResolver" class="org.springframework.web.servlet.theme.CookieThemeResolver"> <beans:property name="defaultThemeName" value="en" /> </beans:bean> <beans:bean id="handlerMapping" class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping"> <beans:property name="interceptors"> <beans:list> <beans:ref bean="themeChangeInterceptor" /> <beans:ref bean="localeChangeInterceptor" /> </beans:list> </beans:property> </beans:bean> </beans:beans> </code></pre>
Tags
<mysql><dbunit><spring-test>
Title
Spring test DBUnit : table comparison fails even in simplest test
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USHtonS
UserOwnerUserId
1. USHtonS
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POSpring test DBUnit : table comparison fails even in simplest test
 UserUserId
 USHtonS
 VoteTypeVoteTypeId
 VTBountyStart
2. VO
 singulars
 PostPostId
 POSpring test DBUnit : table comparison fails even in simplest test
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POSpring test DBUnit : table comparison fails even in simplest test
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTBountyClose
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.