java + sqlite:如何以只读方式打开数据库? [英] java + sqlite: how to open database as read-only?

问题描述

我有一个大型数据库，我想以只读模式打开...我正在使用 SQLiteJDBC ，并且不确定使用什么使它以只读方式工作.

I have a large database that I want to open in read-only mode... I'm using SQLiteJDBC and am not sure what to use to get it to work as read-only.

任何人都可以帮忙吗?

推荐答案

Test demonstrate how to set connection to be read-only:

SQLiteConfig config = new SQLiteConfig();

config.setReadOnly(true); 

Connection conn = DriverManager.getConnection("jdbc:sqlite:sample.db",
config.toProperties());

这篇关于java + sqlite:如何以只读方式打开数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！