Product Version = NetBeans IDE 6.9 RC2 (Build 201005312001)
Operating System = Windows 7 version 6.1 running on x86
Java; VM; Vendor = 1.6.0_17
Runtime = Java HotSpot(TM) Client VM 14.3-b01


The wizard (Create Entity From Database) is not working properly. 

Consider this data model ( MYSQL )  that has 3 tables. The parent table is named LIB, which has 2 child tables LIB_NODE and LIB_SCOPE

CREATE  TABLE  `XXX`.`LIB` (
  `LIB_ID` CHAR(32) NOT NULL ,
  `OBJ_ID` CHAR(32) NOT NULL ,
  PRIMARY KEY (`LIB_ID`) ,
  INDEX `FK_LIB_OBJ_ID` (`OBJ_ID` ASC) ,
  CONSTRAINT `FK_LIB_OBJ_ID`
    FOREIGN KEY (`OBJ_ID` )
    REFERENCES `XXX`.`OBJ` (`OBJ_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB


CREATE  TABLE  `XXX`.`LIB_NODE` (
  `LIB_NODE_ID` CHAR(32) NOT NULL ,
  `LIB_ID` CHAR(32) NOT NULL ,
  `PARENT_LIB_NODE_ID` CHAR(32) NULL ,
  `LABEL` VARCHAR(40) NOT NULL ,
  `STATUS` VARCHAR(1) NOT NULL ,
  `CREATED_BY` CHAR(32) NOT NULL ,
  `MODIFIED_BY` CHAR(32) NOT NULL ,
  `DTTM_CREATED` TIMESTAMP NOT NULL ,
  `DTTM_MODIFIED` TIMESTAMP NOT NULL ,
  PRIMARY KEY (`LIB_NODE_ID`) ,
  INDEX `FK_LIB_NODE_LIB_ID` (`LIB_ID` ASC) ,
  INDEX `FK_LIB_NODE_PARENT_LIB_NODE_ID` (`PARENT_LIB_NODE_ID` ASC) ,
  CONSTRAINT `FK_LIB_NODE_LIB_ID`
    FOREIGN KEY (`LIB_ID` )
    REFERENCES `XXX`.`LIB` (`LIB_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_LIB_NODE_PARENT_LIB_NODE_ID`
    FOREIGN KEY (`PARENT_LIB_NODE_ID` )
    REFERENCES `XXX`.`LIB` (`LIB_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

CREATE  TABLE  `XXX`.`LIB_SCOPE` (
  `LIB_SCOPE_ID` CHAR(32) NOT NULL ,
  `LIB_ID` CHAR(32) NOT NULL ,
  `OBJ_TYPE_ID` CHAR(32) NOT NULL ,
  `USE_FLAG` VARCHAR(1) NOT NULL ,
  `CREATE_FLAG` VARCHAR(1) NOT NULL ,
  `STATUS` VARCHAR(1) NOT NULL ,
  `CREATED_BY` CHAR(32) NOT NULL ,
  `MODIFIED_BY` CHAR(32) NOT NULL ,
  `DTTM_CREATED` TIMESTAMP NOT NULL ,
  `DTTM_MODIFIED` TIMESTAMP NOT NULL ,
  PRIMARY KEY (`LIB_SCOPE_ID`) ,
  INDEX `FK_LIB_SCOPE_LIB_ID` (`LIB_ID` ASC) ,
  INDEX `FK_LIB_SCOPE_OBJ_TYPE_ID` (`OBJ_TYPE_ID` ASC) ,
  CONSTRAINT `FK_LIB_SCOPE_LIB_ID`
    FOREIGN KEY (`LIB_ID` )
    REFERENCES `XXX`.`LIB` (`LIB_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_LIB_SCOPE_OBJ_TYPE_ID`
    FOREIGN KEY (`OBJ_TYPE_ID` )
    REFERENCES `XXX`.`OBJ_TYPE` (`OBJ_TYPE_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB


 For instance, for LIB, here are two issues:

a) missing foreign key reppresentaiton in the model ( LIB.OBJ_ID is missing ) 
b) duplicate child collection reppresentation for LibNode : see libNodeCollection and libNodeCollection1

MODEL = Lib ( table LIB )

    @Id
    @Basic(optional = false)
    @Column(name = "LIB_ID")
    private String libId;
   <===  here it is missing the objID ( OBJ_ID ) column reference, which is a foreign key
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "lib")
    private Collection<LibScope> libScopeCollection;
    @OneToMany(mappedBy = "lib")
    private Collection<LibNode> libNodeCollection;
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "lib1")
    private Collection<LibNode> libNodeCollection1;                    <== there is only one child table ( LIB_NODE ) therefore this is duplicate