The Free and Open Productivity Suite
Follow us on Twitter: @ApacheOO

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: com :: sun :: star ::

module sdbcx
Description
High-level database component interfaces.

Services
Column describes the common properties of a database column.
ColumnDescriptor describes the common properties of a database column. Could be used for the creation of a database columns within a table.
Container describes every container which is used for data definition. Each container must support access to its elements by the element's name or by the element's position.
DatabaseDefinition could be used as an extension for performing data definition tasks on databases, and to control the access rights on database objects.
Descriptor is used to create a new object within a database.
Driver extends the service ::com::sun::star::sdbc::Driver by beans for data definition.
Group represents a group of users, which has certain access rights for the objects of the database.
GroupDescriptor is used to create a new group in a database.
Index is used to specify the index for a database table. It refers to one or more columns of a table.
IndexColumn adds a property to determine the sort order of the column values within the index. Some database drivers may ignore this property.
IndexColumnDescriptor adds a property to determine the sort order of the column values within the index. Some database drivers may ignore this property.
IndexDescriptor is used to define a new index for a database table.
Key is used to define a new key for a table.
KeyColumn adds a property to specify the referenced column. This is used to specify foreign keys.
KeyColumnDescriptor adds a property to specify the referenced column. This is used to specify foreign keys.
KeyDescriptor is used to define a new key for a table.
PreparedStatement extends the definition of the service ::com::sun::star::sdbc::PreparedStatement with a flag for the usage of bookmarks.
ReferenceColumn adds a property to specify the referenced column. This is used to specify foreign keys.
ResultSet extends the SDBC ResultSet by the possibility of bookmark positioning, cancelling the positioning, and updating of rows.
Statement extends the definition of the service ::com::sun::star::sdbc::Statement with a flag for the usage of bookmarks.
Table used to specify a table in a database. A table is described by its name and one or more columns.
TableDescriptor is used to define a table of a database. A table is described by its name and one or more columns and the keys for semantic rules.
User represents a user of the database, who has certain access rights for the objects of the database.
UserDescriptor is used to create a new user in a database.
View is used to specify views on data. A view object is only used for creation and deletion. Inspecting the command of a view is normally not supported.
ViewDescriptor is used to define a new view for a database.
Interfaces
XAlterTable is used for creating and appending new objects to a specific container.
XAlterView implements the possibility to alter aspects of a view's definition
XAppend is used for creating and appending new objects to a specific container.
XAuthorizable is used for accessing and setting the permissions of a user for a database object.
XColumnsSupplier provides the access to a container of columns, typically used for tables and indexes.
XCreateCatalog may be implemented to hide the complexity of creating a database catalog.
XDataDefinitionSupplier provides the access to data definition beans from a connected database.
XDataDescriptorFactory provides the creation of a descriptor for a definition object.
XDeleteRows provides for the deletion of more than one row at a time.
XDrop provides methods to remove an element of its container and to drop it from the related database.
XDropCatalog may be implemented to hide the complexity of dropping a database catalog. Could normally be used only in offline mode, no connection on the database. This should be checked by the driver.
XGroupsSupplier provides for access to a container of groups, typically used for a database definition object.
XIndexesSupplier provides for access to a container of indexes, typically used for a table definition object.
XKeysSupplier provides for access to a container of keys, typically used for a table definition object.
XRename supports the renaming of definition objects.
This is a very desirable feature which is not supported by all databases. There is no standard SQL statement provided for this feature.
XRowLocate is used to identify rows within a result set and to find rows by a bookmark.
XTablesSupplier provides for access to a container of tables, typically used for a database definition object.
XUser allows for changing a users password.
XUsersSupplier provides the access to a container of users, typically used for a database definition object.
XViewsSupplier provides for access to a container of views, typically used for a database definition object.
Constant Groups
CheckOption determines the check option for a view.
CompareBookmark describes the result of a comparision of two bookmarks.
KeyType determines the type of a key.
Privilege defines a list of flags (bitmaps) which determines the accessrights of a user or a user group. This list may grow in the future.
PrivilegeObject defines the list of objects for which a user may have accessrights or not. This list may grow in the future.
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Website Feedback | Contact Us | Donate | Thanks

Apache, the Apache feather logo, and OpenOffice are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.