jOOQ icon indicating copy to clipboard operation
jOOQ copied to clipboard

jOOQ is the best way to write SQL in Java

Results 866 jOOQ issues
Sort by recently updated
recently updated
newest added

Currently, we cannot batch stored procedure calls through the jOOQ API as is possible through JDBC ---- See also: - https://groups.google.com/forum/#!topic/jooq-user/o0Zd9rKoxlg - https://stackoverflow.com/q/47185044/521799

T: Enhancement
C: Functionality
P: Medium

Do its have IGNORE in dsl.update() observer object? http://dev.mysql.com/doc/refman/5.7/en/update.html sql: (UPDATE IGNORE ...) I cant find it.

T: Enhancement
C: Functionality
C: DB: MySQL
P: Medium
E: All Editions

When using `DSLContext::connection` or `DSLContext::connectionResult`, there's currently no `ExecuteContext` available, meaning that any UDT types that may need to be registered are unavailable to the `ConnectionRunnable` or `ConnectionCallable`. This is...

T: Defect
C: Functionality
P: High
E: All Editions

We should probably add support for all the `RANGE` functions available here: https://www.postgresql.org/docs/current/functions-range.html E.g. `UPPER(anyrange)` would be quite useful. Since all of these types are part of this extensions module,...

T: Enhancement
C: Functionality
C: DB: PostgreSQL
P: Medium
E: All Editions

We've just upgraded to jOOQ 3.17, since we are interested in the new `LTREE` type that is included in the `org.jooq:jooq-postgres-extensions` package. We've read [this](https://blog.jooq.org/3-17-0-release-with-computed-columns-audit-columns-pattern-matching-reactive-transactions-and-kotlin-coroutine-support/) blogpost, installed the required package...

C: Code Generation
P: Medium
T: Support request
R: Feedback Pending
E: All Editions

Creating this issue as suggested by Lukas Eder here: https://stackoverflow.com/questions/73083090/jooq-fetchinto-with-fieldsrow-returns-null-for-record-object-but-not-for-pojo. ### Expected behavior When calling `fieldsRow()` within a `multiset` call, a fetched Record object has all fields correctly populated. ###...

T: Defect
C: Functionality
P: Medium
E: All Editions

### Use case: The use of default arguments (no arguments specified) when calling the constructor of the generated `Record` class appears to be using the table defaults. On the other...

T: Enhancement

The popular code generation catalog and schema mapping feature is used mainly for multi tenancy purposes: https://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/codegen-config-database/codegen-database-catalog-and-schema-mapping/ It could be extended to all types of identifiers, including table and columns,...

T: Enhancement
C: Code Generation
P: Medium
E: All Editions

Presto ([old site](https://prestodb.io/), [new site](https://prestosql.io/), see [comment below](https://github.com/jOOQ/jOOQ/issues/5414#issuecomment-526102959)) is an open source SQL engine used in big data scenarios. We use it with the community edition of jOOQ and would...

T: Enhancement
P: Medium
E: All Editions
C: DB: Presto

### Expected behavior Application should not hang when running `DSL.using()` from two codepaths. The actual production breakage involved running two `DSL.using()` triggered from two codepaths: one manual invocation alongside one...

T: Defect
C: Functionality
P: High
E: All Editions