Difference between revisions of "Database/Drivers/MySQL Native/SDBC(X)2MySQL"
From Apache OpenOffice Wiki
< Database | Drivers | MySQL Native
(→SDBCX to wrapper) |
(→Mapping from SDBC(X) to the MySQL library interface) |
||
Line 1: | Line 1: | ||
== Mapping from SDBC(X) to the MySQL library interface == | == Mapping from SDBC(X) to the MySQL library interface == | ||
− | + | Connector/OOo is a wrapper above of an underlying MySQL library. The underlying library needs to provide all required methods to C/OOo which C/OO cannot "emulate". The table shows if any methods are missing in the underlying library. It says nothing about the completeness of C/OOo as such. Its only purpose is to find out if C/OOo gets from the library all it needs. | |
All interfaces listed are required core functionality. However, OOo might not use all methods of the interfaces, see [[Database/Drivers/MySQL_Native/SDBC%28X%29_Interface|SDBC(X) Interface]]. | All interfaces listed are required core functionality. However, OOo might not use all methods of the interfaces, see [[Database/Drivers/MySQL_Native/SDBC%28X%29_Interface|SDBC(X) Interface]]. |
Revision as of 17:17, 13 May 2008
Mapping from SDBC(X) to the MySQL library interface
Connector/OOo is a wrapper above of an underlying MySQL library. The underlying library needs to provide all required methods to C/OOo which C/OO cannot "emulate". The table shows if any methods are missing in the underlying library. It says nothing about the completeness of C/OOo as such. Its only purpose is to find out if C/OOo gets from the library all it needs.
All interfaces listed are required core functionality. However, OOo might not use all methods of the interfaces, see SDBC(X) Interface.
SDBC(X) | Comment | MySQL | Comment |
---|---|---|---|
XConnection | Connection | 5 methods missing (13.05.2008) | |
XDatabaseMetaData | ConnectionMetaData | 80% done (13.05.2008) | |
XDriver | Driver | 2 methods missing, use wrapper to provide them | |
XResultSet | ResultSet | 2 methods missing | |
XColumnLocate | Required by ResultSet | PreparedResultSet::findColumn() - ResultSet::findColumn() | Use wrapper |
XPropertySet | Required by ResultSet | Missing, use wrapper | |
XResultSetMetaDataSupplier | Required by ResultSet, returns XResultSetMetaData, one method only | ResultSetMetadata | Use wrapper |
XResultSetMetaData | ResultSetMetadata | Use wrapper | |
XRow | Required by ResultSet | ||
XRowUpdate | Required by ResultSet | ||
XPreparedStatement | PreparedStatement | 50% done (13.05.2008) | |
XCloseable | Required by PreparedStatement - is it optional? | ||
XPropertySet | Required by PreparedStatement | ||
XParameters | Required by PreparedStatement | ||
XWarningSupplier | Required by PreparedStatement | ||
XMultipleResults | Required by PreparedStatement | ||
XStatement | Statement | 100% complete |
Potential problems with the library
- Connection::prepareCall() - not supported
SDBCX to wrapper
In the first step we need no more but the table administration.
SDBC(X) | Comment | MySQL | Comment |
---|---|---|---|
XAlterTable | 2 methods, belong to Table | Table administration | |
XColumnsSupplier | 1 method, belongs to Table | Table administration | |
XDataDescriptorFactory | 1 method, belongs to Table | Table administration | |
XIndexedSupplier | 1 method, belongs to Table | Table administration | |
XKeysSupplier | 1 method, belongs to Table | Table administration | |
XRename | 1 method, belongs to Table | Table administration | |
XDriver | Driver | 2 methods missing, use wrapper | |
XCreateCatalog | 1 method | Catalog/database administration | |
XDropCatalog | 1 method | Catalog/database administration | |
XDropCatalog | 1 method | Catalog/database administration | |
XUsersSupplier | 1 method | User/account administration | |
XUser | User/account administration |