2008-08-18

Using Keyword with Table Name and DbUnit

DbUnit 2.2 doesn't support automatic identifier quotation for auto generated DDLs or DMLs.

So, using with MySQL where table name may be keyword like 'order', 'lower-case-table-names' system variable of MySQL should be set to '0' on Unix or '2' on Windows and FEATURE_QUALIFIED_TABLE_NAMES of DbUnit should be set to 'true'.

Note that 'lower-case-table-names' is not dynamic variable, so it should be set at start-up like using my.ini.

0 comments:

Post a Comment