[jboss-user] [EJB 3.0] - duplicate foreign key and index key mapping

[jimmymani]

hi,
i am using ejb3 and jboss 4.0.5. we are deploying two ear files with same entity beans in each. one is application and other is admin website.

after deploying both ears i am getting duplicate mapping in all tables.
is there any way to ignore the foreign key mapping while deployment other than removing the foreign key mapping from the file.

below is the duplicate mapping 

  KEY `FKBE30CE93603AEC0` (`brandId`),
  KEY `FK9E150A05C2D2217D` (`uniqueId`,`brandId`),
  KEY `FKBE30CE9501179D2` (`brandId`),
  KEY `FKBE30CE9C2D2217D` (`brandId`,`uniqueId`),
   CONSTRAINT `FKBE30CE91C08B9EB` FOREIGN KEY (`brandId`, `uniqueId`) REFERENCES `users` (`brandId`, `uniqueId`),
  CONSTRAINT `FKBE30CE93603AEC0` FOREIGN KEY (`brandId`) REFERENCES `brands` (`brandId`),
  CONSTRAINT `FKBE30CE9501179D2` FOREIGN KEY (`brandId`) REFERENCES `brands` (`brandId`),
  CONSTRAINT `FKBE30CE9C2D2217D` FOREIGN KEY (`brandId`, `uniqueId`) REFERENCES `users` (`brandId`, `uniqueId`)


please help me


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4110478#4110478

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4110478