Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Removed the info about connection meta-data sensor.
Tip
titleinspectIT already comes with out-of-the-box support for most databases

The inspectIT default configuration file already integrates database sensor configurations for most databases. Changes to the database sensor configuration are rarely needed.

...

Connection Meta-Data Sensor

Sensortype

Class

Description

Statement Sensor

info.novatec.inspectit.agent.sensor.method.jdbc.StatementSensor

Assigned to methods of classes that perform un-prepared SQL Statements

Connection Sensor

info.novatec.inspectit.agent.sensor.method.jdbc.ConnectionSensor

Assigned to the methods that create prepared Statements. Without the instrumenting of the Connection the concrete prepared Statements are not found by inspectIT

Prepared Statement Sensor

info.novatec.inspectit.agent.sensor.method.jdbc.PreparedStatementSensor

Assigned to the execute methods of prepared Statements

Prepared Statement Parameter Sensor

info.novatec.inspectit.agent.sensor.method.jdbc.PreparedStatementParameterSensor

Optional sensor that allows to trace the concrete values that a prepared statement had when it was executed. All methods that set the values in the prepared statement classes need to be assigned with this sensor type

info.novatec.inspectit.agent.sensor.method.jdbc.ConnectionMetaDataSensorAssigned to the constructors of the Connection(s) to obtain the metadata about the database to which the Connection object represents a connection.

Example sensor type definition (not necessary to change!)

Code Block
method-sensor-type jdbc-connection info.novatec.inspectit.agent.sensor.method.jdbc.ConnectionSensor MIN
method-sensor-type jdbc-prepared-statement info.novatec.inspectit.agent.sensor.method.jdbc.PreparedStatementSensor MIN
method-sensor-type jdbc-prepared-statement-parameter info.novatec.inspectit.agent.sensor.method.jdbc.PreparedStatementParameterSensor MIN
method-sensor-type jdbc-statement info.novatec.inspectit.agent.sensor.method.jdbc.StatementSensor MIN
method-sensor-type jdbc-connection-meta-data info.novatec.inspectit.agent.sensor.method.jdbc.ConnectionMetaDataSensor MIN

Prepared Statement Parameter Replacement

...