Author: jeff.yuchang Date: 2010-01-20 02:46:00 -0500 (Wed, 20 Jan 2010) New Revision: 466 Modified: trunk/distribution/src/main/release/db/sql/oracle.drop.sql Log: * update the sequence of dropping tables for oracle, fix following error in hudson server. [sql] Failed to execute: drop table BPEL_MESSAGE_EXCHANGE [sql] java.sql.SQLException: ORA-02449: unique/primary keys in table referenced by foreign keys Modified: trunk/distribution/src/main/release/db/sql/oracle.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-01-19 06:07:26 UTC (rev 465) +++ trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-01-20 07:46:00 UTC (rev 466) @@ -9,7 +9,6 @@ drop table BPEL_FAULT; drop table BPEL_INSTANCE; drop table BPEL_MESSAGE; -drop table BPEL_MESSAGE_EXCHANGE; drop table BPEL_MEX_PROPS; drop table BPEL_PLINK_VAL; drop table BPEL_PROCESS; @@ -23,6 +22,7 @@ drop table STORE_PROCESS; drop table STORE_PROCESS_PROP; drop table STORE_VERSIONS; +drop table BPEL_MESSAGE_EXCHANGE; drop sequence hibernate_sequence;