在hibernate第一个实例中遇到的问题和解决方法

 

在hibernate第一个实例中遇到的问题和解决方法

1．驱动找不到

    记得要导入的驱动必须有的是：

MySQL驱动 

hibernate3.jar

hibernate-distribution-3.6.8.Fina/lib/required/所有jar文件

       hibernate-distribution-3.6.8.Fina/lib/jpa/jar文件

2.Unknown entity: com.hbsi.domain.User

（1）抛的异常是：

Exception in thread "main" org.hibernate.MappingException: Unknown entity: com.hbsi.domain.User

    at org.hibernate.impl.SessionFactoryImpl.getEntityPersister(SessionFactoryImpl.java:693)

    at org.hibernate.impl.SessionImpl.getEntityPersister(SessionImpl.java:1485)

    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:120)

    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:713)

    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)

    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)

    at com.hbsi.test.TestHibernate.main(TestHibernate.java:41)

 

（2）解决的方法

在配置文件中增加属性

<!-- 指定映射文件的位置 -->

<mapping resource="com/hbsi/domain/User.hbm.xml"/>

 

3．Table 'demo.user' doesn't exist

（1）抛的异常是

Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not insert: [com.hbsi.domain.User]

    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)

    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)

    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)

    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)

    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)

    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)

    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:713)

    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)

    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)

    at com.hbsi.test.TestHibernate.main(TestHibernate.java:33)

 

 

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'demo.user' doesn't exist

    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:411)

    at com.mysql.jdbc.Util.getInstance(Util.java:386)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)

    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)

    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)

    ... 16 more

（2）解决的方法：Hbinate会自动创建，必须在hibrnate.cfg.xml中写一句话

    <property name="hibernate.hbm2ddl.auto"></property>

属性的取值：

（1）

    <property name="hibernate.hbm2ddl.auto"> create-drop </property>

Create-drop:表示在hebarinate初始化时创建表格,程序运行结束的时候会删除相应的表格，在实际项目中不用

（2）

    <property name="hibernate.hbm2ddl.auto">create</property>

在hibernate初始化时会创建表格，在运行结束之后不删除表格，而是在下一次运行的时候如果有旧的删掉，没有旧的，重新建表格

（3）

<property name="hibernate.hbm2ddl.auto">update</property>

只是根据映射文件去和数据库中的表对应起来，如果不一致，就更新表的结构

（4）

<property name="hibernate.hbm2ddl.auto">validate</property>

校验映射文件和数据库中的表是不是能对应起来，不能对应报错，实际中常用

 

4．表建好了，但是表格中没有记录，增加属性即可

    <!-- 执行的sql语句显示出来 -->

    <property name="hibernate.show_sql">true</property>

.