Over a million developers have joined DZone.

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

· Performance Zone

Download Forrester’s “Vendor Landscape, Application Performance Management” report that examines the evolving role of APM as a key driver of customer satisfaction and business success, brought to you in partnership with BMC.

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.

See Forrester’s Report, “Vendor Landscape, Application Performance Management” to identify the right vendor to help IT deliver better service at a lower cost, brought to you in partnership with BMC.


The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}