Thanks!
No I did not receive any other responses from cross posting.
Yes I am still interested in help.
The problem I am having is that I cannot make any examples of DBUnit (that demonstrate the CLEAN_INSERT feature) that I have found thru google searching work with SQL Server or Oracle or MySQL or PostgresSQL.
I suspect they only work with databases like H2 and HSQL which is kinda silly because you can start with a "clean slate" with those databases and there is no need to delete the old database tables.
The link posted above is a problem about a missing table using an ORM.
ORMs are good. However I need to test complex SQL queries without an ORM on multiple databases including MS SQL Server, Oracle, MySQL and PostgresSQL.
Since I could not make any of the examples implement the CLEAN_INSERT feature (to delete old tables), I began to wonder how it works. After digging into source code for several hours, I gave up. But it begs the question:
How would the author of DBUnit write database neutral code to enumerate all the non-system tables in a database and delete them without using database specific JPA providers? Can it be done?
Maybe not.
Maybe that is why it does not work.
Can you find an example of CLEAN_INSERT that works with MS SQL Server, Oracle, MySQL and PostgresSQL?
There are of course, examples of DBUnit that work (that I have found) but they don't use CLEAN_INSERT (which I thought was one of the great features of DBUnit! Why not just use
JUnit instead if you are not going to clean up the tables?).
Can you find any that work with CLEAN_INSERT? On Oracle, MS SQL Server, MySQL and PostgresSQL?
Thanks
Siegfried