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) |
(→SDBC(X) to wrapper) |
||
Line 111: | Line 111: | ||
|2 methods, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | |2 methods, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | ||
| | | | ||
− | | | + | |Table administration |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XColumnsSupplier.html XColumnsSupplier] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XColumnsSupplier.html XColumnsSupplier] | ||
|1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | |1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | ||
| | | | ||
− | | | + | |Table administration |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XDataDescriptorFactory.html XDataDescriptorFactory] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XDataDescriptorFactory.html XDataDescriptorFactory] | ||
|1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | |1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | ||
| | | | ||
− | | | + | |Table administration |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XIndexesSupplier.html XIndexedSupplier] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XIndexesSupplier.html XIndexedSupplier] | ||
|1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | |1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | ||
| | | | ||
− | | | + | |Table administration |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XKeysSupplier.html XKeysSupplier] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XKeysSupplier.html XKeysSupplier] | ||
|1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | |1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | ||
| | | | ||
− | | | + | |Table administration |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XRename.html XRename] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XRename.html XRename] | ||
|1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | |1 method, belongs to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] | ||
| | | | ||
− | | | + | |Table administration |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XDriver.html XDriver] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XDriver.html XDriver] | ||
Line 146: | Line 146: | ||
|1 method | |1 method | ||
| | | | ||
− | | | + | |Catalog/database administration |
|} | |} |
Revision as of 16:03, 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 [Database/Drivers/MySQL_Native/SDBC%28X%29_Interface 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
SDBC(X) to wrapper
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 |