This data source is usually used to create a Connection. If no DataSourceName is given and the DatabaseLocation and the ConnectionResource are emtpy, then an ActiveConnection is required.

This database location is usually used to create a Connection. If no DatabaseLocation is given and the ConnectionResource is emtpy, then an ActiveConnection is reuqired.

This database URL is usually used to create a Connection. If no ConnectionResource is given, then an ActiveConnection is reuqired.

This member is evaluated only when ConnectionResource is used: In this case, ::com::sun::star::sdbc::XDriverManager::getConnectionWithInfo is used to create a connection for the given connection resource, instead of ::com::sun::star::sdbc::XDriverManager::getConnection.

If the sequence is empty, it is ignored.

This object is guaranteed to be a ::com::sun::star::sdbc::Connection, but usually it will be a Connection from the module com::sun::star::sdb.
Especially in the case where no DataSourceName is given, but CommandType is CommandType::QUERY, the ActiveConnection needs to fully support the Connection service, to actually retrieve the query specified by Command

If no ActiveConnection is given, then a DataSourceName is required.

This property is only meaningful together with the CommandType property, thus either both or none of them are present.

Command needs to be interpreted depending on the value of this property.

This property is only meaningfull together with the Command property, thus either both or none of them are present.

The Filter string has to form a WHERE-clause, without the WHERE-string itself.

If a DataSourceName, Command and CommandType are specified, a RowSet can be created with this information. If the results provided by the row set are to be additionally filtered, the Filter property can be used.

Note that the Filter property does not make sense if a ResultSet has been specified in the DataAccessDescriptor.

The keyword ORDER BY itself is not part of this property.

The keyword HAVING itself is not part of this property.

The keyword GROUP BY itself is not part of this property.

The default value of this property is true. By switching it to false, you can pass backend-specific SQL statements, which are not standard SQL, to your database.

This property is usually present together with the Command and CommandType properties, and is evaluated if and only if CommandType equals CommandType::COMMAND.

Usually, you use the properties DataSourceName (alternatively ActiveConnection), Command and CommandType to specify how to obtain a result set. However, in scenarious where the provider of a DataAccessDescriptor has access to an already existent result set, it can pass it along for reusage. This is encouraged to increase performance.

The object will at least support the ::com::sun::star::sdbc::ResultSet service.

Note that any superservices of ::com::sun::star::sdbc::ResultSet are also allowed. Especially, this member can denote an instance of the RowSet, or an instance obtained by calling XResultSetAccess::createResultSet on such a RowSet. This becomes important in conjunction with the Selection property.

When you specify a result set either implicitly (DataSourceName, Command, CommandType) or explicitly (ResultSet), the set of results can be additionally refined with this property.

The single elements of the Selection are either record numbers (see ::com::sun::star::sdbc::XResultSet::getRow), or bookmarks (see ::com::sun::star::sdbcx::XRowLocate::getBookmark).
It is up to the component which provides or requires a DataAccessDescriptor to specify which of the two alternatives it expects. If it does not specify this, then the property BookmarkSelection becomes mandatory.

If the elements specify bookmarks, and a ResultSet has been specified, then this result set is required to support the ::com::sun::star::sdbcx::XRowLocate interface.

If present, BookmarkSelection specifies the semantics of Selection. If not present, it's up to the implementing component to specify this semantics.

If true, then the single elements of the array specified by Selection are bookmarks relative to the result set, if false, they're record numbers.

This property is usually used together with the Command and CommandType properties.

For reasons of performance and saving resources, a supplier of an DataAccessDescriptor which is used to describe a column object can pass this object directly, instead of specifying it only implicitly with the ColumnName property.

The object will at least support the ::com::sun::star::sdbcx::Column service, but more often it will even be a Column from the com::sun::star::sdb module.