Understanding Connection Pooling

1. Introduction Connection Pooling is a technique to boost application’s performance where N connections to the database are opened and managed…

Read More »

SpringBoot : Working with JdbcTemplate

Spring provides a nice abstraction on top of JDBC API using JdbcTemplate and also provides great transaction management capabilities using…

Read More »

Easy Database Manipulation with Groovy and Gradle

Groovy:  The “Enterprise Hipster” Language Not everyone sees the Java programming language as sexy.  However, the Java virtual machine is…

Read More »

How we accidentally doubled our JDBC traffic with Hibernate

This post describes my recent experience with Hibernate ORM. Over the years the framework has not stopped to amaze me…

Read More »

Using the JDBC Insert Features in Oracle

Introduction In this article I will show an example of how to use the JDBC bulk insert features supported by…

Read More »

How does the MySQL JDBC driver handle prepared statements

Prepared statement types While researching for the Statement Caching chapter in my High-Performance Java Persistence book, I got the chance…

Read More »

Why you should always use connection pooling with Oracle XE

Introduction Oracle Express Edition is the free version of Oracle Enterprise Edition and its smaller size makes it very convenient…

Read More »

Installing PostgreSQL PL/Java as a PostgreSQL Extension

In 2011 I wrote a series of articles on PostgreSQL PL/Java. The basic information is still solid but there is…

Read More »

What’s Even Harder Than Dates and Timezones? Dates and Timezones in SQL / JDBC!

There was an interesting discussion recently on the jOOQ mailing list about jOOQ’s current lack of out-of-the-box support for TIMESTAMP…

Read More »