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)

...

id	serverProperty
class	servoy sDetail

...

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Server Property Details

...

id	servoy.rawSQL.allowClientCacheFlushes

...

id	name

...

table

.

...

class	lastDetailRow

servoy sDetail

id

function

class

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style

2100%

height:30px

;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

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.

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

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, id

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)

Table Row (tr) Divclass

des

Table Cell (td)id

sIndent

Execute any SQL, returns true if successful.

Table Row (tr)

prs

Table Cell (td)

Parameters

div

classsIndent{String} serverName – the name of the server
{String} tableName – the name of the table
{String} sql – the sql query to execute
{Object[]} sql_args – Table Row (tr)idthe arguments for the querytdret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

Boolean Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td) Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	executeStoredProcedure-String_String_ObjectArray_NumberArray_Number

Table Row (tr)

id	name

Table Cell (td)
executeStoredProcedure

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSDataSet

Span

style	font-weight: bold;

executeStoredProcedure

Span

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.

id

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)

Table Row (tr)class

des

Table Cell (td) Divid

sIndent

Execute a stored procedure.

Table Row (tr)

prs

Table Cell (td)class

Parameters

Div

sIndent

{String} serverName
{String} procedureDeclaration
{Object[]} arguments
{Number[]} inOutDirectionality
{Number} maxNumberOfRowsToRetrieve

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);

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

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.

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

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.

Table Row (tr)

class	lastDetailRow

Table Cell (td) Table Body (tbody)

id	notifyDataChange-String_String_JSDataSet_Number

Table Row (tr)

id	name

Table Cell (td)
notifyDataChange

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

notifyDataChange

Span

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)

tr

id Divclass

des

Table Cell (td)

sIndent

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

Table Row (tr)id

prs Table Cell (td)
Parameters
 Divclass 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)
 Table Row (tr)class lastDetailRow
tdsIndent{String} serverName
 {String} tableName
 {JSDataSet} pksDataset
 {Number} actionserverName ;tableName ;pksDataset ;action ;ret
Returns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 24

New Version Current

Key

executeSQL

executeSQL

executeSQL(serverName, sql)

executeSQL(serverName, sql, sql_args)

executeStoredProcedure

executeStoredProcedure(serverName, procedureDeclaration, arguments, maxNumberOfRowsToRetrieve)

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

flushAllClientsCache

getException

notifyDataChange

flushAllClientsCache(serverName, tableName)

getException()

notifyDataChange(serverName, tableName, pksDataset, action)