On 22-4-2019 14:03, Ananta Jena wrote:
Hi All,Need quick help to resolve one issue i am getting now. I am a new user of SQLite. my code: connection = DriverManager.getConnection("jdbc:sqlite:C:\\sqllite\\sqlite-tools-win32-x86-3280000\\Stories.db"); Statement st = connection.createStatement(); ResultSet b = st.executeQuery("select count(*) from stories;"); Note : Connection is established successfully and also table STORIES has 1 record as well. while executing this ,i am geting below error: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: stories)
The error says: "SQL error or missing database" on the next line is: "no such table: stories" Conclusion: there must be something wrong in the code you did not post. (but i'm not a java programmer....) _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
