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 8: | Line 8: | ||
!SDBC(X) | !SDBC(X) | ||
!Comment | !Comment | ||
| − | !MySQL | + | !Underlying MySQL library |
!Comment | !Comment | ||
|- | |- | ||
| Line 34: | Line 34: | ||
|Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/ResultSet.html ResultSet] | |Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/ResultSet.html ResultSet] | ||
|PreparedResultSet::findColumn() - ResultSet::findColumn() | |PreparedResultSet::findColumn() - ResultSet::findColumn() | ||
| − | |Use wrapper | + | |Use wrapper (C/OOo) to implement it |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/beans/XPropertySet.html XPropertySet] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/beans/XPropertySet.html XPropertySet] | ||
|Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/ResultSet.html ResultSet] | |Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/ResultSet.html ResultSet] | ||
| | | | ||
| − | |Missing, | + | |Missing, Use wrapper (C/OOo) to implement it |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XResultSetMetaDataSupplier.html XResultSetMetaDataSupplier] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XResultSetMetaDataSupplier.html XResultSetMetaDataSupplier] | ||
| Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/ResultSet.html ResultSet], returns [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XResultSetMetaData.html XResultSetMetaData], one method only | | Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/ResultSet.html ResultSet], returns [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XResultSetMetaData.html XResultSetMetaData], one method only | ||
| ResultSetMetadata | | ResultSetMetadata | ||
| − | | Use wrapper | + | |Use wrapper (C/OOo) to implement it |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XResultSetMetaData.html XResultSetMetaData] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XResultSetMetaData.html XResultSetMetaData] | ||
| | | | ||
| ResultSetMetadata | | ResultSetMetadata | ||
| − | | Use wrapper | + | |Use wrapper (C/OOo) to implement it |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XRow.html XRow] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XRow.html XRow] | ||
Revision as of 17:19, 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 | Underlying MySQL library | 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 (C/OOo) to implement it |
| XPropertySet | Required by ResultSet | Missing, Use wrapper (C/OOo) to implement it | |
| XResultSetMetaDataSupplier | Required by ResultSet, returns XResultSetMetaData, one method only | ResultSetMetadata | Use wrapper (C/OOo) to implement it |
| XResultSetMetaData | ResultSetMetadata | Use wrapper (C/OOo) to implement it | |
| 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 |
