jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guido Jäkel (JIRA) <j...@apache.org>
Subject [jira] Updated: (JCR-1320) Support for Sybase
Date Fri, 18 Jan 2008 15:14:34 GMT

     [ https://issues.apache.org/jira/browse/JCR-1320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Guido Jäkel updated JCR-1320:
-----------------------------

    Attachment: jackrabbit-core-1.4-sybase.jar

Dear Stefan,

i've attached my 2 cents of a patchset, deriving sybase.ddl files from the mssql.ddl. This
was done by replacing BIGINT to DECIMAL(19,0) -- a great job for sed ;)

One of the tables have been created on startup, now. But i got:

com.sybase.jdbc3.jdbc.SybSQLException: TEXT and IMAGE datatypes may not be used in a WHERE
clause, except with the LIKE expression.

        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        ...

Because there no select statements inside the dll resources, the next step may be to locate
and change the prepared statements. 

But to what? Or have one to exchange the datatype IMAGE? Or is sybase unusable?

> 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
>         Attachments: jackrabbit-core-1.4-sybase.jar
>
>
> 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.


Mime
View raw message