Bug 779043 (SOA-1454)

Summary: MSSQL config files added twice
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Martin Vecera <mvecera>
Component: Configuration, DeploymentAssignee: Julian Coleman <jcoleman>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: unspecified   
Target Milestone: ---   
Target Release: 4.3 CP02   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-1454
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
SOA 4.3 CP02 CR2
Last Closed: 2009-09-11 19:06:34 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:

Description Martin Vecera 2009-08-19 13:34:38 UTC 
Date of First Response: 2009-08-21 10:12:26
project_key: SOA

There are two different (!) create_database.sql scripts:
* server/*/deploy/jbossesb.sar/juddi-sql/mssql/create_database.sql 
* server/*/deploy/jbossesb.sar/lib/juddi-2.0rc5.aop.jar/juddi-sql/mssql/create_database.sql

The script should be present only on the second location.
Comment 1 Martin Vecera 2009-08-19 13:36:34 UTC 
Link: Added: This issue related SOA-544
Comment 2 Julian Coleman 2009-08-21 14:12:26 UTC 
The files in the former location (.../jbossesb.sar/juddi-sql/mssql) will override the files from the
latter location (.../sesb.sar/lib/juddi-2.0rc5.aop.jar|juddi-sql/mssql) and are now provided from
ESB.
Comment 3 Julian Coleman 2009-08-21 14:16:37 UTC 
Fixed in revision 3644 (4.3 branch) of:
  build-tools/builers/eap/build.xml
  eap/resources/juddi-sql (deleted)

Commit message:
  SOA-1454 
  Don't provide MSSQL jUDDI config files, as these are now provided by ESB.
Comment 4 Len DiMaggio 2009-09-10 17:17:43 UTC 
Looking at 4.3 CP02 CR3 - the original problem is resolved - but, why is there a create_database.sql for only MS-SQL? It's not a regression - it's the same as 4.3 CP01:

[ldimaggi@ldimaggi server]$ pwd
/opt/local/43_CP02_CR3/jboss-soa-p.4.3.0/jboss-as/server

[ldimaggi@ldimaggi server]$ tree  ./all/deploy/jbossesb.sar/juddi-sql
./all/deploy/jbossesb.sar/juddi-sql
|-- daffodildb
|   `-- import.sql
|-- db2
|   `-- import.sql
|-- derby
|   `-- import.sql
|-- firebird
|   `-- import.sql
|-- hsqldb
|   `-- import.sql
|-- informix
|   `-- import.sql
|-- jdatastore
|   `-- import.sql
|-- mssql
|   |-- create_database.sql
|   `-- import.sql
|-- mysql
|   `-- import.sql
|-- oracle
|   `-- import.sql
|-- postgresql
|   `-- import.sql
|-- sybase
|   `-- import.sql
`-- totalxml
    `-- import.sql
Comment 5 Len DiMaggio 2009-09-11 19:06:34 UTC 
Verified in CP02 CR3.