[JS2-838] scripts for mssql database generation doesn't work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.2.0
• Component/s: Persistence and DAO
• Environment: MS SQL Server 2005
• Assignee: Ate Douma
• Reporter: Vitaly Baranovsky
• Created: 26/Dec/07 20:09
• Updated: 04/Oct/11 21:37
• Resolved: 16/May/08 08:21

Description

When I run script for mssql on MS SQL Server 2005 it doesn't create database.
For foreign keys that references to same table, ms sql server writes next error:

com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'FK_PAGE_MENU_1' on table 'PAGE_MENU' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

So, for Ms Sql Server there is need to change ON DELETE CASCADE to ON DELETE NO ACTION for all foreign keys that references to same table.

I have a patch to schemas (to phase2-schema.xml and security-schema.xml). But after this changes generated scripts will change ON DELETE type of constraint (from CASCADE to NO ACTION) for described types of foreign keys for all databases (not only for mssql).

Issue Links

• duplicates: JS2-812 Better support for MSSQL