[jboss-jira] [JBoss JIRA] Resolved: (JBPORTAL-2284) MSSQL does not like null RegistrationInfo

[Chris Laprun (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBPORTAL-2284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Laprun resolved JBPORTAL-2284.
------------------------------------

    Fix Version/s: 2.7.2 Final
       Resolution: Done


> MSSQL does not like null RegistrationInfo
> -----------------------------------------
>
>                 Key: JBPORTAL-2284
>                 URL: https://jira.jboss.org/jira/browse/JBPORTAL-2284
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal WSRP
>    Affects Versions: 2.6.7 Final, 2.7.1 Final
>            Reporter: Chris Laprun
>            Assignee: Chris Laprun
>             Fix For: 2.7.2 Final
>
>
> MSSQL (and possibly Sybase) don't like nullable FKs so, as soon as you have a consumer associated with a producer that doesn't require registration, it becomes impossible to create new consumers as doing so will result in the unicity constraint on the FK linking ProducerInfo and RegistrationInfo becomes violated because the previously created consumer and the new one both have null as a FK to RegistrationInfo in their ProducerInfo.
> This is linked to http://opensource.atlassian.com/projects/hibernate/browse/ANN-777

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira