Could not execute JDBC batch update : java.sql.BatchUpdateException: ORA-00926: 缺失 VALUES 关键字

解决Hibernate与Oracle数据库整合中主键字段位置错误问题
最新推荐文章于 2023-10-30 15:06:01 发布
原创 最新推荐文章于 2023-10-30 15:06:01 发布 · 9.7k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文解决了一个在使用Hibernate进行Java应用程序与Oracle数据库整合时遇到的错误：由于实体类中主键字段放置不当导致的SQL语法错误。通过将主键字段调整到正确位置，成功解决了问题并确保了数据操作的正常执行。 

<span style="font-size:14px;">org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
Caused by: java.sql.BatchUpdateException: ORA-00926: 缺失 VALUES 关键字</span>

=》把实体类中放置在最后的主键字段，放到了第一位 问题解决

java.sql.BatchUpdateException(解决方案).md
11-25
在项目开发过程中，经常会发生Java程序在进行数据库批量更新操作时抛出java.sql.BatchUpdateException异常。这种异常表明一批SQL语句中的一部分或全部操作执行失败。为了解决这个问题，我们需要采取一些有效的措施。...
oracle+ora-各种常见java.sq
06-21
oracle+ora-各种常见java.sq
eclipse中测试Hibernate异常报 ORA-00926: 缺失 VALUES 关键字
weixin_30376453的博客
05-29 3702
1 log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment). 2 log4j:WARN Please initialize the log4j system properly. 3 log4j:WARN See http://logging.apache.org/log4j/1...
oracle 00926,List插入数据库报错oracle-00926：缺失VALUES关键字
weixin_35488643的博客
04-13 3617
在数据入库的时候报错——oracle-00926：缺失VALUES关键字.这是我的SQLINSERT INTO TableOneUSING(SELECT#{item.ID,jdbcType=NUMERIC} as ID,#{item.NAME,jdbcType=NUMERIC} as NAME,#{item.sex,jdbcType=STRING} as sexFROM DUAL) bon (#查...
List插入数据库报错oracle-00926：缺失VALUES关键字
qq_42061233的博客
12-05 4996
<insert id="xxxInsert" parameterType="java.util.List"> </insert> 有可能不是语法问题！我就不是！ 因为传入的参数是list，如果list.size()=0就会报这个错！
oracle 00926,ORA-00926: missing VALUES keyword
weixin_39841709的博客
04-13 2762
Dear all,while testing this procedure i received the following errors;ORA-06512: at line 1ORA-00926: missing VALUES keywordORA-06512: at "RBI.CBS_ARTICLE5_WORK_INR", line 16ORA-06512: at line 3my proc...
DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update xx_contract set b_modifier=?, m... [Caused by: DataException: Could not execute JDBC batch update]
08-19
DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update xx_contract set b_modifier=?, modifier_name=? where id=?]; nested exception is org.hibernate.exception....
java.sql.BatchUpdateException: ORA-00001: unique constraint (YKT.SYS_C00580447) violated
最新发布
10-24
</think>### 解决方案：处理 `ORA-00001: unique constraint violated` 错误 #### 错误原因 `ORA-00001` 表示违反了数据库的唯一性约束。具体到您的错误： - **约束标识**: `YKT.SYS_C00580447` - **根本原因**: 您...
java.sql.BatchUpdateException: ORA-00001: unique constraint (ZGTA.UI_TRADE_CONFIRM_LOG) violated什么错误
08-23
`java.sql.BatchUpdateException` 中的 `ORA-00001` 错误通常是由唯一性约束冲突引起的，尤其是在批量插入或更新操作中。解决此类问题的关键在于数据预处理、使用合适的 SQL 语句（如 `MERGE`）、调整批处理执行模式...
[25/09/25 15:48:13:665][com.huawei.dao.TbcsDaoImpl-batchAddSettleData] Exception: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into LOC_NGSETTLE_CTACRSUBDETAIL (OID,REGION,CYCLE,ORGID,ACCOUNTTYPE,FINANCEID,BUSINESSMINORCLASSCODE,MARKETSORT,PRODUCTCODE,VENDORNUM,CONTRACTID, OWNERCSTCODE,ISPUBLICACCOUNT,ISESTIMATE,STATUS,STATUSDATE,ORIGAMOUNT,DESTAMOUNT,ASSESSORIGAMOUNT,CONTRACTTYPE) values(seq_oid.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,'0',sysdate,?,?,?,?)]; SQL state [HY000]; error code [1438]; (conn=3496437) ORA-01438: value larger than specified precision allowed for this column; nested exception is java.sql.BatchUpdateException: (conn=3496437) ORA-01438: value larger than specified precision allowed for this column at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989) at org.springframework.jdbc.core.namedparam.NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(NamedParameterBatchUpdateUtils.java:40) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:361) at com.huawei.dao.TbcsDaoImpl.batchAddSettleData(TbcsDaoImpl.java:132) at com.huawei.service.GenerateDataServiceImpl.insertCtAcrSubDetail(GenerateDataServiceImpl.java:418) at com.huawei.service.GenerateDataServiceImpl.cityGeneral(GenerateDataServiceImpl.java:325) at com.huawei.service.GenerateDataServiceImpl.doProcess(GenerateDataServiceImpl.java:171) at com.huawei.main.LocNgsettle01ContractManageSys.main(LocNgsettle01ContractManageSys.java:49) Caused by: java.sql.BatchUpdateException: (conn=3496437) ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:338) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) ... 9 more Caused by: java.sql.SQLTransientConnectionException: (conn=3496437) ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:334) ... 14 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:196) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:362) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:391) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:305) ... 13 more Caused by: java.sql.SQLException: ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1973) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1838) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1728) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:359) ... 15 more [25/09/25 15:48:13:667][com.huawei.main.LocNgsettle01ContractManageSys-main] Exception: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into LOC_NGSETTLE_CTACRSUBDETAIL (OID,REGION,CYCLE,ORGID,ACCOUNTTYPE,FINANCEID,BUSINESSMINORCLASSCODE,MARKETSORT,PRODUCTCODE,VENDORNUM,CONTRACTID, OWNERCSTCODE,ISPUBLICACCOUNT,ISESTIMATE,STATUS,STATUSDATE,ORIGAMOUNT,DESTAMOUNT,ASSESSORIGAMOUNT,CONTRACTTYPE) values(seq_oid.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,'0',sysdate,?,?,?,?)]; SQL state [HY000]; error code [1438]; (conn=3496437) ORA-01438: value larger than specified precision allowed for this column; nested exception is java.sql.BatchUpdateException: (conn=3496437) ORA-01438: value larger than specified precision allowed for this column at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989) at org.springframework.jdbc.core.namedparam.NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(NamedParameterBatchUpdateUtils.java:40) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:361) at com.huawei.dao.TbcsDaoImpl.batchAddSettleData(TbcsDaoImpl.java:132) at com.huawei.service.GenerateDataServiceImpl.insertCtAcrSubDetail(GenerateDataServiceImpl.java:418) at com.huawei.service.GenerateDataServiceImpl.cityGeneral(GenerateDataServiceImpl.java:325) at com.huawei.service.GenerateDataServiceImpl.doProcess(GenerateDataServiceImpl.java:171) at com.huawei.main.LocNgsettle01ContractManageSys.main(LocNgsettle01ContractManageSys.java:49) Caused by: java.sql.BatchUpdateException: (conn=3496437) ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:338) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:310) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) ... 9 more Caused by: java.sql.SQLTransientConnectionException: (conn=3496437) ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:126) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:334) ... 14 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:80) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:196) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:362) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternalBatch(JDBC4PreparedStatement.java:391) at com.oceanbase.jdbc.JDBC4PreparedStatement.executeBatch(JDBC4PreparedStatement.java:305) ... 13 more Caused by: java.sql.SQLException: ORA-01438: value larger than specified precision allowed for this column at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1973) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1838) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1728) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:359)
09-26
当使用Spring JdbcTemplate批量插入数据到OceanBase数据库时出现ORA - 01438错误，意味着插入的值超出了列指定的精度。以下是一些可能的解决方案： ... jdbcTemplate.batchUpdate(sql, batchArgs); } } ```
java.sql.SQLSyntaxErrorException: ORA-00926: missing VALUES keyword
weixin_44889856的博客
08-11 8518
java.sql.SQLSyntaxErrorException: ORA-00926: missing VALUES keyword报错处理 oracle如果insert不全数据，不能写insert into table（）value（）；写成insert into table（） values（），value变成values就不报这个错误了，这是我这边的处理方法 ...
Could not execute JDBC batch update 错误原因
kun_998的博客
08-06 1万+
错误原因1：你将要插入到数据库中的内容长度超过了数据库中字段的实际设置的长度. 修改数据库中的字段长度 错误原因2：java类里面属性的类型和Hibernate的配置文件.hbm.xml里面声明不一致都可以造成以上错误 本人错误原因: 我用的是oracle数据库, 经排查发现是因为表中的主键ID 序列自增到了设置的最大值.修改一下序列的最大值就好了. ...
记一些oracle的踩坑记录
lonelyisland_syz的博客
10-30 1340
some error occurred during my dev
oracle插入数据的时候报错：ORA-00928: 缺失 SELECT 关键字
热门推荐
MyMBS的博客
04-05 2万+
比如：插入数据的时候是这样的insert into a value('哈哈'); 报的是这样的错误：ORA-00928: 缺失 SELECT 关键字 其实就是value少了一个s，在oracle中，插入数据要用values ...
java.sql.BatchUpdateException
xidajiancun
10-17 1407
异常信息： java.sql.BatchUpdateException:批次处理0insertintoxxx (id, ...)values(44, ...)被中止，呼叫getNextException以取得原因。 org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2St...
[ERROR] Could not execute SQL statement. Reason: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
02-20
### Java中`java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver`解决方案 当应用程序尝试加载MySQL JDBC驱动程序时抛出`java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver`异常，表明JVM未能...
评论 1
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值