[Hsqldb-user] How to disable HSQLDB foreign key constraint checks?

[James Adams]

I am running a DbUnit test using in-memory HSQLDB and the test fails because
the data I'm inserting is missing the table containing the foreign key for
the table rows I'm loading.

I want to disable HSQLDB's foreign key constraint checking for this test,
perhaps by specifying an option on the URL.

I have tried appending "&sessionVariables=FOREIGN_KEY_CHECKS=0" to the
JDBC URL since (I think) this is how this is done for MySQL, but it doesn't
appear to work for HSQLDB.

Can someone recommend a solution? Thanks in advance!


--James

[WzDrg]

SET REFERENTIAL_INTEGRITY FALSE;

--Marc

[James Adams]

Thanks Marc.

Post by WzDrg
SET REFERENTIAL_INTEGRITY FALSE;
--Marc
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user