问题源于这样一个异常:
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")
);
分享到:
相关推荐
hibernate中使用自定义类型映射Oracle LONG类型
hibernate实体映射文件字段设置默认值
自动生成hibernate映射文件和实体类
hibernate映射枚举类型,hibernate如何映射枚举类型
关于hibernate映射和查询,使用MySQL,适合初学者的练习
build.xml 手写自动生成Hibernate映射文件和配置文件源代码
下面小编就为大家带来一篇spring hibernate实现动态替换表名(分表)的方法。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,hibernate,包含4个说明文档,分别详细解说了hibernate关联映射的...
用MyEclipse自动生成hibernate映射文件和实体类
Hibernate映射导致的几个常见异常
一下午才整合成功,书中的bulidSessionFactory()方法在hibernate4.3.5中已经deprecated,这里面有方法实现,用完请给好评。
Hibernate映射解析 七种映射关系
常用 Hibernate 映射配置说明.doc
用来生成hibernate映射文件.从而实现不需手动写入。。。很实用的东东哦。。
myeclipse自动生成hibernate映射文件
用Hibernate映射继承关系
根据实体类生成简单的Hibernate映射文件,对不用Myeclipse的童鞋还是有用
hibernate 映射关系 小结
使用hibernate的query调用oracle的存储过程/function,包含例子,源码以及数据库文件