Error CREATE DATABASE cannot run inside a transaction block

Question

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?

Why does it run inside a transaction? Can you please show your code? — Simon Martinelli
– Simon Martinelli, Commented Mar 2, 2021 at 10:44
@SimonMartinelli, that basically IS the entire code. I do not touch any transactional behavior other than what jOOQ does out of the box. — Bernd Prager
– Bernd Prager, Commented Mar 2, 2021 at 15:50

Lukas Eder · Accepted Answer · 2021-03-02 21:28:16Z

2

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.

edited Mar 2, 2021 at 21:28

answered Mar 2, 2021 at 16:02

Lukas Eder

224k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error CREATE DATABASE cannot run inside a transaction block

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related