Logging JDBC Activity
From Apache OpenOffice Wiki
Revision as of 08:41, 23 May 2007 by Frank Schoenheit (Talk | contribs)
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