You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org> on 2007/12/26 21:10:43 UTC
[jira] Created: (JS2-838) scripts for mssql database generation
doesn't work
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.1.3
Environment: MS SQL Server 2005
Reporter: Vitaly Baranovsky
Attachments: patchmssqlschema.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
[jira] Updated: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitaly Baranovsky updated JS2-838:
----------------------------------
Attachment: (was: patchmssqlschema.txt)
> 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
>
> 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
[jira] Commented: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597386#action_12597386 ]
Vitaly Baranovsky commented on JS2-838:
---------------------------------------
Yes, Ate, of course I agree with you!
My solution was just quick workaround...
> 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
[jira] Commented: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ 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
[jira] Commented: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597387#action_12597387 ]
Vitaly Baranovsky commented on JS2-838:
---------------------------------------
Ate, I'm working with MS SQL 2005 every day. So, if you need some testing or help, you can ask me.
> 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
[jira] Updated: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitaly Baranovsky updated JS2-838:
----------------------------------
Attachment: patchmssqlschema2.txt
After testing I found, that in prefs-schema one more
on delete="cascade"
wasn't changed to
on delete="none"
So, I upload new patch for this situation
> 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
> 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
[jira] Assigned: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ate Douma reassigned JS2-838:
-----------------------------
Assignee: Ate Douma (was: David Sean Taylor)
> 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
[jira] Updated: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitaly Baranovsky updated JS2-838:
----------------------------------
Affects Version/s: (was: 2.1.3)
2.2
> 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
> Attachments: patchmssqlschema.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
[jira] Resolved: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ate Douma resolved JS2-838.
---------------------------
Resolution: Duplicate
Vitaly,
You're correct that the MSSQL database support isn't correct yet.
But, your patch isn't the right way to fix that removing the cascade actiions from those constraints isn't enough: the children rows still need to be removed somehow, right?
I've reopened JS2-812 for that as it better targets the whole problem.
> 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
[jira] Commented: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597975#action_12597975 ]
Vitaly Baranovsky commented on JS2-838:
---------------------------------------
Ok, I made some investigations, and I think tomorrow I'll send correct scripts for ms sql generation...
> 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
[jira] Updated: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitaly Baranovsky updated JS2-838:
----------------------------------
Attachment: patchmssqlschema.txt
> 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.1.3
> Environment: MS SQL Server 2005
> Reporter: Vitaly Baranovsky
> Attachments: patchmssqlschema.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
[jira] Assigned: (JS2-838) scripts for mssql database generation
doesn't work
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Sean Taylor reassigned JS2-838:
-------------------------------------
Assignee: David Sean Taylor
> 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: David Sean Taylor
> 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