java.sql.SQLException: 数据库被锁定 [英] java.sql.SQLException: database locked

问题描述

我们在代码中使用 sqlite056.jar.在批量插入数据库时​​，我们在提交时在线收到异常.

We are using sqlite056.jar in our code. While inserting into database in batch we are getting exception on line when we going to commit.

代码行

<object of Connection>.commit();
<object of Connection>.setAutoCommit(true);

例外

java.sql.SQLException: database locked

推荐答案

每次查询后需要关闭连接.如果任何连接仍然存在.我在 Java 桌面应用上遇到了同样的错误，现已解决.

Connection needs to be closed after each query. If any of the connections still persist. I had got the same error on Java desktop apps, now solved.

这篇关于java.sql.SQLException: 数据库被锁定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！