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
View Supported Platform Table
APIBB5.0BB6.0BB7.0PB1.0PB2.0BB10Ripple
code Y Y Y Y Y YY
message Y Y Y Y Y YY
UNKNOWN_ERR Y Y Y Y Y YY
DATABASE_ERR Y Y Y Y Y YY
VERSION_ERR Y Y Y Y Y YY
TOO_LARGE_ERR Y Y Y Y Y YY
QUOTA_ERR Y Y Y Y Y YY
SYNTAX_ERR Y Y Y Y Y YY
CONSTRAINT_ERR Y Y Y Y Y YY
TIMEOUT_ERR Y Y Y Y Y YY

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.

Properties

Number code
String message

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

readonly Number code


The most appropriate error code.


Supported Platforms
 - BlackBerry OS 5.0+
 - BlackBerry PlayBook 1.0+
 - BlackBerry 10
 - Ripple Emulator

readonly String message


An error message describing the error encountered. The message should be localized to the user's language.


Supported Platforms
 - BlackBerry OS 5.0+
 - BlackBerry PlayBook 1.0+
 - BlackBerry 10
 - Ripple Emulator

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

static Number TIMEOUT_ERR = 7


A lock for the transaction could not be obtained in a reasonable time.


Supported Platforms
 - BlackBerry OS 5.0+
 - BlackBerry PlayBook 1.0+
 - BlackBerry 10
 - Ripple Emulator

Documentation generated by JsDoc Toolkit 2.4.0 on Mon Feb 11 2013 14:51:10 GMT-0500 (EST)