You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have an application that doing large number of inserts during startup. CPU snapshot shows that about 10% of time consumed by creating SQLExcpetions based on missed columns in ResultSet returned by JDBC driver.
Preconditions
Having this as dependencies
implementation group: 'org.xerial', name: 'sqlite-jdbc', version: '3.39.2.1'
api group: 'org.jetbrains.exposed', name: 'exposed-core', version: '0.39.2'
api group: 'org.jetbrains.exposed', name: 'exposed-dao', version: '0.39.2'
api group: 'org.jetbrains.exposed', name: 'exposed-jdbc', version: '0.39.2'
Having dummy scheme:
object Locations : IntIdTable() {
val path = varchar("path", length = 1024)
val runtime = bool("runtime").default(false)
val outdated = reference("outdated_id", Locations.id).nullable()
}
and code:
Locations.insertAndGetId {
it[path] = "smth"
}
This code produces 4 SQLExceptions with message no such column: 'id' and no such column: 'id', no such column: 'path'. no such column: 'runtime' and no such column: 'outdated'
As I can see in debug after insert driver returns result set for query select last_insert_rowid() and Exposed tries to restore entity with it.
The text was updated successfully, but these errors were encountered:
Hey @lehvolk. I tried to reproduce this issue with your setup but couldn't. Could you please verify that it still happens in the latest Exposed version (0.43.0 at the time of writing)?
I have an application that doing large number of inserts during startup.
I have an application that doing large number of inserts during startup. CPU snapshot shows that about 10% of time consumed by creating SQLExcpetions based on missed columns in ResultSet returned by JDBC driver.
Preconditions
Having this as dependencies
Having dummy scheme:
and code:
This code produces 4 SQLExceptions with message
no such column: 'id'
andno such column: 'id'
,no such column: 'path'
.no such column: 'runtime'
andno such column: 'outdated'
As I can see in debug after insert driver returns result set for query
select last_insert_rowid()
and Exposed tries to restore entity with it.The text was updated successfully, but these errors were encountered: