[
https://issues.apache.org/jira/browse/JS2-812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12610422#action_12610422
]
David Sean Taylor commented on JS2-812:
---------------------------------------
see http://svn.apache.org/viewvc?view=rev&revision=673895
I committed schema for SQL Server that works from a custom Jetspeed installer
(Ant)
Its not clear to me how the jetspeed-db maven plugin handles schema that should
not be generated, like for Derby
These scripts require two different kinds of delimiters, for the 2 trigger sql
files (phase2-trig-schema.sql, prefs-trig-schema.sql),
we use '/' as the delimiter and 'row' as the delimeterType. For the other
scripts, we use defaults (;)
Additionally, the order of SQL file execution will be important
> Better support for MSSQL
> ------------------------
>
> Key: JS2-812
> URL: https://issues.apache.org/jira/browse/JS2-812
> Project: Jetspeed 2
> Issue Type: Improvement
> Components: Project Build
> Affects Versions: 2.1.2, 2.1.3
> Reporter: Scott T Weaver
> Assignee: Ate Douma
> Priority: Minor
> Fix For: 2.1.3, 2.2
>
> Attachments: 213patched.zip, mssqlschema.patch
>
>
> Need to add better support for MS SQL. The real issue is that MS SQL lacks
> support for recursive constraints, where all other databases support it just
> fine. As is always the case with MS, they consider this a "feature"
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
