Carter
08/30/2023, 7:44 PMCaused by: java.sql.SQLFeatureNotSupportedException: not implemented by SQLite JDBC driver
at org.sqlite.jdbc3.JDBC3PreparedStatement.unsupported(JDBC3PreparedStatement.java:448) ~[sqlite-jdbc-3.43.0.0.jar:?]
at org.sqlite.jdbc3.JDBC3Statement.getGeneratedKeys(JDBC3Statement.java:357) ~[sqlite-jdbc-3.43.0.0.jar:?]
at com.zaxxer.hikari.pool.ProxyStatement.getGeneratedKeys(ProxyStatement.java:229) ~[HikariCP-5.0.1.jar:?]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.getGeneratedKeys(HikariProxyPreparedStatement.java) ~[HikariCP-5.0.1.jar:?]
at org.jetbrains.exposed.sql.statements.jdbc.JdbcPreparedStatementImpl.getResultSet(JdbcPreparedStatementImpl.kt:14) ~[exposed-jdbc-0.43.0.jar:?]
at org.jetbrains.exposed.sql.statements.InsertStatement.execInsertFunction(InsertStatement.kt:138) ~[exposed-core-0.43.0.jar:?]
at org.jetbrains.exposed.sql.statements.InsertStatement.executeInternal(InsertStatement.kt:144) ~[exposed-core-0.43.0.jar:?]
at org.jetbrains.exposed.sql.statements.InsertStatement.executeInternal(InsertStatement.kt:11) ~[exposed-core-0.43.0.jar:?]
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:63) ~[exposed-core-0.43.0.jar:?]
... 20 more
Based on the release notes, I don’t see any specific compatibility for SQLite databases. I can’t quite tell from the logs what is triggering this. The table I’m inserting into is a UUIDTable with one extra column.
val createdAt = timestamp("created_at").clientDefault { Clock.System.now() }
I’m working to do some more digging but in the meantime wanted to share this initial feedback.