// select exact
bool CmpSeabaseDDLauth::selectExactRow(const NAString & cmd)
{
ExeCliInterface cliInterface(STMTHEAP);
Int32 cliRC = cliInterface.fetchRowsPrologue(cmd.data(), true/*no exec*/);
if (cliRC < 0)
{
cliInterface.retrieveSQLDiagnostics(CmpCommon::diags());
DDLException excp (cliRC, NULL, 0);
excp.throwException();
}
cliRC = cliInterface.clearExecFetchClose(NULL, 0);
if (cliRC < 0)
{
cliInterface.retrieveSQLDiagnostics(CmpCommon::diags());
DDLException excp (cliRC, NULL, 0);
excp.throwException();
}
// if diags not cleared, then no error is returned -- ??
if (cliRC == 100) // did not find the row
{
cliInterface.clearGlobalDiags();
return false;
}
char * ptr = NULL;
Lng32 len = 0;
char type [6];
// value 1: auth_id (int32)
cliInterface.getPtrAndLen(1, ptr, len);
setAuthID(*(Int32*)ptr);
// value 2: auth_db_name (NAString)
cliInterface.getPtrAndLen(2,ptr,len);
NAString dbName(ptr,len);
setAuthDbName(dbName);
// value 3: auth_ext_name (NAString)
cliInterface.getPtrAndLen(3,ptr,len);
NAString extName(ptr,len);
setAuthExtName(extName);
// value 4: auth_type (char)
// str_cpy_and_null params: *tgt, *src, len, endchar, blank, null term
cliInterface.getPtrAndLen(4,ptr,len);
str_cpy_and_null(type, ptr, len, '\0', ' ', true);
if ( type[0] == 'U')
setAuthType(COM_USER_CLASS);
else if (type[0] == 'R')
setAuthType(COM_USER_CLASS);
else
setAuthType(COM_UNKNOWN_ID_CLASS);
// value 5: auth_creator (int32)
cliInterface.getPtrAndLen(5,ptr,len);
setAuthCreator(*(Int32*)ptr);
// value 6: auth_is_valid (char)
cliInterface.getPtrAndLen(6,ptr,len);
str_cpy_and_null(type, ptr, len, '\0', ' ', true);
if (type[0] == 'Y')
setAuthValid(true);
else
setAuthValid(false);
// value 7: auth_create_time (int64)
cliInterface.getPtrAndLen(7,ptr,len);
Int64 intValue = *(Int64*)ptr;
setAuthCreateTime((ComTimestamp) intValue);
// value 8: auth_redef_time (int64)
cliInterface.getPtrAndLen(8,ptr,len);
intValue = *(Int64*)ptr;
setAuthRedefTime((ComTimestamp) intValue);
cliInterface.fetchRowsEpilogue(NULL, true);
return true;
}
NARoutine::NARoutine(const QualifiedName &name,
const TrafDesc *routine_desc,
BindWA *bindWA,
Int32 &errorOccurred,
NAMemory *heap)
: name_ (name, heap)
, hashKey_ (name, heap)
, language_ (routine_desc->routineDesc()->language)
, UDRType_ (routine_desc->routineDesc()->UDRType)
, sqlAccess_ (routine_desc->routineDesc()->sqlAccess)
, transactionAttributes_ (routine_desc->routineDesc()->transactionAttributes)
, maxResults_ (routine_desc->routineDesc()->maxResults)
, stateAreaSize_ (routine_desc->routineDesc()->stateAreaSize)
, externalFile_ ("", heap)
, externalPath_ (routine_desc->routineDesc()->libraryFileName, heap)
, externalName_ ("", heap)
, librarySqlName_ (routine_desc->routineDesc()->librarySqlName, COM_UNKNOWN_NAME, FALSE, heap) //TODO
, signature_ (routine_desc->routineDesc()->signature, heap)
, paramStyle_ (routine_desc->routineDesc()->paramStyle)
, paramStyleVersion_ (COM_ROUTINE_PARAM_STYLE_VERSION_1)
, isDeterministic_ (routine_desc->routineDesc()->isDeterministic)
, isCallOnNull_ (routine_desc->routineDesc()->isCallOnNull )
, isIsolate_ (routine_desc->routineDesc()->isIsolate)
, externalSecurity_ (routine_desc->routineDesc()->externalSecurity)
, isExtraCall_ (FALSE) //TODO
, hasOutParams_ (FALSE)
, redefTime_ (0) //TODO
, lastUsedTime_ (0)
, routineSecKeySet_ (heap)
, passThruDataNumEntries_ (0)
, passThruData_ (NULL)
, passThruDataSize_ (0)
, udfFanOut_ (1) // TODO
, uecValues_ (heap,0)
, isUniversal_ (0) // TODO
, actionPosition_ (0) // TODO
, executionMode_ (COM_ROUTINE_SAFE_EXECUTION)
, objectUID_ (routine_desc->routineDesc()->objectUID)
, dllName_ (routine_desc->routineDesc()->libraryFileName, heap)
, dllEntryPoint_ (routine_desc->routineDesc()->externalName, heap)
, sasFormatWidth_ ("", heap) //TODO
, systemName_ ("", heap) // TODO
, dataSource_ ("", heap) // TODO
, fileSuffix_ ("", heap) // TODO
, schemaVersionOfRoutine_ ((COM_VERSION)0) // TODO
, objectOwner_ (routine_desc->routineDesc()->owner)
, schemaOwner_ (routine_desc->routineDesc()->schemaOwner)
, privInfo_ (NULL)
, heap_(heap)
{
char parallelism[5];
CmGetComRoutineParallelismAsLit(routine_desc->routineDesc()->parallelism, parallelism);
comRoutineParallelism_ = ((char *)parallelism);
if (paramStyle_ == COM_STYLE_JAVA_CALL)
{
NAString extName(routine_desc->routineDesc()->externalName);
size_t pos=extName.last('.');
externalName_ = extName(pos+1, (extName.length()-pos-1)); // method_name
externalFile_ = extName.remove (pos); // package_name.class_name
}
else
{
externalName_ = routine_desc->routineDesc()->externalName;
if (language_ == COM_LANGUAGE_C ||
language_ == COM_LANGUAGE_CPP)
{
// Split the fully-qualified DLL name into a directory name and
// simple file name
ComUInt32 len = dllName_.length();
if (len > 0)
{
size_t lastSlash = dllName_.last('/');
if (lastSlash == NA_NPOS)
{
// No slash was found
externalPath_ = ".";
externalFile_ = dllName_;
}
else
{
// A slash was found. EXTERNAL PATH is everything before the
// slash. EXTERNAL FILE is everything after.
externalPath_ = dllName_;
externalPath_.remove(lastSlash, len - lastSlash);
externalFile_ = dllName_;
externalFile_.remove(0, lastSlash + 1);
}
}
} // if (len > 0)
}
ComSInt32 colCount = routine_desc->routineDesc()->paramsCount;
NAColumn *newCol = NULL;
NAType *newColType = NULL;
extRoutineName_ = new (heap) ExtendedQualName( name_, heap );
extActionName_ = new (heap) NAString(heap);
intActionName_ = new (heap) ComObjectName(heap);
params_ = new (heap) NAColumnArray(heap);
inParams_ = new (heap) NAColumnArray(heap);
outParams_ = new (heap) NAColumnArray(heap);
// to compute java signature
ComFSDataType *paramType = new STMTHEAP ComFSDataType[colCount];
ComUInt32 *subType = new STMTHEAP ComUInt32 [colCount];
ComColumnDirection *direction = new STMTHEAP ComColumnDirection[colCount] ;
//
// Construct the CostVectors
// CQDs are checked at Bind time.
Int32 initCpuCost = -1;
Int32 initIOCost = -1;
Int32 initMsgCost = -1;
CostScalar initialCpuCost( initCpuCost);
CostScalar initialIOCost( initIOCost);
CostScalar initialMsgCost( initMsgCost);
initialRowCost_.setCPUTime( initCpuCost < 0 ? csMinusOne : initialCpuCost);
initialRowCost_.setIOTime( initIOCost < 0 ? csMinusOne : initialIOCost);
initialRowCost_.setMSGTime( initMsgCost < 0 ? csMinusOne : initialMsgCost);
Int32 normCpuCost = -1;
Int32 normIOCost = -1;
Int32 normMsgCost = -1;
CostScalar normalCpuCost( normCpuCost);
CostScalar normalIOCost( normIOCost);
CostScalar normalMsgCost( normMsgCost);
normalRowCost_.setCPUTime( normCpuCost < 0 ? csMinusOne : normalCpuCost);
normalRowCost_.setIOTime( normIOCost < 0 ? csMinusOne : normalIOCost);
normalRowCost_.setMSGTime( normMsgCost < 0 ? csMinusOne : normalMsgCost);
TrafDesc *params_desc_list = routine_desc->routineDesc()->params;
TrafColumnsDesc *param_desc;
int i = 0;
while (params_desc_list)
{
param_desc = params_desc_list->columnsDesc();
// Create the new NAType.
if (NAColumn::createNAType(param_desc->columnsDesc(), (const NATable *)NULL, newColType, heap_))
{
errorOccurred = TRUE;
return;
}
if (param_desc->colname && strncmp(param_desc->colname, "#:", 2) == 0)
{
memset(param_desc->colname, 0, 2);
}
ComParamDirection colDirection = param_desc->paramDirection();
// Create the new NAColumn and insert it into the NAColumnArray
newCol = new (heap) NAColumn(
(const char *)UDRCopyString (param_desc->colname, heap)
, param_desc->colnumber
, newColType
, heap
, NULL // NATable *
, USER_COLUMN
, COM_NO_DEFAULT
, NULL // default value
, UDRCopyString("", heap) // TODO:heading can it have some value
, param_desc->isUpshifted()
, FALSE // addedColumn
, (ComColumnDirection) colDirection
, param_desc->isOptional()
, (char *) COM_NORMAL_PARAM_TYPE_LIT
);
// We have to check for INOUT in both the
// if's below
if ( COM_OUTPUT_PARAM == colDirection ||
COM_INOUT_PARAM == colDirection )
{
hasOutParams_ = TRUE;
outParams_->insert (newCol);
params_->insert (newCol );
}
if ( COM_INPUT_PARAM == colDirection ||
COM_INOUT_PARAM == colDirection )
{
inParams_->insert (newCol);
if ( COM_INOUT_PARAM != colDirection )
{
params_->insert (newCol );
} // if not INOUT
} // if IN or INOUT
// Gather the param attributes for LM from the paramDefArray previously
// populated and from the routineparamList generated from paramDefArray.
paramType[i] = (ComFSDataType)newColType->getFSDatatype();
subType[i] = 0; // default
// Set subType for special cases detected by LM
switch ( paramType[i] )
{
case COM_SIGNED_BIN16_FSDT :
case COM_SIGNED_BIN32_FSDT :
case COM_SIGNED_BIN64_FSDT :
case COM_UNSIGNED_BIN16_FSDT :
case COM_UNSIGNED_BIN32_FSDT :
case COM_UNSIGNED_BPINT_FSDT :
{
subType[i] = newColType->getPrecision();
break;
}
case COM_DATETIME_FSDT :
{
switch ( ((DatetimeType *)newColType)->getSubtype() )
{
case DatetimeType::SUBTYPE_SQLDate : subType[i] = 1; break;
case DatetimeType::SUBTYPE_SQLTime : subType[i] = 2; break;
case DatetimeType::SUBTYPE_SQLTimestamp : subType[i] = 3; break;
}
}
} // end switch paramType[i]
direction[i] = (ComColumnDirection) colDirection;
params_desc_list = params_desc_list->next;
i++;
} // for
passThruDataNumEntries_ = 0;
passThruData_ = NULL;
passThruDataSize_ = NULL;
#define MAX_SIGNATURE_LENGTH 8193
if ((language_ == COM_LANGUAGE_JAVA)&&(signature_.length() < 2))
{
// Allocate buffer for generated signature
char sigBuf[MAX_SIGNATURE_LENGTH];
sigBuf[0] = '\0';
// If the syntax specified a signature, pass that to LanguageManager.
char* optionalSig = NULL;
ComBoolean isJavaMain =
((str_cmp_ne(externalName_.data(), "main") == 0) ? TRUE : FALSE);
LmResult createSigResult;
LmJavaSignature *lmSignature = new (STMTHEAP) LmJavaSignature(NULL,
STMTHEAP);
createSigResult = lmSignature->createSig(paramType, subType, direction,
colCount, COM_UNKNOWN_FSDT, 0,
maxResults_, optionalSig,
isJavaMain, sigBuf,
MAX_SIGNATURE_LENGTH,
CmpCommon::diags());
NADELETE(lmSignature, LmJavaSignature, STMTHEAP);
// Lm returned error. Lm fills diags area
if (createSigResult != LM_ERR)
signature_ = sigBuf;
}
getPrivileges(routine_desc->routineDesc()->priv_desc);
heapSize_ = (heap ? heap->getTotalSize() : 0);
}
