I use DB2 Database, with table Contact have ( id - Integer, firstname - varchar(20), lastname - varchar(20), email - varchar(30)). But firstExample don't run, it throw a Exception. And I don't know why ? :( Plz to help me!
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment). log4j:WARN Please initialize the log4j system properly.
Inserting Record Done Hibernate: insert into CONTACT (FIRSTNAME, LASTNAME, EMAIL, ID) values (?, ?, ?, ?)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not insert: [roseindia.tutorial.hibernate.Contact] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1839) at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2171) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669) at roseindia.tutorial.hibernate.FirstExample.main(FirstExample.java:36) Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: NESAVER.CONTACT at com.ibm.db2.jcc.b.ig.e(ig.java:1594) at com.ibm.db2.jcc.b.ig.a(ig.java:1204) at com.ibm.db2.jcc.c.gb.g(gb.java:140) at com.ibm.db2.jcc.c.gb.a(gb.java:39) at com.ibm.db2.jcc.c.w.a(w.java:34) at com.ibm.db2.jcc.c.vb.f(vb.java:139) at com.ibm.db2.jcc.b.ig.n(ig.java:1175) at com.ibm.db2.jcc.b.jg.eb(jg.java:1877) at com.ibm.db2.jcc.b.jg.d(jg.java:2319) at com.ibm.db2.jcc.b.jg.W(jg.java:463) at com.ibm.db2.jcc.b.jg.executeUpdate(jg.java:446) at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1823) ... 9 more