How to unlock SQLite database file?

Question

When I execute the below code, I get :

"[SQLITE_BUSY] The database file is locked (database is locked)"

try {
    String query = "WITH updates(ID, newvalue) AS ( SELECT TotalStock.Sl_No, TotalStock.Price * TotalStock.Preferred_Stock  FROM TotalStock ) update TotalStock SET Total_Price=  ( SELECT newvalue FROM updates WHERE TotalStock.Sl_No = ID )";
    String query_2="select Sl_No, Item_Name, Perishable, Stock, Preferred_Stock, Total_Price from TotalStock where Stock=?";
    PreparedStatement pst=connection.prepareStatement(query);
    PreparedStatement pst_2=connection.prepareStatement(query_2);
    pst_2.setString(1, "0");
    pst.executeUpdate() ;
    ResultSet rs_2 = pst_2. executeQuery() ;
    
    table.setModel(DbUtils.resultSetToTableModel(rs_2));
} 
catch (Exception e1) {
    e1.printStackTrace();
}

SQLite connection :

Connection conn = null;

public static Connection dbConnector()
{
    try
    {
        Class.forName("org.sqlite.JDBC");
    
        Connection conn = DriverManager.getConnection("jdbc:sqlite:/Users/aditya/Downloads/EISJ/CS/IA/DATABASE/login_cred.db");
            
        return conn;
    }
    catch (Exception e)
    {
        JOptionPane.showMessageDialog(null,e);
        return null;
    }
}

"Lock" means: Some other process is using it. The fix is to find whatever other application (could be another JVM, an SQLite command line tool, etc) and close it. — rzwitserloot
– rzwitserloot, Commented Sep 24, 2022 at 15:14

Chilusoft · Accepted Answer · 2022-09-24 15:00:38Z

1

There is an instance that is using the SQlite file, Check if you are not running a similar project instance that is making use of the Sqlite File.

Also ensure that you are not using external tools to inspect the sqlite file. That could block I/O operations too.

answered Sep 24, 2022 at 15:00

Chilusoft

4691 gold badge7 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to unlock SQLite database file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related