hibernate映射异常，oracle 表名和字段名有么有大小写区分的问题。

最新推荐文章于 2021-01-30 07:06:39 发布

azmwz

最新推荐文章于 2021-01-30 07:06:39 发布

阅读量744

点赞数

分类专栏： hibernate 文章标签： Hibernate Oracle Java junit Eclipse

hibernate 专栏收录该内容

1 篇文章

订阅专栏

本文解决了一个关于Oracle数据库中字段大小写敏感导致的Hibernate同步异常问题。通过调整表定义方式，确保字段名称与映射文件一致，避免了大小写引起的错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题源于这样一个异常：

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: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:1027)
	at com.feosa.common.dao.BaseDao.flush(BaseDao.java:340)
	at com.feosa.common.service.BaseService.flush(BaseService.java:311)
	at com.feosa.framework.workflow.blservice.FlowFormBLServiceTest.initData(FlowFormBLServiceTest.java:57)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59)
	at org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:98)
	at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:79)
	at org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:87)
	at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:77)
	at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
	at org.junit.internal.runners.JUnit4ClassRunner.invokeTestMethod(JUnit4ClassRunner.java:88)
	at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
	at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
	at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
	at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
	at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: java.sql.BatchUpdateException: ORA-00904: "INPUTCODE": 标识符无效

	at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10720)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 30 more

我仔细核对了hibernate的映射文件和表名（不考虑大小写的情况下）。保证一致了，但还是报这个错。
我创建表的语句是：

CREATE TABLE "RISK"."FE_FIELD_INPUT"  (
   "ID"                 INTEGER                         NOT NULL,
   "inputname"               VARCHAR2(100),
   "inputcode"           VARCHAR2(100),
   CONSTRAINT PK_FE_FIELD_INPUT PRIMARY KEY ("ID")
);

注意看，字段名是加了引号的，查看一下创建后的表，在数据库中显示确实是小写的。
所以会报上面的异常。hibernate会自动将字段名改成大写。而我数据库中是小写。

但是如果我创建语句字段名没有引号的话，oracle是不区分大小写的，会自动转换成大写。所以之前没有遇到过这种问题。
正确的创建表的语句是：

CREATE TABLE RISK.FE_FIELD_INPUT  (
   ID                 INTEGER                         NOT NULL,
   inputname               VARCHAR2(100),
   inputcode           VARCHAR2(100),
   CONSTRAINT PK_FE_FIELD_INPUT PRIMARY KEY ("ID")
);