The Best of the Week (May 23): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (May 23 to May 29). Here they are, in order of popularity:

1. PostgreSQL 9.4 Beta 1 Released

Beta 1 of PostgreSQL 9.4 has been released. If you're interested in previewing the new features (and there are quite a few) of PostgreSQL 9.4, take a look.

2. Better Exceptions

I had the idea when I stumbled upon JUnit GitHub issue #706, which is about a new method proposal

3. Spring/Hibernate Improved SQL Logging with log4jdbc

Hibernate provides SQL logging out of the box, but such logging only shows prepared statements, and not the actual SQL queries sent to the database. This blog post will go over how to setup Hibernate query logging, and then compare it to the logging that can be obtained with log4jdbc .

4. Performance Tuning of Spring/Hibernate Applications

For most Spring/Hibernate enterprise applications, the performance depends almost entirely on that of its persistence layer. This post will go over how to confirm we are in the presence of a 'database-bound' application, and then walk through 7 frequently used 'quick-win' tips to help improve performance.

5. Oracle Tip: v$sql Table or View Does Not Exist

If we want to analyze execution plans on the SQL console, we probably need to find a SQL_ID first, which we can then pass to the DBMS_XPLAN.DISPLAY_CURSOR function. One way to find this SQL_ID is by querying the v$sql table first.