0 Replies Latest reply on Dec 5, 2007 6:16 AM by jimmy mani

    duplicate foreign key and index key mapping

    jimmy mani Newbie

      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