Difference between revisions of "Logging JDBC Activity"
From Apache OpenOffice Wiki
(→Logged Events) |
|||
Line 5: | Line 5: | ||
== Logged Events == | == Logged Events == | ||
− | Below are lists of which events are logged at which log level. | + | Below are lists of which events are logged at which log level. Note that if you [http://wiki.services.openoffice.org/wiki/Category:Logging#Enabling_a_logger_.2F_Setting_a_LogLevel enable logging for a certain level], then all events of this level <em>and above</em> are logged. Below, the levels are in decreasing order. |
+ | |||
+ | === LogLevel.SEVERE === | ||
+ | * a driver class which has not been set up correctly | ||
+ | * a failure in obtaining the JDBC connection which is to be bridged | ||
+ | * most (if not all) exceptions thrown by the JDBC driver | ||
+ | |||
+ | === LogLevel.WARNING === | ||
+ | No events are logged at this level. | ||
=== LogLevel.INFO === | === LogLevel.INFO === | ||
Line 12: | Line 20: | ||
* [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XStatement.html#executeQuery executeQuery] and [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XStatement.html#executeUpdate executeUpdate] calls | * [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XStatement.html#executeQuery executeQuery] and [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XStatement.html#executeUpdate executeUpdate] calls | ||
* setting the [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/Statement.html#EscapeProcessing escape processing] of a statement | * setting the [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/Statement.html#EscapeProcessing escape processing] of a statement | ||
+ | |||
+ | === LogLevel.CONFIG === | ||
+ | No events are logged at this level. | ||
=== LogLevel.FINE === | === LogLevel.FINE === |
Revision as of 08:51, 23 May 2007
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).
Contents
Logged Events
Below are lists of which events are logged at which log level. Note that if you enable logging for a certain level, then all events of this level and above are logged. Below, the levels are in decreasing order.
LogLevel.SEVERE
- a driver class which has not been set up correctly
- a failure in obtaining the JDBC connection which is to be bridged
- most (if not all) exceptions thrown by the JDBC driver
LogLevel.WARNING
No events are logged at this level.
LogLevel.INFO
- connecting to a database, and shutting down of connections
- execution and disposal of statements
- executeQuery and executeUpdate calls
- setting the escape processing of a statement
LogLevel.CONFIG
No events are logged at this level.
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