I'm using

SqlNormalizedCacheFactory

and for JVM have following (injected using Koin)

single { SqlNormalizedCacheFactory("jdbc:sqlite:swapi.db") }

Running a

main

function in JVM code and this works fine first time but on subsequent runs I get

Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (table records already exists)
	at org.sqlite.core.DB.newSQLException(DB.java:1012)

Is there some other init/config needed for case of JVM?

Looks reaaaallly similar to https://github.com/cashapp/sqldelight/issues/1901

https://github.com/apollographql/apollo-kotlin/issues/3758 Let me know if I should add any other info to this.