[dbunit-user] Escape character in table dataset

[Gregory O. <g.o...@gm...>]

Hi,

I do have a trouble with one of tables which was named SET. Regardless the
idiot in my company who wanted this name :/

So we do have it defined in JPA2/Hibernate as below:
@Table(schema = "media", name = "[set]")
public class Set {...}

(because it wants to work with MS SQL Server, where obviously SET is a
reserved word).
(changing name="set" causes hibernate not to find the table on MS SQL side).

Then I do run same JPA entity in the integration tests with H2, and it is
created with statement:
Hibernate: create table media."set" (id integer....)

At the end I want to load a dataset using DBUnit to this H2, so within
dataset I do have
<....>
<MEDIA.set id="1" bla="ssss"/>

However it fails to load because of exception:
org.dbunit.dataset.NoSuchTableException: MEDIA.SET

Currently I do not have an option to refactor table name. so it has to stay
[set] in JPA entity.

When I write a dataset like <MEDIA."set" ... it complains about the "
character.

Any idea how to load data in this crappy situation ?

BR,
Gregory