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 | |