[
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.
