Avoid Extra SQL

Inspect generated SQL for extra calls. Tools like Oracle's tkprof, Yourkit java profiler, or debug application logs can help identify extra database calls. The screen capture below shows how Yourkit is able to reveal SQL statements behind PreparedStatement calls.

Yourkit Demo: http://www.yourkit.com/docs/demo/JavaEE/JavaEE.htm

Untitled: image108