No such table while select query


#1

net.sqlcipher.database.SQLiteException: no such table: MY_PORTFOLIO: , while compiling: SELECT * FROM MY_PORTFOLIO WHERE …
at net.sqlcipher.database.SQLiteCompiledSql.native_compile(Native Method)
at net.sqlcipher.database.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91)
at net.sqlcipher.database.SQLiteCompiledSql.(SQLiteCompiledSql.java:64)
at net.sqlcipher.database.SQLiteProgram.(SQLiteProgram.java:89)
at net.sqlcipher.database.SQLiteQuery.(SQLiteQuery.java:55)
at net.sqlcipher.database.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:41)
at net.sqlcipher.database.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1814)

  1. android 8.0
  2. there is the db file in assets. (no creation, just file)
  3. only select usages
  4. it happens ralely.
  5. implementation ‘net.zetetic:android-database-sqlcipher:3.5.9@aar’

#2

Hi @honglai

Have you copied the database file from your assets directory to the databases directory of your application?