https://kotlinlang.org logo
#exposed
Title
# exposed
d

dave08

09/30/2021, 11:32 AM
Trying to figure out why
Schema.create
only creates my tables once when running h2 in memory dbs in my tests, I need to recreate the connection and tables for each test, but it doesn't do it after the first time... and then all the following tests fail...
r

Recca Chao

09/30/2021, 11:53 AM
Mayne use
"jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;"
and make your schema be permanent?
d

dave08

09/30/2021, 12:50 PM
It looks like that + using
SchemaUtil.drop
on all the tables helps... but now it seems like just one column is missing... but it's there in the table definition... 🤕
Maybe SchemaUtil ignores the current transactions' db? I have multiple dbs running...
e

Endre Deak

09/30/2021, 3:18 PM
did you specify the database for your transaction? so instead of doing
transaction { .. }
you do
transaction(db) { … }
d

dave08

09/30/2021, 3:39 PM
Yes...
my bad... typical error of assigning a column to a column instead of the value (with the same name...). It works now...
3 Views