springboot+druid+sqlite遇到的问题

1.springboot中使用druid查询sqlite报错getFetchDirection error ResultSet closed

https://blog.csdn.net/u011943534/article/details/88060139

2.@Transactional(readOnly = true)

Cannot change read-only flag after establishing a connection. Use SQLiteConfig#setReadOnly and SQLiteConfig.createConnection().

在只有查询的方法上设置readOnly=true时报出以上错误,更换为postgresql时没有错误了,不知道是什么原因,是sqlite-jdbc本身存在的bug吗?

https://github.com/xerial/sqlite-jdbc/issues/247

原文地址:https://www.cnblogs.com/SmilingEye/p/11187239.html