title: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
body: <p>I have two table Student and Address.I am using hibernate 3 annotation for here.</p>
  
  <h1>My Student class</h1>
  
  <pre><code>package net.viralpatel.contact.form;
  
  import javax.persistence.CascadeType;
  import javax.persistence.Column;
  import javax.persistence.Entity;
  import javax.persistence.GeneratedValue;
  import javax.persistence.Id;
  import javax.persistence.ManyToOne;
  import javax.persistence.Table;
  
  @Entity
  @Table(name = "STUDENT")
  public class Student {
  
      private long studentId;
      private String studentName;
      private Address studentAddress;
  
      public Student() {
      }
  
      public Student(String studentName, Address studentAddress) {
          this.studentName = studentName;
          this.studentAddress = studentAddress;
      }
  
      @Id
      @GeneratedValue
      @Column(name = "STUDENT_ID")
      public long getStudentId() {
          return this.studentId;
      }
  
      public void setStudentId(long studentId) {
          this.studentId = studentId;
      }
  
      @Column(name = "STUDENT_NAME", nullable = false, length = 100)
      public String getStudentName() {
          return this.studentName;
      }
  
      public void setStudentName(String studentName) {
          this.studentName = studentName;
      }
  
      @ManyToOne(cascade = CascadeType.ALL)
      public Address getStudentAddress() {
          return this.studentAddress;
      }
  
      public void setStudentAddress(Address studentAddress) {
          this.studentAddress = studentAddress;
      }
  
  }
  </code></pre>
  
  <h1>Address class</h1>
  
  <pre><code>import javax.persistence.Column;
  import javax.persistence.Entity;
  import javax.persistence.GeneratedValue;
  import javax.persistence.Id;
  import javax.persistence.Table;
  
  @Entity
  @Table(name = "ADDRESS")
  public class Address {
  
      private long addressId;
      private String street;
      private String city;
      private String state;
      private String zipcode;
  
      public Address() {
      }
  
      public Address(String street, String city, String state, String zipcode) {
          this.street = street;
          this.city = city;
          this.state = state;
          this.zipcode = zipcode;
      }
  
      @Id
      @GeneratedValue
      @Column(name = "ADDRESS_ID")
      public long getAddressId() {
          return this.addressId;
      }
  
      public void setAddressId(long addressId) {
          this.addressId = addressId;
      }
  
      @Column(name = "ADDRESS_STREET", nullable = false, length=250)
      public String getStreet() {
          return this.street;
      }
  
      public void setStreet(String street) {
          this.street = street;
      }
  
      @Column(name = "ADDRESS_CITY", nullable = false, length=50)
      public String getCity() {
          return this.city;
      }
  
      public void setCity(String city) {
          this.city = city;
      }
  
      @Column(name = "ADDRESS_STATE", nullable = false, length=50)
      public String getState() {
          return this.state;
      }
  
      public void setState(String state) {
          this.state = state;
      }
  
      @Column(name = "ADDRESS_ZIPCODE", nullable = false, length=10)
      public String getZipcode() {
          return this.zipcode;
      }
  
      public void setZipcode(String zipcode) {
          this.zipcode = zipcode;
      }
  
  }
  </code></pre>
  
  <h1>Hibernate Config File</h1>
  
  <pre><code>&lt;?xml version='1.0' encoding='utf-8'?&gt;
  &lt;!DOCTYPE hibernate-configuration PUBLIC
      "-//Hibernate/Hibernate Configuration DTD//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"&gt;
  
  
  &lt;hibernate-configuration&gt;
      &lt;session-factory&gt;
          &lt;mapping class="net.viralpatel.contact.form.Contact" /&gt;
          &lt;mapping class="net.viralpatel.contact.form.Student" /&gt;
          &lt;mapping class="net.viralpatel.contact.form.Address" /&gt;
      &lt;/session-factory&gt;
  
  &lt;/hibernate-configuration&gt;
  </code></pre>
  
  <h1>I got the error</h1>
  
  <p>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'student0_.studentAddress_ADDRESS_ID' in 'field list'</p>
  
  <p>Anybody know what is the exact issue</p>
  
  <p>help is highly appreciated,
  Thanks,
  Shihab.</p>