Hi All

am searching for something that seems strange but i really need this.

our enviroment is maven, andromda, spring, hibernate, DB engine & dbunit for testing. we are working now using mysql but we want migrate to postgres. the point is that the connection url we used with mysql is:-
jdbc:mysql://localhost:3306/testDB?sessionVariables=FOREIGN_KEY_CHECKS=0

but i found nothing similar to this(FOREIGN_KEY_CHECKS) with postgres i searched & found that i have to drop the sql refrential checks first in order to behave the same. the problem is that the DB is automatically recreated about 10 times everyday (with each single build) so it is so hard to drop the refrential constraints manually each time specially with a huge number of tabels & relations.

we need this issue for testing purpose. so i was wondering if hibernate has a solution for this problem or not.?? something like generating the foreign key columns but not to make the constraints !!!!


thnx for any reply,,,