kagkarlsson / db-scheduler

Persistent cluster-friendly scheduler for Java
Apache License 2.0
1.23k stars 188 forks source link

feat: add missing indexes to the oracle ddl script #503

Closed iluwa closed 2 months ago

iluwa commented 2 months ago

Add missing indexes to the oracle ddl script

Every example for other databases (Postgres, Mssql, Mysql) contains indexes on execution_time and last_heartbeat while for Oracle DB they are missing.

I also expanded DbUtiils method to allow splitting sql statements from an sql file. jdbcRunner.execute(statement, NOOP) can run only one statement at a time for Oracle Db.

PS: two tests for oracle db are failing on master, is that expected?

Reminders


cc @kagkarlsson

kagkarlsson commented 1 month ago

🎉 This issue has been resolved in v14.0.3 (Release Notes)