I think that is what I used. Here are DDL,
1. table 2 which has two FK,
CREATE TABLE `user_role_fuel` (
`user_id` mediumint(8) NOT NULL,
`role_id` smallint(2) NOT NULL,
PRIMARY KEY (`user_id`,`role_id`),
KEY `role_id` (`role_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `user_role_fuel_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
CONSTRAINT `user_role_fuel_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `role_fuel` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
2. table 1
CREATE TABLE `user` (
`id` mediumint(8) NOT NULL auto_increment,
`username` char(10) NOT NULL,
`password` char(10) NOT NULL,
`password_hint` char(10) default NULL,
`first_name` char(5) NOT NULL,
`last_name` char(5) NOT NULL,
`address` char(20) default NULL,
`city` smallint(4) NOT NULL,
`county` smallint(3) NOT NULL,
`province` smallint(2) NOT NULL,
`postal_code` char(6) NOT NULL,
`email` char(20) NOT NULL,
`phone_number` char(15) default NULL,
`ip` char(15) NOT NULL,
`account_enabled` char(1) NOT NULL,
`account_locked` char(1) NOT NULL,
`last_update_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
3. table 3
CREATE TABLE `role_fuel` (
`id` smallint(2) NOT NULL auto_increment,
`name` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
After I ran following reveng.xml I still got one-to-many/many-to-one instead of many-to-many.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering SYSTEM "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd">
<!--!DOCTYPE hibernate-reverse-engineering SYSTEM "file:///C:/eclipse/workspace/appgen/hibernateTool.dtd"-->
<hibernate-reverse-engineering>
<schema-selection match-table="role_fuel"/>
<schema-selection match-table="user"/>
<schema-selection match-table="user_role_fuel"/>
<type-mapping>
<!-- jdbc-type is name fom java.sql.Types -->
<sql-type jdbc-type="DECIMAL" precision="10" scale="0" hibernate-type="Long"/>
<sql-type jdbc-type="CHAR" length="1" hibernate-type="yes_no"/>
<sql-type jdbc-type="DECIMAL" precision="1" scale="0" hibernate-type="yes_no"/>
<sql-type jdbc-type="DECIMAL" precision="19" scale="0" hibernate-type="Long"/>
<sql-type jdbc-type="DECIMAL" precision="5" scale="2" hibernate-type="Float"/>
</type-mapping>
<table name="user_role_fuel">
<primary-key>
<generator class="native"/>
</primary-key>
</table>
<table name="user">
<primary-key>
<generator class="native"/>
</primary-key>
</table>
<table name="role_fuel">
<primary-key>
<generator class="native"/>
</primary-key>
</table>
</hibernate-reverse-engineering>
Login
FAQ
Search
