CODEWITHSUNDEEP
sqlitein-memory-database
junaidp
junaidp

Reputation: 11221

sqlite:How to use in memory

I am trying to store my data in memory

here is what i have right now

//sq lite driver
Class.forName("org.sqlite.JDBC");
//database path, if it's new data base it will be created in project folder
con = DriverManager.getConnection("jdbc:sqlite:mydb.db");

Statement stat = con.createStatement(); 

stat.executeUpdate("drop table if exists weights");

//creating table
stat.executeUpdate("create table weights(id integer,"
    + "firstName varchar(30)," + "age INT," + "sex varchar(15),"
    + "weight INT," + "height INT,"
    + "idealweight INT, primary key (id));");

Now where should i put this statement[ ":memory:"] to store my this data in memory and the data should keep saved until i delete it .

Thanks

Upvotes: 12

Views: 17108

Answers (1)

Paul Rigor
Paul Rigor

Reputation: 1026

Try:

con = DriverManager.getConnection("jdbc:sqlite::memory:");

Upvotes: 24

Related Questions