:: com :: sun :: star :: sdb ::
||constants group ErrorCondition
- Usage Restrictions
- not published
- defines error conditions for OpenOffice.org Base core components
Core components of OpenOffice.org will use those error conditions
as error codes (::com::sun::star::sdbc::SQLException::ErrorCode)
That is, if an
SQLException is raised by
such a component, caused by an error condition which is included in the
ErrorCondition group, then the respective negative value
will be used as
This allows to determine specific error conditions in your client code, and
to handle it appropriately.
Note that before you examine the
ErrorCode member of a caught
SQLException, you need to make sure that the exception
is really thrown by an OpenOffice.org Base core component. To do so, check
whether the error message (
Exception::Message) starts with the
The list of defined error conditions, by nature, is expected to permanently grow,
so never assume it being finalized.
catch ( SQLException e )
if ( e.Message.startsWith( "[OOoBase]" ) )
if ( e.ErrorCode + ErrorCondition.SOME_ERROR_CONDITION == 0 )
Top of Page
|const long PARSER_CYCLIC_SUB_QUERIES = 200;
- indicates that while parsing an SQL statement, cyclic sub queries have been detected.
Imagine you have a client-side query
SELECT * FROM table, which is
saved as "query1". Additionally, there is a query "query2" defined
SELECT * FROM query1. Now if you try to change the statement of
SELECT * FROM query2, this is prohibited, because
it would lead to a cyclic sub query.
|const long DB_OBJECT_NAME_WITH_SLASHES = 300;
- indicates that the name of a client side database object - a query, a form,
or a report - contains one or more slashes, which is forbidden.
|const long DB_INVALID_SQL_NAME = 301;
- indicates that an identifier is not SQL conform.
|const long DB_QUERY_NAME_WITH_QUOTES = 302;
- indicates that the name of a query contains quote characters.
This error condition is met when the user attempts to save a query
with a name which contains one of the possible database quote characters.
This is an error since query names can potentially be used in
SELECT statements, where quote identifiers would render the statement invalid.
- See also
|const long DB_OBJECT_NAME_IS_USED = 303;
- indicates that an attempt was made to save a database object under a name
which is already used in the database.
In databases which support query names to appear in
statements, this could mean that a table was attempted to be saved with the
name of an existing query, or vice versa.
Otherwise, it means an object was attempted to be saved with the
name of an already existing object of the same type.
- See also
- ::com::sun::star::sdb::application::DatabaseObject, ::com::sun::star::sdb::tools::XDataSourceMetaData::supportsQueriesInFrom
|const long DB_NOT_CONNECTED = 304;
- indicates an operation was attempted which needs a connection to the
database, which did not exist at that time.
|const long AB_ADDRESSBOOK_NOT_FOUND = 500;
- used by the component implementing address book access to indicate that a requested address book could
not be accessed.
For instance, this error code is used when you try to access the address book
in a Thunderbird profile named
MyProfile, but there does not exist a profile
with this name.
|const long DATA_CANNOT_SELECT_UNFILTERED = 550;
- used to indicate that a
SELECT operation on a table needs a filter.
Some database drivers are not able to
SELECT from a table if the
statement does not contain a
WHERE clause. In this case, a statement
SELECT * FROM "table" with fail with the error code
It is also legitimate for the driver to report this error condition as warning, and provide
an empty result set, instead of ungracefull failing.
Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.