Unable to create a table in hibernate using OneToMany and ManyToOne relationship(also unable to create Foreign Key)

huangapple
go评论109阅读模式
英文:

Unable to create a table in hibernate using OneToMany and ManyToOne relationship(also unable to create Foreign Key)

问题

这里的代码主要用于确定OneToMany和ManyToOne的关系。我使用Spring Tool Suite 3.9.11与XAMPP以及Apache 7.5作为服务器。

以下是第一个文件/表customer.java的代码部分：

  1. @Entity
  2. @Table(name = "Customer")
  3. public class Customer {
  5. 	@Id
  6. 	@GeneratedValue(strategy = GenerationType.IDENTITY)
  7. 	private int cid;
  9. 	private String cname;
  10. 	private int ccontact;
  11. 	private String cemail;
  12. 	private String cpassword;
  14. 	@OneToMany(mappedBy = "customer")
  15. 	private List<OrderF> order;
  17. 	// 省略了其他方法和构造函数
  18. }

以下是第二个文件/表OrderF.java的代码部分：

  1. @Entity
  2. @Table(name="Order")
  3. public class OrderF {
  5. 	@Id
  6. 	@GeneratedValue(strategy = GenerationType.IDENTITY)
  7. 	private int food_id;
  8. 	private String foodName;
  10. 	@ManyToOne(cascade = CascadeType.PERSIST)
  11. 	@JoinColumn(name = "cid")
  12. 	private Customer customer;
  14. 	// 省略了其他方法和构造函数
  15. }

这是你的main.java的代码部分：

  1. public static void main(String[] args) {
  2. 	Customer c = new Customer();
  3. 	c.setCid(1);
  4. 	OrderF o = new OrderF();
  5. 	o.setCustomer(c);
  6. 	o.setFood_id(1);
  7. 	o.setFoodName("Java");
  8. 	
  9. 	SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
  10. 	Session session = sessionFactory.openSession();
  11. 	session.beginTransaction();
  12. 	session.save(o);
  13. 	session.getTransaction().commit();
  14. 	session.close();
  15. }

这是你的hibernate配置文件hibernate.cfg.xml的代码部分：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE hibernate-configuration PUBLIC
  3. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  4. "http://hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  6. <hibernate-configuration>
  7. 	<session-factory>
  8. 		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  9. 		<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/spring</property>
  10. 		<property name="hibernate.connection.username">root</property>
  11. 		<property name="hibernate.connection.password"></property>	
  12. 		<property name="hibernate.show_sql">true</property>
  13. 		<property name="hbm2ddl.auto">create</property>
  14. 		<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
  15. 		
  16. 		<mapping class="com.bean.Customer"></mapping>
  17. 		<mapping class="com.bean.OrderF"></mapping>
  18. 	</session-factory>
  19. </hibernate-configuration>

这是你的控制台/错误日志部分。

英文:

This code here is simply used to determine the relation of OnetoMany and ManyToOne, I use Spring Tool suite 3.9.11 with XAMPP and Server as apache 7.5

This is first file/table customer.java

  1. package com.bean;
  3. import java.util.List;
  5. import javax.persistence.CascadeType;
  7. import javax.persistence.Entity;
  9. import javax.persistence.GeneratedValue;
  10. import javax.persistence.GenerationType;
  11. import javax.persistence.Id;
  12. import javax.persistence.JoinColumn;
  13. import javax.persistence.ManyToOne;
  14. import javax.persistence.OneToMany;
  15. import javax.persistence.Table;
  18. @Entity
  19. @Table(name = &quot;Customer&quot;)
  20. public class Customer {
  22. 	@Id
  23. 	@GeneratedValue(strategy = GenerationType.IDENTITY)
  24. 	private int cid;
  26. 	private String cname;
  27. 	private int ccontact;
  28. 	private String cemail;
  29. 	private String cpassword;
  31. 	@OneToMany(mappedBy = &quot;customer&quot;)
  32. 	private List&lt;OrderF&gt; order;
  34. 	public List&lt;OrderF&gt; getOrder() {
  35. 		return order;
  36. 	}
  38. 	public void setOrder(List&lt;OrderF&gt; order) {
  39. 		this.order = order;
  40. 	}
  42. 	public Customer() {
  43. 		super();
  44. 	}
  46. 	public int getCid() {
  47. 		return cid;
  48. 	}
  50. 	public void setCid(int cid) {
  51. 		this.cid = cid;
  52. 	}
  54. 	public String getCname() {
  55. 		return cname;
  56. 	}
  58. 	public void setCname(String cname) {
  59. 		this.cname = cname;
  60. 	}
  62. 	public int getCcontact() {
  63. 		return ccontact;
  64. 	}
  66. 	public void setCcontact(int ccontact) {
  67. 		this.ccontact = ccontact;
  68. 	}
  70. 	public String getCemail() {
  71. 		return cemail;
  72. 	}
  74. 	public void setCemail(String cemail) {
  75. 		this.cemail = cemail;
  76. 	}
  78. 	public String getCpassword() {
  79. 		return cpassword;
  80. 	}
  82. 	public void setCpassword(String cpassword) {
  83. 		this.cpassword = cpassword;
  84. 	}
  86. }

This is my second file/table OrderF.java

  1. package com.bean;
  3. import javax.persistence.CascadeType;
  4. import javax.persistence.Entity;
  5. import javax.persistence.GeneratedValue;
  6. import javax.persistence.GenerationType;
  7. import javax.persistence.Id;
  8. import javax.persistence.JoinColumn;
  9. import javax.persistence.ManyToOne;
  10. import javax.persistence.Table;
  12. @Entity
  13. @Table(name=&quot;Order&quot;)
  14. public class OrderF {
  16. 	@Id
  17. 	@GeneratedValue(strategy = GenerationType.IDENTITY)
  18. 	private int food_id;
  19. 	private String foodName;
  20. 	@ManyToOne(cascade = CascadeType.PERSIST)
  21. 	@JoinColumn(name = &quot;cid&quot;)
  22. 	private Customer customer;
  24. 	public int getFood_id() {
  25. 		return food_id;
  26. 	}
  28. 	public void setFood_id(int food_id) {
  29. 		this.food_id = food_id;
  30. 	}
  32. 	public String getFoodName() {
  33. 		return foodName;
  34. 	}
  36. 	public void setFoodName(String foodName) {
  37. 		this.foodName = foodName;
  38. 	}
  40. public Customer getCustomer() {
  41. 	return customer;
  42. 	}
  44. 	public void setCustomer(Customer customer) {
  45. 		this.customer = customer;
  46. 	}
  48. }

This is my main.java

  1. package com.bean;
  3. import org.hibernate.Session;
  4. import org.hibernate.SessionFactory;
  5. import org.hibernate.cfg.Configuration;
  7. public class MainClass {
  9. 	public static void main(String[] args) {
  10. 		Customer c=new Customer();
  11. 		c.setCid(1);
  12. 		OrderF  o=new OrderF();
  13. 		o.setCustomer(c);
  14. 		o.setFood_id(1);
  15. 		o.setFoodName(&quot;Java&quot;);
  16. 		
  17. 		SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
  18. 		Session session=sessionFactory.openSession();
  19. 		session.beginTransaction();
  20. 		session.save(o);
  21. 		session.getTransaction().commit();
  22. 		session.close();
  23. 	}
  25. }

This is hibernate Configuration file hibernate.cfg.xml

  1. &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
  2. &lt;!DOCTYPE hibernate-configuration PUBLIC
  3. &quot;-//Hibernate/Hibernate Configuration DTD 3.0//EN&quot;
  4. &quot;http://hibernate.org/dtd/hibernate-configuration-3.0.dtd&quot;&gt;
  6. &lt;hibernate-configuration&gt;
  7. 	&lt;session-factory&gt;
  8. 	&lt;property name=&quot;hibernate.connection.driver_class&quot;&gt;com.mysql.jdbc.Driver&lt;/property&gt;
  9. 	&lt;property name=&quot;hibernate.connection.url&quot;&gt;jdbc:mysql://localhost:3306/spring&lt;/property&gt;
  10. 	&lt;property name=&quot;hibernate.connection.username&quot;&gt;root&lt;/property&gt;
  11. 	&lt;property name=&quot;hibernate.connection.password&quot;&gt;&lt;/property&gt;	
  12. 	&lt;property name=&quot;hibernate.show_sql&quot;&gt;true&lt;/property&gt;
  13. 	&lt;property name=&quot;hbm2ddl.auto&quot;&gt;create&lt;/property&gt;
  14. 	&lt;property name=&quot;hibernate.dialect&quot;&gt;org.hibernate.dialect.MySQL5Dialect&lt;/property&gt;
  15. 	
  16. 	&lt;mapping class=&quot;com.bean.Customer&quot;&gt;&lt;/mapping&gt;
  17. 	&lt;mapping class=&quot;com.bean.OrderF&quot;&gt;&lt;/mapping&gt;
  18. 	&lt;/session-factory&gt;
  19. 	
  21. &lt;/hibernate-configuration&gt;

This is my Console/Error Log:

  1. version for the right syntax to use near &#39;Order drop foreign key FKk8oprs3d23xg7tjw95wxaft8l&#39; at line 1
  2. Hibernate: drop table if exists Customer
  3. Hibernate: drop table if exists Order
  4. Aug 14, 2020 12:04:34 PM org.hibernate.tool.hbm2ddl.SchemaExport perform
  5. ERROR: HHH000389: Unsuccessful: drop table if exists Order
  6. Hibernate: create table Customer (cid integer not null auto_increment, ccontact integer not null, cemail varchar(255), cname varchar(255), cpassword varchar(255), primary key (cid))
  7. Aug 14, 2020 12:04:34 PM org.hibernate.tool.hbm2ddl.SchemaExport perform
  8. ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#39;Order&#39; at line 1
  9. Hibernate: create table Order (food_id integer not null auto_increment, foodName varchar(255), cid integer, primary key (food_id))
  10. Aug 14, 2020 12:04:35 PM org.hibernate.tool.hbm2ddl.SchemaExport perform
  11. ERROR: HHH000389: Unsuccessful: create table Order (food_id integer not null auto_increment, foodName varchar(255), cid integer, primary key (food_id))
  12. Hibernate: alter table Order add constraint FKk8oprs3d23xg7tjw95wxaft8l foreign key (cid) references Customer (cid)
  13. Aug 14, 2020 12:04:35 PM org.hibernate.tool.hbm2ddl.SchemaExport perform
  14. ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#39;Order (food_id integer not null auto_increment, foodName varchar(255), cid integ&#39; at line 1
  15. Aug 14, 2020 12:04:35 PM org.hibernate.tool.hbm2ddl.SchemaExport perform
  16. ERROR: HHH000389: Unsuccessful: alter table Order add constraint FKk8oprs3d23xg7tjw95wxaft8l foreign key (cid) references Customer (cid)
  17. Aug 14, 2020 12:04:35 PM org.hibernate.tool.hbm2ddl.SchemaExport perform
  18. ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#39;Order add constraint FKk8oprs3d23xg7tjw95wxaft8l foreign key (cid) references Cu&#39; at line 1
  19. Aug 14, 2020 12:04:35 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
  20. INFO: HHH000230: Schema export complete
  21. Hibernate: insert into Order (cid, foodName) values (?, ?)
  22. Aug 14, 2020 12:04:35 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
  23. WARN: SQL Error: 1064, SQLState: 42000
  24. Aug 14, 2020 12:04:35 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
  25. ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#39;Order (cid, foodName) values (1, &#39;Java&#39;)&#39; at line 1
  26. Exception in thread &quot;main&quot; org.hibernate.exception.SQLGrammarException: could not execute statement
  27. 	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
  28. 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  29. 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
  30. 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
  31. 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
  32. 	at org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
  33. 	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
  34. 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2792)
  35. 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3363)
  36. 	at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
  37. 	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:597)
  38. 	at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:232)
  39. 	at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:213)
  40. 	at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:256)
  41. 	at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:317)
  42. 	at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:272)
  43. 	at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:178)
  44. 	at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:109)
  45. 	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
  46. 	at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
  47. 	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
  48. 	at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
  49. 	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
  50. 	at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:679)

答案1

得分: 0

您的Order实体的表名是SQL引擎中的保留字，尝试重新命名表名。

  1. @Entity
  2. @Table(name="OrderF")
  3. public class OrderF {...}
英文:

Your Order entity's table name is a reserved word in the SQL engine, try renaming the table's name

  1. @Entity
  2. @Table(name=&quot;OrderF &quot;)
  3. public class OrderF {...}

答案2

得分: 0

作为重命名的替代方法，您可以使用SQL带引号的标识符:

  1. @Entity
  2. @Table(name="`Order`")
  3. public class OrderF {
  4.   // ...
  5. }
英文:

As an alternative to renaming you can use SQL quoted identifiers:

  1. @Entity
  2. @Table(name=&quot;`Order`&quot;)
  3. public class OrderF {
  4.   // ...
  5. }

huangapple
  • 本文由 发表于 2020年8月14日 14:46:15
  • 转载请务必保留本文链接：https://go.coder-hub.com/63407833.html
  • hibernate
  • hibernate-onetomany
  • java
  • many-to-one
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定