portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ate Douma (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Commented: (JS2-838) scripts for mssql database generation doesn't work
Date Fri, 16 May 2008 09:25:00 GMT

    [ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597404#action_12597404

Ate Douma commented on JS2-838:

If you or some of your team could help with properly fixing the other cascading constraints
by providing real cascading delete triggers on the DBPSML tables (FOLDER/PAGE/FOLDER_MENU/PAGE_MENU
etc.) that would be great.
See: JS2-812 for more information.

> scripts for mssql database generation doesn't work
> --------------------------------------------------
>                 Key: JS2-838
>                 URL: https://issues.apache.org/jira/browse/JS2-838
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Persistence and DAO
>    Affects Versions: 2.2
>         Environment: MS SQL Server 2005
>            Reporter: Vitaly Baranovsky
>            Assignee: Ate Douma
>         Attachments: patchmssqlschema2.txt
> 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).

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org

View raw message