Hibernate: insert into book (catalogId, publishId, subjectId, bookNO, bookName, synopsis, price, discount, publishTime, picture, hit, show, updateTime, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WARN - SQL Error: 1064, SQLState: 42000
ERROR - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show, updateTime, id) values ('2c9ab2d51637c2ca0116380396f80009', '2c9ab2d516382' at line 1
ERROR - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
... 144 more
ERROR - Servlet.service() for servlet default threw exception
java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show, updateTime, id) values ('2c9ab2d51637c2ca0116380396f80009', '2c9ab2d516382' at line 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1103)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:853)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
........
at java.lang.Thread.run(Thread.java:595)
原因:show 在mysql數(shù)據(jù)中為關(guān)鍵字
posted on 2007-11-13 17:07
Ke 閱讀(1011)
評論(0) 編輯 收藏 所屬分類:
exception