CODEWITHSUNDEEP
javasqlsqlitejdbcreadonly
Jason S
Jason S

Reputation: 189676

java + sqlite: how to open database as read-only?

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.

Can anyone help?

Upvotes: 9

Views: 10363

Answers (5)

hecko84
hecko84

Reputation: 1324

I had a slightly different scenario, but the same issue. If you have a spring boot service using Hikari you need to provide 2 configuration settings in your application.properties

spring.datasource.url=jdbc:sqlite:myDatabase.db?open_mode=1
spring.datasource.hikari.read-only=true

Upvotes: 2

rustyx
rustyx

Reputation: 85351

Just want to add that when using HikariCP, you need two datasource properties:

readOnly=true
dataSource.open_mode=1

Upvotes: 2

dlock
dlock

Reputation: 9577

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());

Upvotes: 13

szcoder
szcoder

Reputation: 1396

Try this.

Properties config = new Properties();
config.setProperty("open_mode", "1");  //1 == readonly
Connection conn = DriverManager.getConnection("jdbc:sqlite:sample.db", config);

Upvotes: 4

tricknology
tricknology

Reputation: 1138

I came across your post and this is what helped me: I made a connection similar to the one listed here http://www.shoaibinamdar.in/blog/?p=313 but insread of 

    ds.setUrl("jdbc:sqlite::resource:"+
    getClass().getResource("sample.db").toString());

I put 

    ds.setUrl("jdbc:sqlite:resource/sample.db");

the sample.db went in /myprojectname/resource/sample.db, with resource being in the same dir (myprojectname) as /myprojectname/src/

Hope this helps someone

Upvotes: -1

Related Questions