Qore OracleExtensions Module Reference  1.1
OracleExtensions::OracleDatasourceBase Class Reference

A base class for OracleDatasource and OracleDatasourcePool. Not intended to be used directly. More...

Inheritance diagram for OracleExtensions::OracleDatasourceBase:

Private:Internal Member Methods

*string getDBName ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
*string getUserName ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
any getServerVersion ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
*string getPassword ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
hash getConfigHash ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
*int getPort ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
string getConfigString ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
any getClientVersion ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
*string getOSEncoding ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
string getDriverName ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
string getDBEncoding ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
*string getHostName ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
bool inTransaction ()
 AbstractDatasource implementation for Datasource and DatasourcePool.
 
 setAppInfoCallback (*string oraclient, *string oramodule, *string oraaction)
 Set app info by wrapped Datasource/Pool object.
 
bool currentThreadInTransaction ()
 A backend provided m_ds.currentThreadInTransaction() for wrappeed Datasource/Pool.
 
nothing beginTransaction (*string client, *string module, *string action)
 Start new transaction with Application info set as strings or with potential automatic Application info set. More...
 
nothing beginTransaction (OracleExtensions::OracleApplicationInfo info)
 Start new transaction with Application info set as object. More...
 
any exec (string sql)
 exec with automatic approach of getting application info More...
 
any execRaw (string sql)
 execRaw with automatic approach of getting application info More...
 
any select (string sql)
 select with automatic approach of getting application info More...
 
any selectRow (string sql)
 selectRow with automatic approach of getting application info More...
 
any selectRows (string sql)
 selectRows with automatic approach of getting application info More...
 
any vexec (string sql, softlist vargs)
 vexec with automatic approach of getting application info More...
 
any vselect (string sql, softlist vargs)
 vselect with automatic approach of getting application info More...
 
any vselectRow (string sql, softlist vargs)
 vselectRow with automatic approach of getting application info More...
 
any vselectRows (string sql, softlist vargs)
 vselectRows with automatic approach of getting application info More...
 
any exec (OracleExtensions::OracleApplicationInfo info, string sql)
 exec with user defined application info More...
 
any execRaw (OracleExtensions::OracleApplicationInfo info, string sql)
 execRaw with user defined application info More...
 
any select (OracleExtensions::OracleApplicationInfo info, string sql)
 select with user defined application info More...
 
any selectRow (OracleExtensions::OracleApplicationInfo info, string sql)
 selectRow with user defined application info More...
 
any selectRows (OracleExtensions::OracleApplicationInfo info, string sql)
 selectRows with user defined application info More...
 
any vexec (OracleExtensions::OracleApplicationInfo info, string sql)
 vexec with user defined application info More...
 
any vselect (OracleExtensions::OracleApplicationInfo info, string sql)
 vselect with user defined application info More...
 
any vselectRow (OracleExtensions::OracleApplicationInfo info, string sql)
 vselectRow with user defined application info More...
 
any vselectRows (OracleExtensions::OracleApplicationInfo info, string sql)
 vselectRows with user defined application info More...
 

Additional Inherited Members

- Public Member Methods inherited from OracleExtensions::OracleInstrumentationBase
bool setAutomaticDBInfo (*OracleExtensions::OracleApplicationInfo item, bool checkTransaction=True)
 Obtain info about transaction capturing and try to get available Application Info. More...
 
 setAppInfo (*OracleExtensions::OracleApplicationInfo audit, bool fromSystem=True)
 Set the explicit Application Info. The transaction lock is taken. More...
 
 setAppInfo (*string client, *string module, *string action, bool fromSystem=True)
 An overloaded method with the same functionality as the OracleExtensions::OracleApplicationInfo variant.
 
- Private Attributes inherited from OracleExtensions::OracleInstrumentationBase
*OracleExtensions::OracleApplicationInfo userInfo
 potential user Application Info set by beginTransaction or explicit call of setAppInfo
 
*code autoCode
 user code used in setAutomaticDBInfo when there is no OracleApplicationInfo value provided
 
object m_ds
 Internally used datasource/pool.
 

Detailed Description

A base class for OracleDatasource and OracleDatasourcePool. Not intended to be used directly.

Member Function Documentation

◆ beginTransaction() [1/2]

nothing OracleExtensions::OracleDatasourceBase::beginTransaction ( *string  client,
*string  module,
*string  action 
)
private:internal

Start new transaction with Application info set as strings or with potential automatic Application info set.

Parameters
clientoptional string, application info Client
moduleoptional string, application info Module
actionoptional string, application info Action

Currently used application info will be used in any following method calls if there is no OracleExtensions::OracleApplicationInfo instance used. If there is no user info provided, OracleDatasource tries to find the appropriate Application info automatically if possible.

◆ beginTransaction() [2/2]

nothing OracleExtensions::OracleDatasourceBase::beginTransaction ( OracleExtensions::OracleApplicationInfo  info)
private:internal

Start new transaction with Application info set as object.

Parameters
infomandatory. Application info object instance

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

◆ exec() [1/2]

any OracleExtensions::OracleDatasourceBase::exec ( string  sql)
private:internal

exec with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ exec() [2/2]

any OracleExtensions::OracleDatasourceBase::exec ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

exec with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ execRaw() [1/2]

any OracleExtensions::OracleDatasourceBase::execRaw ( string  sql)
private:internal

execRaw with automatic approach of getting application info

Parameters
sqla SQL statement
Return values
anya result as in parent class method

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

◆ execRaw() [2/2]

any OracleExtensions::OracleDatasourceBase::execRaw ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

execRaw with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
Return values
anya 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.

◆ select() [1/2]

any OracleExtensions::OracleDatasourceBase::select ( string  sql)
private:internal

select with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ select() [2/2]

any OracleExtensions::OracleDatasourceBase::select ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

select with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ selectRow() [1/2]

any OracleExtensions::OracleDatasourceBase::selectRow ( string  sql)
private:internal

selectRow with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ selectRow() [2/2]

any OracleExtensions::OracleDatasourceBase::selectRow ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

selectRow with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ selectRows() [1/2]

any OracleExtensions::OracleDatasourceBase::selectRows ( string  sql)
private:internal

selectRows with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ selectRows() [2/2]

any OracleExtensions::OracleDatasourceBase::selectRows ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

selectRows with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vexec() [1/2]

any OracleExtensions::OracleDatasourceBase::vexec ( string  sql,
softlist  vargs 
)
private:internal

vexec with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vexec() [2/2]

any OracleExtensions::OracleDatasourceBase::vexec ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

vexec with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vselect() [1/2]

any OracleExtensions::OracleDatasourceBase::vselect ( string  sql,
softlist  vargs 
)
private:internal

vselect with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vselect() [2/2]

any OracleExtensions::OracleDatasourceBase::vselect ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

vselect with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vselectRow() [1/2]

any OracleExtensions::OracleDatasourceBase::vselectRow ( string  sql,
softlist  vargs 
)
private:internal

vselectRow with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vselectRow() [2/2]

any OracleExtensions::OracleDatasourceBase::vselectRow ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

vselectRow with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vselectRows() [1/2]

any OracleExtensions::OracleDatasourceBase::vselectRows ( string  sql,
softlist  vargs 
)
private:internal

vselectRows with automatic approach of getting application info

Parameters
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.

◆ vselectRows() [2/2]

any OracleExtensions::OracleDatasourceBase::vselectRows ( OracleExtensions::OracleApplicationInfo  info,
string  sql 
)
private:internal

vselectRows with user defined application info

Parameters
infoa OracleExtensions::OracleApplicationInfo instance
sqla SQL statement
...binding arguments as in parent class method
Return values
anya 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.