HSQLDB错误：java.sql.BatchUpdateException: fail batch

最新推荐文章于 2024-05-21 13:13:57 发布
最新推荐文章于 2024-05-21 13:13:57 发布 · 307 阅读 · 0
文章标签：

#HSQLDB #SQL #Java #Hibernate #JDBC

本文介绍了解决使用HibernateTemplate时遇到的BatchUpdateException错误的方法。通过禁用HSQLDB的批量更新功能并设置hibernate.jdbc.batch_size参数为0来解决此问题。
部分错误信息：
java.sql.BatchUpdateException: failed batch
org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)

导致这个错误的原因只是使用了HibernateTemplate中的一个简单方法：
getHibernateTemplate().bulkUpdate("delete FileInfo where fileId = ?", fileId);

初步认为是HSQLDB的问题，关闭了HSQLDB的批量更新功能就解决了问题。
由于使用的是hibernate，所以设置了hibernate.jdbc.batch_size=0就解决了问题。
【异常】BatchUpdateException: Batch entry 0 ,PSQLException: ERROR: duplicate key value violates unique
本本本添哥
04-12 1644
解决这个问题，你可以采取以下几种方法之一，在解决这个问题时，你应该查看 ScenarioActionBindingMapper.insert 方法中的代码，确保在插入数据之前进行必要的检查，并正确处理任何可能发生的冲突。这通常意味着你尝试插入的记录中的 bind_id 字段的值与数据库中已有的记录中的 bind_id 值重复了。错误消息指出 bind_id 的值为 0 的记录已经存在，所以无法再插入一个具有相同 bind_id 的新记录。在数据库中，主键或唯一约束字段的值必须是唯一的，不能重复。
hsqldb-1.8.0.7.jar
12-29
HSQDB，全称HyperSQL DataBase，是一个由Java编写的开源数据库管理系统，其核心特性在于其对标准SQL语法的全面支持以及与Java应用程序的无缝集成。HSQDB以其小巧、快速和灵活的特点，在各种应用场景中得到了广泛的...
配置 Spring Batch 批处理失败重试
程序猿DD
12-20 1068
点击上方蓝色“程序猿DD”，选择“设为星标”回复“资源”获取独家整理的学习资料！1. 引言默认情况下，Spring批处理作业在执行过程中出现任何错误都会失败。然而有些时候，为了提高应用程...
Table not found in statement [select sequence_name from system_sequences]
qqaniu的专栏
02-04 2698
错误：用hibernate配置文件生成数据库Schema。设置hbm2ddl = update，启动JBoss时报错误Table not found in statement [select sequence_name from system_sequences]。如果去掉这条，则启动没问题。HSQLDB版本：1.8.0.10Hibernate版本：3.0.5JBoss版本：4.2.3
mybatis-plus批量插入报错Invalid bound statement (not found): insertBatchSomeColumn问题解决
李洪亮的博客
05-21 2305
mybatis-plus自带的saveBatch性能并不能满足我们的需求，故有了insertBatchSomeColumn的扩展。但是扩展后出现了Invalid bound statement (not found): insertBatchSomeColumn的报错，网上却始终搜不到正确的解决办法，故这里记录一下，需要看解决办法的可以直接拉到最后。注:这里我使用的mybatis-plus是3.1.2版本的，不同版本可能有所差别。
jdbc executeBatch()事务批量提交获取到其中一条存在异常sql
qq_39457143的博客
11-02 3356
import java.sql.BatchUpdateException; try{ ps.executeBatch();//批量执行 connection.commit();//提交 }catch (BatchUpdateException throwables) { int[] exc = throwables.getUpdateCounts();//获取到sql执行后返回的信息 int count = 0; //遍历 获取到第几条sql有问题 for (in
Caused by: java.sql.BatchUpdateException: Violate not null constraint on [ID]
07-24
在 Java 程序中，当使用 JDBC 批量更新操作时，可能会遇到 `java.sql.BatchUpdateException: Violate not null constraint on ID` 这类错误。这种异常通常发生在批量更新或插入操作中，某个字段的值为 `null`，而该...
Factory method 'sqlSessionFactory' threw exception; nested exception is com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail ! Cause:java.lang.RuntimeException: Driver com.mysql.cj.jdbc.Driver claims to not accept jdbcUrl, jdbc:hsqldb:mem:testdb
06-10
这是Mybatis-Plus框架的异常，可能是因为配置文件中的数据库驱动配置有误导致的。具体原因是由于Mybatis-Plus默认使用了Druid数据源，但是在使用MySQL数据库时，需要使用MySQL提供的JDBC驱动而不是Druid提供的JDBC...
java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 Invalid argument in JDBC call
09-19
如果错误是在执行 SQL 查询时抛出的，检查 SQL 查询语句是否正确。确保查询语句中的表名、列名和语法都是正确的。示例代码如下： ```java import java.sql.Connection; import java.sql.DriverManager; import java....
[root@yfw ~]# cd /opt/openfire [root@yfw openfire]# sudo -u openfire tee /opt/openfire/conf/openfire.xml > /dev/null << 'EOF' > <?xml version="1.0" encoding="UTF-8"?> > <jive> > <adminConsole> > <port>9090</port> > <securePort>9091</securePort> > </adminConsole> > <locale>en_US</locale> > <setup>true</setup> <!-- 关键：强制进入安装模式 --> > </jive> > EOF [root@yfw openfire]# [root@yfw openfire]# # 设置权限 [root@yfw openfire]# sudo chown openfire:openfire /opt/openfire/conf/openfire.xml [root@yfw openfire]# sudo chmod 644 /opt/openfire/conf/openfire.xml [root@yfw openfire]# sudo chown -R openfire:openfire /opt/openfire/logs [root@yfw openfire]# sudo chmod -R 755 /opt/openfire/logs [root@yfw openfire]# sudo su - openfire Last login: Sat Nov 15 17:22:29 CST 2025 on pts/0 ✅ JAVA_HOME: /usr/lib/jvm/java-11-openjdk ✅ Maven home: /opt/maven ✅ Java version: openjdk version "11.0.13" 2021-10-19 LTS ✅ Environment loaded for openfire PATH = /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/lib/jvm/java-11-openjdk/bin:/opt/maven/bin:/usr/local/ffmpeg/bin:/opt/spark/bin JAVA_HOME = /usr/lib/jvm/java-11-openjdk [openfire@yfw ~]$ cd /opt/openfire [openfire@yfw openfire]$ ./bin/start.sh --no-daemon Starting OpenFire in foreground mode... 17:35:21.754 [main] ERROR org.jivesoftware.util.JiveGlobals - Unable to load default security properties from: /opt/openfire/conf/openfire.xml java.io.IOException: XML properties file must be writable: security.xml at org.jivesoftware.util.XMLProperties.<init>(XMLProperties.java:156) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveGlobals.loadSecurityProperties(JiveGlobals.java:1312) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveGlobals.isXMLPropertyEncrypted(JiveGlobals.java:1010) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.XMLProperties.getProperty(XMLProperties.java:212) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.XMLProperties.getProperty(XMLProperties.java:171) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveGlobals.getXMLProperty(JiveGlobals.java:310) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:367) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:658) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] 17:35:21.791 [main] ERROR org.jivesoftware.util.JiveProperties - null java.lang.NullPointerException: null at java.lang.Class.forName0(Native Method) ~[?:?] at java.lang.Class.forName(Class.java:375) ~[?:?] at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvider.java:99) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:652) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.ensureConnectionProvider(DbConnectionManager.java:109) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:162) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:472) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:108) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:84) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:547) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.cache.CacheFactory.<clinit>(CacheFactory.java:102) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:381) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:658) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] Database setup or configuration error: Please verify your database settings and check the logs/openfire.log file for detailed error messages. 17:35:24.385 [main] ERROR org.jivesoftware.openfire.XMPPServer - Database could not be accessed java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1020) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) at java.base/java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) at java.base/jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) at java.base/java.lang.Class.newInstance(Class.java:645) at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) ... 11 more 17:35:24.386 [main] ERROR org.jivesoftware.openfire.XMPPServer - java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1020) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) ~[xmppserver-5.0.2.jar:5.0.2] ... 11 more Error starting the server. Please check the log files for more information.
最新发布
11-16
java.sql.SQLException: Check JDBC properties; data source was not be initialised ``` **根本原因**：由于 `security.xml` 无法加载 → 导致配置解析中断 → 数据库配置未初始化 → 启动失败。 > ✅ 这个...
执行executeBatch批处理遇到的问题
小老虎的专栏
10-18 1万+
执行Batch批处理遇到的问题 1.务必关掉自动提交 增强执行效率 conn.setAutoCommit(false); 2.executeBatch失效问题 务必将语句pstmt = conn.prepareStatement(sql);放到循环体外，否则只能插入一条语句 int size = ipAdressList.size(); try {
java1.7开始hsqldb,来自java的hsqldb调用过程
weixin_34297395的博客
03-21 310
我在hsqldb中创建了这个过程create procedure insertarUsuario(nombre varchar(50), apellidos varchar(50), usuariowin varchar(10),xlnet varchar(10), correo varchar(150), planta integer, telefono integer)MODIFIES SQL...
批量插入数据库发生addBatch错误
思之远也的博客
01-10 2487
向数据库中批量插入数据时发生addBatch错误 java.sql.BatchUpdateException: Batch Update Failed, See next exception for details     at org.trafodion.jdbc.t4.TrafT4PreparedStatement.executeBatch(TrafT4PreparedStatement....
weblogic 包加载与冲突等问题
热门推荐
Jacob
07-25 5万+
问题1(org.apache.commons.lang.ClassUtils.getClass) ? Caused by: org.springframework.beans.factory.BeanCreationException: **Error creating bean with name 'dorado.dataParser'** define
部署Weblogic9.2 常见错误
lyayfy的专栏
03-31 3744
配置：Weblogic9.2  MyEclipse 7.0 或手动部署Weblogic9.2   第一：浏览器浏览时，报以下错误   Error 404--Not Found From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.4.5 404 Not Found The server has not f
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值