Could not execute JDBC batch update异常,求大神科普一下
初学Hibernate,想用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 cn.pb.hibernate.dao.LoginDao.sava(LoginDao.java:22)
at cn.pb.hibernate.test.TestHi.main(TestHi.java:19)
Caused by: java.sql.BatchUpdateException: ORA-00942: 表或视图不存在
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 9 more
用plsql可以连到数据库进行插入
求大神帮帮忙看下
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 cn.pb.hibernate.dao.LoginDao.sava(LoginDao.java:22)
at cn.pb.hibernate.test.TestHi.main(TestHi.java:19)
Caused by: java.sql.BatchUpdateException: ORA-00942: 表或视图不存在
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 9 more
用plsql可以连到数据库进行插入
求大神帮帮忙看下
...全文
相关推荐
JDBC中PreparedStatement接口提供的execute、executeQuery和executeUpdate之间的区别及用法
JDBC 中 PreparedStatement 接口提供的 execute、executeQuery 和 executeUpdate 之间的区别及用法JDBC 中的 PreparedStatement
JDBC高级批处理
;stmt.addBatch("UPDATE table SET column = ? WHERE id = ?")
MySQL execute、executeUpdate、executeQuery三者的区别
**execute()**: `boolean execute(String sql)` 方法允许执行任何SQL语句,包括查询语句、更新语句(INSERT、UPDATE、DELETE)以及数据定义语言(
Hibernate映射导致的几个异常
SQLGrammerException, Could not execute JDBC batch update当执行批量更新操作时,如果SQL语法错误或数据库不支持批处理,可能会遇到此异常。
SSH整合常见错误总结
execute JDBC batch update`异常。


