I can't configure it to sqlite DB.

[shohrab-swl]

I just change application.conf file

ktor {
deployment {
port = 9090
}
application {
modules = [ ktor.ServerKt.module ]
}
development = true
}

database {
type = "JDBC"
drop = false
jdbc {

    driver = "org.sqlite.JDBC" 
    url = "jdbc:sqlite:file:test?mode=memory&cache=shared"
    schema = ""
    username = "root"
    username = ${?MYSQL_USER}
    password = "root"
    username = ${?MYSQL_PASSWORD}
}

}

jwt {
domain = "http://localhost:8080"
domain = ${?DOMAIN}
secret = "490626fc-d735-4b85-a953-386f0b8cd2f5"
secret = ${?JWT_SECRET}
}

and add this dependency implementation("org.xerial:sqlite-jdbc:3.45.0.0")

that throw this error message:

Exception in thread "DefaultDispatcher-worker-1" java.lang.IllegalStateException: repositories.user.UserTable.id is not in record set

CleanArchitecture.zip

Can anyone help me to solve this problem?