Hibernate: select max(ID) from gewsd
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not fetch initial value for increment generator
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:107)
at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:44)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:91)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
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:530)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
at aaa.Mx_msDaoImpl.insertM(Mx_msDaoImpl.java:25)
at aaa.App.main(App.java:12)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'dsj.gewsd' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428)
at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:85)
... 12 more
解决方案 »
- ajax实现异步通信遇到的问题
- AJAX基础问题
- 怎么下载文件夹下的文件
- <%! %>声明中哪些可以用哪些不可以用?
- request 和session的setAttribute有什么区别
- Ext.Ajax.request 调用action
- 示例程序也出现unreachable statement 问题,奇怪~~~
- jsp的文档路径问题,想download文件<a href="aaa.xls">sdsf</a>总是说早不到The requested resource (/servlet/aaa.xls) is not available
- 类文件我放在web-inf/classes/mydb/mydb.class下,却出现错误
- 能否将一个jsp文件的内容嵌入到另一个jsp代码中??
- socket传送大文件
- 新浪博客段落截取预览问题
后来发现是MySQL对表名是区分大小写的可以在/etc/mysql/my.cnf文件的[mysqld](30行左右)后面添加
lower_case_table_names=1
然后重新启动mysql就可以了