Databases
-
Software Development
10 SQL Articles Everyone Must Read
Weāve been blogging about Java and SQL for a while now, on the jOOQ blog. Over the years, while researching…
Read More » -
Software Development
Five easy steps to improve your database performance
January 30, 2015: Based on reader feedback, section 4 āDo you have enough database connections?ā has been revised. Database access…
Read More » -
Enterprise Java
How to fix optimistic locking race conditions with pessimistic locking
Recap In my previous post, I explained the benefits of using explicit optimistic locking. As we then discovered, thereās a…
Read More » -
Core Java
JDBC Tutorial – The ULTIMATE Guide (PDF Download)
In this post, we feature a comprehensive JDBC Tutorial (Java Database Connectivity), an API provided by Oracle that allows programmers…
Read More » -
Software Development
Declarative SQL Mode Pitfall
As we know a view object definition supports three SQL modes. There are normal, declarative and expertĀ modes. In this post…
Read More » -
Software Development
How to Emulate the MEDIAN() Aggregate Function Using Inverse Distribution Functions
Some databases are awesome enough to implement the MEDIAN() aggregate function. Remember that the MEDIAN() is sligthly different from (and…
Read More » -
Software Development
The Awesome PostgreSQL 9.4 / SQL:2003 FILTER Clause for Aggregate Functions
Sometimes when aggregating data with SQL, weād love to add some additional filters. For instance, consider the following world bank…
Read More » -
Enterprise Java
Leaky Abstractions, or How to Bind Oracle DATE Correctly with Hibernate
Weāve recently published an article about how to bind the Oracle DATE type correctly in SQL / JDBC, and jOOQ.…
Read More » -
Enterprise Java
A beginnerās guide to transaction isolation levels in enterprise Java
Introduction A relational database strong consistency model is based on ACID transaction properties. In this post we are going to…
Read More »
