[jira] Issue Comment Edited: (JCR-1320) Support for Sybase

["Stefan Guggisberg (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/JCR-1320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12559962#action_12559962 ] 

stefan@jira edited comment on JCR-1320 at 1/17/08 7:50 AM:
-----------------------------------------------------------------

AFAIK, sybase and mssql ddl syntax is pretty similar 
(not that surprising, knowing their common roots ;).

see e.g.
http://db.apache.org/ddlutils/databases/sybase.html
http://db.apache.org/ddlutils/databases/sqlserver.html
 
chances are pretty good that the existing mssql.ddl files
also work with sybase.

i don't have a sybase server at hand so i can't test it myself.

it would be great if you could test my assumption and report your 
findings.

if the mssql.ddl files don't work for sybase i'd be happy to accept
patches for sybase support ;)

      was (Author: stefan@jira):
    AFAIK, sybase and mssql ddl syntax is pretty similar 
(not that surprising, knowing their common roots ;).

see e.g.
http://db.apache.org/ddlutils/databases/sybase.html
http://db.apache.org/ddlutils/databases/sqlserver.html
 
chances are pretty good that the existing mssql.ddl files
also work with sybase.

i don't have a sybase server at hand so i can't test it myself.

i'd be great if you could test my assumption and report your 
findings.

if the mssql.ddl files don't work for sybase i'd be happy to accept
patches for sybase support ;)
  
> Support for Sybase
> ------------------
>
>                 Key: JCR-1320
>                 URL: https://issues.apache.org/jira/browse/JCR-1320
>             Project: Jackrabbit
>          Issue Type: New Feature
>          Components: jackrabbit-core
>    Affects Versions: 1.4
>            Reporter: Guido Jäkel
>
> To use Sybase as a database backend for all the components and different implementation, one need specific sybase.ddl-files to configure a schema sybase. Sybase don't seems to be compatible to one of the already existing schema.
> The following files are required:
> * org/apache/jackrabbit/core/persistence/db/sybase.ddl
> * org/apache/jackrabbit/core/persistence/bundle/sybase.ddl
> * org/apache/jackrabbit/core/fs/db/sybase.ddl
> * org/apache/jackrabbit/core/journal/sybase.ddl
> Thank you for support.

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