jkbbwr
09/18/2017, 4:16 PMobject Address : Table() {
val id = uuid("id").primaryKey()
val postcode = text("postcode")
}
object User : Table() {
val id = uuid("id").primaryKey()
val name = text("name")
val age = integer("age")
val address = (uuid("address_id").references(Address.id))
}
fun main(args: Array<String>) {
Database.connect("jdbc:sqlite:./test.db", driver="org.sqlite.JDBC")
transaction {
create(User, Address)
}
}
Gives
SLF4J: See <http://www.slf4j.org/codes.html#StaticLoggerBinder> for further details.
Exception in thread "main" java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and TRANSACTION_READ_UNCOMMITTED.
at org.sqlite.jdbc3.JDBC3Connection.setTransactionIsolation(JDBC3Connection.java:82)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManager$ThreadLocalTransaction$connection$2.invoke(ThreadLocalTransactionManager.kt:25)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManager$ThreadLocalTransaction$connection$2.invoke(ThreadLocalTransactionManager.kt:20)
at kotlin.UnsafeLazyImpl.getValue(Lazy.kt:153)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManager$ThreadLocalTransaction.getConnection(ThreadLocalTransactionManager.kt)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManager$ThreadLocalTransaction.close(ThreadLocalTransactionManager.kt:42)
at org.jetbrains.exposed.sql.Transaction.close(Transaction.kt)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:94)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:58)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:49)
at MainKt.main(main.kt:21)