Hibernate operation: could not insert: 急问

[lvkai0452]

我做了个小程序spring+hibernate，当做插入的时候总报这种错误，怎么解决呀.
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [po.Student]; uncategorized SQLException for SQL [insert into student (name, age, tel) values (?, ?, ?)]; SQL state [HY000]; error code [1364]; Field 'id' doesn't have a default value; nested exception is java.sql.SQLException: Field 'id' doesn't have a default value
java.sql.SQLException: Field 'id' doesn't have a default value
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1759)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2178)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:240)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:617)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:614)
at dao.Dao.insert(Dao.java:13)
at Test.main(Test.java:26)

[kingssq]

是说你的id没有默认值。。

[jastby]

Student 表 'id' 值为空？

设置为 自动编号 或者 给它编号吧

[lvkai0452]

stu.setId(Integer.valueOf("1"));

stu.setName("aa");

stu.setAge(Integer.valueOf("24"));

stu.setTel(Integer.valueOf("12345"));

我给id值了，还是不好使。
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="native" />
</id>这个是我的hibernate中配置信息

[jastby]

<generator class="native" />

改为：
<generator class="identity" />

然后数据库 改为 自动编号吧

就不用给 id 赋值了

[jastby]

还用 是 什么数据库呢？？

[jastby]

用了 native 或者 identity， 就不用给id赋值了

但是 需要数据库 设置 这个字段 为 自增

[Shine_Panda]

这样改把：

<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="assigned" />
</id>这个是我的hibernate中配置信息

[fumin1987]

将id设置为自增即可解决！

[txa173420882]

5.0后版本出现的问题

[enjoyinwind]

谢谢楼主的问题~~