请教一下,SQLite数据库文件被锁定。
本人在做一个swing项目,使用的是sqlite数据库,在操作数据库时使用了MyBatis框架
某一个功能需要在数据库中插入新的字段
但是在执行完sql语句后进行commit时报错
插入操作是单线程的,所有的增删改查都有session.close();
### Error committing transaction. Cause: org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)
### Cause: org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)
相关代码:
private Mapper getConn() {
session = mybatisUtil.sqlSessionFactory.openSession();
Mapper mapper = session.getMapper(Mapper.class);
return mapper;
}
private void insertMessage(Message message) {
try {
Mapper mapper = getConn();
int i = mapper.insertMessage(message);
session.commit(); // 这里在报错
session.close();
}catch (Exception e) {
e.printStackTrace();
}
}