3.18.0 Launch with Help for extra Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 – Java, SQL and jOOQ.

on

|

views

and

comments

[ad_1]

DiagnosticsListener enhancements

Plenty of further diagnostics have been added, together with the automated detection of sample replacements, serving to you lint your SQL queries regardless of whether or not you’re utilizing jOOQ to jot down your SQL, or in case you’re utilizing it as a JDBC / R2DBC proxy for an present utility.

Plenty of these diagnostics can be found as abnormal sample transformations, which we’ve began including in jOOQ 3.17. Some new patterns embody:

  • CASE WHEN a = b THEN 1 END to CASE a WHEN b THEN 1 END
  • CASE WHEN x IS NULL THEN y ELSE x END to NVL(x, y)
  • CASE WHEN x = y THEN NULL ELSE x END to NULLIF(x, y)
  • (SELECT COUNT(*) FROM t) > 0 to EXISTS(SELECT 1 FROM t)
  • And way more

See these sections for extra particulars:

Extra SQL/JSON assist

SQL/JSON is among the most promising latest additions to the SQL language, and we’re at all times eager on enhancing jOOQ’s assist for these options. On this launch, we’ve added assist for quite a lot of helpful, vendor particular SQL/JSON extensions, together with:

  • JSON_KEYS (from MySQL)
  • JSON_SET (from MySQL)
  • JSON_INSERT (from MySQL)
  • JSON_REPLACE (from MySQL)
  • JSON_REMOVE (from MySQL)
  • Accessors -> and ->> (from PostgreSQL)

Extra info on new JSON perform assist might be discovered right here

Extra QOM implementation

The Question Object Mannequin (QOM) API, which was launched in jOOQ 3.16, has been enhanced with extra assertion, perform, expression assist, permitting for extra full SQL transformation and traversal. That is particularly fascinating for sample replacements, diagnostics, and customized SQL transformations.

The QOM API continues to be in an experimental state. Whereas we don’t count on any basic modifications anymore, there can nonetheless be supply incompatibilities between minor releases.

For extra particulars in regards to the mannequin API, click on right here

Oracle associative array assist

When utilizing saved procedures in Oracle, customers are seemingly going to make heavy use of Oracle PL/SQL bundle sorts. We’ve supported PL/SQL RECORD sorts and PL/SQL TABLE sorts for some time, each of which had restricted ojdbc assist prior to now. Associative array assist can nonetheless be a problem with ojdbc, however with jOOQ and its code generator, most associative arrays might be sure and fetched very simply.

PostgreSQL Multi dimensional array sorts

An usually requested function from our PostgreSQL integration is multi dimensional array assist. This model of jOOQ will assist these sorts in code era (the place doable) and at runtime through multi dimensional Java arrays.

Kotlin particular enhancements

jOOQ can be one of the simplest ways to jot down SQL in kotlin. We’re at all times searching for brand new comfort through the jOOQ-kotlin extension module, for instance:

  • ResultQuery Collectors
  • JSON entry
  • Extra nullability assist in generated code

For extra particulars, see this part of the guide

R2DBC 1.0 assist

This jOOQ model upgrades its R2DBC dependency to 1.0.0.RELEASE.

The complete launch notes might be discovered right here.

[ad_2]

Supply hyperlink

Share this
Tags

Must-read

Google Presents 3 Suggestions For Checking Technical web optimization Points

Google printed a video providing three ideas for utilizing search console to establish technical points that may be inflicting indexing or rating issues. Three...

A easy snapshot reveals how computational pictures can shock and alarm us

Whereas Tessa Coates was making an attempt on wedding ceremony clothes final month, she posted a seemingly easy snapshot of herself on Instagram...

Recent articles

More like this

LEAVE A REPLY

Please enter your comment!
Please enter your name here