Logging JDBC Activity

From Apache OpenOffice Wiki
Jump to: navigation, search

Base's JDBC bridge - the database driver to access database with an JDBC compliant driver - allows to log its activity. For this, the driver uses a logger named "org.openoffice.sdbc.jdbcBridge" (see Logging for more information about loggers).

Logged Events

Below are lists of which events are logged at which log level.

LogLevel.INFO

LogLevel.FINE

  • statement related connection activity, such as creation and preparation of statements and calls
  • successful retrieving of a system JDBC connection

LogLevel.FINER

  • setting certain statement attributes such as fetch direction and fetch size
  • setting parameters of a prepared statement
  • translating SQL statements to native SQL
  • the update count of statements

LogLevel.FINEST

  • meta data activitiy, such as asking for database properties and settings
Personal tools