[riftsaw-commits] riftsaw SVN: r466 - trunk/distribution/src/main/release/db/sql.
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;