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 "Frank Otto (JIRA)" <je...@portals.apache.org> on 2009/05/29 16:16:45 UTC
[jira] Created: (JS2-1024) mssql create-schema.sql is incorrect
mssql create-schema.sql is incorrect
------------------------------------
Key: JS2-1024
URL: https://issues.apache.org/jira/browse/JS2-1024
Project: Jetspeed 2
Issue Type: Bug
Components: Persistence and DAO
Affects Versions: 2.2.0
Reporter: Frank Otto
Fix For: 2.2.1
The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
for example: table SECURITY_DOMAIN is missing
--
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-1024) mssql create-schema.sql is incorrect
Posted by "Frank Otto (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Frank Otto updated JS2-1024:
----------------------------
Attachment: (was: create-schema.sql)
> mssql create-schema.sql is incorrect
> ------------------------------------
>
> Key: JS2-1024
> URL: https://issues.apache.org/jira/browse/JS2-1024
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Persistence and DAO
> Affects Versions: 2.2.0
> Reporter: Frank Otto
> Assignee: Ate Douma
> Fix For: 2.2.1
>
> Attachments: create-schema.sql, drop-schema.sql
>
>
> The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
> for example: table SECURITY_DOMAIN is missing
--
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-1024) mssql create-schema.sql is incorrect
Posted by "Frank Otto (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Frank Otto updated JS2-1024:
----------------------------
Attachment: (was: drop-schema.sql)
> mssql create-schema.sql is incorrect
> ------------------------------------
>
> Key: JS2-1024
> URL: https://issues.apache.org/jira/browse/JS2-1024
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Persistence and DAO
> Affects Versions: 2.2.0
> Reporter: Frank Otto
> Assignee: Ate Douma
> Fix For: 2.2.1
>
> Attachments: create-schema.sql, drop-schema.sql
>
>
> The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
> for example: table SECURITY_DOMAIN is missing
--
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-1024) mssql create-schema.sql is incorrect
Posted by "Frank Otto (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Frank Otto updated JS2-1024:
----------------------------
Attachment: drop-schema.sql
create-schema.sql
I have included the triggers for the tables, which have no cascade delete on mssql.
I think, there are "only" this tables: FOLDER, FOLDER_MENU, FRAGMENT, PAGE_MENU?
> mssql create-schema.sql is incorrect
> ------------------------------------
>
> Key: JS2-1024
> URL: https://issues.apache.org/jira/browse/JS2-1024
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Persistence and DAO
> Affects Versions: 2.2.0
> Reporter: Frank Otto
> Assignee: Ate Douma
> Fix For: 2.2.1
>
> Attachments: create-schema.sql, drop-schema.sql
>
>
> The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
> for example: table SECURITY_DOMAIN is missing
--
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-1024) mssql create-schema.sql is incorrect
Posted by "Frank Otto (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Frank Otto updated JS2-1024:
----------------------------
Attachment: drop-schema.sql
create-schema.sql
the correct sql scripts for mssql
> mssql create-schema.sql is incorrect
> ------------------------------------
>
> Key: JS2-1024
> URL: https://issues.apache.org/jira/browse/JS2-1024
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Persistence and DAO
> Affects Versions: 2.2.0
> Reporter: Frank Otto
> Assignee: Ate Douma
> Fix For: 2.2.1
>
> Attachments: create-schema.sql, drop-schema.sql
>
>
> The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
> for example: table SECURITY_DOMAIN is missing
--
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-1024) mssql create-schema.sql is incorrect
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ate Douma reassigned JS2-1024:
------------------------------
Assignee: Ate Douma
> mssql create-schema.sql is incorrect
> ------------------------------------
>
> Key: JS2-1024
> URL: https://issues.apache.org/jira/browse/JS2-1024
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Persistence and DAO
> Affects Versions: 2.2.0
> Reporter: Frank Otto
> Assignee: Ate Douma
> Fix For: 2.2.1
>
>
> The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
> for example: table SECURITY_DOMAIN is missing
--
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-1024) mssql create-schema.sql is incorrect
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12716244#action_12716244 ]
Ate Douma commented on JS2-1024:
--------------------------------
Hi Frank,
Thanks for the patches, but I'm afraid they are not yet good enough to incorporate in the jetspeed src.
I see a lot of changes on column data types (e.g. INT -> INTEGER) and adjustments for the changed table definitions, which seems fine to me.
But, what has gone missing (including possible required adjustments) is all the required mssql trigger code.
For mssql, as it doesn't properly support (standard) cascade deletes for hierarchical references, there were are several tables which has additional triggers to deal with that functionality (e.g. FOLDER, FOLDER_MENU, FRAGMENT, PAGE_MENU).
In your environment you might not be yet using database stored psml, but to be able to do so, these additional triggers are required to handle hierarchical references on delete.
And the same and even more so applies to the drop-schema.sql!
You might also might want to review the issues JS2-812 and JS2-838 which specifically dealt with these problems and were the basis for the current (but now outdated) hand crafted mssql schema sql.
> mssql create-schema.sql is incorrect
> ------------------------------------
>
> Key: JS2-1024
> URL: https://issues.apache.org/jira/browse/JS2-1024
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Persistence and DAO
> Affects Versions: 2.2.0
> Reporter: Frank Otto
> Assignee: Ate Douma
> Fix For: 2.2.1
>
> Attachments: create-schema.sql, drop-schema.sql
>
>
> The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
> for example: table SECURITY_DOMAIN is missing
--
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-1024) mssql create-schema.sql is incorrect
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ate Douma resolved JS2-1024.
----------------------------
Resolution: Fixed
I've finally found the time (and need :) ) to pickup this issue.
The patches were provided by Frank Otto, but I had to adjust them a little for recent database model chances.
Tested on MsSQL 2005, seems to be working well.
Thanks Frank for providing the patches!
> mssql create-schema.sql is incorrect
> ------------------------------------
>
> Key: JS2-1024
> URL: https://issues.apache.org/jira/browse/JS2-1024
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Persistence and DAO
> Affects Versions: 2.2.0
> Reporter: Frank Otto
> Assignee: Ate Douma
> Fix For: 2.2.1
>
> Attachments: create-schema.sql, drop-schema.sql
>
>
> The mssql create-schema.sql contains old tables less tables then in derbydb create-schema.sql.
> for example: table SECURITY_DOMAIN is missing
--
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