Databases


  The JEE & Probes is one of two probe sections in JProfiler. This section features the following built-in probes:
  •  JDBC

    The control objects are database connections which can be in the following active states:

    • Statement execution
      A statement created via one of the java.sql.Connection#createStatement(...) methods is being executed.
    • Prepared statement execution
      A statement created via one of the java.sql.Connection#prepareStatement(...) or java.sql.Connection#prepareCall(...) methods is being executed.
    • Batch execution
      java.sql.Statement#executeBatch() is being executed on a statement.

    The probe annotates the SQL strings of statements into the call tree and shows them in the hot spots view. Bound values are not shown for prepared statements. This can be changed in the probe settings.

    The following telemetries are provided:

    • Executed statements
      The number of executed statements per second.
    • Average statement execution time
      The average execution time in seconds for statements that completed in the last second.
    • Recorded open connections
      The number of open database connections at any time.
  •  JPA/Hibernate

    There are no control objects for this view, so the probe does not have time line and control objects views.

    The probe annotates the SQL strings of persistence operations into the call tree and shows them in the hot spots view.

    The following telemetries are provided:

    • Entity Operation Count
      The number of entity operations per second.
    • Query Count
      The number of executed queries per second.
    • Query Duration
      The average duration of queries in the last second.
  •  MongoDB

    There are no control objects for this view, so the probe does not have time line and control objects views.

    The probe annotates MongoDB operations into the call tree and shows them in the hot spots view.

    The detected MongoDB operation types are

    • Query
    • Retrieve data
    • Update
    • Insert
    • Delete
    • Other

    The probe replaces primitive data with question marks. This can be changed in the probe settings.

    The following telemetries are provided:

    • Executed operations
      The number of executed operations per second.
    • Average operations execution time
      The average execution time in seconds for operations that completed in the last second.
  •  Cassandra

    There are no control objects for this view, so the probe does not have time line and control objects views.

    The probe annotates Cassandra CQL queries into the call tree and shows them in the hot spots view.

    Two query types are distinguished:

    • Statements
    • Prepared statements

    Bound values for prepared statements are not displayed.

    The following telemetries are provided:

    • Executed operations
      The number of executed operations per second.
    • Average operations execution time
      The average execution time in seconds for operations that completed in the last second.
  •  HBase

    There are no control objects for this view, so the probe does not have time line and control objects views.

    The probe annotates HBase commands into the call tree and shows them in the hot spots view.

    The detected HBase operation types are

    • Scanner open
    • Scanner fetch
    • Query
    • Modify
    • Map-reduce
    • Aggregation

    The following telemetries are provided:

    • Executed operations
      The number of executed operations per second.
    • Average operations execution time
      The average execution time in seconds for operations that completed in the last second.