[
https://issues.apache.org/jira/browse/JCR-1320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12560966#action_12560966
]
Guido Jäkel commented on JCR-1320:
----------------------------------
The "core reason" seems to be, that Sybase don't allow to test a IMAGE-column
to be NULL.
\java\org\apache\jackrabbit\core\fs\db\DatabaseFileSystem.java:1215
selectFolderExistSQL = "select 1 from "
+ schemaObjectPrefix + "FSENTRY where FSENTRY_PATH = ? "
+ "and FSENTRY_NAME = ? and FSENTRY_DATA is null";
By help of SQuirreL, i've verified it: On Sybase
select * from REP_FSENTRY where FSENTRY_DATA is null
leads to
Error: TEXT and IMAGE datatypes may not be used in a WHERE clause, except
with the LIKE expression.
SQLState: S1000
ErrorCode: 306
On mySQL (, where this collum data type is longblob), it works flawless.
Any sybase guru out here?
> 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.
