New Dialects It’s been a few releases since we’ve added support for new dialects, but finally some very interesting RDBMS of increasing popularity have joined the jOOQ family including: These dialects are available in all jOOQ editions. New dialect versions In addition to these entirely new dialects, big new CockroachDB and Oracle versions have shipped: … Continue reading jOOQ 3.19.0 Released with DuckDB, Trino, Oracle 23c support, join path improvements, an official gradle plugin, commercial maven repositories, policies, UDT paths, trigger meta data, hierarchies, and much more →

from Java, SQL and jOOQ. https://ift.tt/aOfGzDe
via IFTTT

Do you need to add a JDBC driver to your application, and don’t know its Maven coordinates? This blog post lists the most popular drivers from the jOOQ integration tests. Look up the latest versions directly on https://ift.tt/8Fmtpx2 with parameters g:groupId a:artifactId, for example, the H2 database and driver: https://ift.tt/Yisx6BG The list only includes drivers … Continue reading Maven Coordinates of the most popular JDBC Drivers →

from Java, SQL and jOOQ. https://ift.tt/oCqHtJv
via IFTTT

jOOQ’s DAO API is one of jOOQ’s most controversial features. When it was first implemented, it was implemented merely: There’s a strong hint about the third bullet given how popular Spring Data’s repository “pattern” is. A lot of developers just want to quickly fetch and store data, without giving individual queries much thought. A fun … Continue reading To DAO or not to DAO →

from Java, SQL and jOOQ. https://ift.tt/0u5dN4X
via IFTTT

Need to connect to your RDBMS with JDBC and don’t have the JDBC connection URL or driver name at hand? No problem, just look up your RDBMS below:

from Java, SQL and jOOQ. https://ift.tt/3bFCQhW
via IFTTT

Java’s package private visibility is an underrated feature. When you omit any visibility modifier in Java, then the default (for most objects) is package private, i.e. the object is visible only to types in the same package: In fact, a compilation unit (the .java file) can contain multiple such classes. You don’t have to create … Continue reading How to Generate Package Private Code with jOOQ’s Code Generator →

from Java, SQL and jOOQ. https://ift.tt/Pmz06lw
via IFTTT