Bug 779043 (SOA-1454)

Summary:	MSSQL config files added twice
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Martin Vecera <mvecera>
Component:	Configuration, Deployment	Assignee:	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:
Embargoed:

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.