org.dbunit.dataset.NoSuchTableException: Did not find table ‘xxx’ in schema ‘null’

by

I’ve also come across this same error and the accepted fix above did not fix my problems. However I was able to find the solution.

My setup consisted of DBUnit(2.4), EclipseLink(2.1) as my JPA provider, and Postgres as my backend database. Also, in my scenario I was not dropping and recreating the tables for each test run. My test data already existed. Bad practice I know, but it was more of a test/prototyping scenario. The code below illustrates the DBUnit configuration used to fix my problem. 

54    // ctx represents a spring context
55    DataSource ds = (DataSource)ctx.getBean("myDatasourceBean");
56    Connection conn = DataSourceUtils.getConnection(ds);
57    IDatabaseConnection dbUnitConn = new DatabaseConnection(conn, "public");
58    DatabaseConfig dbCfg = dbUnitConn.getConfig();
59    dbCfg.setFeature(DatabaseConfig.FEATURE_CASE_SENSITIVE_TABLE_NAMES, Boolean.TRUE);
60    IDataSet dataSet = new FlatXmlDataSet(ClassLoader.getSYstemResourceAsStream("mydbunitdata.xml"));
61    DatabaseOperation.REFRESH.execute(dbUnitConn, dataSet);

Two things in the code above fixed my problem. First I needed to define the schema DBUnit should use. That is done on line 57 above. When the new DatabaseConnection is set, the schema(“public”) should be passed in if it is not null.

Secondly, I needed DBUnit to be case sensitive about the database table names. In my DBUnit xml file(“mydbunitdata.xml”) the table names are all lowercase like they are in the database. However, if you don’t tell DBUnit to use case sensitive table names it looks for uppercase table names which Postgres didn’t like. Therefore I needed to set the case sensitive feature in DBUnit which is done on line 59.

More Related Contents:

  1. java.lang.ClassCastException: java.lang.String cannot be cast to
  2. How do I call the default deserializer from a custom deserializer in Jackson
  3. How to solve the “failed to lazily initialize a collection of role” Hibernate exception
  4. How do I use annotations to define different types of relationships in Hibernate 4 and Spring?
  5. Bypass GeneratedValue in Hibernate (merge data not in db?)
  6. Mapping ManyToMany with composite Primary key and Annotation:
  7. How does the FetchMode work in Spring Data JPA
  8. Spring Boot – Handle to Hibernate SessionFactory
  9. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  10. Unable to get spring boot to automatically create database schema
  11. Exception NoClassDefFoundError for CacheProvider
  12. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  13. Hibernate table not mapped error in HQL query
  14. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  15. java.lang.NoSuchMethodError: org.hibernate.SessionFactory.openSession()Lorg/hibernate/classic/Session
  16. Do you need a database transaction for reading data?
  17. Hibernate-sequence doesn’t exist
  18. Could not commit JPA transaction: Transaction marked as rollbackOnly
  19. Spring JpaRepository – Detach and Attach entity
  20. Rollback transaction after @Test
  21. How do I properly do a background thread when using Spring Data and Hibernate?
  22. Manually call Spring Annotation Validation
  23. Getting a ‘No thread-bound request found’ error from spring in my web app
  24. Spring 4 + Hibernate 5 = org.springframework.orm.jpa.EntityManagerHolder cannot be cast to org.springframework.orm.hibernate5.SessionHolder
  25. How to map a JSON column with H2, JPA, and Hibernate
  26. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  27. Error creating bean with name ‘entityManagerFactory
  28. Hibernate: CRUD Generic DAO
  29. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  30. Autowired Repository is Null in Custom Constraint Validator

Leave a Comment