Bug 1029007

Summary: Remove multiple drop table statements and guard against multiple create table statements.
Product: [JBoss] JBoss Fuse Service Works 6 Reporter: Steve Johnson <stejohns>
Component: ConfigurationAssignee: Steve Johnson <stejohns>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Macik <pmacik>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 6.0.0 GACC: jpechane, ldimaggi, soa-p-jira
Target Milestone: ER7   
Target Release: 6.0.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-02-06 15:26:38 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Steve Johnson 2013-11-11 13:18:56 UTC
Description of problem:


As part of installation, a number SQL schemas are run against database account.  As these SQL files come from different projects and share some common tables they must not drop tables and also must be guarded against creating tables that already exist.


Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.  Run an installation and view sqlresults.log for sqlexceptions caused by multiple table creates and for the existence of drop table statements. 
2.
3.

Actual results:


Expected results:

That no sqlexceptions exist due to multiple table creates or that no drop table statements have been run.


Additional info:

Comment 2 Julian Coleman 2013-11-14 16:50:58 UTC
*** Bug 1014562 has been marked as a duplicate of this bug. ***

Comment 3 Pavel Macik 2013-12-20 16:04:47 UTC
Verified in ER7