Difference between revisions of "Database/Drivers/MySQL Native/SDBC(X)2MySQL"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(One intermediate revision by one other user not shown)
Line 82: Line 82:
 
|[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/PreparedStatement.html PreparedStatement]
 
|Required by [http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/PreparedStatement.html PreparedStatement]
|
+
|PreparedResultSet
|Use wrapper and use PreparedResultSet for the returned XResultSetMetaData
+
|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]
Line 175: 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
Personal tools