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

[Chris Laprun (JIRA)]

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


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