The SDBC Driver for ODBC

From Apache OpenOffice Wiki
Jump to: navigation, search



This driver is comparable to the SDBC driver for JDBC described above. It maps the ODBC functionality to the SDBC API, but not completely. However, some functionality the SDBC API supports may not work with ODBC, because an ODBC driver may not support this feature and throws an SQL Exception to indicate this. To create a new connection, the driver uses the following URL format:

 sdbc:odbc: Name of a datasource defined in the system

Additionally, this driver supports several properties through the service com.sun.star.sdbc.ODBCConnectionProperties. These properties are set while creating a connection:

Properties of com.sun.star.sdbc.ODBCConnectionProperties
Silent boolean - If True, the ODBC driver will not be asked for completion. This may happen if the username and password are already known. Otherwise False.
Timeout int - A value corresponding to the number of seconds to wait for any request on the connection to complete before returning to the application.
UseCatalog boolean - If False, the SDBC driver should not use catalogs. Otherwise True.
SystemDriverSettings string - Settings that are submitted to the ODBC driver directly.
Charset string - Converts data from the ODBC driver into the corresponding text encoding. The value must be a value of the list from www.iana.org/assignments/character-sets. Only a few character sets are supported
ParameterNameSubstitution boolean - If True, all occurrences of "?" as a parameter name will be replaced by a valid parameter name. This is for some drivers that mix the order of the parameters.
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages