Database/Drivers/MySQL Native/SDBC(X) Interface
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 :-\