How to map PostgreSQL Enums to JPA entity properties using Hibernate

Introduction The open-source hibernate-types project allows you to map JSON, ARRAY, YearMonth, Month or database-specific columns (e.g. INET addresses). In…

Read More »

A beginner’s guide to read and write skew phenomena

Introduction In my article about ACID and database transactions, I introduced the three phenomena described by the SQL standard: dirty…

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 »

A paranoid’s guide to backing up a working folder

Oops time Leanpub supports multiple storage engines and a private GitHub repository is probably the safest way to the backing…

Read More »

How does FlexyPool support both Connection proxies and decorators

Proxies FlexyPool monitors connection pool usage and so it needs to intercept the connection close method call. For simplicity sake,…

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 »

How does FlexyPool support the Dropwizard Metrics package renaming

Introduction FlexyPool relies heavily on Dropwizard (previously Codahale) Metrics for monitoring the connection pool usage. Being integrated into Dropwizard, the…

Read More »

How to monitor a Java EE DataSource

Introduction FlexyPool is an open-source framework that can monitor a DataSource connection usage. This tool come out of necessity, since…

Read More »

How does Hibernate Query Cache work

Introduction Now that I covered both Entity and Collection caching, it’s time to investigate how Query Caching works. The Query…

Read More »