I'm using `SqlNormalizedCacheFactory` and for JVM ...

# apollo-kotlin

[John O'Reilly]

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?

[mbonnin]

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

[mbonnin]

Do you mind opening an issue on apollo-kotlin. Looks like you're the first one using the cache with the jdbc driver 🙂

[John O'Reilly]

https://github.com/apollographql/apollo-kotlin/issues/3758

Let me know if I should add any other info to this.