Hibernate many-to-many mappings for the third table Manytomany "XML and Annotations" instance (17)

1 This method is quite good "the original many-to-many failure is because the third table mapping has not been caused by"

Package Com.sm.hibernate.pojo;

Import Java.util.Set;

public class Iuser {

	private int id;
	private String name;
	Private ICard ICard;
	Private I2card I2card;
	Private set<icourse> courses;

	Public set<icourse> getcourses () {
		return courses;
	}
	public void setcourses (set<icourse> courses) {
		this.courses = courses;
	}
	Public I2card Geti2card () {
		return i2card;
	}
	public void Seti2card (I2card i2card) {
		this.i2card = I2card;
	}
	public int getId () {
		return ID;
	}
	public void setId (int id) {
		this.id = ID;
	}
	Public String GetName () {
		return name;
	}
	public void SetName (String name) {
		this.name = name;
	}
	Public ICard Geticard () {
		return ICard;
	}
	public void Seticard (ICard ICard) {
		this.icard = ICard;
	}
	
}

<?xml version= "1.0"?>
<! DOCTYPE hibernate-mapping public
        "-//hibernate/hibernate mapping DTD 3.0//en"
        "http// Hibernate.sourceforge.net/hibernate-mapping-3.0.dtd ">

 

 
Package Com.sm.hibernate.pojo;

Import Java.util.Set;

public class Icourse {

	private int id;
	private String name;
	Private set<iuser> iusers;
	public int getId () {
		return ID;
	}
	public void setId (int id) {
		this.id = ID;
	}
	Public String GetName () {
		return name;
	}
	public void SetName (String name) {
		this.name = name;
	}
	Public set<iuser> Getiuser () {
		return iusers;
	}
	public void Setiuser (set<iuser> iuser) {
		this.iusers = Iuser;
	}

	
}
 

 
<?xml version= "1.0"?>
<! DOCTYPE hibernate-mapping public
        "-//hibernate/hibernate mapping DTD 3.0//en"
        "http// Hibernate.sourceforge.net/hibernate-mapping-3.0.dtd ">

 

3 results


September 27, 2013 10:11:44 am org.hibernate.annotations.common.Version <clinit> INFO:HCANN000001:Hibernate Commons Anno tations {4.0.1.Final} September 27, 2013 10:11:44 am org.hibernate.Version logversion INFO:HHH000412:Hibernate Core {4.1.1} borlnd 27, 2013 10:11:44 am org.hibernate.cfg.Environment <clinit> INFO:HHH000206:hibernate.properties not found September 27, 2  013 10:11:44 am org.hibernate.cfg.Environment buildbytecodeprovider INFO:HHH000021:Bytecode provider Name:javassist September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration Configure INFO:HHH000043:Configuring from resource:/hibernate.cfg . XML September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration getconfigurationinputstream INFO:HHH000040:Configuration R
Esource:/hibernate.cfg.xml September 27, 2013 10:11:44 am org.hibernate.internal.util.xml.DTDEntityResolver resolveentity WARN:HHH000223:Recognized obsolete Hibernate namespace http://hibernate.sourceforge.net/. Use namespace Http://www.hibernate.org/dtd/instead. Refer toHibernate 3.6 Migration guide! September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration addResource INFO:HHH000221:Reading mappings from resource:com/s
M/hibernate/pojo/book.hbm.xml September 27, 2013 10:11:44 am org.hibernate.internal.util.xml.DTDEntityResolver resolveentity WARN:HHH000223:Recognized obsolete Hibernate namespace http://hibernate.sourceforge.net/. Use namespace Http://www.hibernate.org/dtd/instead.
Refer to Hibernate 3.6 migration guide! September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration addResource INFO:HHH000221:Reading mappings from resource:com/s M/hibernate/pojo/iuser.hbm.xml September 27, 2013 10:11:44 am Org.hibernate.internal.util.xml.DTDEntityResolver ResolveEntity WARN:HHH000223:Recognized obsolete Hibernate namespace http://hibernate.sourceforge.net/. Use namespace Http://www.hibernate.org/dtd/instead.
Refer to Hibernate 3.6 migration guide! September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration addResource INFO:HHH000221:Reading mappings from Resource:cOm/sm/hibernate/pojo/icard.hbm.xml September 27, 2013 10:11:44 am Org.hibernate.internal.util.xml.DTDEntityResolver ResolveEntity WARN:HHH000223:Recognized obsolete Hibernate namespace http://hibernate.sourceforge.net/. Use namespace Http://www.hibernate.org/dtd/instead.
Refer to Hibernate 3.6 migration guide! September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration addResource INFO:HHH000221:Reading mappings from resource:com/s M/hibernate/pojo/i2card.hbm.xml September 27, 2013 10:11:44 am Org.hibernate.internal.util.xml.DTDEntityResolver ResolveEntity WARN:HHH000223:Recognized obsolete Hibernate namespace http://hibernate.sourceforge.net/. Use namespace Http://www.hibernate.org/dtd/instead.
Refer to Hibernate 3.6 migration guide! September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration addResource INFO:HHH000221:Reading mappings from resource:com/s M/hibernate/pojo/icourse.hbm.xml September 27, 2013 10:11:44 am Org.hibernate.internal.util.xml.DTDEntityResolver ResolveEntity WARN:HHH000223:RECOGNized obsolete Hibernate namespace http://hibernate.sourceforge.net/. Use namespace Http://www.hibernate.org/dtd/instead.
Refer to Hibernate 3.6 migration guide! September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration addResource INFO:HHH000221:Reading mappings from resource:com/s M/hibernate/pojo/category.hbm.xml September 27, 2013 10:11:44 am Org.hibernate.internal.util.xml.DTDEntityResolver ResolveEntity WARN:HHH000223:Recognized obsolete Hibernate namespace http://hibernate.sourceforge.net/. Use namespace Http://www.hibernate.org/dtd/instead.
Refer to Hibernate 3.6 migration guide! September 27, 2013 10:11:44 am org.hibernate.cfg.Configuration doconfigure INFO:HHH000041:Configured sessionfactory:null September 27 , 2013 10:11:45 Org.hibernate.dialect.Dialect <init> INFO:HHH000400:Using dialect: Org.hibernate.dialect.MySQLDialect September 27, 2013 10:11:45 am Org.hibernate.tool.hbm2ddl.SchemaExport execute INFO: Hhh000227:running HBM2DDL Schema Export September 27, 2013 10:11:45 am org.hibernate.Service.jdbc.connections.internal.DriverManagerConnectionProviderImpl Configure INFO:HHH000402:Using Hibernate Built-in connection pool (not for production use!) September 27, 2013 10:11:45 am org.hibernate.service.jdbc.connections.internal . Drivermanagerconnectionproviderimpl Configure INFO:HHH000115:Hibernate Connection pool size:20 September 27, 2013 10:11:45 a.m. Org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl Configure info:hhh000006: Autocommit Mode:false September 27, 2013 10:11:45 am Org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl Configure info:hhh000401: Using driver [Com.mysql.jdbc.Driver] at URL [Jdbc:mysql://localhost:3306/wanju] September 27, 2013 10:11:45 am Org.hibernate.ser Vice.jdbc.connections.internal.DriverManagerConnectionProviderImpl Configure INFO:HHH000046:Connection Properties : {user=root, password=****} ALTER TABLE book drop FOREIGN key fk2e3ae949f733e ALTER TABLE ICA RD DROP FOREIGN key fk5f61ef9dffcd6a8 ALTER TABLE IUC drop FOREIGN key fk198b735a1d52c September 27, 20 13 10:11:45 am org.hibernate.tool.hbm2ddl.SchemaExport perform ERROR:HHH000389:Unsuccessful:alter table Iuc drop Foreig N Key fk198b735a1d52c ALTER TABLE IUC drop FOREIGN key fk198b76096495c September 27, 2013 10:11:45 am org. Hibernate.tool.hbm2ddl.SchemaExport perform error:table ' Wanju.iuc ' doesn ' t exist September 27, 2013 10:11:45 am ORG.HIBERNATE.T Ool.hbm2ddl.SchemaExport perform ERROR:HHH000389:Unsuccessful:alter table Iuc drop foreign key fk198b76096495c September 27, 2 013 10:11:45 am Org.hibernate.tool.hbm2ddl.SchemaExport perform error:table ' Wanju.iuc ' doesn ' t exist alter Table IU C Drop FOREIGN Key fk198b76f252f3c September 27, 2013 10:11:45 am Org.hibernate.tool.hbm2ddl.SchemaExport PERFO RM ERROR:HHH000389:Unsuccessful:alter Table IUC drop foreign key fk198b76f252f3c September 27, 2013 10:11:45 am org.hibernate. Tool.hbm2ddl.SchemaExporT perform error:table ' Wanju.iuc ' doesn ' t exist alter Table iuser drop FOREIGN key fk5fe8fb4d3b53c drop table if exists book drop table if exists category drop table if exists i2card drop table if E Xists icard drop table if exists icourse drop table if exists iuc drop table if exists Iuser create Ta BLE book (ID integer NOT NULL auto_increment, name varchar ($) NOT NULL, author varchar NULL, categoryId Integer, primary key (ID)) CREATE TABLE category (ID integer NOT NULL Auto_increment, Name varchar ($) NOT NULL, PRIMARY key (ID)) CREATE TABLE I2card (ID I  Nteger NOT NULL auto_increment, name varchar (255) NOT NULL, PRIMARY key (ID)) CREATE TABLE Icard (ID integer NOT NULL, name varchar (255) is not NULL, PRIMARY key (ID)) CREATE TABLE Icour SE (ID integerNot NULL auto_increment, name varchar (255) is not NULL, PRIMARY key (ID)) CREATE TABLE Iuc (  Iuserid integer NOT NULL, Icourseid integer NOT NULL, primary key (Icourseid, Iuserid)) create Table Iuser (ID integer NOT NULL auto_increment, name varchar (255) is not NULL, I2card integer uniq UE, PRIMARY key (ID)) ALTER TABLE book add index fk2e3ae949f733e (categoryId), add con 
        Straint fk2e3ae949f733e foreign KEY (categoryId) references category (ID) ALTER TABLE Icard Add index fk5f61ef9dffcd6a8 (ID), add Constraint fk5f61ef9dffcd6a8 foreign key (ID) reference 
        s Iuser (ID) ALTER TABLE IUC Add index fk198b735a1d52c (iuserid), add constraint fk198b735a1d52c Foreign KEY (Iuserid) references Icourse (ID) ALTER TABLE IUC Add index fk198b76096495c (iUs Erid), add consTraint fk198b76096495c foreign KEY (Iuserid) references Iuser (ID) ALTER TABLE IUC Add IND Ex fk198b76f252f3c (Icourseid), add constraint fk198b76f252f3c foreign key (Icourseid) Referenc ES icourse (ID) ALTER TABLE iuser Add index fk5fe8fb4d3b53c79 (i2card), add constraint fk5fe8fb4d3b 53c79 foreign KEY (I2card) references I2card (ID) September 27, 2013 10:11:47 am Org.hibernate.service.jdbc.con Nections.internal.DriverManagerConnectionProviderImpl stop INFO:HHH000030:Cleaning up connection pool [jdbc:mysql:// Localhost:3306/wanju] September 27, 2013 10:11:47 am Org.hibernate.tool.hbm2ddl.SchemaExport EXECUTE INFO:HHH000230:Schema Exp ORT complete
 


The note version looks slightly simpler:


Package com.bjsxt.hibernate;
Import Java.util.HashSet;

Import Java.util.Set;
Import javax.persistence.Entity;
Import Javax.persistence.GeneratedValue;
Import Javax.persistence.Id;
Import Javax.persistence.JoinColumn;
Import javax.persistence.JoinTable;
Import Javax.persistence.ManyToMany;
Import Javax.persistence.OneToMany;

Import javax.persistence.Table;
	@Entity public class Teacher {private int id;
	private String name;
	Private set<student> students = new hashset<student> ();
	@Id @GeneratedValue public int getId () {return Id;
	} public void setId (int id) {this.id = ID;
	} public String GetName () {return name;
	} public void SetName (String name) {this.name = name; } @ManyToMany @JoinTable (name= "t_s", joincolumns={@JoinColumn (name= "teacher_id")}, inversejoincolumns={@JoinColumn
		(name= "student_id")}
	) public set<student> getstudents () {return students; } public void Setstudents (set<student> students) {this.students = StudenTs
 }
}
 

 
Package com.bjsxt.hibernate;

Import Java.util.HashSet;
Import Java.util.Set;

Import javax.persistence.Entity;
Import Javax.persistence.GeneratedValue;
Import Javax.persistence.Id;
Import Javax.persistence.ManyToMany;

@Entity public
class Student {
	private int id;
	private String name;
	Private set<teacher> teachers = new hashset<teacher> ();
	@ManyToMany (mappedby= "students") public
	set<teacher> getteachers () {
		return teachers;
	}
	public void Setteachers (set<teacher> teachers) {
		this.teachers = teachers;
	}
	@Id
	@GeneratedValue Public
	int getId () {
		return Id;
	}
	public void setId (int id) {
		this.id = ID;
	}
	Public String GetName () {
		return name;
	}
	public void SetName (String name) {
		this.name = name;
	}
}