[jbossseam-issues] [JBoss JIRA] Closed: (JBSEAM-3920) Seam-gen creates code which will not compile for multiple foreign keys (mysql)

[Ondrej Skutka (JIRA)]

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

Ondrej Skutka closed JBSEAM-3920.
---------------------------------

    Resolution: Duplicate Issue


> Seam-gen creates code which will not compile for multiple foreign keys (mysql)
> ------------------------------------------------------------------------------
>
>                 Key: JBSEAM-3920
>                 URL: https://jira.jboss.org/jira/browse/JBSEAM-3920
>             Project: Seam
>          Issue Type: Bug
>    Affects Versions: 2.1.1.GA
>            Reporter: philip andrew
>
> The bug is described at forum reference. Duplicate description is below.
> Hi,
> I have two mysql tables, user and staff. On my user table I have three foreign keys, social_security_assistance_confirmed_by_staff_id, approved_by_staff_id, rejected_by_staff_id, all reference staff.id.
> I seam-gen with seam generate-entities and one problem is it makes my UserHome class wrong with:
> @Name("userHome")
> public class UserHome extends EntityHome<User> {
> 	@In(create = true)
> 	StaffHome staffHome;
> 	@In(create = true)
> 	StaffHome staffHome;
> 	@In(create = true)
> 	StaffHome staffHome;
> That does NOT compile, how come it generates this? Everything is ok if I delete the multiples and cut it down to one.
> Here are the mysql tables
> CREATE TABLE `staff` (
>   `id` int(10) NOT NULL auto_increment,
>   `user` varchar(80) collate utf8_unicode_ci NOT NULL,
>   `password` varchar(80) collate utf8_unicode_ci NOT NULL,
>   PRIMARY KEY  (`id`),
>   UNIQUE KEY `user` (`user`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
> CREATE TABLE `user` (
>   `id` int(10) NOT NULL auto_increment,
>   `user` varchar(80) collate utf8_unicode_ci NOT NULL,
>   `password` varchar(80) collate utf8_unicode_ci NOT NULL,
>   `first_name_chinese` varchar(80) collate utf8_unicode_ci default NULL,
>   `last_name_chinese` varchar(80) collate utf8_unicode_ci default NULL,
>   `first_name_english` varchar(80) collate utf8_unicode_ci default NULL,
>   `last_name_english` varchar(80) collate utf8_unicode_ci default NULL,
>   `hk_id_number` varchar(20) collate utf8_unicode_ci NOT NULL,
>   `date_of_birth` date NOT NULL,
>   `contact_phone_number` varchar(20) collate utf8_unicode_ci default NULL,
>   `email` varchar(80) collate utf8_unicode_ci NOT NULL,
>   `address` varchar(255) collate utf8_unicode_ci default NULL,
>   `school` varchar(80) collate utf8_unicode_ci default NULL,
>   `social_security_assistance_indicated` tinyint(1) NOT NULL,
>   `social_security_assistance_confirmed` tinyint(1) NOT NULL default '0',
>   `social_security_assistance_confirmed_by_staff_id` int(10) default NULL,
>   `date_signed` date default NULL,
>   `approved_by_staff` tinyint(1) NOT NULL default '0',
>   `approved_by_staff_id` int(10) default NULL,
>   `rejected_by_staff` tinyint(1) NOT NULL default '0',
>   `rejected_by_staff_id` int(10) default NULL,
>   `blacklist` tinyint(1) NOT NULL default '0',
>   `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
>   `updated` timestamp NOT NULL default '0000-00-00 00:00:00',
>   PRIMARY KEY  (`id`),
>   UNIQUE KEY `user` (`user`),
>   UNIQUE KEY `hk_id_number` (`hk_id_number`),
>   UNIQUE KEY `email` (`email`),
>   KEY `social_security_assistance_confirmed_by_staff_id_idxfk` (`social_security_assistance_confirmed_by_staff_id`),
>   KEY `approved_by_staff_id_idxfk` (`approved_by_staff_id`),
>   KEY `rejected_by_staff_id_idxfk` (`rejected_by_staff_id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
> ALTER TABLE `user`
>   ADD CONSTRAINT `user_ibfk_3` FOREIGN KEY (`rejected_by_staff_id`) REFERENCES `staff` (`id`),
>   ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`social_security_assistance_confirmed_by_staff_id`) REFERENCES `staff` (`id`),
>   ADD CONSTRAINT `user_ibfk_2` FOREIGN KEY (`approved_by_staff_id`) REFERENCES `staff` (`id`);

-- 
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