Questions tagged [jooq-codegen-maven]

72 questions
1
vote
1 answer

jOOQ throws class file for java.util.concurrent.Flow not found for where condition

I'm using delete and update methods that uses 'where' function of jOOQ: public static void delete(DSLContext context, Table table, Condition condition) { context.delete(table) .where(condition) …
1
vote
1 answer

How to configure jOOQ auto generator to run on basis of liquibase schema xml file?

I want jOOQ auto-code generator to run on basis of liquibase schema xml file located in resources folder (not on basis of database connection). The configuration part looks like this in pom.xml:
1
vote
1 answer

jOOQ auto-generator is not running after liquibase update on doing mvn clean compile

I want jOOQ to auto-generate code based on the liquibase schema xml file that I have provided (not on basis of db connection). If I change something in liquibase xml file, the change reflects in the database, but I am not able the new auto-generated…
1
vote
1 answer

Running Quarkus in native Mode fails: Image Generation failed. Does Quarkus native Mode support Jooq Generation

Running ./mvnw package -Dnative followed by this error: [ERROR] [error]: Build step io.quarkus.deployment.pkg.steps.NativeImageBuildStep#build threw an exception:…
1
vote
1 answer

Deleting several rows in table of DB

I am using code-generator. I have two tables. In one table I have user_id an several docs of this user_id. In second table a have docs of this user_id, but without user_id and I have to delete these docs. Please help!
1
vote
1 answer

Why does the database float value is always generated by JOOQ generator as Double instead of Float

When the JOOQ generator generates the records using database tables, It maps the 'float' type column to Double instead of Float Why? Database: MySQL, Create statement: CREATE TABLE `product_attribute` ( `id` int NOT NULL auto_increment, `value`…
Sai Uttej
  • 199
  • 7
1
vote
2 answers

Jooq enum converter uses the ordinal number. How can I switch to use the enum value number instead?

We have an Enum class with customized values. The values are different from their ordinals intentionally for business purpose which I cannot change. enum class Role(val value: Int) { EXECUTOR(1), MONITOR(3), ADMIN(5), companion object { …
HeyThere
  • 503
  • 1
  • 5
  • 19
1
vote
1 answer

Could jOOQ(Java)-SQL translator API be self hosted?

I am using https://www.jooq.org/translate/ to translate SQL queries, and I want to translate SQL into jOOQ (Java) statements. Can the program for to this API provide an installation package for self-hosting? I want to deploy this API on my own…
1
vote
1 answer

jooq liquibase generation with maven plugin. Getting resource not found

I am trying to use the jooq code generation plugin to point to my liquibase change set. I am using the following plugin configuration org.jooq jooq-codegen-maven
Gokul
  • 237
  • 3
  • 13
1
vote
1 answer

Jooq forced type not being applied to column

I'm trying to use jOOQ with a postgres db featuring tsvectors. I added this to my configuration file : example.textsearch.TsVector .*tsvector.*
Vinz243
  • 9,654
  • 10
  • 42
  • 86
1
vote
1 answer

how to generate classes and properties using Entity bean class name and property names?

I'm successfully generating jOOQ classes using the jooq-codegen-maven plugin together with the jooq meta hibernate extension. The names of the generated classes and methods for tables/column are using the actual DB table and column names. Is…
1
vote
0 answers

Migrating oracle 11g to 19c using Jooq 3.7.1 version degrades performance(insertion) on database significantly

Currently we are using jooq 3.7.1 pro version and oracle 11g database in our application. Now we need to upgrade database from 11g to 19c, So we used ojdbc8.jar to connect to oracle 19c and passing ORACLE12C dialect as Jooq 3.7.1 provides dialect…
1
vote
1 answer

Is there a way to setup code generation in JOOQ for multiple schemas with the same table structure?

We have a multi-tenant database, where each tenant has their own dedicated schema. The schemas always have identical table structures. What I'm trying to figure out is if there's a way to pass the schema to JOOQ at query time when using code…
1
vote
1 answer

jOOQ code generation fails on triggers - how to skip them?

In my application I use Flyway to migrate the database. I have a SQL file containing the database structure which includes some CREATE TRIGGER statements. jOOQ code generation fails because it uses H2 which does not support triggers. What is the…
McPringle
  • 1,939
  • 2
  • 16
  • 19
1
vote
1 answer

Jooq codegen classes for ref-cursor on oracle12 and oracle19

I have plsql code in package context: type t_demand_for_excel_upload is record ( bsns_oper_name t_string, demand_date date, demand_hour integer, demand_value number ); type t_cur_demands_for_excel_upload is ref cursor return…