Page History

Divcache

Div

id	description

HTML Table

id

class

servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Constants Summary

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)ABSTRACT_FORM

styleindex	display:none

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.

true
refresh	100d
showRefresh	true
id	doc
title	Refresh page
showDate	true
retry	Enable

idclass

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Constants SummaryException code for ABSTRACT_FORM. Table Row (tr)

Table Cell (td)
Number

Table Cell (td)ACQUIRE_LOCK_FAILURE

Table Cell (td)BAD_SQL_SYNTAX

Exception code for ACQUIRE_LOCK_FAILURE.

Table Row (tr)

Table Cell (td)
Number

Exception code for BAD_SQL_SYNTAX.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)CLIENT_NOT_AUTHORIZED

Table Cell (td)DATA_ACCESS_RESOURCE_FAILURE

Exception code for CLIENT_NOT_AUTHORIZED.

Table Row (tr)

Table Cell (td)
Number

Exception code for DATA_ACCESS_RESOURCE_FAILURE.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)DATA_INTEGRITY_VIOLATION

Table Cell (td)
Number

Table Cell (td)DEADLOCK

Exception code for DATA_INTEGRITY_VIOLATION.

Table Row (tr)

Exception code for DEADLOCK.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)DELETE_NOT_GRANTED
Exception

Table Cell (td)EXECUTE_PROGRAM_FAILED

Exception code for DELETE_NOT_GRANTED.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)INCORRECT_LOGIN

Exception code for EXECUTE_PROGRAM_FAILED.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)INVALID_INPUT

Exception code for INCORRECT_LOGIN.

Table Row (tr)

Table Cell (td)
Number

Exception code for INVALID_INPUT.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)INVALID_RESULTSET_ACCESS

Table Cell (td)MAINTENANCE_MODE

Exception code for INVALID_RESULTSET_ACCESS.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)NO_ACCESS

Exception code for MAINTENANCE_MODE.

Table Row (tr)

Table Cell (td)
Number

Exception code for NO_ACCESS.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)

Exception code for NO_CREATE_ACCESS

.

Exception code for NO_

CREATE_ACCESS. Table Row (tr)

Table Cell (td)
Number

Table Cell (td)NO_DELETE_ACCESS
Exception code for NO_DELETE Table Cell (td)NO_LICENSE

DELETE_ACCESS.

Table Row (tr)

Table Cell (td)
Number

Exception code for NO_LICENSE.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)NO_MODIFY_ACCESS

Exception code for NO_MODIFY_ACCESS.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)NO_PARENT_DELETE_WITH_RELATED_RECORDS
Table Cell (td)NO_RELATED_CREATE_ACCESS

Exception code for NO_PARENT_DELETE_WITH_RELATED_RECORDS.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)

Exception code for NO_RELATED_CREATE_ACCESS.

Table Row (tr)

Table Cell (td)
Number

Exception code for PERMISSION_DENIED

.

Exception code for

PERMISSION

RECORD_

DENIED.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
RECORD_LOCKED Exception code for RECORD_LOCKED.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)RECORD_VALIDATION_FAILED
Exception code Table Cell (td)SAVE_FAILED

LOCKED.

Exception code for RECORD_VALIDATION_FAILED.

Table Row (tr)

Table Cell (td)
Number

Exception code for SAVE_FAILED.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)UNEXPECTED_UPDATE_COUNT

Table Cell (td)UNKNOWN_DATABASE_EXCEPTION

Exception code for UNEXPECTED_UPDATE_COUNT.

Table Row (tr)

Table Cell (td)
Number

Exception code for UNKNOWN_DATABASE_EXCEPTION.

HTML Table

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style

servoy sSummary

id

12%

30%

58%

height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)getErrorCode()
Returns

3

Methods Summary

Returns the error code for this ServoyException.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)getMessage()

Table Cell (td)
Object[]

Table Cell (td)getParameters()

Returns the string message for this ServoyException.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)getSQL()

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

Table Row (tr)

Table Cell (td)
String

Table Cell (td)getSQLState()

Returns the SQL query that caused this DataException.

Returns the SQLState for this DataException.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)getScriptStackTrace()
Table Row (tr)

Table Cell (td)
String

Table Cell (td)getStackTrace()

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

Table Row (tr)

Table Cell (td)
Object

Table Cell (td)
getValue() Returns the value for this DataException.

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)getVendorErrorCode()

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.

HTML Table

constantclass Colgroup Tag Colcolspanservoy sDetail2width100%

Col

Table Head (thead) Table Row (tr)style

height:30px

; Table Head (th)colspan

2

Constants Details

Table Body (tbody)idid

ABSTRACT_FORM

Table Row (tr)

name

td

ABSTRACT_FORM

tr

id

des

Table Cell (td) Divclass

sIndent

Exception code for ABSTRACT_FORM.

Table Row (tr)id

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

td

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

Number Table Row (tr)

Colgroup Tag

Col

colspan	2
width	100%

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Details

Table Body (tbody)

id	getErrorCode

Table Row (tr)

id	name

Table Cell (td)
getErrorCode

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Number

Span

style	font-weight: bold;

getErrorCode

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number - the error code for this ServoyException. Can be one of the constants declared in ServoyException.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getMessage

Table Row (tr)

id	name

Table Cell (td)
getMessage

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getMessage

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns the string message for this ServoyException.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - the string message for this ServoyException.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getParameters

Table Row (tr)

id	name

Table Cell (td)
getParameters

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Object[]

Span

style	font-weight: bold;

getParameters

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Object[] - the parameters of the SQL query that caused this DataException in an array.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var record = array[i];
application.output(record.exception);
if (record.exception instanceof DataException)
{
	var param = record.exception.getParameters();
	for (j = 0; j < param.length; j++)
	{
		application.output("SQL Parameter [" + j + "]: " + param[j]);
	}
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getSQL

Table Row (tr)

id	name

Table Cell (td)
getSQL

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getSQL

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns the SQL query that caused this DataException.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - the SQL query that caused this DataException.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var record = array[i];
application.output(record.exception);
if (record.exception instanceof DataException)
{
	application.output("SQL: " + record.exception.getSQL());
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getSQLState

Table Row (tr)

id	name

Table Cell (td)
getSQLState

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getSQLState

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - the SQLState for this DataException.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var record = array[i];
application.output(record.exception);
if (record.exception instanceof DataException)
{
	application.output("SQLState: " + record.exception.getSQLState());
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getScriptStackTrace

Table Row (tr)

id	name

Table Cell (td)
getScriptStackTrace

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getScriptStackTrace

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - the string stack trace for this ServoyException.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getStackTrace

Table Row (tr)

id	name

Table Cell (td)
getStackTrace

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getStackTrace

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns the stack trace for this ServoyException.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - the string stack trace for this ServoyException.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getValue

Table Row (tr)

id	name

Table Cell (td)
getValue

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Object

Span

style	font-weight: bold;

getValue

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Object - the value for this DataException.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var record = array[i];
application.output(record.exception);
if (record.exception instanceof DataException)
{
	application.output("VALUE: " + record.exception.getValue());
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getVendorErrorCode

Table Row (tr)

id	name

Table Cell (td)
getVendorErrorCode

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Number

Span

style	font-weight: bold;

getVendorErrorCode

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number -

SmartClient,WebClient,NGClient

sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	ACQUIRE_LOCK_FAILURE

Table Row (tr)

id	name

Table Cell (td)
ACQUIRE_LOCK_FAILURE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for ACQUIRE_LOCK_FAILURE.

This code is used when a database failed to lock a row or table.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	BAD_SQL_SYNTAX

Table Row (tr)

id	name

Table Cell (td)
BAD_SQL_SYNTAX

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for BAD_SQL_SYNTAX.

This code is used when a database exception is recognized as an sql syntax error.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	CLIENT_NOT_AUTHORIZED

Table Row (tr)

id	name

Table Cell (td)
CLIENT_NOT_AUTHORIZED

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	DATA_ACCESS_RESOURCE_FAILURE

Table Row (tr)

id	name

Table Cell (td)
DATA_ACCESS_RESOURCE_FAILURE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for DATA_ACCESS_RESOURCE_FAILURE.

This code is used when a database exception received an error accessing storage devices.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	DATA_INTEGRITY_VIOLATION

Table Row (tr)

id	name

Table Cell (td)
DATA_INTEGRITY_VIOLATION

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for DATA_INTEGRITY_VIOLATION.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	DEADLOCK

Table Row (tr)

id	name

Table Cell (td)
DEADLOCK

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for DEADLOCK.

This code is used when a deadlock is detected by the database.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	DELETE_NOT_GRANTED

Table Row (tr)

id	name

Table Cell (td)
DELETE_NOT_GRANTED

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for DELETE_NOT_GRANTED.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	EXECUTE_PROGRAM_FAILED

Table Row (tr)

id	name

Table Cell (td)
EXECUTE_PROGRAM_FAILED

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for EXECUTE_PROGRAM_FAILED.

This code is used when an external program was not executed correctly.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	INCORRECT_LOGIN

Table Row (tr)

id	name

Table Cell (td)
INCORRECT_LOGIN

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for INCORRECT_LOGIN.

This code is used when the user enters invalid credentials.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	INVALID_INPUT

Table Row (tr)

id	name

Table Cell (td)
INVALID_INPUT

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for INVALID_INPUT.

This code is used when the user enters data that could not be validated.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	INVALID_RESULTSET_ACCESS

Table Row (tr)

id	name

Table Cell (td)
INVALID_RESULTSET_ACCESS

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for INVALID_RESULTSET_ACCESS.

This code is used when a data is requested that is not selected in the sql.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	MAINTENANCE_MODE

Table Row (tr)

id	name

Table Cell (td)
MAINTENANCE_MODE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NO_ACCESS

Table Row (tr)

id	name

Table Cell (td)
NO_ACCESS

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for NO_ACCESS.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NO_CREATE_ACCESS

Table Row (tr)

id	name

Table Cell (td)
NO_CREATE_ACCESS

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for NO_CREATE_ACCESS.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NO_DELETE_ACCESS

Table Row (tr)

id	name

Table Cell (td)
NO_DELETE_ACCESS

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for NO_DELETE_ACCESS.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NO_LICENSE

Table Row (tr)

id	name

Table Cell (td)
NO_LICENSE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for NO_LICENSE.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NO_MODIFY_ACCESS

Table Row (tr)

id	name

Table Cell (td)
NO_MODIFY_ACCESS

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for NO_MODIFY_ACCESS.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NO_PARENT_DELETE_WITH_RELATED_RECORDS

Table Row (tr)

id	name

Table Cell (td)
NO_PARENT_DELETE_WITH_RELATED_RECORDS

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NO_RELATED_CREATE_ACCESS

Table Row (tr)

id	name

Table Cell (td)
NO_RELATED_CREATE_ACCESS

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	PERMISSION_DENIED

Table Row (tr)

id	name

Table Cell (td)
PERMISSION_DENIED

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for PERMISSION_DENIED.

This code is used when a database exception is recognized as a authorization error.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	RECORD_LOCKED

Table Row (tr)

id	name

Table Cell (td)
RECORD_LOCKED

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for RECORD_LOCKED.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	RECORD_VALIDATION_FAILED

Table Row (tr)

id	name

Table Cell (td)
RECORD_VALIDATION_FAILED

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for RECORD_VALIDATION_FAILED.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	SAVE_FAILED

Table Row (tr)

id	name

Table Cell (td)
SAVE_FAILED

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for SAVE_FAILED.

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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	UNEXPECTED_UPDATE_COUNT

Table Row (tr)

id	name

Table Cell (td)
UNEXPECTED_UPDATE_COUNT

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception 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).

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	UNKNOWN_DATABASE_EXCEPTION

Table Row (tr)

id	name

Table Cell (td)
UNKNOWN_DATABASE_EXCEPTION

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Exception code for UNKNOWN_DATABASE_EXCEPTION.

This code is used when an unrecognized database exception has occurred.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//this sample script should be attached to onError method handler in the solution settings
application.output('Exception Object: '+ex)
application.output('MSG: '+ex.getMessage())
if (ex instanceof ServoyException)
{
	/** @type {ServoyException} */
	var servoyException = ex;
	application.output("is a ServoyException")
	application.output("Errorcode: "+servoyException.getErrorCode())
	var trace = "";
	if (ex.getScriptStackTrace) trace = servoyException.getScriptStackTrace();
	else if (servoyException.getStackTrace)  trace = servoyException.getStackTrace();
	if (servoyException.getErrorCode() == ServoyException.SAVE_FAILED)
	{
		plugins.dialogs.showErrorDialog( 'Error',  'It seems you did not fill in a required field', 'OK');
		//Get the failed records after a save
		var array = databaseManager.getFailedRecords()
		for( var i = 0 ; i < array.length ; i++ )
		{
			var record = array[i];
			application.output(record.exception);
			if (record.exception instanceof DataException)
			{
				/** @type {DataException} */
				var dataException = record.exception;
				application.output('SQL: '+dataException.getSQL())
				application.output('SQLState: '+dataException.getSQLState())
				application.output('VendorErrorCode: '+dataException.getVendorErrorCode())
			}
		}
		return false
	}
}
//if returns false or no return, error is not reported to client; if returns true error is reported
//by default error report means logging the error, in smart client an error dialog will also show up
return true

Table Row (tr)

class	lastDetailRow

Table Cell (td)

HTML Table

id	function
class	servoy sDetail

Sample

sIdent

javascript

lastDetailRow

ACQUIRE_LOCK_FAILURE

name

ACQUIRE_LOCK_FAILURE

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

BAD_SQL_SYNTAX

name

BAD_SQL_SYNTAX

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

CLIENT_NOT_AUTHORIZED

name

CLIENT_NOT_AUTHORIZED

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

DATA_ACCESS_RESOURCE_FAILURE

name

DATA_ACCESS_RESOURCE_FAILURE

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

DATA_INTEGRITY_VIOLATION

name

DATA_INTEGRITY_VIOLATION

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

DEADLOCK

name

DEADLOCK

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

DELETE_NOT_GRANTED

name

DELETE_NOT_GRANTED

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

EXECUTE_PROGRAM_FAILED

name

EXECUTE_PROGRAM_FAILED

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

INCORRECT_LOGIN

name

INCORRECT_LOGIN

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

INVALID_INPUT

name

INVALID_INPUT

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

INVALID_RESULTSET_ACCESS

name

INVALID_RESULTSET_ACCESS

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

MAINTENANCE_MODE

name

MAINTENANCE_MODE

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

NO_ACCESS

name

NO_ACCESS

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

NO_CREATE_ACCESS

name

NO_CREATE_ACCESS

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

NO_DELETE_ACCESS

name

NO_DELETE_ACCESS

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

NO_LICENSE

name

NO_LICENSE

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

NO_MODIFY_ACCESS

name

NO_MODIFY_ACCESS

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

NO_PARENT_DELETE_WITH_RELATED_RECORDS

name

NO_PARENT_DELETE_WITH_RELATED_RECORDS

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

NO_RELATED_CREATE_ACCESS

name

NO_RELATED_CREATE_ACCESS

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

PERMISSION_DENIED

name

PERMISSION_DENIED

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

RECORD_LOCKED

name

RECORD_LOCKED

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

RECORD_VALIDATION_FAILED

name

RECORD_VALIDATION_FAILED

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

SAVE_FAILED

name

SAVE_FAILED

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

UNEXPECTED_UPDATE_COUNT

name

UNEXPECTED_UPDATE_COUNT

des

sIndent

Exception 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

UNKNOWN_DATABASE_EXCEPTION

name

UNKNOWN_DATABASE_EXCEPTION

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods DetailsgetErrorCodename

getErrorCode()

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getMessage

name

getMessage()

des

sIndent

Returns the string message for this ServoyException.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getParameters

name

getParameters()

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getSQL

name

getSQL()

des

sIndent

Returns the SQL query that caused this DataException.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getSQLState

name

getSQLState()

des

sIndent

Returns 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getScriptStackTrace

name

getScriptStackTrace()

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getStackTrace

name

getStackTrace()

des

sIndent

Returns the stack trace for this ServoyException.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getValue

name

getValue()

des

sIndent

Returns 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

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getVendorErrorCode

name

getVendorErrorCode()

des

sIndent

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

ret

Returns

trtd

sIndent

clients

id	sam

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

Div

class	sIndent

Code Block

language	javascript

var record = array[i];
application.output(record.exception);
if (record.exception instanceof DataException)
{
	application.output("VendorErrorCode: " + record.exception.getVendorErrorCode());
}

sIdent

javascript

lastDetailRow

Child pages

Page History

Versions Compared

Old Version 23

New Version 24

Key

ABSTRACT_FORM

getErrorCode

getMessage

getParameters

getSQL

getSQLState

getScriptStackTrace

getStackTrace

getValue

getVendorErrorCode

ACQUIRE_LOCK_FAILURE

BAD_SQL_SYNTAX

CLIENT_NOT_AUTHORIZED

DATA_ACCESS_RESOURCE_FAILURE

DATA_INTEGRITY_VIOLATION

DEADLOCK

DELETE_NOT_GRANTED

EXECUTE_PROGRAM_FAILED

INCORRECT_LOGIN

INVALID_INPUT

INVALID_RESULTSET_ACCESS

MAINTENANCE_MODE

NO_ACCESS

NO_CREATE_ACCESS

NO_DELETE_ACCESS

NO_LICENSE

NO_MODIFY_ACCESS

NO_PARENT_DELETE_WITH_RELATED_RECORDS

NO_RELATED_CREATE_ACCESS

PERMISSION_DENIED

RECORD_LOCKED

RECORD_VALIDATION_FAILED

SAVE_FAILED

UNEXPECTED_UPDATE_COUNT

UNKNOWN_DATABASE_EXCEPTION

ACQUIRE_LOCK_FAILURE

BAD_SQL_SYNTAX

CLIENT_NOT_AUTHORIZED

DATA_ACCESS_RESOURCE_FAILURE

DATA_INTEGRITY_VIOLATION

DEADLOCK

DELETE_NOT_GRANTED

EXECUTE_PROGRAM_FAILED

INCORRECT_LOGIN

INVALID_INPUT

INVALID_RESULTSET_ACCESS

MAINTENANCE_MODE

NO_ACCESS

NO_CREATE_ACCESS

NO_DELETE_ACCESS

NO_LICENSE

NO_MODIFY_ACCESS

NO_PARENT_DELETE_WITH_RELATED_RECORDS

NO_RELATED_CREATE_ACCESS

PERMISSION_DENIED

RECORD_LOCKED

RECORD_VALIDATION_FAILED

SAVE_FAILED

UNEXPECTED_UPDATE_COUNT

UNKNOWN_DATABASE_EXCEPTION

getErrorCode()

getMessage()

getParameters()

getSQL()

getSQLState()

getScriptStackTrace()

getStackTrace()

getValue()

getVendorErrorCode()