OracleDatasourcePool class implementation. More...

Inherits DatasourcePool, and OracleExtensionsPriv::OracleDatasourceBase.

Public Member Functions
	constructor (string driver, string user, string pass, string db, string encoding, string host, softint min=3, softint max=10, softint port=0, code userAutoInfo)
	Standard Qore::DatasourcePool constructor.

	constructor (string desc, *code userAutoInfo)
	Standard Qore::DatasourcePool constructor.

	constructor (hash opts, *code userAutoInfo)
	Standard Qore::DatasourcePool constructor.

	constructor (DatasourcePool ds, *code userAutoInfo)
	New constructor: use login attributes from already existing DatasourcePool.

	commit ()
	Commit the transaction. Application info is cleared. DBMS_OUTPUT disabled.

	rollback ()
	Rollback the transaction. Application info is cleared. DBMS_OUTPUT disabled.

	beginTransaction (string client, string module, *string action)
	Start new transaction with Aplication info set as strings.

	beginTransaction (OracleExtensions::OracleApplicationInfo info)
	Start new transaction with Aplication info set as object.

	beginTransaction ()
	Start new transaction with potential automatic Aplication info set.

any	exec (string sql)
	exec with automatic approach of getting application info

any	execRaw (string sql)
	execRaw with automatic approach of getting application info

any	select (string sql)
	select with automatic approach of getting application info

any	selectRow (string sql)
	selectRow with automatic approach of getting application info

any	selectRows (string sql)
	selectRows with automatic approach of getting application info

any	vexec (string sql)
	vexec with automatic approach of getting application info

any	vselect (string sql)
	vselect with automatic approach of getting application info

any	vselectRow (string sql)
	vselectRow with automatic approach of getting application info

any	vselectRows (string sql)
	vselectRows with automatic approach of getting application info

any	exec (OracleExtensions::OracleApplicationInfo info, string sql)
	exec with user defined application info

any	execRaw (OracleExtensions::OracleApplicationInfo info, string sql)
	execRaw with user defined application info

any	select (OracleExtensions::OracleApplicationInfo info, string sql)
	select with user defined application info

any	selectRow (OracleExtensions::OracleApplicationInfo info, string sql)
	selectRow with user defined application info

any	selectRows (OracleExtensions::OracleApplicationInfo info, string sql)
	selectRows with user defined application info

any	vexec (OracleExtensions::OracleApplicationInfo info, string sql)
	vexec with user defined application info

any	vselect (OracleExtensions::OracleApplicationInfo info, string sql)
	vselect with user defined application info

any	vselectRow (OracleExtensions::OracleApplicationInfo info, string sql)
	vselectRow with user defined application info

any	vselectRows (OracleExtensions::OracleApplicationInfo info, string sql)
	vselectRows with user defined application info

	setAppInfo (string client, string module, *string action)
	Set user application info and assign the transaction lock.

	setAppInfo (OracleExtensions::OracleApplicationInfo info)
	Set user application info and assign the transaction lock.

	setLongOpsProgress (OracleExtensions::OracleLongOps lo)
	set Long Operations progress

	outputEnable (*int bufferSize)
	Enable output buffering.

	outputDisable ()
	Disable the output buffering.

	outputPut (softstring text)
	Put string into the buffer without new line at the end.

	outputPutLine (softstring text)
	Put string into the buffer with new line at the end.

*string	outputGet ()
	Get the DBMS server outout buffer content.

Detailed Description

OracleDatasourcePool class implementation.

Directly inherited from Qore::DatasourcePool.

Member Function Documentation

OracleExtensions::OracleDatasourcePool::beginTransaction	(	*string	client,
		*string	module,
		*string	action
	)

Start new transaction with Aplication info set as strings.

Parameters

client	optional string, application info `Client`
module	optional string, application info `Module`
action	optional string, application info `Action`

Currently used application info will be used in any following method calls if there is no OracleExtensions::OracleApplicationInfo instance used.

OracleExtensions::OracleDatasourcePool::beginTransaction ( OracleExtensions::OracleApplicationInfo info )

Start new transaction with Aplication info set as object.

Parameters

info	mandatory. Application info object instance

Currently used application info will be used in any following method calls if there is no OracleExtensions::OracleApplicationInfo instance used.

OracleExtensions::OracleDatasourcePool::beginTransaction ( )

Start new transaction with potential automatic Aplication info set.

There is no user info provided. OracleDatasourcePool tries to find the appropriate Application info automatically if possible.

OracleExtensions::OracleDatasourcePool::constructor	(	string	driver,
		*string	user,
		*string	pass,
		*string	db,
		*string	encoding,
		*string	host,
		softint	min = `3`,
		softint	max = `10`,
		softint	port = `0`,
		*code	userAutoInfo
	)

inline

Standard Qore::DatasourcePool constructor.

Parameters

userAutoInfo see Automatic Application Info

OracleExtensions::OracleDatasourcePool::constructor	(	string	desc,
		*code	userAutoInfo
	)

inline

Standard Qore::DatasourcePool constructor.

Parameters

userAutoInfo see Automatic Application Info

OracleExtensions::OracleDatasourcePool::constructor	(	hash	opts,
		*code	userAutoInfo
	)

inline

Standard Qore::DatasourcePool constructor.

Parameters

userAutoInfo see Automatic Application Info

OracleExtensions::OracleDatasourcePool::constructor	(	DatasourcePool	ds,
		*code	userAutoInfo
	)

inline

New constructor: use login attributes from already existing DatasourcePool.

The original DatasourcePool staus unaffected as in DatasourcePool::copy() method.

Parameters

userAutoInfo see Automatic Application Info

any OracleExtensions::OracleDatasourcePool::exec ( string sql )

exec with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::exec	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

exec with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

any OracleExtensions::OracleDatasourcePool::execRaw ( string sql )

execRaw with automatic approach of getting application info

Parameters

sql	a SQL statement

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::execRaw	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

execRaw with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

OracleExtensions::OracleDatasourcePool::outputEnable ( *int bufferSize )

Enable output buffering.

Parameters

bufferSize a size of buffer in 2000-1000000 interval or NOTHING

If there are multiple calls to ENABLE, then buffer_size is the last of the values specified. The maximum size is 1,000,000, and the minimum is 2,000 when the user specifies bufferSize.

NOTHING is expected to be the usual choice. The default is 20,000 for backwards compatibility with earlier database versions that did not support unlimited buffering.

*string OracleExtensions::OracleDatasourcePool::outputGet ( )

Get the DBMS server outout buffer content.

Return values

__7_	string a buffer content or NOTHING if there is no server outout enabled

any OracleExtensions::OracleDatasourcePool::select ( string sql )

select with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::select	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

select with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

any OracleExtensions::OracleDatasourcePool::selectRow ( string sql )

selectRow with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::selectRow	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

selectRow with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

any OracleExtensions::OracleDatasourcePool::selectRows ( string sql )

selectRows with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::selectRows	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

selectRows with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

OracleExtensions::OracleDatasourcePool::setAppInfo ( OracleExtensions::OracleApplicationInfo info )

Set user application info and assign the transaction lock.

Parameters

info	mandatory. Application info object instance

Currently used application info will be used in any following method calls if there is no OracleExtensions::OracleApplicationInfo instance used.

OracleExtensions::OracleDatasourcePool::setLongOpsProgress ( OracleExtensions::OracleLongOps lo )

set Long Operations progress

Parameters

lo	an OracleExtensions::OracleLongOps instance

any OracleExtensions::OracleDatasourcePool::vexec ( string sql )

vexec with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::vexec	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

vexec with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

any OracleExtensions::OracleDatasourcePool::vselect ( string sql )

vselect with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::vselect	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

vselect with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

any OracleExtensions::OracleDatasourcePool::vselectRow ( string sql )

vselectRow with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::vselectRow	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

vselectRow with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

any OracleExtensions::OracleDatasourcePool::vselectRows ( string sql )

vselectRows with automatic approach of getting application info

Parameters

sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method tries to find application info automatically. The previously set info (beginTransaction, setAppInfo) is used or a context related info is used in Qorus Integration Engine.

any OracleExtensions::OracleDatasourcePool::vselectRows	(	OracleExtensions::OracleApplicationInfo	info,
		string	sql
	)

vselectRows with user defined application info

Parameters

info	a OracleExtensions::OracleApplicationInfo instance
sql	a SQL statement
...	binding arguments as in parent class method

Return values

any	a result as in parent class method

This method sets given application info. The previously set info (beginTransaction, setAppInfo) is overriden and the context related info is skipped.

Public Member Functions

Detailed Description

Member Function Documentation