var sqlUtils = new Packages.com.quantros.utils.SQLUtils();
var DBMS_URL="train";
var vErrors="";
/**************************** START FUNCTIONS ****************************************/

var checkManFields = function(arrlabels,arr)
{
var errorMsgs="";
if (arr.length!=arrlabels.length)
{
errorMsgs+="Tahoe 16801 Labels and columns array must match";
}
for(var i=0; i<arr.length; i++)
{
if (arr[i]=="")
{
errorMsgs+="Tahoe 16801 Mandatory: " + arrlabels[i];
}
}

return errorMsgs;
}

function executeUpdate(strSQL,inParamsArray,inParamsTypesArray)
{
return sqlUtils.executeUpdate(DBMS_URL,strSQL,makeJavaArr(inParamsArray),makeJavaArr(inParamsTypesArray));
}

function executeSingleRowQuery(strSQL,inParamsArray,inParamsTypesArray)
{
var s=sqlUtils.executeSingleRowQuery(DBMS_URL,strSQL,makeJavaArr(inParamsArray),makeJavaArr(inParamsTypesArray));
var arr = s.split(",");
return arr;
}

function executeSingleValQuery(strSQL,inParamsArray,inParamsTypesArray)
{
return sqlUtils.executeSingleValQuery(DBMS_URL,strSQL,makeJavaArr(inParamsArray),makeJavaArr(inParamsTypesArray));
}

function makeJavaArr(jsArray)
{
var ae = java.lang.reflect.Array.newInstance(java.lang.String, jsArray.length);
for(var i=0; i<jsArray.length; i++)
{
ae[i]=jsArray[i];
}
return ae;
}

function arrayToString(arr)

{
var s="";
for(var i=0; i<arr.length; i++)
{
s+= arr[i] +",";
}
return s;
}

function checkSize(elemLabel,elemValue,sizeSpec)
{
if (elemValue.length > sizeSpec)
{
vErrors += elemLabel + "Tahoe 16801 Size greather than specified. Expecting: " + sizeSpec + " Actual: " + elemValue.length;
logger.error("Tahoe 16801" + elemLabel + " size greather than specified. elemValue: " + elemValue + " Expecting: " + sizeSpec + " Actual: " + elemValue.length + " msg: " + connectorMessage.getRawData());
}
return elemValue;
}

function formatDate(value,dateFormat)
{
var s="";
if ((value=="")||(value.length<8)) return "";
else
{
value=value.substring(0,8);
s=new java.text.SimpleDateFormat("MM/dd/yyyy").format(new java.text.SimpleDateFormat(dateFormat).parse(value));
}
return s;

}

String.prototype.trim = function() {
a = this.replace(/^\s+/, '');
return a.replace(/\s+$/, '');
};