You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Stefan Thieme (JIRA)" <ji...@apache.org> on 2015/01/28 12:04:36 UTC

[jira] [Comment Edited] (OAK-1914) RDB: Oracle support

    [ https://issues.apache.org/jira/browse/OAK-1914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14295002#comment-14295002 ] 

Stefan Thieme edited comment on OAK-1914 at 1/28/15 11:04 AM:
--------------------------------------------------------------

Adding a node which has been deleted earlier will result in a java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAK.SYS_C00XXXXX) violated.
This has not been resolved by adding the deletedOnce column to the NODES table in jackrabbit-oak 1.1.5.

11:50:37.735 [qtp821622613-17] DEBUG o.a.j.o.plugins.document.CommitQueue - created commit r14b302a0f27-0-1
11:50:37.750 [qtp821622613-17] DEBUG o.a.j.o.p.d.rdb.RDBDocumentStore - insert of [1:/test] failed
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAK.SYS_C0011008) violated
...
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.dbInsert(RDBDocumentStore.java:1410) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.insertDocuments(RDBDocumentStore.java:1069) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.internalCreate(RDBDocumentStore.java:676) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.create(RDBDocumentStore.java:243) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.applyToDocumentStore(Commit.java:321) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.applyToDocumentStore(Commit.java:246) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.applyInternal(Commit.java:215) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.apply(Commit.java:200) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
...



was (Author: stefan123t):
Adding a node which has been deleted earlier will result in a java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAK.SYS_C00XXXXX) violated.
This has not been resolved by adding the deletedOnce column to the NODES table in OAK-1.1.5.

11:50:37.735 [qtp821622613-17] DEBUG o.a.j.o.plugins.document.CommitQueue - created commit r14b302a0f27-0-1
11:50:37.750 [qtp821622613-17] DEBUG o.a.j.o.p.d.rdb.RDBDocumentStore - insert of [1:/test] failed
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAK.SYS_C0011008) violated
...
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.dbInsert(RDBDocumentStore.java:1410) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.insertDocuments(RDBDocumentStore.java:1069) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.internalCreate(RDBDocumentStore.java:676) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.create(RDBDocumentStore.java:243) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.applyToDocumentStore(Commit.java:321) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.applyToDocumentStore(Commit.java:246) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.applyInternal(Commit.java:215) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
	at org.apache.jackrabbit.oak.plugins.document.Commit.apply(Commit.java:200) [oak-run-1.1-SNAPSHOT.jar:1.1-SNAPSHOT]
...


> RDB: Oracle support
> -------------------
>
>                 Key: OAK-1914
>                 URL: https://issues.apache.org/jira/browse/OAK-1914
>             Project: Jackrabbit Oak
>          Issue Type: Sub-task
>          Components: rdbmk
>            Reporter: Julian Reschke
>            Assignee: Julian Reschke
>            Priority: Minor
>             Fix For: 1.2
>
>         Attachments: OAK-1914.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)