portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Sean Taylor (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Commented: (JS2-812) Better support for MSSQL
Date Fri, 04 Jul 2008 02:24:45 GMT

    [ 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: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message