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

Stefan Thieme commented on OAK-1914:
------------------------------------

Thanks for trying, I have no clue what has changed in the Tables Primary Key 
Constraint between my Oracle 11g2 setup and your 12c instance.

Would you mind sharing your Table description and constraints, as I have no 12c 
instance at hand ?

desc OAK.NODES;
Name        Null     Type           
----------- -------- -------------- 
ID          NOT NULL VARCHAR2(512)  
MODIFIED             NUMBER         
HASBINARY            NUMBER         
DELETEDONCE          NUMBER         
MODCOUNT             NUMBER         
CMODCOUNT            NUMBER         
DSIZE                NUMBER         
DATA                 VARCHAR2(4000) 
BDATA                BLOB           


SELECT * FROM user_constraints WHERE table_name = 'NODES';
OWNER                          CONSTRAINT_NAME                CONSTRAINT_TYPE 
TABLE_NAME                     SEARCH_CONDITION                                 
                                R_OWNER                        
R_CONSTRAINT_NAME              DELETE_RULE STATUS   DEFERRABLE     DEFERRED  
VALIDATED     GENERATED      BAD RELY LAST_CHANGE INDEX_OWNER                   
 INDEX_NAME                     INVALID VIEW_RELATED 
------------------------------ ------------------------------ --------------- 
------------------------------ 
--------------------------------------------------------------------------------
 ------------------------------ ------------------------------ ----------- 
-------- -------------- --------- ------------- -------------- --- ---- 
----------- ------------------------------ ------------------------------ 
------- --------------
OAK                            SYS_C0011077                   C               
NODES                          "ID" IS NOT NULL                                 
                                                                                
                          ENABLED  NOT DEFERRABLE IMMEDIATE VALIDATED     
GENERATED NAME          29-JAN-15                                               
                                         
OAK                            SYS_C0011078                   P               
NODES                                                                           
                                                                                
                          ENABLED  NOT DEFERRABLE IMMEDIATE VALIDATED     
GENERATED NAME          29-JAN-15   OAK                            SYS_C0011078 
                                         




> 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, insert2.log, oak_20150127.patch
>
>




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

Reply via email to