HTML5 SQLError
Errors in the asynchronous database API are reported using callbacks that have a SQLError object as one of their arguments.
Supported Platform(s)
- BlackBerry OS 5.0+ |
- BlackBerry PlayBook 1.0+ |
- BlackBerry 10 |
- Ripple Emulator |
API | BB5.0 | BB6.0 | BB7.0 | PB1.0 | PB2.0 | BB10 | Ripple |
---|---|---|---|---|---|---|---|
code | Y | Y | Y | Y | Y | Y | Y |
message | Y | Y | Y | Y | Y | Y | Y |
UNKNOWN_ERR | Y | Y | Y | Y | Y | Y | Y |
DATABASE_ERR | Y | Y | Y | Y | Y | Y | Y |
VERSION_ERR | Y | Y | Y | Y | Y | Y | Y |
TOO_LARGE_ERR | Y | Y | Y | Y | Y | Y | Y |
QUOTA_ERR | Y | Y | Y | Y | Y | Y | Y |
SYNTAX_ERR | Y | Y | Y | Y | Y | Y | Y |
CONSTRAINT_ERR | Y | Y | Y | Y | Y | Y | Y |
TIMEOUT_ERR | Y | Y | Y | Y | Y | Y | Y |
Configuration Document Settings
To use all of the API described for this object, you must ensure the following settings are in your configuration document: |
This API does not require a <feature> element to be declared in the configuration document of your BlackBerry WebWorks Application. |
Permission Elements (PlayBook and BlackBerry 10+) |
---|
This API does not require a <permission> element to be declared in the configuration document of your BlackBerry WebWorks Application. |
Constants
Number | UNKNOWN_ERR |
Number | DATABASE_ERR |
Number | VERSION_ERR |
Number | TOO_LARGE_ERR |
Number | QUOTA_ERR |
Number | SYNTAX_ERR |
Number | CONSTRAINT_ERR |
Number | TIMEOUT_ERR |
Properties
Constants
static
Number
UNKNOWN_ERR
= 0
The transaction failed for reasons unrelated to the database itself and not covered by any other error code.
Supported Platforms | |
---|---|
- BlackBerry OS 5.0+ | |
- BlackBerry PlayBook 1.0+ | |
- BlackBerry 10 | |
- Ripple Emulator |
static
Number
DATABASE_ERR
= 1
The statement failed for database reasons not covered by any other error code.
Supported Platforms | |
---|---|
- BlackBerry OS 5.0+ | |
- BlackBerry PlayBook 1.0+ | |
- BlackBerry 10 | |
- Ripple Emulator |
static
Number
VERSION_ERR
= 2
The operation failed because the actual database version was not what it should be.
Supported Platforms | |
---|---|
- BlackBerry OS 5.0+ | |
- BlackBerry PlayBook 1.0+ | |
- BlackBerry 10 | |
- Ripple Emulator |
static
Number
TOO_LARGE_ERR
= 3
The statement failed because the data returned from the database was too large. The SQL "LIMIT" modifier might be useful to reduce the size of the result set.
Supported Platforms | |
---|---|
- BlackBerry OS 5.0+ | |
- BlackBerry PlayBook 1.0+ | |
- BlackBerry 10 | |
- Ripple Emulator |
static
Number
QUOTA_ERR
= 4
The statement failed because there was not enough remaining storage space, or the storage quota was reached and the user declined to give more space to the database.
Supported Platforms | |
---|---|
- BlackBerry OS 5.0+ | |
- BlackBerry PlayBook 1.0+ | |
- BlackBerry 10 | |
- Ripple Emulator |
static
Number
SYNTAX_ERR
= 5
The statement failed because of a syntax error, or the number of arguments did not match the number of ? placeholders in the statement, or the statement tried to use a statement that is not allowed, such as BEGIN, COMMIT, or ROLLBACK, or the statement tried to use a verb that could modify the database but the transaction was read-only.
Supported Platforms | |
---|---|
- BlackBerry OS 5.0+ | |
- BlackBerry PlayBook 1.0+ | |
- BlackBerry 10 | |
- Ripple Emulator |
static
Number
CONSTRAINT_ERR
= 6
An INSERT, UPDATE, or REPLACE statement failed due to a constraint failure. For example, because a row was being inserted and the value given for the primary key column duplicated the value of an existing row.
Supported Platforms | |
---|---|
- BlackBerry OS 5.0+ | |
- BlackBerry PlayBook 1.0+ | |
- BlackBerry 10 | |
- Ripple Emulator |