CODEWITHSUNDEEP
postgresqljooqmicronaut
Bernd Prager
Bernd Prager

Reputation: 99

Error CREATE DATABASE cannot run inside a transaction block

I am trying to create a database from a Java application running in Micronaut framework using jOOQ.

The code

contextSupplier.get().createDatabaseIfNotExists(this.databaseName).execute();

with a PostgreSQL datasource fails with:

org.jooq.exception.DataAccessException: SQL [do $$ begin create database "mydb"; exception when sqlstate '42P07' then null; end $$]; ERROR: CREATE DATABASE cannot run inside a transaction block

Is there a simple way to turn transactions off within jOOQ just for this statement?

Upvotes: 2

Views: 608

Answers (1)

Lukas Eder
Lukas Eder

Reputation: 221106

As of jOOQ 3.14, the DSLContext.createDatabaseIfNotExists() method is supported by these dialects (see its @Support annotation):

@Support({AURORA_POSTGRES,COCKROACHDB,MARIADB,MEMSQL,MYSQL,SQLDATAWAREHOUSE,SQLSERVER})

So, this statement is not yet supported in jOOQ for PostgreSQL - if I remember correctly, for this precise reason. Perhaps there's a different way to emulate the statement, but it hasn't been implemented yet.

Upvotes: 2

Related Questions