Difference between revisions of "Database/Drivers/MySQL Native/SDBC(X)2MySQL"
From Apache OpenOffice Wiki
< Database | Drivers | MySQL Native
(→Mapping from SDBC(X) to the MySQL library interface) |
(→Mapping from SDBC(X) to the MySQL library interface) |
||
Line 3: | Line 3: | ||
Note: There will be an additional wrapper (Connector/OOo) to provide functionality not provided by the MySQL library interface. | Note: There will be an additional wrapper (Connector/OOo) to provide functionality not provided by the MySQL library interface. | ||
− | All interfaces listed are required core functionality. However, OOo might not use all methods of the interfaces, see [[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]]. |
{|class="wikitable" | {|class="wikitable" |
Revision as of 16:31, 13 May 2008
Mapping from SDBC(X) to the MySQL library interface
Note: There will be an additional wrapper (Connector/OOo) to provide functionality not provided by the MySQL library interface.
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, belongs 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 |