jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Esteban Franqueiro (JIRA)" <j...@apache.org>
Subject [jira] Commented: (JCR-1560) Data Store: Oracle fails to create the table
Date Tue, 29 Apr 2008 14:53:56 GMT

    [ https://issues.apache.org/jira/browse/JCR-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593031#action_12593031

Esteban Franqueiro commented on JCR-1560:

You're correct. But I used the following line in oracle.properties:
createTable=CREATE TABLE ${tablePrefix}${table}(ID VARCHAR2(255) PRIMARY KEY, LENGTH NUMBER,
BTW, I also had to modify db2.properties. Should we open a new issue?

> Data Store: Oracle fails to create the table
> --------------------------------------------
>                 Key: JCR-1560
>                 URL: https://issues.apache.org/jira/browse/JCR-1560
>             Project: Jackrabbit
>          Issue Type: Bug
>    Affects Versions: 1.4
>            Reporter: Thomas Mueller
>            Assignee: Thomas Mueller
>             Fix For: core 1.4.3
> When using an Oracle database, the following exception occurs when trying to create the
table: ORA.00902: invalid datatype
> The problem is that Oracle doesn't support the data type BIGINT. Instead, LONG should
be used.

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

View raw message