Bug 991581 - One-off patch for BZ 991578 - Foreign key reference generated before unique constraint exists
Summary: One-off patch for BZ 991578 - Foreign key reference generated before unique c...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Hibernate
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: GA
: One-off release
Assignee: Brett Meyer
QA Contact: Martin Simka
Russell Dickenson
URL:
Whiteboard:
Depends On: 979103 991578
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-08-02 18:49 UTC by Ricardo Martinelli de Oliveira
Modified: 2018-12-02 16:37 UTC (History)
5 users (show)

Fixed In Version:
Clone Of: 991578
Environment:
Last Closed: 2013-09-05 13:47:18 UTC
Type: Support Patch
Embargoed:


Attachments (Terms of Use)
patched Hibernate module (3.99 MB, application/zip)
2013-08-02 20:42 UTC, Brett Meyer
no flags Details

Description Ricardo Martinelli de Oliveira 2013-08-02 18:49:19 UTC
+++ This bug was initially created as a clone of Bug #991578 +++

In H2 the generated schema works:
[main            ] DEBUG  - 18:27:01,763 - org.hibernate.SQL: 
    create table Item (
        id bigint not null,
        name varchar(255),
        SELLER_CUSTOMERNR varchar(255),
        primary key (id)
    )
[main            ] DEBUG  - 18:27:01,769 - org.hibernate.SQL: 
    create table USERS (
        id bigint not null,
        customerNr varchar(255),
        primary key (id)
    )
[main            ] DEBUG  - 18:27:01,769 - org.hibernate.SQL: 
    alter table Item 
        add constraint FK_76d41162ea614944b8333c7c440 
        foreign key (SELLER_CUSTOMERNR) 
        references USERS (customerNr)
[main            ] DEBUG  - 18:27:01,775 - org.hibernate.SQL: 
    alter table USERS 
        add constraint UK_8a5ec890d05a4545a1e9660dea0 unique (customerNr)
On Oracle this fails, as the foreign key reference is actually checked before the UNIQUE constraint is generated.
http://www.techonthenet.com/oracle/errors/ora02270.php

Comment 1 Brett Meyer 2013-08-02 20:29:06 UTC
This patch will be based off of 979103

Comment 2 Brett Meyer 2013-08-02 20:41:31 UTC
This should be considered as superseding 979103 altogether, in my opinion.

Comment 3 Brett Meyer 2013-08-02 20:42:49 UTC
Created attachment 782180 [details]
patched Hibernate module

Comment 5 Martin Simka 2013-08-06 13:23:00 UTC
No regressions were found and the issue was verified. QA Passed. 

md5sum of tested files:
89bab72cce8577e47e57dea2790558e6  BZ991581.zip
c8d720de9d682b212e0aed565e9aad84  BZ-991581.zip
6a6cc939a97fd1b2fc9a9676ea8639d2  hibernate-core-4.2.0.Final-redhat-1-BZ-991581.jar
d6020f8a16feb5ca50b39b105c1acde9  module.xml


Note You need to log in before you can comment on or make changes to this bug.