Difference between revisions of "Logging JDBC Activity"
From Apache OpenOffice Wiki
(→Logged Events) |
|||
Line 37: | Line 37: | ||
=== LogLevel.FINEST === | === LogLevel.FINEST === | ||
* meta data activitiy, such as asking for database properties and settings | * meta data activitiy, such as asking for database properties and settings | ||
+ | |||
+ | == Example == | ||
+ | Say you want to see erros which happen in an JDBC driver. With the Basic macros found in [http://wiki.services.openoffice.org/wiki/Category:Logging this article], this boils down to | ||
+ | * execute | ||
+ | <code>[starbasic] | ||
+ | setLogLevel( "org.openoffice.sdbc.jdbcBridge", com.sun.star.logging.LogLevel.SEVERE ) | ||
+ | </code> | ||
+ | * (maybe restart OpenOffice.org) |
Revision as of 08:54, 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
Example
Say you want to see erros which happen in an JDBC driver. With the Basic macros found in this article, this boils down to
- execute
[starbasic]
setLogLevel( "org.openoffice.sdbc.jdbcBridge", com.sun.star.logging.LogLevel.SEVERE )
- (maybe restart OpenOffice.org)