Database/Drivers/MySQL Native/SDBC(X) Interface

From Apache OpenOffice Wiki
< Database‎ | Drivers‎ | MySQL Native
Revision as of 10:51, 6 May 2008 by Frank Schoenheit (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database drivers in OpenOffice.org need to adhere to the SDBC API, alternatively to (selected parts of) the SDBCX API.

Those APIs were originally modeled after JDBC (quite some times ago), but didn't evolve with JDBC. Also, not all the API defined in SDBC(X) is actually used in OpenOffice.org.

The concepts in SDBC are pretty similar to what you expect from other database APIs - connections, (prepared) statements, result sets, ... nothing really surprising.

Looking over the interfaces, a minimal driver implementation for OOo probably needs to support

Talking about interfaces, this means

  • XDriver
  • XConnection
  • XDatabaseMetaData
  • XStatement
  • XPreparedStatement
  • XParameters
  • XResultSet*
  • XRow
  • XRowUpdate

Talking about methods .... well, that's hard to determine. Admittedly, there simply is no comprehensive specification of what OOo expects a driver to support. A significant part of a driver development is to debug OOo and find out what it expects from the driver :-\

Personal tools