Kotlin/Android: android.database.sqlite.SQLiteException: no such table: Table_xx (code 1 SQLITE_ERROR): , while compiling: select * from Table_xx

Question

I have a problem to access to my table, but impossible to know where is the problem. The table exists well in the SQL select * from Table_xx.

I don't know if the no such table error message is really a problem of missing table...

class DBLocal(context: Context, name: String?, factory: SQLiteDatabase.CursorFactory?, version: Int) : SQLiteOpenHelper(context, DATABASE_NAME, factory, DATABASE_VERSION)
{

    override fun onCreate(db: SQLiteDatabase)
    {
        print(DATABASE_NAME)
    }

    override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int)
    {
    }
    fun methodToSelectData(strQuery: String)/*, completion: @escaping (_ result:*/
    {
         print("test")

        val list = ArrayList<String>()
        val db = this.readableDatabase


        val c = db.rawQuery(strQuery, null)

        if (c.moveToFirst()) {
            do {
                list.add(c.getString(c.getColumnIndexOrThrow("lng")))
            } while (c.moveToNext())
        }
        c.close()
        db.close()
    }

    fun methodToInsertUpdateDeleteData(strQuery: String)/*, completion: @escaping (_ result: Bool) -> Void)*/
    {

    }
    companion object {
        private val DATABASE_VERSION = 1
        private val DATABASE_NAME = "Local.db"
    }

Thanks in advance.

Please include your logcat output in the question. If you're new to SQL or SQLite, I'd suggest you look into Room Persistence Library, which is safer, less error-prone and easier to use. Android Developer video about it here. — MD Naseem Ashraf
– MD Naseem Ashraf, Commented Apr 5, 2019 at 13:55
@MDNaseemAshraf It makes me think to CoreData on iOS that I don't like... Too much code, even for simple SQL queries. I prefer to let the power to the SQL — ΩlostA
– ΩlostA, Commented Apr 5, 2019 at 14:08
I did not get you. Room is easier than SQLite. Setting up SQLite is more verbose (lots of boiler plate code) and has a possibility of error creeping into it. Room instead checks for error and issues before and during compilation, plus it's a Data Object Mapper making it easier to use. It's preferred by Google against direct use of SQLite; Read here: developer.android.com/training/data-storage/sqlite — MD Naseem Ashraf
– MD Naseem Ashraf, Commented Apr 5, 2019 at 14:21

dt dino · Accepted Answer · 2019-04-09 08:33:11Z

1

It is best to create your own database and import from the assets: https://medium.com/@johann.pardanaud/ship-an-android-app-with-a-pre-populated-database-cd2b3aa3311f

answered Apr 9, 2019 at 8:33

dt dino

1,2147 silver badges19 bronze badges

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

1 Comment

ΩlostA Over a year ago

Interesting, it seems to be what I want. I will tell you.

laalto · Accepted Answer · 2019-04-05 13:53:49Z

1

With SQLiteOpenHelper, you need to write code in the onCreate() override to execute SQL that creates the tables you want. Your implementation just prints the database name, leaving you with an empty database and no tables.

After adding the SQL there, you can uninstall your app once to remove the old empty database and make onCreate() trigger again.

answered Apr 5, 2019 at 13:53

laalto

153k68 gold badges293 silver badges306 bronze badges

2 Comments

ΩlostA Over a year ago

Because I don't create the table, I use a filled database SQLite. May be it is not well copied?

laalto Over a year ago

Most attempts at such I’ve seen on SO have been wraught with many bugs

Collectives™ on Stack Overflow

Kotlin/Android: android.database.sqlite.SQLiteException: no such table: Table_xx (code 1 SQLITE_ERROR): , while compiling: select * from Table_xx

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related