``` object Address : Table() { val id = uuid("...
# exposed
j
Copy code
object 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
Copy code
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)