DBUnit disappearing columns

[nickarls]

I have a really strange issue with a DBUnit test (@UsingDataSet, XLS) against the H2 ExampleDS. I get the exception

Caused by: org.dbunit.dataset.NoSuchColumnException: T_MYY405.AVAIN_MYY405 -  (Non-uppercase input column: AVAIN_MYY405) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive.

          at org.dbunit.dataset.AbstractTableMetaData.getColumnIndex(AbstractTableMetaData.java:117) [arquillian-service:]

When I debug the code I see the _columnsToIndexes map built correctly with the 31 columns mapped on the first run of getColumnIndex. Then when the second call comes in but now the _columnsToIndexes map only contains 18 keys and a few calls later I get the exception above when the column is not among the 18 present. And this is a private map only accessed within that method, how is it even possible?

[bmajsak]

Hi Nicklas,

that is very strange indeed. Can you share some details about the structure of data sets and tests you are executing? That would help me trying to reproduce the problem.

If the data sets are not that big how about trying another format to see if the problem remains?

[nickarls]

The excel is very simple (7 rows of 31 columns of data) and the columns are mapped correctly the first time it's lazily loaded. The test is a

   @PersistenceContext

   private EntityManager em;

   @Test

   @UsingDataSet("datasets/t_myy405.xls")

   public void test()

   {

      Assert.assertEquals(7, em.createQuery("select a from Asetukset a", Asetukset.class).getResultList().size());

   }

running against an AS7

[bmajsak]

Would it be possible to share it somehow?

[nickarls]

Thanks. Spammed you by email.

[nickarls]

BTW, did you ever find time to look into it?

[bmajsak]

Not yet, sorry... Hopefully will manage to work on it this week.