A developer explains how to configure a ColdFusion JDBC connection string to use UTC time, fixing a 5-hour time discrepancy with MySQL.
A reference list of Maven coordinates (groupId and artifactId) for the most popular JDBC drivers, sourced from jOOQ integration tests.
A reference list of JDBC driver names and connection URL formats for numerous popular relational database management systems (RDBMS).
Explains a caveat with using jOOQ's ad-hoc converters in UNION operations and provides solutions for proper client-side type conversion.
Explains how to call stored procedures with default parameters using jOOQ and JDBC, covering syntax for Oracle, PostgreSQL, and other databases.
Explores various SQL dialects and jOOQ methods for returning data from INSERT, UPDATE, and DELETE statements using the RETURNING clause.
Explains how to use jOOQ to call stored procedures from Java, highlighting benefits over raw JDBC for type safety and maintainability.
Explores whether setting JDBC Statement.setFetchSize(1) for single-row queries improves performance, with benchmark results across databases.
Explains jOOQ's API for managing nested transactions, comparing it to JDBC defaults and Spring's @Transactional behavior.
Oracle 19c Docker containers timeout with JDBC driver versions 19.3.0.0+, causing a 'Got minus one from read call' error. The fix is to set oracle.net.disableOob=true.
Exploring how to use Java 16's new Unix-domain socket support to connect to a PostgreSQL database for improved security and performance.
A guide on connecting to and working with Windows Azure SQL Database directly within the PhpStorm IDE, covering setup, queries, and database management.
A summary of a talk on advanced Aspect-Oriented Programming (AOP) concepts, including practical examples using Hibernate and JDBC.
A summary of a talk by Spring JDBC lead Thomas Risberg on performance tuning for data access in Spring applications, covering JDBC, transactions, and ORM configuration.
