Default readOnly = true in DbConnectionConfig breaks SQLite #1365
Description
To reproduce:
val connection = DbConnectionConfig("jdbc:sqlite:/path/to/my.db")
val dfs = DataFrame.readAllSqlTables(connection)causes:
Exception in thread "main" java.sql.SQLException: Cannot change read-only flag after establishing a connection. Use SQLiteConfig#setReadOnly and SQLiteConfig.createConnection().
at org.sqlite.jdbc3.JDBC3Connection.setReadOnly(JDBC3Connection.java:146)
at org.jetbrains.kotlinx.dataframe.io.ReadJdbcKt.readAllSqlTables(readJdbc.kt:1464)
at org.jetbrains.kotlinx.dataframe.io.ReadJdbcKt.readAllSqlTables$default(readJdbc.kt:776)
at example.Sqlite_testKt.main(sqlite test.kt:10)
at example.Sqlite_testKt.main(sqlite test.kt)
It works fine when I set readOnly = false, but it seems like true is not a good default for all databases