SQLGrammarException

[Samanthi perera]

here is my config file

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/vanila</property>
    <property name="hibernate.connection.username">root</property>
    <property name="connection.pool_size">1</property>

    <mapping class="Student" />
    <mapping class="Address" />
  </session-factory>
</hibernate-configuration>

here is my main class

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;


public class Main {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
       SessionFactory sessions = new AnnotationConfiguration().configure().buildSessionFactory();
       Session session = sessions.openSession();

       try{
       session.beginTransaction();
      Address address = new Address("OMR Road", "Chennai", "TN", "600097");

      Student student1 = new Student("Eswar", address);
      Student student2 = new Student("Joe", address);
      session.save(student1);
      session.save(student2);

       session.getTransaction().commit();

       }catch(Exception e){
           e.printStackTrace();
       }
       finally{
           session.close();
       }
    }

}

here is student class

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;
    }
}

here is address class

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;
    }
}

here is exception

run:
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.3.1.GA
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: Student
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity Student on table STUDENT
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: Address
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity Address on table ADDRESS
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Jan 29, 2010 9:35:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
Jan 29, 2010 9:35:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
Jan 29, 2010 9:35:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
Jan 29, 2010 9:35:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/vanila
Jan 29, 2010 9:35:24 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root}
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.0.45-community-nt
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
Jan 29, 2010 9:35:24 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
Jan 29, 2010 9:35:24 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
Jan 29, 2010 9:35:24 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
Jan 29, 2010 9:35:24 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
Jan 29, 2010 9:35:24 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
Jan 29, 2010 9:35:25 PM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Jan 29, 2010 9:35:25 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Jan 29, 2010 9:35:25 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 1054, SQLState: 42S22
Jan 29, 2010 9:35:25 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Unknown column 'studentAddress_ADDRESS_ID' in 'field list'
org.hibernate.exception.SQLGrammarException: could not insert: [Student]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
        at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
        at Main.main(Main.java:23)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'studentAddress_ADDRESS_ID' in 'field list'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
        at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
        ... 16 more
BUILD SUCCESSFUL (total time: 1 second)

[Cameron Wallace McKenzie]

Grammar is usually a problem with the mapping.

Can you get an example to work that doesn't use an association? Maybe you should start with something a bit easier.

-Cameron McKenzie

[Samanthi perera]

I was able to run one to one example.
Also i was able to run many to one mapping without annotation.
This is with many to one mapping with annotation.
I need to study annotation also.
when i am running this example without annotation it works.
can you please tell me where is the error?

here is the site where is Refer

without annotation(Works withour error)
http://www.vaannila.com/hibernate/hibernate-example/hibernate-mapping-many-to-one-1.html

with annotation(still error)
http://www.vaannila.com/hibernate/hibernate-example/hibernate-mapping-many-to-one-using-annotations-1.html

[ishan dave]

hi,

@ManyToOne(cascade = CascadeType.ALL)
public Address getStudentAddress() {
return this.studentAddress;
}

please put the join column name like

@ManyToOne(cascade = CascadeType.ALL)
@JoinColumn(name="ADDRESS_ID")
public Address getStudentAddress() {
return this.studentAddress;
}

thank you,
ishaan

[Samanthi perera]

i change my student clas

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.Id;
import javax.persistence.JoinColumn;

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)
    @JoinColumn(name="ADDRESS_ID") 
    public Address getStudentAddress() {
        return this.studentAddress;
    }

    public void setStudentAddress(Address studentAddress) {
        this.studentAddress = studentAddress;
    }
}

still i get this error?

run:
Jan 31, 2010 11:20:00 AM org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.3.1.GA
Jan 31, 2010 11:20:00 AM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
Jan 31, 2010 11:20:00 AM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
Jan 31, 2010 11:20:00 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
Jan 31, 2010 11:20:00 AM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
Jan 31, 2010 11:20:00 AM org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
Jan 31, 2010 11:20:00 AM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: Student
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity Student on table STUDENT
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: Address
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity Address on table ADDRESS
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Jan 31, 2010 11:20:01 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
Jan 31, 2010 11:20:01 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
Jan 31, 2010 11:20:01 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
Jan 31, 2010 11:20:01 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/vanila
Jan 31, 2010 11:20:01 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root}
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.0.45-community-nt
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
Jan 31, 2010 11:20:01 AM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
Jan 31, 2010 11:20:01 AM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
Jan 31, 2010 11:20:01 AM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
Jan 31, 2010 11:20:01 AM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
Jan 31, 2010 11:20:01 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
Jan 31, 2010 11:20:01 AM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Jan 31, 2010 11:20:01 AM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Jan 31, 2010 11:20:01 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 1054, SQLState: 42S22
Jan 31, 2010 11:20:01 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Unknown column 'ADDRESS_ID' in 'field list'
org.hibernate.exception.SQLGrammarException: could not insert: [Student]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
        at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
        at Main.main(Main.java:23)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ADDRESS_ID' in 'field list'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
        at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
        ... 16 more
BUILD SUCCESSFUL (total time: 1 second)

i think this may be database error?
if there is @GeneratedValue in id filed is it must to make default value for clume value?

[ishan dave]

hi,
may know your DDL of both the tables.

Do you have Address_id column in your Student tale ?
if not then please put that.

and please make sure that you checked the auto-increment on in both your tables in mysql.


thank you,
ishaan

[Samanthi perera]

I manually created the tables.
here is a site witch i use.
http://www.vaannila.com/hibernate/hibernate-example/hibernate-mapping-many-to-one-using-annotations-1.html

there is a address columne in student table.
can you send me the DDL please?
i didn't use DDl .i make tables manually.
how to check auto-increment option?

[Christian Dillinger]

You talk to your MySQL in a language only you and MySQL understand?!? Quite cool... If you don't know what he means with "DDL", you could ask. He wants you to show us, how your table looks like. That means table name, column names and column types. Maybe you don't a column named ADRESS_ID, because thats what the error is about.

[Samanthi perera]

here is screen shot of my student table
http://3.bp.blogspot.com/_bpkZ2BsqXug/S2byNyT3tWI/AAAAAAAAABw/rv4cL0dy34U/s1600-h/student.GIF

here is a screenshot of my address table
http://4.bp.blogspot.com/_bpkZ2BsqXug/S2byf5z8VdI/AAAAAAAAAB4/MUs24v3Ixtw/s1600-h/address.GIF

[ishan dave]

i am not able to see the images of your tables

[Christian Dillinger]

If you switch to the mobile version of the forum you see the complete link.

[Samanthi perera]

student
http://1.bp.blogspot.com/_bpkZ2BsqXug/S2mTSN0RnNI/AAAAAAAAADc/ZU1DuBhMNsc/s1600-h/student.GIF


address
http://1.bp.blogspot.com/_bpkZ2BsqXug/S2mTYxG6vgI/AAAAAAAAADk/XfJOIKm_Fh4/s1600-h/address.GIF

anyway when creating table is it should add address?_id as a forieng key ?