detach sqlite database in java

Question

I want to detach the current sqlite database(OLD) before i attach the NEW sqlite database. But when I execute below code:

Statement statement = connection.createStatement();
statement.execute("DETACH database '" + alias+"'");
statement.close();**

I am getting following error:

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such database: OLD)

I have attached the database using the below code :

SQLiteDataSource dataSource = new SQLiteDataSource();
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
statement.execute("ATTACH DATABASE '" + path + "' AS " + alias);
statement.close();**

Can anybody please help me where i am doing wrong?

Answer 1

Resolved the issue by creating new reference each time i am calling the the method for initializing database connection :)