Difference between revisions of "Logging JDBC Activity"
From Apache OpenOffice Wiki
| Line 1: | Line 1: | ||
[[Category:Logging]] | [[Category:Logging]] | ||
| − | [[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 [http://wiki.services.openoffice.org/wiki/Category:Logging Logging] for more information about loggers). | + | [[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 "<code>org.openoffice.sdbc.jdbcBridge</code>" (see [http://wiki.services.openoffice.org/wiki/Category:Logging 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 [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html prepared statement] | ||
| + | * translating SQL statements to native SQL | ||
| + | * the [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XMultipleResults.html#getUpdateCount update count] of statements | ||
| + | |||
| + | === LogLevel.FINEST === | ||
| + | * meta data activitiy, such as asking for database properties and settings | ||
Revision as of 08:41, 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).
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
