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

[Prabhat Jha (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBPORTAL-2284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12450127#action_12450127 ] 

Prabhat Jha commented on JBPORTAL-2284:
---------------------------------------

Base is covered meaning testsuite passes with both jdk, bea consumer thing works. Please do the rest. Selnium test will take a while to finish.

> 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