Page History

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

...

Table Cell (td)
Boolean

...

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.
Enter additional information related to this 'class' inside the {div} macro with 'id=description'

Divcache

styleindex	display:none

...

id	description

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Server Property Summary

...

Table Cell (td)
servoy.rawSQL.allowClientCacheFlushes

...

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

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Methods SummaryExecute any SQL, returns true if successful.

...

Table Cell (td)
Boolean

...

Execute any SQL, returns true if successful.

...

Table Cell (td)
JSDataSet

...

Execute a stored procedure, return all created result sets.

Execute a stored procedure.

...

Table Cell (td)
Boolean

...

Flush cached database data.

...

Table Cell (td)
ServoyException

If the result from a function was false, it will return the exception object.

...

Table Cell (td)
Boolean

...

Notify clients about changes in records, based on pk(s).

...

0px

HTML Table

id	serverProperty
class	servoy sDetail

Colgroup Tag

Column

padding

width

100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Server Property Details

Table Body (tbody)

id	servoy.rawSQL.allowClientCacheFlushes

Table Row (tr)

id	name

Table Cell (td)
servoy.rawSQL.allowClientCacheFlushes

Table Row (tr)

class	lastDetailRow

Table Cell (td)

...

function

...

servoy sDetail

...

padding	0px
width	100%

...

2100%

height:30px

...

Table Head (th)

colspan	1

Method Details

...

id	executeSQL-String_String_String

Table Row (tr)

id	name

Table Cell (td)
executeSQL

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

executeSQL

Span
(serverName, tableName, sql)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Execute any SQL, returns true if successful.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} serverName - the name of the server
{String} tableName - the name of the table
{String} sql - the sql query to execute

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS

Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/

var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
	//flush is required when changes are made in db
	plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
	var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
	plugins.dialogs.showErrorDialog('Error',  'SQL exception: '+msg,  'Ok')
}

// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed.

...

class	lastDetailRow

...

id	executeSQL-String_String_String_ObjectArray

Table Row (tr)

id	name

Table Cell (td)
executeSQL

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

executeSQL

Span
(serverName, tableName, sql, sql_args)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Execute any SQL, returns true if successful.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} serverName - the name of the server
{String} tableName - the name of the table
{String} sql - the sql query to execute
{Object[]} sql_args - the arguments for the query

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS

Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/

var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
	//flush is required when changes are made in db
	plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
	var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
	plugins.dialogs.showErrorDialog('Error',  'SQL exception: '+msg,  'Ok')
}

// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed.

...

class	lastDetailRow

...

id	executeStoredProcedure-String_String_ObjectArray_NumberArray_Number

Table Row (tr)

id	name

Table Cell (td)
executeStoredProcedure

...

id	sig

...

Span

style	margin-right: 5px;

JSDataSet

Span

style	font-weight: bold;

executeStoredProcedure

...

2

Methods Details

executeSQL

name

executeSQL(serverName, sql)

des

sIndent

Execute any SQL, returns true if successful.

prs

Parameters

sIndent

serverName

the name of the server

sql

the sql query to execute

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

executeSQL

name

executeSQL(serverName, sql, sql_args)

des

sIndent

Execute any SQL, returns true if successful.

prs

Parameters

sIndent

serverName

the name of the server

sql

the sql query to execute

sql_args

the arguments for the query

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

executeStoredProcedure

name

executeStoredProcedure(serverName, procedureDeclaration, arguments, maxNumberOfRowsToRetrieve)

des

sIndent

Execute a stored procedure, return all created result sets.

prs

Parameters

sIndent

serverName

;

procedureDeclaration

;

arguments

;

maxNumberOfRowsToRetrieve

;

ret

Returns

sIndent

the result sets created by the procedure.

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

executeStoredProcedure

name

executeStoredProcedure(serverName, procedureDeclaration, arguments, inOutDirectionality, maxNumberOfRowsToRetrieve)

...

des

...

sIndent

Execute a stored procedure.

...

prs

...

Parameters

...

sIndent

...

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSDataSet

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS

Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/

var maxReturnedRows = 10; //useful to limit number of rows
var procedure_declaration = '{?=calculate_interest_rate(?)}'
// define the direction, a 0 for input data, a 1 for output data
var typesArray = [1, 0];
// define the types and values, a value for input data, a sql-type for output data
var args = [java.sql.Types.NUMERIC, 3000]
// A dataset is returned, when no output-parameters defined, the last select-result in the procedure will be returned.
// When one or more output-parameters are defined, the dataset will contain 1 row with the output data.
var dataset = plugins.rawSQL.executeStoredProcedure(databaseManager.getDataSourceServerName(controller.getDataSource()), procedure_declaration, args, typesArray, maxReturnedRows);
var interest_rate = dataset.getValue(1, 1);

...

class	lastDetailRow

...

id	flushAllClientsCache-String_String

Table Row (tr)

id	name

Table Cell (td)
flushAllClientsCache

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

flushAllClientsCache

Span
(serverName, tableName)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Flush cached database data. Use with extreme care, its affecting the performance of clients!

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} serverName
{String} tableName

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS

Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/

var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
	//flush is required when changes are made in db
	plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
	var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
	plugins.dialogs.showErrorDialog('Error',  'SQL exception: '+msg,  'Ok')
}

// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed.

...

class	lastDetailRow

...

id	getException

Table Row (tr)

id	name

Table Cell (td)
getException

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

ServoyException

Span

style	font-weight: bold;

getException

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

If the result from a function was false, it will return the exception object.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

ServoyException

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS

Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/

var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
	//flush is required when changes are made in db
	plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
	var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
	plugins.dialogs.showErrorDialog('Error',  'SQL exception: '+msg,  'Ok')
}

// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed.

...

class	lastDetailRow

...

id	notifyDataChange-String_String_JSDataSet_Number

Table Row (tr)

id	name

Table Cell (td)
notifyDataChange

...

id	sig

...

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

notifyDataChange

...

serverName

;

procedureDeclaration

;

arguments

;

inOutDirectionality

;

maxNumberOfRowsToRetrieve

;

ret

Returns

sIndent

a dataset with output (in case of output data) or the last result set executed by the procedure.

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

flushAllClientsCache

name

flushAllClientsCache(serverName, tableName)

des

sIndent

Flush cached database data. Use with extreme care, its affecting the performance of clients!

prs

Parameters

sIndent

serverName

;

tableName

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getException

name

getException()

des

sIndent

If the result from a function was false, it will return the exception object.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

notifyDataChange

name

notifyDataChange(serverName, tableName, pksDataset, action)

...

des

...

sIndent

Notify clients about changes in records, based on pk(s). Use with extreme care, its affecting the performance of clients!

...

prs

...

Parameters

...

class	lastDetailRow

...

sIndent

...

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS

Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/

var action = SQL_ACTION_TYPES.DELETE_ACTION //pks deleted
//var action = SQL_ACTION_TYPES.INSERT_ACTION //pks inserted
//var action = SQL_ACTION_TYPES.UPDATE_ACTION //pks updates
var pksdataset = databaseManager.convertToDataSet(new Array(12,15,16,21))
var ok = plugins.rawSQL.notifyDataChange(databaseManager.getDataSourceServerName(controller.getDataSource()), 'employees', pksdataset,action)

serverName

;

tableName

;

pksDataset

;

action

;

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 25

New Version Current

Key

servoy.rawSQL.allowClientCacheFlushes

executeSQL

executeSQL

executeStoredProcedure

executeSQL(serverName, sql)

executeSQL(serverName, sql, sql_args)

executeStoredProcedure(serverName, procedureDeclaration, arguments, maxNumberOfRowsToRetrieve)

executeStoredProcedure(serverName, procedureDeclaration, arguments, inOutDirectionality, maxNumberOfRowsToRetrieve)

des

flushAllClientsCache

getException

notifyDataChange

flushAllClientsCache(serverName, tableName)

getException()

notifyDataChange(serverName, tableName, pksDataset, action)