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) |
B michaelsen (Talk | contribs) |
||
(6 intermediate revisions by 3 users not shown) | |||
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]]. | ||
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] | ||
Line 66: | Line 66: | ||
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XCloseable.html XCloseable] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XCloseable.html XCloseable] | ||
− | | Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html PreparedStatement] | + | | Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html PreparedStatement] |
| | | | ||
− | | | + | | basically implements freeing of resources; 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] | ||
Line 79: | Line 79: | ||
| | | | ||
| | | | ||
+ | |- | ||
+ | |[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/PreparedStatement.html PreparedStatement] | ||
+ | |PreparedResultSet | ||
+ | |Use wrapper (C/OOo) and use PreparedResultSet for the returned XResultSetMetaData | ||
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XWarningsSupplier.html XWarningSupplier] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XWarningsSupplier.html XWarningSupplier] | ||
|Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html PreparedStatement] | |Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html PreparedStatement] | ||
| | | | ||
− | | | + | | can probably be omitted (aka: implemented as dummy) in a first step, nobody makes use of it as of today |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XMultipleResults.html XMultipleResults] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XMultipleResults.html XMultipleResults] | ||
|Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html PreparedStatement] | |Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html PreparedStatement] | ||
| | | | ||
− | | | + | | can probably be omitted (aka: implemented as dummy) in a first step, nobody makes use of it as of today |
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XStatement.html XStatement] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XStatement.html XStatement] | ||
Line 111: | Line 116: | ||
|- | |- | ||
|[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XAlterTable.html XAlterTable] | |[http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/XAlterTable.html XAlterTable] | ||
− | |2 methods, | + | |2 methods, belong to [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/Table.html Table] |
| | | | ||
|Table administration | |Table administration | ||
Line 170: | Line 175: | ||
|User/account administration | |User/account administration | ||
|} | |} | ||
+ | [[Category:MySQL]] |
Latest revision as of 21:42, 15 December 2009
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 | basically implements freeing of resources; use wrapper (C/OOo) to implement it | |
XPropertySet | Required by PreparedStatement | ||
XParameters | Required by PreparedStatement | ||
XResultSetMetaDataSupplier | Required by PreparedStatement | PreparedResultSet | Use wrapper (C/OOo) and use PreparedResultSet for the returned XResultSetMetaData |
XWarningSupplier | Required by PreparedStatement | can probably be omitted (aka: implemented as dummy) in a first step, nobody makes use of it as of today | |
XMultipleResults | Required by PreparedStatement | can probably be omitted (aka: implemented as dummy) in a first step, nobody makes use of it as of today | |
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 |