Simulate trigger with dbUnit

Question

I'm using dbUnit to put test data in DB with dataset like

     <dataset>
        <TABLE_1 PRIMARY_KEY_COL="10000001" OTHER_COL="Some Text"/>
     </dataset>

My problem is that there's on-insert trigger in db that populates child records into TABLE_2. So when I try to

   DatabaseOperation.DELETE.execute();

at tearDown() it fails with java.sql.SQLException: ORA-02292: integrity constraint (TABLE_2_TABLE_1_FK) violated - child record found.

Is there any way to simulate on-delete trigger for TABLE_1 to delete child records with dbUnit and do not add trigger into DB?

score 1 · Accepted Answer · answered Sep 05 '11 at 18:18

We do not have triggers in our databases, but we do use dbunit and this might work for you:

You can have a different dataset for the DELETE operation that includes the table where the trigger inserts data into. Order is important so dbunit can do the delete or insert operation on the table that references TABLE_1 first...

<dataset>
    <TABLE_WITH_TRIGGERED_DATA_HERE...>
    <TABLE_1 PRIMARY_KEY_COL="10000001" OTHER_COL="Some Text"/>
 </dataset>

score 0 · Answer 2 · answered Sep 05 '11 at 16:10

0

I just put two links here, they should be enough

http://www.dbunit.org/apidocs/org/dbunit/operation/TruncateTableOperation.html

http://www.dbunit.org/bestpractices.html#nocleanup

answered Sep 05 '11 at 16:10

bpgergo

15,669
5
44
68

TRUNCATE doesn't solve the problem: we can't truncate tables which have dependent foreign keys. – APC Sep 05 '11 at 16:43
Yup, then maybe DeleteAllOperation will do http://www.dbunit.org/apidocs/org/dbunit/operation/DeleteAllOperation.html – bpgergo Sep 05 '11 at 16:45

Simulate trigger with dbUnit

2 Answers2