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

    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