'Can not using foreign table in DBunit

My project is using SpringMVC, MyBatis, and PostgreSql.

In postgres, I have 2 servers: sv1, sv2.

I imported a table from sv2 into sv1 using:

import foreign schema public limit to (tbl2) from server sv2 into public;

But, when using DBUnit to do testing, I cannot insert data into the foreign table tbl2. The exception is:

ERROR org.dbunit.database.DatabaseDataSet - Table 'tbl2' not found in tableMap=org.dbunit.dataset.OrderedTableNameMap

How can I use foreign table in DBUnit?

postgresqlspring-mvcmybatisdbunit


Solution 1:[1]

You need to configure the DatabaseConfig.

databaseConfig.setProperty(PROPERTY_TABLE_TYPE, [array of string with table types]);
or
databaseConfig.setTableType([array with table types]);
or configure your bean and add property 

<property name="tableType">
  <array value-type="java.lang.String">
  <value>TABLE</value>
  <value>FOREIGN TABLE</value>
 </array>
</property>

You can see the whole map of table types if you go to any of the implementations DatabaseMetadata and look for "TABLE".

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 randobigor

Related Questions