private void checkRecords() {
mStatus = NOTOK;
if (mPrintINFO) {
System.out.println(mSdf.format(new java.util.Date()) + CHECKSTRAT + mTablesAndColumnsString[0]);
}//end if
DataRecord drc = null;
String collumn3 = mTablesAndColumnsString[3].substring(0, mTablesAndColumnsString[3].indexOf(";"));
String collumn4 = mTablesAndColumnsString[4].substring(0, mTablesAndColumnsString[4].indexOf(";"));
try {
while (mRs.next()) {
int countrow = 7;
drc = new DataRecord(checkString(mChangeID, 1, mRs.getString(1)),
checkString(mChangeID, 2, mRs.getString(2)),
checkTimestamp(mChangeID, collumn3, mRs.getTimestamp(3)),
checkTimestamp(mChangeID, collumn4, mRs.getTimestamp(4)),
checkString(mChangeID, 5, mRs.getString(5)),
checkString(mChangeID, 6, mRs.getString(6)));
if (mSetGant) {
drc.setmGantFreigabe(getGant(drc.getmFreigabe()));
}//end if
if (mTablesAndColumnsString.length > 8) {
String[] stringValues = new String[mTablesAndColumnsString.length - 8];
for (int i = 0; i < stringValues.length; i++) {
stringValues[i] = checkString(mChangeID, i, mRs.getString(countrow));
countrow++;
}//end for
drc.setmStringValues(stringValues);
if (mPrintDEBU) {
System.out.println("Stringvalues.length: : " + stringValues.length);
}//end if
}//end if
if (mTablesAndColumnsInt.length > 0) {
int[] intValues = new int[mTablesAndColumnsInt.length];
for (int i = 0; i < intValues.length; i++) {
intValues[i] = checkInt(mChangeID, i, mRs.getInt(countrow));
countrow++;
}//end for
drc.setmIntValues(intValues);
if (mPrintDEBU) {
System.out.println("Intvalue.length: " + intValues.length);
}//end if
}//end if
if (mTablesAndColumnsTimestamp.length > 0) {
Timestamp[] timestampValues = new Timestamp[mTablesAndColumnsTimestamp.length];
for (int i = 0; i < timestampValues.length; i++) {
timestampValues[i] = checkTimestamp(mChangeID, mTablesAndColumnsTimestamp[i].substring(0, mTablesAndColumnsTimestamp[i].indexOf(";")), mRs.getTimestamp(countrow));
countrow++;
}//end for
drc.setmTimeStampValues(timestampValues);
if (mPrintDEBU) {
System.out.println("Timestampvalue.length: " + timestampValues.length);
}//end if
}//end if
if (mTablesAndColumnsTime.length > 0) {
Time[] timeValues = new Time[mTablesAndColumnsTime.length];
for (int i = 0; i < timeValues.length; i++) {
timeValues[i] = checkTime(mChangeID, i, mRs.getTime(countrow));
countrow++;
}//end for
drc.setmTimeValues(timeValues);
if (mPrintDEBU) {
System.out.println("Timevalue.length: " + timeValues.length);
}//end if
}//end if
if (mTablesAndColumnsDate.length > 0) {
Date[] DateValues = new Date[mTablesAndColumnsDate.length];
for (int i = 0; i < DateValues.length; i++) {
DateValues[i] = checkDate(mChangeID, i, mRs.getDate(countrow));
countrow++;
}//end for
drc.setmDateValues(DateValues);
if (mPrintDEBU) {
System.out.println("Datevalue.length: " + DateValues.length);
}//end if
}//end if
if (mTablesAndColumnsDouble.length > 0) {
double[] DoubleValues = new double[mTablesAndColumnsDouble.length];
for (int i = 0; i < DoubleValues.length; i++) {
DoubleValues[i] = checkDouble(mChangeID, i, mRs.getDouble(countrow));
countrow++;
}//end for
drc.setmDoubleValues(DoubleValues);
if (mPrintDEBU) {
System.out.println("Doublevalue.length: " + DoubleValues.length);
}//end if
}//end if
if (mPrintDEBU) {
drc.print();
System.out.println("Status @ DRC: " + mStatus + "\n");
} else {
updateProgress();
}//end else
if(drc.getmStartTime() == null){
drc.setmStartTime(new Timestamp(0L));
mStatus = NULLDATE;
}//end if
if(drc.getmEndTime() == null){
drc.setmEndTime(new Timestamp(0L));
mStatus = NULLDATE;
}//end if
if (getmStatus() == OK || getmStatus() == NULLFIELD) {
if (drc.getmStartTime().before(drc.getmEndTime())) {
mDataRecords.add(drc);
if (mPrintDEBU) {
System.out.println("DRC added\n");
}//end if
} else {
if (mPrintDEBU) {
System.out.println(" --------> Invalid Dates @ " + drc.getmUniqueID() + " <--------\n");
}//end if
mErrors.add(new Error(drc.getmUniqueID(), "Invalid Dates", drc.getmStartTime().toString(), drc.getmEndTime().toString()));
mErrorRC++;
}//end else
}//end if
}//end while
if (mPrintINFO) {
System.out.println("\b" + mSdf.format(new java.util.Date()) + CHECKEND_A + mDataRecords.size() + CHECKEND_C);
}//end if
mRs.close();
if (mPrintDEBU) {
System.out.println("\n" + mSdf.format(new java.util.Date()) + " --> mRs.close @ checkRecords" + "\n");
}//end if
mLoadStmt.close();
if (mPrintDEBU) {
System.out.println("\n" + mSdf.format(new java.util.Date()) + " --> mLoadStmt.close @ checkRecords" + "\n");
}//end if
mStatus = OK;
} catch (SQLException s) {
printOut(s, CHECKERROR);
} catch (Exception ex) {
printOut(ex, CHECKERROR);
}//end catch
if (mPrintDEBU) {
System.out.println("Status " + LOADERROR + ": " + mStatus + "\n");
}//end if
}//end methode