Exposed can eager load them at the time of the parent query, this is prevents the classic "N+1" problem as references can be aggregated and loaded in a single query

day(date_time)

val id =  Roles.insertAndGetId { it[name] = ROLE_ADMIN;it[createdAt] = DateTime.now();it[updatedAt] = DateTime.now() }

UserEntity.new {
                email = "<mailto:admin@test.com|admin@test.com>"
                roleId = id
                emailVerified = true
                password = 'password'
                createdAt = DateTime.now()
                updatedAt = DateTime.now()
            }

INFO  Exposed - Transaction attempt #2 failed: Invalid argument value: java.io.NotSerializableException. Statement(s): null

Column<EntityId<UUID>>

Column<UUID>

ModuleVersionNotFoundException

if (Table(tableName).exists()) {

SqlExpressionBuilder

UNION

SELECT MAX(views) FROM (
    SELECT views FROM articles WHERE user_id = 1
    UNION ALL
    SELECT views FROM comments WHERE user_id = 1
) as writings

UPDATE Users SET active=false WHERE id IN (SELECT user_id FROM deactivated)

inList

map{..}/toList()

suspendedTransaction

Database.connect(datasource = HikariDataSource(poolConfig),
            manager = { ThreadLocalTransactionManager(it, Connection.TRANSACTION_REPEATABLE_READ, 0) })

KotlinNullPointerException

batchInsert

List<T>

batchInsert

List<Any>

Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.

Database.connect(
        url = "jdbc:<postgresql://localhost:5432/library>",
        user = "hm",
        password = "wouldn't u like to know",
        driver = "org.postgresql.Driver"
    )

    transaction {
        Books.select { Op.TRUE }.forEach(::println)
    }

java.lang.IllegalStateException: transaction.connection.catalog must not be null

getDatabase

null

connection is closed

Database.connect

db

Database

Database