You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Thomas Mueller (JIRA)" <ji...@apache.org> on 2008/04/29 11:37:57 UTC
[jira] Created: (JCR-1560) Data Store: Oracle fails to create the
table
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.
[jira] Commented: (JCR-1560) Data Store: Oracle fails to create the
table
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593241#action_12593241 ]
Thomas Mueller commented on JCR-1560:
-------------------------------------
Hi,
You are right of course: NUMBER is correct. LONG doesn't work actually.
> db2.properties
Yes, please open an 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.
[jira] Commented: (JCR-1560) Data Store: Oracle fails to create the
table
Posted by "Esteban Franqueiro (JIRA)" <ji...@apache.org>.
[ 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, LAST_MODIFIED NUMBER, DATA BLOB)
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.
[jira] Updated: (JCR-1560) Data Store: Oracle fails to create the
table
Posted by "Jukka Zitting (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jukka Zitting updated JCR-1560:
-------------------------------
Component/s: jackrabbit-core
> 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
> Components: jackrabbit-core
> Affects Versions: 1.4
> Reporter: Thomas Mueller
> Assignee: Thomas Mueller
> Fix For: core 1.4.4
>
>
> 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.
[jira] Commented: (JCR-1560) Data Store: Oracle fails to create the
table
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593245#action_12593245 ]
Thomas Mueller commented on JCR-1560:
-------------------------------------
It would be great to have this fixed in 1.4.4, should I commit it to the 1.4 branch?
> 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.
[jira] Commented: (JCR-1560) Data Store: Oracle fails to create the
table
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593243#action_12593243 ]
Thomas Mueller commented on JCR-1560:
-------------------------------------
Fixed in revision 652306 (trunk)
> 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.
[jira] Resolved: (JCR-1560) Data Store: Oracle fails to create the
table
Posted by "Jukka Zitting (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jukka Zitting resolved JCR-1560.
--------------------------------
Resolution: Fixed
Merged to the 1.4 branch in revision 653349.
> 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
> Components: jackrabbit-core
> Affects Versions: 1.4
> Reporter: Thomas Mueller
> Assignee: Thomas Mueller
> Fix For: core 1.4.4
>
>
> 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.
[jira] Updated: (JCR-1560) Data Store: Oracle fails to create the
table
Posted by "Jukka Zitting (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jukka Zitting updated JCR-1560:
-------------------------------
Fix Version/s: (was: core 1.4.3)
core 1.4.4
OK to commit to 1.4.4
> 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.4
>
>
> 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.