Hello, I am trying to make a very simple query against an oracle database but no matter what I try ...

# exposed

[Chris]

Hello,
I am trying to make a very simple query against an oracle database but no matter what I try I get error occurred during batching: batch must be either executed or cleared. Is there something I am missing. This is all I have:

Database.connect("jdbc:oracle:thin:@localhost:1521/xe", driver = "oracle.jdbc.OracleDriver",user = "XXXX", password = "XXXX")
    transaction(java.sql.Connection.TRANSACTION_READ_COMMITTED,1){
       PaymentOption.selectAll().forEach { println(it[PaymentOption.paymentPlanCode]) }
    }

I am using Maven btw

[tapac]

Could you provide full stack-trace (starting from inTopLevelTtransaction part) ?

[Chris]

turns out I was on an older version: 0.6.3, upgrading fixed the issue. Thanks for replying