JDBC
If required, you can choose to resolve parameters of prepared statements. By default,
those parameters are shown as question marks in the hot spots view
and the event view. Resolving these parameters
makes the hot spots view more cluttered, but can be useful for debugging purposes.
To group unprepared statements in the hot spots view, you can select the "Replace literals in unprepared statements"
option. JProfiler analyzes the SQL statement and tries to replace literals with question marks. For certain SQL
dialects and delimiter options, this may have no effect or yield partial replacements. By default,
this literal replacement is not performed in the events view of the JDBC probe. The "Keep literals for events view"
option can be deselected to change this behavior.
To activate the connection leaks analysis when probe recording is started, select the "Record open virtual
connections for connection leak analysis" check box. Once the session is running, the "Connection leaks" view
of the JDBC probe also shows a recording button that allows you to switch the connection leak detection on
and off.