The Best of the Week (May 23): SQL Zone
Join the DZone community and get the full member experience.Join For Free
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:
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.
I had the idea when I stumbled upon JUnit GitHub issue #706, which is about a new method proposal
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 .
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.
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.
Opinions expressed by DZone contributors are their own.