Difference between revisions of "Logging JDBC Activity"
From Apache OpenOffice Wiki
| Line 3: | Line 3: | ||
[[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). | [[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. | Below are lists of which events are logged at which log level. | ||
=== LogLevel.INFO === | === LogLevel.INFO === | ||
| − | * | + | * connecting to a database, and shutting down of connections |
| + | * execution and disposal of [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/Statement.html statements] | ||
| + | * [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 | ||
=== LogLevel.FINE === | === LogLevel.FINE === | ||
Revision as of 08:46, 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
- 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.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
