Child pages
  • DataException

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Cache
indextrue
refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Constants SummaryException code for ABSTRACT_FORM.Exception code for ACQUIRE_LOCK_FAILURE.Exception code for BAD_SQL_SYNTAX.Exception code for CLIENT_NOT_AUTHORIZED.Exception code for DATA_ACCESS_RESOURCE_FAILURE.Exception code for DATA_INTEGRITY_VIOLATION.Exception code for DEADLOCK.Exception code for DELETE_NOT_GRANTED.Exception code for EXECUTE_PROGRAM_FAILED.Exception code for INCORRECT_LOGIN.Exception code for INVALID_INPUT.Exception code for INVALID_RESULTSET_ACCESS.Exception code for MAINTENANCE_MODE.Exception code for NO_ACCESS.Exception code for NO_CREATE_ACCESS.Exception code for NO_DELETE_ACCESS.Exception code for NO_LICENSE.Exception code for NO_MODIFY_ACCESS.Exception code for NO_PARENT_DELETE_WITH_RELATED_RECORDS.Exception code for NO_RELATED_CREATE_ACCESS.Exception code for PERMISSION_DENIED.Exception code for RECORD_LOCKED.Exception code for RECORD_VALIDATION_FAILED.Exception code for SAVE_FAILED.Exception code for UNEXPECTED_UPDATE_COUNT.Exception code for UNKNOWN_DATABASE_EXCEPTION.

servoy sSummary12%30%58%height: 30px;3Methods SummaryReturns the error code for this ServoyException.Returns the string message for this ServoyException.Returns the parameters of the SQL query that caused this DataException in an array.Returns the SQL query that caused this DataException.Returns the SQLState for this DataException.Returns the script stack trace for this ServoyException if this could be created.Returns the stack trace for this ServoyException.Returns the value for this DataException.Returns the error code of the error thrown by the back-end database server.

constantservoy sDetail2100%height:30px2Constants DetailsABSTRACT_FORMname

ABSTRACT_FORM

dessIndentException code for ABSTRACT_FORM. This code is used when a form, that cannot be created, is shown (for example, a form without parts).ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow ACQUIRE_LOCK_FAILUREname

ACQUIRE_LOCK_FAILURE

dessIndentException code for ACQUIRE_LOCK_FAILURE. This code is used when a database failed to lock a row or table.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
BAD_SQL_SYNTAXname

BAD_SQL_SYNTAX

dessIndentException code for BAD_SQL_SYNTAX. This code is used when a database exception is recognized as an sql syntax error.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
CLIENT_NOT_AUTHORIZEDname

CLIENT_NOT_AUTHORIZED

dessIndentException code for CLIENT_NOT_AUTHORIZED. This code is used when an client performs an action that requires the user to be logged in and the user has not logged in yet.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
DATA_ACCESS_RESOURCE_FAILUREname

DATA_ACCESS_RESOURCE_FAILURE

dessIndentException code for DATA_ACCESS_RESOURCE_FAILURE. This code is used when a database exception received an error accessing storage devices.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
DATA_INTEGRITY_VIOLATIONname

DATA_INTEGRITY_VIOLATION

dessIndentException code for DATA_INTEGRITY_VIOLATION. This code is used when a database exception is recognized as an integrity exception (like constraint violation).ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
DEADLOCKname

DEADLOCK

dessIndentException code for DEADLOCK. This code is used when a deadlock is detected by the database.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
DELETE_NOT_GRANTEDname

DELETE_NOT_GRANTED

dessIndentException code for DELETE_NOT_GRANTED. This code is used when a record deletion was rejected by a pre-delete Servoy trigger.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
EXECUTE_PROGRAM_FAILEDname

EXECUTE_PROGRAM_FAILED

dessIndentException code for EXECUTE_PROGRAM_FAILED. This code is used when an external program was not executed correctly.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
INCORRECT_LOGINname

INCORRECT_LOGIN

dessIndentException code for INCORRECT_LOGIN. This code is used when the user enters invalid credentials.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
INVALID_INPUTname

INVALID_INPUT

dessIndentException code for INVALID_INPUT. This code is used when the user enters data that could not be validated.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
INVALID_RESULTSET_ACCESSname

INVALID_RESULTSET_ACCESS

dessIndentException code for INVALID_RESULTSET_ACCESS. This code is used when a data is requested that is not selected in the sql.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
MAINTENANCE_MODEname

MAINTENANCE_MODE

dessIndentException code for MAINTENANCE_MODE. This code is used when a client could not be registered with the server because the server is in maintenance mode.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
NO_ACCESSname

NO_ACCESS

dessIndentException code for NO_ACCESS. This code is used when a user wants to view data and this is disallowed by security settings.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
NO_CREATE_ACCESSname

NO_CREATE_ACCESS

dessIndentException code for NO_CREATE_ACCESS. This code is used when a user wants to create new records and this is disallowed by security settings.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
NO_DELETE_ACCESSname

NO_DELETE_ACCESS

dessIndentException code for NO_DELETE_ACCESS. This code is used when a user wants to delete data and this is disallowed by security settings.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
NO_LICENSEname

NO_LICENSE

dessIndentException code for NO_LICENSE. This code is used when a client could not be registered with the server because of license limitations.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
NO_MODIFY_ACCESSname

NO_MODIFY_ACCESS

dessIndentException code for NO_MODIFY_ACCESS. This code is used when a user wants to update data and this is disallowed by security settings.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
NO_PARENT_DELETE_WITH_RELATED_RECORDSname

NO_PARENT_DELETE_WITH_RELATED_RECORDS

dessIndentException code for NO_PARENT_DELETE_WITH_RELATED_RECORDS. This code is used when a record could not be deleted because a non-empty relation exists for the record that does not allow parent delete when having related records.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
NO_RELATED_CREATE_ACCESSname

NO_RELATED_CREATE_ACCESS

dessIndentException code for NO_RELATED_CREATE_ACCESS. This code is used when a user wants to create new related records and this is disallowed by security settings.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
PERMISSION_DENIEDname

PERMISSION_DENIED

dessIndentException code for PERMISSION_DENIED. This code is used when a database exception is recognized as a authorization error.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
RECORD_LOCKEDname

RECORD_LOCKED

dessIndentException code for RECORD_LOCKED. This code is used when a record could not be updated or deleted because it is locked by another client.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
RECORD_VALIDATION_FAILEDname

RECORD_VALIDATION_FAILED

dessIndentException code for RECORD_VALIDATION_FAILED. This code is used when a record update/insert was rejected by a pre-update/insert Servoy trigger.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
SAVE_FAILEDname

SAVE_FAILED

dessIndentException code for SAVE_FAILED. This code is used when a javascript exception occurred during saving data to the database.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
UNEXPECTED_UPDATE_COUNTname

UNEXPECTED_UPDATE_COUNT

dessIndentException code for UNEXPECTED_UPDATE_COUNT. This code is used when a data could not be deleted or updated when expected (for example when a record was deleted outside Servoy and a Servoy client wants to update the record).ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
UNKNOWN_DATABASE_EXCEPTIONname

UNKNOWN_DATABASE_EXCEPTION

dessIndentException code for UNKNOWN_DATABASE_EXCEPTION. This code is used when an unrecognized database exception has occurred.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 

functionservoy sDetail2100%height:30px2Methods DetailsgetErrorCodename

getErrorCode()

dessIndentReturns the error code for this ServoyException. Can be one of the constants declared in ServoyException.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow getMessagename

getMessage()

dessIndentReturns the string message for this ServoyException.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getParametersname

getParameters()

dessIndentReturns the parameters of the SQL query that caused this DataException in an array.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getSQLname

getSQL()

dessIndentReturns the SQL query that caused this DataException.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getSQLStatename

getSQLState()

dessIndentReturns the SQLState for this DataException. This is a "SQLstate" string, which follows either the XOPEN SQLstate conventions or the SQL 99 conventions. The values of the SQLState string are described in the appropriate spec.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getScriptStackTracename

getScriptStackTrace()

dessIndentReturns the script stack trace for this ServoyException if this could be created.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getStackTracename

getStackTrace()

dessIndentReturns the stack trace for this ServoyException.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getValuename

getValue()

dessIndentReturns the value for this DataException. The value is the object thrown in table pre-insert, pre-update or pre-delete triggers.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow 
getVendorErrorCodename

getVendorErrorCode()

dessIndentReturns the error code of the error thrown by the back-end database server.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow