Hibernate tool code generation org.hibernate.MappingException: Foreign key

[Sven Beckmann]

Hi,

I am working on some school project and have been trying to get my pojos, daos and mapping.xml documents generated.
I get some of my classes generated but others not.
When I select the option "Reverse Engineer from JDBC Connection" I get an Error Message:

org.hibernate.MappingException: Foreign key (FKA41D1932BD901987:tanswer [tStudent_idtStudent])) must have same number of columns as the referenced primary key (tstudent [idtStudent,tResearch_idtResearch])
Foreign key (FKA41D1932BD901987:tanswer [tStudent_idtStudent])) must have same number of columns as the referenced primary key (tstudent [idtStudent,tResearch_idtResearch])
  <No message>

I have been working with the Hibernate tools before and had no problems. Does anyone have an idea?

Thanks in advance.

I am using MySQL 5.1 with InnoDB. Here is my SQL:

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `mydb`.`tRoles`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tRoles` (
  `idtRoles` INT NOT NULL AUTO_INCREMENT ,
  `rolename` VARCHAR(70) NOT NULL ,
  `isadmin` TINYINT(1)  NOT NULL ,
  PRIMARY KEY (`idtRoles`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tUser`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tUser` (
  `idtUser` INT NOT NULL AUTO_INCREMENT ,
  `uid` VARCHAR(4) NOT NULL ,
  `firstname` VARCHAR(50) NOT NULL ,
  `lastname` VARCHAR(50) NOT NULL ,
  `email` VARCHAR(255) NOT NULL ,
  `password` VARCHAR(20) NOT NULL ,
  `passwordattempts` INT NOT NULL DEFAULT 0 ,
  `isactive` TINYINT(1)  NOT NULL ,
  `tRoles_idtRoles` INT NOT NULL ,
  PRIMARY KEY (`idtUser`, `tRoles_idtRoles`) ,
  INDEX `fk_tUser_tRoles` (`tRoles_idtRoles` ASC) ,
  UNIQUE INDEX `uid_UNIQUE` (`uid` ASC) ,
  CONSTRAINT `fk_tUser_tRoles`
    FOREIGN KEY (`tRoles_idtRoles` )
    REFERENCES `mydb`.`tRoles` (`idtRoles` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tForm`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tForm` (
  `idtForm` INT NOT NULL ,
  PRIMARY KEY (`idtForm`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tQuestion`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tQuestion` (
  `idtQuestion` INT NOT NULL AUTO_INCREMENT ,
  `questiontext` TEXT NOT NULL ,
  `isMultipleChoice` TINYINT(1)  NOT NULL ,
  `tUser_idtUser` INT NOT NULL ,
  `tUser_tRoles_idtRoles` INT NOT NULL ,
  PRIMARY KEY (`idtQuestion`, `tUser_idtUser`, `tUser_tRoles_idtRoles`) ,
  INDEX `fk_tQuestion_tUser1` (`tUser_idtUser` ASC, `tUser_tRoles_idtRoles` ASC) ,
  CONSTRAINT `fk_tQuestion_tUser1`
    FOREIGN KEY (`tUser_idtUser` , `tUser_tRoles_idtRoles` )
    REFERENCES `mydb`.`tUser` (`idtUser` , `tRoles_idtRoles` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tForm_has_tQuestion`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tForm_has_tQuestion` (
  `tForm_idtForm` INT NOT NULL AUTO_INCREMENT ,
  `tQuestion_idtQuestion` INT NOT NULL ,
  PRIMARY KEY (`tForm_idtForm`, `tQuestion_idtQuestion`) ,
  INDEX `fk_tForm_has_tQuestion_tQuestion1` (`tQuestion_idtQuestion` ASC) ,
  CONSTRAINT `fk_tForm_has_tQuestion_tForm1`
    FOREIGN KEY (`tForm_idtForm` )
    REFERENCES `mydb`.`tForm` (`idtForm` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tForm_has_tQuestion_tQuestion1`
    FOREIGN KEY (`tQuestion_idtQuestion` )
    REFERENCES `mydb`.`tQuestion` (`idtQuestion` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tUser_has_tForm`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tUser_has_tForm` (
  `tUser_idtUser` INT NOT NULL ,
  `tForm_idtForm` INT NOT NULL ,
  PRIMARY KEY (`tUser_idtUser`, `tForm_idtForm`) ,
  INDEX `fk_tUser_has_tForm_tForm1` (`tForm_idtForm` ASC) ,
  CONSTRAINT `fk_tUser_has_tForm_tUser1`
    FOREIGN KEY (`tUser_idtUser` )
    REFERENCES `mydb`.`tUser` (`idtUser` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tUser_has_tForm_tForm1`
    FOREIGN KEY (`tForm_idtForm` )
    REFERENCES `mydb`.`tForm` (`idtForm` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tChoice`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tChoice` (
  `idtChoice` INT NOT NULL AUTO_INCREMENT ,
  `choiceText` TEXT NOT NULL ,
  PRIMARY KEY (`idtChoice`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tQuestion_has_tChoice`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tQuestion_has_tChoice` (
  `tQuestion_idtQuestion` INT NOT NULL ,
  `tChoice_idtChoice` INT NOT NULL ,
  PRIMARY KEY (`tQuestion_idtQuestion`, `tChoice_idtChoice`) ,
  INDEX `fk_tQuestion_has_tChoice_tChoice1` (`tChoice_idtChoice` ASC) ,
  CONSTRAINT `fk_tQuestion_has_tChoice_tQuestion1`
    FOREIGN KEY (`tQuestion_idtQuestion` )
    REFERENCES `mydb`.`tQuestion` (`idtQuestion` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tQuestion_has_tChoice_tChoice1`
    FOREIGN KEY (`tChoice_idtChoice` )
    REFERENCES `mydb`.`tChoice` (`idtChoice` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tResearch`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tResearch` (
  `idtResearch` INT NOT NULL AUTO_INCREMENT ,
  `className` VARCHAR(50) NOT NULL ,
  `year` YEAR NOT NULL ,
  `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ,
  `password` VARCHAR(45) NOT NULL ,
  `tForm_idtForm` INT NOT NULL ,
  `tUser_idtUser` INT NOT NULL ,
  PRIMARY KEY (`idtResearch`, `tForm_idtForm`, `tUser_idtUser`) ,
  INDEX `fk_tResearch_tForm1` (`tForm_idtForm` ASC) ,
  INDEX `fk_tResearch_tUser1` (`tUser_idtUser` ASC) ,
  CONSTRAINT `fk_tResearch_tForm1`
    FOREIGN KEY (`tForm_idtForm` )
    REFERENCES `mydb`.`tForm` (`idtForm` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tResearch_tUser1`
    FOREIGN KEY (`tUser_idtUser` )
    REFERENCES `mydb`.`tUser` (`idtUser` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tStudent`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tStudent` (
  `idtStudent` INT NOT NULL AUTO_INCREMENT ,
  `tResearch_idtResearch` INT NOT NULL ,
  PRIMARY KEY (`idtStudent`, `tResearch_idtResearch`) ,
  INDEX `fk_tStudent_tResearch1` (`tResearch_idtResearch` ASC) ,
  CONSTRAINT `fk_tStudent_tResearch1`
    FOREIGN KEY (`tResearch_idtResearch` )
    REFERENCES `mydb`.`tResearch` (`idtResearch` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tAnswer`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`tAnswer` (
  `idtAnswer` INT NOT NULL AUTO_INCREMENT ,
  `answerText` TEXT NOT NULL ,
  `tStudent_idtStudent` INT NOT NULL ,
  `tQuestion_idtQuestion` INT NOT NULL ,
  PRIMARY KEY (`idtAnswer`, `tStudent_idtStudent`, `tQuestion_idtQuestion`) ,
  INDEX `fk_tAnswer_tStudent1` (`tStudent_idtStudent` ASC) ,
  INDEX `fk_tAnswer_tQuestion1` (`tQuestion_idtQuestion` ASC) ,
  CONSTRAINT `fk_tAnswer_tStudent1`
    FOREIGN KEY (`tStudent_idtStudent` )
    REFERENCES `mydb`.`tStudent` (`idtStudent` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tAnswer_tQuestion1`
    FOREIGN KEY (`tQuestion_idtQuestion` )
    REFERENCES `mydb`.`tQuestion` (`idtQuestion` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;



SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

[Joe carco]

from what I gather is that tResearch has a composite primary key and your only referencing a part of it in the foreign key in tStudent.
Try referencing the entire composite key of tResearch in your foreign key in tStudent

[Sven Beckmann]

Hey,

but there are no composite keys in tReseach, just simple foreign key constraints.

[Joe carco]

are you sure? check your sql code, youre using composite PK's in almost all of youre tables:

 PRIMARY KEY (`idtResearch`, `tForm_idtForm`, `tUser_idtUser`) ,

(line 155)

some of the primary keys in your tables ARE foreign keys