Hibernate列名是保留字的解决方法

最新推荐文章于 2024-03-25 12:01:20 发布

智学无忧-老曹

最新推荐文章于 2024-03-25 12:01:20 发布

阅读量2.3k

点赞数

分类专栏： Java开发文章标签： Hibernate配置错误 select Hibernate常见错误 oracle列名关键字的解决缺失 SELECT 关键字

本文链接：https://blog.youkuaiyun.com/lxcao/article/details/17455923

版权

Java开发专栏收录该内容

10 篇文章

订阅专栏

在Hibernate框架下，如果要操作的列名是Oracle的保留字，则会报如下的错误。

Exception in thread "main" org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
	at com.accp.dao.impl.LoggerDaoImpl.addLogger(LoggerDaoImpl.java:21)
	at com.accp.dao.impl.LoggerDaoImpl.main(LoggerDaoImpl.java:29)
Caused by: java.sql.BatchUpdateException: ORA-00928: 缺失 SELECT 关键字

	at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9409)
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 9 more

在oracle中保留字有

ACCESS ADD ALL ALTER AND ANY AS ASC AUDIT BETWEEN BY CHAR 
CHECK CLUSTER COLUMN COMMENT COMPRESS CONNECT CREATE CURRENT 
DATE DECIMAL DEFAULT DELETE DESC DISTINCT DROP ELSE EXCLUSIVE 
EXISTS FILE FLOAT FOR FROM GRANT GROUP HAVING IDENTIFIED 
IMMEDIATE IN INCREMENT INDEX INITIAL INSERT INTEGER INTERSECT 
INTO IS LEVEL LIKE LOCK LONG MAXEXTENTS MINUS MLSLABEL MODE 
MODIFY NOAUDIT NOCOMPRESS NOT NOWAIT NULL NUMBER OF OFFLINE ON 
ONLINE OPTION OR ORDER PCTFREE PRIOR PRIVILEGES PUBLIC RAW 
RENAME RESOURCE REVOKE ROW ROWID ROWNUM ROWS SELECT SESSION 
SET SHARE SIZE SMALLINT START SUCCESSFUL SYNONYM SYSDATE TABLE 
THEN TO TRIGGER UID UNION UNIQUE UPDATE USER VALIDATE VALUES 
VARCHAR VARCHAR2 VIEW WHENEVER WHERE WITH

解决的办法：在Hibernate配置文件中给关键字列加上[关键字列名]

<column length="500" name="[comment]" not-null="true" />