Page History

Hidden

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE

HTML Table

class	servoy sSummery

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summery

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#getErrorCode() Returns the error code for this ServoyException.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getMessage() Returns the string message for this ServoyException.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Object[]

Table Cell (td)
#getParameters() Returns the parameters of the SQL query that caused this DataException in an array.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getSQL() Returns the SQL query that caused this DataException.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getSQLState() Returns the SQLState for this DataException.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Object

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#getVendorErrorCode() Returns the error code of the error thrown by the back-end database server.

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	getErrorCode
class	node

Table Row (tr)

id	name

Table Cell (td)
getErrorCode

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

getErrorCode

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
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 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
var e = arguments[0];
application.output("Exception Object: "+e)
application.output("MSG: "+e.getMessage())
if (e instanceof ServoyException)
{
	application.output("is a ServoyException")
	application.output("Errorcode: "+e.getErrorCode())
	if (e.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)
			{
				application.output("SQL: "+record.exception.getSQL())
				application.output("SQLState: "+record.exception.getSQLState())
				application.output("VendorErrorCode: "+record.exception.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
class	node

Table Row (tr)

id	name

Table Cell (td)
getMessage

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getMessage

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Returns the string message for this ServoyException.

Table Row (tr)

id	ret

Table Cell (td)
Returns 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
var e = arguments[0];
application.output("Exception Object: "+e)
application.output("MSG: "+e.getMessage())
if (e instanceof ServoyException)
{
	application.output("is a ServoyException")
	application.output("Errorcode: "+e.getErrorCode())
	if (e.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)
			{
				application.output("SQL: "+record.exception.getSQL())
				application.output("SQLState: "+record.exception.getSQLState())
				application.output("VendorErrorCode: "+record.exception.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
class	node

Table Row (tr)

id	name

Table Cell (td)
getParameters

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Object[]

Span

style	float: left; font-weight: bold;
id	iets

getParameters

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Returns the parameters of the SQL query that caused this DataException in an array.

Table Row (tr)

id	ret

Table Cell (td)
Returns 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
class	node

Table Row (tr)

id	name

Table Cell (td)
getSQL

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getSQL

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Returns the SQL query that caused this DataException.

Table Row (tr)

id	ret

Table Cell (td)
Returns 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
class	node

Table Row (tr)

id	name

Table Cell (td)
getSQLState

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getSQLState

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
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 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	getValue
class	node

Table Row (tr)

id	name

Table Cell (td)
getValue

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Object

Span

style	float: left; font-weight: bold;
id	iets

getValue

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
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 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
class	node

Table Row (tr)

id	name

Table Cell (td)
getVendorErrorCode

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

getVendorErrorCode

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Returns the error code of the error thrown by the back-end database server.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – the error code of the error thrown by the back-end database server.

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("VendorErrorCode: " + record.exception.getVendorErrorCode());
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 14

New Version Current

Key

getErrorCode

getMessage

getParameters

getSQL

getSQLState

getValue

getVendorErrorCode