Blog: jooq (Lukas Eder)

213 blogs updated: 75 min. ago show: latest top this week top this month search:

Automatically Transform Oracle Style Implicit Joins to ANSI JOIN using jOOQ While jOOQ is mostly being used as an internal SQL DSL for embedded, dynamic SQL in Java, where it offers the best solution on the market, j... 3 17-11-2020 21:21:51 jooq (Lukas Eder) Advanced

jOOQ 3.14 Released With SQL/XML and SQL/JSON Support jOOQ 3.14 has been released with support for SQL/XML, SQL/JSON, Kotlin code generation, embeddable types, and domain types, synthetic constr... 16 20-10-2020 14:29:19 jooq (Lukas Eder) Advanced

Using jOOQ 3.14 Synthetic Foreign Keys to Write Implicit Joins on Views jOOQ has supported one of JPQL's most cool features for a while now: implicit joins. Using jOOQ, you can navigate your to-one relationships ... 10 14-10-2020 02:09:27 jooq (Lukas Eder) Advanced

Nesting Collections With jOOQ 3.14's SQL/XML or SQL/JSON support One of the main features of ORMs is M as in Mapping. Libraries like jOOQ help auto-mapping flat or nested database records onto Java classes... 17 09-10-2020 17:59:47 jooq (Lukas Eder) Advanced

Having "constant" columns in foreign keys I was asked a very interesting question on Twitter just now: @lukaseder quick q: in pg can I have a composite foreign key where one value is... 3 10-09-2020 10:26:11 jooq (Lukas Eder) Advanced

Use NATURAL FULL JOIN to compare two tables in SQL There are a few ways to compare two similar tables in SQL. Assuming PostgreSQL syntax, we might have this schema: It is now possible to use ... 16 05-08-2020 14:51:28 jooq (Lukas Eder) Advanced

Could we Have a Language That Hides Collections From Us? I just fixed a bug. The fix required me to initialise an Object[] array with the init values for each type, instead of just null, i.e. false... 13 22-07-2020 11:07:18 jooq (Lukas Eder) Advanced

Using SQL Server FOR XML and FOR JSON Syntax on Other RDBMS With jOOQ SQL Server supports transforming flat tabular SQL result sets into hierarchical structures by convention using the convenient FOR XML or FOR... 12 05-05-2020 18:55:07 jooq (Lukas Eder) Advanced

The Many Flavours of the Arcane SQL MERGE Statement The SQL MERGE statement is a device whose mystery is only exceeded by its power. A simple example shows its full power according to standard... 15 10-04-2020 11:40:54 jooq (Lukas Eder) Advanced

What's a "String" in the jOOQ API? One of jOOQ's biggest strength is the fact that it is a type safe SQL API. "Type safe", in this context, means that every object that you pu... 8 03-04-2020 11:38:52 jooq (Lukas Eder) Advanced

load next 10 items

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.

Made better & faster using https://www.yourkit.com/ Java Profiler