新手 Hibernate 添加总出错误!

Question

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.niejun.webhibernate.bean">
<class name="Student" table="t_student" schema="DBCommunity">
<id name="studentId" >
<generator class="identity" />
</id>
<property name="name"></property>
<property name="age"></property>
<property name="sex"></property>
<property name="like"></property>
<property name="address"></property>
<property name="password"></property>
<property name="number"></property>
<set name="communities" table="t_sc" inverse="true" cascade="all">
<key column="studentId"/>
<many-to-many column="communityId" class="Community" />
</set>
</class>
</hibernate-mapping>这是我的配置package com.niejun.webhibernate.bean;import java.io.Serializable;
import java.util.HashSet;
import java.util.Set;@SuppressWarnings("serial")
public class Student implements Serializable {
private String password;
private String like;
private String number;
private Integer age;
private String name;
private String address;
private String sex;
private Integer studentId;
private Set<Community> communities = new HashSet<Community>(0);

public Set<Community> getCommunities() {
return communities;
}
public void setCommunities(Set<Community> communities) {
this.communities = communities;
}
public Integer getStudentId(){
return this.studentId;
}
public void setStudentId(Integer studentId){
 this.studentId=studentId; 
}
public String getSex(){
return this.sex;
}
public void setSex(String sex){
 this.sex=sex; 
}
public String getAddress(){
return this.address;
}
public void setAddress(String address){
 this.address=address; 
}
public String getName(){
return this.name;
}
public void setName(String name){
 this.name=name; 
}
public Integer getAge(){
return this.age;
}
public void setAge(Integer age){
 this.age=age; 
}
public String getNumber(){
return this.number;
}
public void setNumber(String number){
 this.number=number; 
}
public String getLike(){
return this.like;
}
public void setLike(String like){
 this.like=like; 
}
public String getPassword(){
return this.password;
}
public void setPassword(String password){
 this.password=password; 
}
}这是我的实体类然后就是添加一条记录就开始报错了
Hibernate: 
    insert 
    into
        DBCommunity.t_student
        (studentId, name, age, sex, like, address, password, number) 
    values
        (null, ?, ?, ?, ?, ?, ?, ?)
org.hibernate.exception.SQLGrammarException: could not insert: [com.niejun.webhibernate.bean.Student]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:64)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)
at com.niejun.webhibernate.test.WebTest.main(WebTest.java:40)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:57)
... 16 more
然后每次添加时他都完全不认识那个自动增长列,把自动增长列也加进去

Answer 1

<id name="studentId" >
<generator class="identity" />
</id>
“indentity”改为‘native’

Answer 2

谢谢楼上,但是我改成native还是没有用,依旧会跟主键插个Null值

Answer 3

本帖最后由 AWUSOFT 于 2011-07-11 00:46:54 编辑

  

Answer 4

谢谢你了,找到错误了,换了个access专用的数据库驱动就好了,不能用eclipse自带的那个驱动,不过就是插入时间太慢了,要插入20秒钟.