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).
Exploring the two JDBC driver options for connecting to Apache Flink: the new Flink JDBC driver and the Hive JDBC driver via the SQL Gateway.
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.
Resolving a Kafka Connect JDBC error with Oracle due to case-sensitive table names in connector configuration.
A technical guide on connecting to Oracle Business Intelligence (OBIEE) using the JDBC driver and the jisql command-line client.
A tutorial on connecting to Apache Hive using the open-source SQL Workbench tool via JDBC, covering driver setup and connection configuration.
A guide on connecting to and working with Windows Azure SQL Database directly within the PhpStorm IDE, covering setup, queries, and database management.
Troubleshooting an ODI 10g connection error with OCI, identifying the issue as an incorrect ojdbc5.jar driver version.
Comparing Oracle JDBC drivers for OBIEE Publisher scheduler, highlighting better error feedback from oracle.bi.jdbc.AnaJdbcDriver.
Technical guide on configuring OBIEE Publisher's JDBC connection to a clustered Oracle BI Server, troubleshooting connection string syntax and cluster controller settings.
A summary of a talk on advanced Aspect-Oriented Programming (AOP) concepts, including practical examples using Hibernate and JDBC.
