diff options
| author | jakefeasel <jfeasel@gmail.com> | 2012-12-09 13:17:42 -0800 |
|---|---|---|
| committer | jakefeasel <jfeasel@gmail.com> | 2012-12-09 13:17:42 -0800 |
| commit | 2bdbe77baffbb25047610c4a0d64fddc4ec20a42 (patch) | |
| tree | 4d177157a970c99b361d2916be1453c51f61b953 | |
| parent | a1a4009dcfbcd461127cdc5c7d2c2a15774ee8e3 (diff) | |
| download | sqlfiddle-2bdbe77baffbb25047610c4a0d64fddc4ec20a42.zip sqlfiddle-2bdbe77baffbb25047610c4a0d64fddc4ec20a42.tar.gz sqlfiddle-2bdbe77baffbb25047610c4a0d64fddc4ec20a42.tar.bz2 | |
Altering the method used for preventing Oracle from implicit commits
| -rw-r--r-- | src/main/webapp/models/Query.cfc | 13 |
1 files changed, 5 insertions, 8 deletions
diff --git a/src/main/webapp/models/Query.cfc b/src/main/webapp/models/Query.cfc index 244fdd1..4ffa7e5 100644 --- a/src/main/webapp/models/Query.cfc +++ b/src/main/webapp/models/Query.cfc @@ -45,12 +45,9 @@ <cfset sqlBatchList = REReplaceNoCase(sqlBatchList, "#escaped_separator#\s*(\r?\n|$)", "#chr(7)#", "all")> <cfif this.schema_def.db_type.simple_name IS "Oracle"> - <cfset local.defered_table = "DEFERRED_#Left(Hash(createuuid(), "MD5"), 8)#"> + <cfset local.defered_table = "DEFERRED_#this.schema_def.db_type_id#_#this.schema_def.short_code#"> <cfquery datasource="#this.schema_def.db_type_id#_#this.schema_def.short_code#"> - CREATE TABLE #local.defered_table# (val NUMBER(1) CONSTRAINT #local.defered_table#_ck CHECK(val =1) DEFERRABLE INITIALLY DEFERRED) - </cfquery> - <cfquery datasource="#this.schema_def.db_type_id#_#this.schema_def.short_code#"> - INSERT INTO #local.defered_table# VALUES (2) + INSERT INTO #local.deferred_table# VALUES (2) </cfquery> </cfif> @@ -160,7 +157,7 @@ <cfif this.schema_def.db_type.simple_name IS "Oracle"> <!--- Just in case some sneaky person finds a way to delete the intentionally-invalid record, we put one back in after each statement that executes. ---> <cfquery datasource="#this.schema_def.db_type_id#_#this.schema_def.short_code#"> - INSERT INTO #local.defered_table# VALUES (2) + INSERT INTO #local.deferred_table# VALUES (2) </cfquery> </cfif> @@ -212,7 +209,7 @@ <cfset ArrayAppend(statementArray, statement)> <cfif this.schema_def.db_type.simple_name IS "Oracle" AND - FindNoCase("ORA-02290: check constraint (USER_#UCase(this.schema_def.short_code)#.#local.defered_table#_CK) violated", cfcatch.message)> + FindNoCase("ORA-02290: check constraint (USER_#UCase(this.schema_def.short_code)#.#local.deferred_table#_CK) violated", cfcatch.message)> <cfset ArrayAppend(returnVal["sets"], { succeeded = false, @@ -252,7 +249,7 @@ <cfif this.schema_def.db_type.simple_name IS "Oracle"> <cfquery datasource="#this.schema_def.db_type_id#_#this.schema_def.short_code#"> - DROP TABLE #local.defered_table# + DROP TABLE #local.deferred_table# </cfquery> </cfif> |