title: SQL Error: 1064, SQLState: 42000 while creating new entity
body: <p>I am working on a Spring mvc web application in which I need to create a town using Hibernate. Following is my town model.</p>
  
  <pre><code>@Entity
  @Table(name="town")
  public class TownModel {
  
      @Id
      @Column(name="townid")
      @GeneratedValue 
      private Integer townId;
  
      @Column(name="name")
      private String townName;
  
      @Column(name="desc")
      private String townDesc;
  
      @ManyToOne(optional = true)
      @JoinColumn(name="districtid")
      private DistrictModel districtModel;
  }
  </code></pre>
  
  <p>I have another entity named district. Town is a part of district and a district can have multiple towns. Following is my district model:</p>
  
  <pre><code>@Entity
  @Table(name="district")
  public class DistrictModel {
  
      @Id
      @Column(name="districtid")
      @GeneratedValue
      private Integer districtId;
  
      @Column(name="name")
      private String name;
  
      @Column(name="desc")
      private String description;
  
      @OneToMany(mappedBy = "districtModel", fetch = FetchType.EAGER)
      @Fetch(value = FetchMode.SUBSELECT)
      private List&lt;TownModel&gt; townModelList;
  }
  </code></pre>
  
  <p>I am using following Hibernate code for saving town:</p>
  
  <pre><code>Session session = sessionFactory.getCurrentSession();
  session.save(townModel);
  </code></pre>
  
  <p>But it shows error:</p>
  
  <pre><code>21:22:08,104 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--127.0.0.1-9090-1) SQL Error: 1064, SQLState: 42000
  21:22:08,112 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--127.0.0.1-9090-1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, name) values (2, 'Test town desc.', 'Test town')' at line 1
  
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, name) values (2, 'Test town desc.', 'Test town')' at line 1
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_45]
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_45]
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_45]
      at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_45]
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077) ~[com.mysql.jdbc_5.1.5.jar:na]
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062) ~[com.mysql.jdbc_5.1.5.jar:na]
      at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) ~[na:na]
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) ~[hibernate-core-4.2.16.Final.jar:4.2.16.Final]
      ... 64 common frames omitted
  </code></pre>