Bug 779737 (SOA-2099)

Summary:	Schema tool does not contain config properties for db2, sybase and mssql databases
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Jiri Pechanec <jpechane>
Component:	Tooling	Assignee:	Julian Coleman <jcoleman>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	5.0.0 GA	Keywords:	TestBlocker
Target Milestone:	---
Target Release:	5.0.2
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-2099
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:	5.0.2 CR1
Last Closed:	2010-06-18 09:16:06 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 Jiri Pechanec 2010-05-27 06:11:01 UTC

Date of First Response: 2010-06-03 06:47:12
project_key: SOA

See summary - schema tool does not work for those databases. Moreover if the file is not found then variable config_props is not defined and the script fails miserably

Comment 1 Martin Vecera 2010-06-03 10:47:12 UTC

We would need to get this fixed to be able to certify on the mentioned databases.

Comment 2 Len DiMaggio 2010-06-03 16:00:08 UTC

Affects Testing: Added: [Blocks Testing]
Blocked Tests: Added: Testing of MS-SQL and DB2 - targeted for 5.0.2

Comment 3 Julian Coleman 2010-06-04 10:12:33 UTC

Fixed with revision 5819 of:
  build-tools/resource/schema-tool/build.xml

Commit message:
  SOA-2099
  Always define config_props (not just when we read from the properties file).

(We don't always need a config.properties file, as there are built-in defaults that will be used instead.)

Comment 4 Dana Mison 2010-06-07 00:26:44 UTC

Added to the SOA 5.0.2 release notes as resolved:

SOA-2099
Support MS-SQL and DB2 databases has been added to the SOA Platform database schema tool.  Refer to the ESB Administration Guide and the Getting Started Guide for more information on its use.

Comment 5 Jiri Pechanec 2010-06-18 09:16:06 UTC

Verified in CR2