how to add sqlite driver to kmp for room ```Cannot...

# multiplatform

[calidion]

how to add sqlite driver to kmp for room

Cannot create a RoomDatabase without providing a SQLiteDriver via setDriver().

I have added these lines:

val roomVersion = "2.7.0-alpha12"
    implementation("androidx.room:room-runtime:$roomVersion")
    implementation("androidx.sqlite:sqlite-bundled:2.5.0-alpha12")
    implementation("androidx.sqlite:sqlite-bundled-jvm:2.5.0-alpha12")
    ksp("androidx.room:room-compiler:$roomVersion")

creation code:

fun getDatabaseBuilder(): RoomDatabase.Builder<AppDatabase> {
    val dbFile = File(System.getProperty("java.io.tmpdir"), "my_room.db")
    return Room.databaseBuilder<AppDatabase>(
        name = dbFile.absolutePath,
    )
}

[Chrimaeon]

You are really not good at reading documentation, aren’t you? 😅
https://developer.android.com/kotlin/multiplatform/room#database-instantiation

[calidion]

Ha, I wrote this code previously for android platform but have forgotten.

[calidion]

I don't think it is my problem, but the document is really bad organized.

[calidion]

and once again, I have to comment these two useless lines.

return builder
//        .addMigrations(MIGRATIONS)
//        .fallbackToDestructiveMigrationOnDowngrade()
        .setDriver(BundledSQLiteDriver())
        .setQueryCoroutineContext(<http://Dispatchers.IO|Dispatchers.IO>)
        .build()

[Chrimaeon]

Maybe at some point you will come back and uncomment then 😅 After you have asked here how to enable migration of course 😉

[calidion]

🥶