i placed my sqlite file on src/Database folder in my project.
Untitled.jpg
and in my code, i have this...
String filePath = "\\Database\\glacier.sqlite"; connect = DriverManager.getConnection("jdbc:sqlite:"+getClass().getResource(filePath));
and!
stat = connect.createStatement(); res = stat.executeQuery("select value from controls where command == 'A'"); A = res.getInt("value");
but it errors and says,
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: controls)
this is so terrible i have controls table in my sqlite!
Untitled1.jpg
please help me solve this