fwConfigurationDB_DBAccess.ctl File Reference

Functions

void fwConfigurationDB_dbConnect (string dbConnectionName, string connectString, string dbType, string dbName, string dbUser, string dbSchema, string dbPassword, dbConnection &dbCon, dyn_string &exceptionInfo, bool errorIfOpenFails=TRUE)
void _fwConfigurationDB_getDBDriver (string dbType, string &driver, dyn_string &exceptionInfo)
string _fwConfigurationDB_extractOraErrCode (string errTxt, string &oraMsg)
void fwConfigurationDB_callPlSqlApi (string functionName, dyn_mixed functionParams, string inputColumns, string outputColumns, dyn_dyn_mixed inputData, dyn_dyn_mixed &outputData, dyn_string &exceptionInfo, dyn_int outputColumnTypes=0, bool cleanupInputTable=TRUE)
Database Access functions

These functions are used in context of database access



void fwConfigurationDB_openDBConnection (string dbConnectionName, dbConnection &dbCon, dyn_string &exceptionInfo)
string _fwConfigurationDB_checkSchemaPrivileges (dbConnection dbCon, dyn_string &exceptionInfo)
void fwConfigurationDB_checkOpenDB (dyn_string &exceptionInfo)
void fwConfigurationDB_initializeQuery (string sql, dbConnection conn, dbCommand &dbCmd, dyn_string &exceptionInfo)
void fwConfigurationDB_initializeQueryWithParams (string sql, dbConnection conn, mixed bindParams, dbCommand &dbCmd, dyn_string &exceptionInfo)
int fwConfigurationDB_fetchQuery (dbCommand &dbCmd, dyn_dyn_mixed &aRecords, dyn_string &exceptionInfo, int maxRecords=0, bool columnWise=FALSE, bool closeOnNoMoreData=TRUE, dyn_int colTypes=0, int numCol=999)
void _fwConfigurationDB_executeDBQuery (string sql, dbConnection conn, dyn_dyn_mixed &aRecords, dyn_string &exceptionInfo, int numCol=999, bool columnWise=FALSE, dyn_int colTypes=0)
void _fwConfigurationDB_executeDBQueryWithParams (string sql, dbConnection conn, anytype bindParams, dyn_dyn_mixed &aRecords, dyn_string &exceptionInfo, int numCol=999, bool columnWise=FALSE, dyn_int colTypes=0)
void _fwConfigurationDB_executeDBBulkCmd (string sql, dbConnection conn, dyn_dyn_mixed data, dyn_string &exceptionInfo, bool columnWise=FALSE)
void _fwConfigurationDB_executeDBCmd (string sql, dbConnection conn, anytype params, dyn_string &exceptionInfo)
void fwConfigurationDB_executeSqlSimple (string sql, dbConnection connection, dyn_string &exceptionInfo)
bool _fwConfigurationDB_hasKeywords (string src, string keywords)
void _fwConfigurationDB_executeSqlFromFile (dbConnection dbCon, string fileName, string whatItIs, dyn_string &exceptionInfo, bool breakOnDbError=TRUE)

Variables

global string _fwConfigurationDB_fileVersion_fwConfigurationDB_DBAccess_ctl = "3.5.7"
Error Codes in DBAccess package

see also Error Codes overview module.



const int fwConfigurationDB_ERROR_DBNoConnection = -162

Detailed Description

This package contains database access functions of the Configuration Database tool

Author:
Piotr Golonka (EN/ICE-SCD)
Date:
October 2012

Function Documentation

void fwConfigurationDB_dbConnect ( string  dbConnectionName,
string  connectString,
string  dbType,
string  dbName,
string  dbUser,
string  dbSchema,
string  dbPassword,
dbConnection &  dbCon,
dyn_string &  exceptionInfo,
bool  errorIfOpenFails = TRUE 
)
void _fwConfigurationDB_getDBDriver ( string  dbType,
string &  driver,
dyn_string &  exceptionInfo 
)
string _fwConfigurationDB_extractOraErrCode ( string  errTxt,
string &  oraMsg 
)
void fwConfigurationDB_callPlSqlApi ( string  functionName,
dyn_mixed  functionParams,
string  inputColumns,
string  outputColumns,
dyn_dyn_mixed  inputData,
dyn_dyn_mixed &  outputData,
dyn_string &  exceptionInfo,
dyn_int  outputColumnTypes = 0,
bool  cleanupInputTable = TRUE 
)

Variable Documentation

connection to database does not exist


Generated on 4 Oct 2012 for Configuration Database component by  doxygen 1.6.1