Database/Drivers/MySQL Native/SDBC(X)2MySQL

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