Difference between revisions of "Documentation/DevGuide/Database/The SDBC Driver for ODBC"
From Apache OpenOffice Wiki
< Documentation | DevGuide
OOoWikiBot (Talk | contribs) m (Robot: Changing Category:Database Access) |
m |
||
(2 intermediate revisions by one other user not shown) | |||
Line 7: | Line 7: | ||
|NextPage=Documentation/DevGuide/Database/The SDBC Driver for Adabas D | |NextPage=Documentation/DevGuide/Database/The SDBC Driver for Adabas D | ||
}} | }} | ||
− | {{DISPLAYTITLE:The SDBC Driver for ODBC}} | + | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Database/{{SUBPAGENAME}}}} |
+ | {{DISPLAYTITLE:The SDBC Driver for ODBC}} | ||
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: | 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: | ||
Line 19: | Line 20: | ||
|- | |- | ||
|<idlm>com.sun.star.sdbc.ODBCConnectionProperties:Silent</idlm> | |<idlm>com.sun.star.sdbc.ODBCConnectionProperties:Silent</idlm> | ||
− | |<code>boolean</code> - If <code>True</code>, the ODBC driver will not be asked for completion. This may happen if the | + | |<code>boolean</code> - If <code>True</code>, the ODBC driver will not be asked for completion. This may happen if the username and password are already known. Otherwise <code>False</code>. |
|- | |- | ||
|<idlm>com.sun.star.sdbc.ODBCConnectionProperties:Timeout</idlm> | |<idlm>com.sun.star.sdbc.ODBCConnectionProperties:Timeout</idlm> | ||
Line 31: | Line 32: | ||
|- | |- | ||
|<idlm>com.sun.star.sdbc.ODBCConnectionProperties:Charset</idlm> | |<idlm>com.sun.star.sdbc.ODBCConnectionProperties:Charset</idlm> | ||
− | |<code>string</code> - Converts data from the ODBC driver into the corresponding text encoding. The value must be a value of the list from [ | + | |<code>string</code> - Converts data from the ODBC driver into the corresponding text encoding. The value must be a value of the list from [https://www.iana.org/assignments/character-sets www.iana.org/assignments/character-sets]. Only a few character sets are supported |
|- | |- | ||
|<idlm>com.sun.star.sdbc.ODBCConnectionProperties:ParameterNameSubstitution</idlm> | |<idlm>com.sun.star.sdbc.ODBCConnectionProperties:ParameterNameSubstitution</idlm> | ||
Line 39: | Line 40: | ||
{{PDL1}} | {{PDL1}} | ||
− | [[Category:Documentation/ | + | [[Category:Documentation/Developer's Guide/Database Access]] |
Latest revision as of 14:11, 21 December 2020
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). |