net.sourceforge.msscodefactory.v1_10.MSSBamPg8.MSSBamPg8DateDefTable.java Source code

Introduction

Here is the source code for net.sourceforge.msscodefactory.v1_10.MSSBamPg8.MSSBamPg8DateDefTable.java

Source

// Description: Java 6 PostgreSQL Jdbc DbIO implementation for DateDef.

/*
 *   MSS Code Factory 1.10
 *
 *   Copyright (c) 2012 Mark Sobkow
 *   
 *   This program is available as free software under the GNU GPL v3, or
 *   under a commercial license from Mark Sobkow.  For commercial licensing
 *   details, please contact msobkow@sasktel.net.
 *   
 *   Under the terms of the GPL:
 *   
 *      This program is free software: you can redistribute it and/or modify
 *      it under the terms of the GNU General Public License as published by
 *      the Free Software Foundation, either version 3 of the License, or
 *      (at your option) any later version.
 *     
 *      This program is distributed in the hope that it will be useful,
 *      but WITHOUT ANY WARRANTY; without even the implied warranty of
 *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *      GNU General Public License for more details.
 *     
 *      You should have received a copy of the GNU General Public License
 *      along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *   
 * ***********************************************************************
 *
 *   Code manufactured
 *   by MSS Code Factory version 1.9.3294
 *
 *   $Revision: 26 $
 */

package net.sourceforge.msscodefactory.v1_10.MSSBamPg8;

import java.math.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import net.sourceforge.msscodefactory.cflib.v1_9.CFLib.*;
import org.apache.commons.codec.binary.Base64;
import net.sourceforge.msscodefactory.v1_10.MSSBam.*;

/*
 *   MSSBamPg8DateDefTable PostgreSQL Jdbc DbIO implementation
 *   for DateDef.
 *
 *   Data redaction is the responsibility of another layer.  The raw database
 *   interface returns everything regardless of whether the end user is
 *   authorized to see the data.  A redaction layer replaces protected/redacted
 *   buffs with default values.  They should not be included in client-side
 *   filter sets, and the network redaction layer should actually eliminate them
 *   before transmitting data to the client.  The client should never see
 *   redacted data in order to comply with data privacy regulations in Canada
 *   and the US.
 */
public class MSSBamPg8DateDefTable implements IMSSBamDateDefTable {
    private MSSBamPg8Schema schema;

    public MSSBamPg8DateDefTable(MSSBamPg8Schema argSchema) {
        schema = argSchema;
    }

    public void createDateDef(MSSBamAuthorization Authorization, MSSBamDateDefBuff Buff) {
        final String S_ProcName = "createDateDef ";
        try {
            Connection cnx = schema.getCnx();
            long Id = Buff.getRequiredId();
            Calendar InitValue = Buff.getOptionalInitValue();
            Calendar DefaultValue = Buff.getOptionalDefaultValue();
            Calendar MinValue = Buff.getOptionalMinValue();
            Calendar MaxValue = Buff.getOptionalMaxValue();
            Calendar NullValue = Buff.getOptionalNullValue();
            Calendar UnknownValue = Buff.getOptionalUnknownValue();
            String sql = "INSERT INTO mssbam110.date_def( " + "id, " + "initval, " + "defval, " + "minval, "
                    + "maxval, " + "nullvalue, " + "unknownval" + " )" + "VALUES ( " + Id + ", " + "to_timestamp( "
                    + MSSBamPg8Schema.getDateString(InitValue) + ", 'YYYY-MM-DD' )" + ", " + "to_timestamp( "
                    + MSSBamPg8Schema.getDateString(DefaultValue) + ", 'YYYY-MM-DD' )" + ", " + "to_timestamp( "
                    + MSSBamPg8Schema.getDateString(MinValue) + ", 'YYYY-MM-DD' )" + ", " + "to_timestamp( "
                    + MSSBamPg8Schema.getDateString(MaxValue) + ", 'YYYY-MM-DD' )" + ", " + "to_timestamp( "
                    + MSSBamPg8Schema.getDateString(NullValue) + ", 'YYYY-MM-DD' )" + ", " + "to_timestamp( "
                    + MSSBamPg8Schema.getDateString(UnknownValue) + ", 'YYYY-MM-DD' )" + " )";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            int rowsAffected = stmt.executeUpdate(sql);
            if (rowsAffected != 1) {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 row to be affected by insert, not " + rowsAffected);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public final static String S_sqlSelectDateDefDistinctClassCode = "SELECT " + "DISTINCT anyo.ClassCode "
            + "FROM mssbam110.any_obj AS anyo " + "INNER JOIN mssbam110.scope scp ON " + "scp.Id = anyo.Id "
            + "INNER JOIN mssbam110.valuedef val ON " + "val.Id = anyo.Id "
            + "INNER JOIN mssbam110.atom_def atm ON " + "atm.Id = anyo.Id "
            + "INNER JOIN mssbam110.date_def dat ON " + "dat.Id = anyo.Id ";

    public final static String S_sqlSelectDateDefBuff = "SELECT " + "anyo.ClassCode, " + "anyo.Id, "
            + "anyo.TenantId, " + "anyo.ScopeId, " + "anyo.Name, " + "anyo.short_name, " + "anyo.Label, "
            + "anyo.short_descr, " + "anyo.descr, " + "anyo.AuthorId, " + "val.ValueContainerId, "
            + "val.IsNullable, " + "val.GenerateId, " + "val.DataScopeId, " + "val.ViewAccessSecurityId, "
            + "val.EditAccessSecurityId, " + "val.ViewAccessFrequencyId, " + "val.EditAccessFrequencyId, "
            + "val.PrevId, " + "val.NextId, " + "atm.DbName, " + "to_char( dat.InitVal, 'YYYY-MM-DD' ) AS InitVal, "
            + "to_char( dat.DefVal, 'YYYY-MM-DD' ) AS DefVal, " + "to_char( dat.MinVal, 'YYYY-MM-DD' ) AS MinVal, "
            + "to_char( dat.MaxVal, 'YYYY-MM-DD' ) AS MaxVal, "
            + "to_char( dat.NullValue, 'YYYY-MM-DD' ) AS NullValue, "
            + "to_char( dat.UnknownVal, 'YYYY-MM-DD' ) AS UnknownVal, " + "anyo.Revision "
            + "FROM mssbam110.any_obj AS anyo " + "INNER JOIN mssbam110.scope scp ON " + "scp.Id = anyo.Id "
            + "INNER JOIN mssbam110.valuedef val ON " + "val.Id = anyo.Id "
            + "INNER JOIN mssbam110.atom_def atm ON " + "atm.Id = anyo.Id "
            + "INNER JOIN mssbam110.date_def dat ON " + "dat.Id = anyo.Id ";

    protected MSSBamDateDefBuff unpackDateDefResultSetToBuff(ResultSet resultSet) throws SQLException {
        final String S_ProcName = "unpackDateDefResultSetToBuff";
        int idxcol = 1;
        String classCode = resultSet.getString(idxcol);
        idxcol++;
        MSSBamDateDefBuff buff;
        if (classCode.equals("DAT")) {
            buff = schema.getFactoryDateDef().newBuff();
        } else if (classCode.equals("TDAT")) {
            buff = schema.getFactoryTableDate().newBuff();
        } else if (classCode.equals("SDAT")) {
            buff = schema.getFactorySchemaDate().newBuff();
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Unrecognized class code \"" + classCode + "\"");
        }
        buff.setRequiredId(resultSet.getLong(idxcol));
        idxcol++;
        buff.setRequiredTenantId(resultSet.getLong(idxcol));
        idxcol++;
        {
            long colVal = resultSet.getLong(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalScopeId(null);
            } else {
                buff.setOptionalScopeId(colVal);
            }
        }
        idxcol++;
        buff.setRequiredName(resultSet.getString(idxcol));
        idxcol++;
        {
            String colVal = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalShortName(null);
            } else {
                buff.setOptionalShortName(colVal);
            }
        }
        idxcol++;
        {
            String colVal = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalLabel(null);
            } else {
                buff.setOptionalLabel(colVal);
            }
        }
        idxcol++;
        {
            String colVal = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalShortDescription(null);
            } else {
                buff.setOptionalShortDescription(colVal);
            }
        }
        idxcol++;
        {
            String colVal = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalDescription(null);
            } else {
                buff.setOptionalDescription(colVal);
            }
        }
        idxcol++;
        {
            long colVal = resultSet.getLong(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalAuthorId(null);
            } else {
                buff.setOptionalAuthorId(colVal);
            }
        }
        idxcol++;
        buff.setRequiredValueContainerId(resultSet.getLong(idxcol));
        idxcol++;
        buff.setRequiredIsNullable(resultSet.getBoolean(idxcol));
        idxcol++;
        {
            boolean colVal = resultSet.getBoolean(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalGenerateId(null);
            } else {
                buff.setOptionalGenerateId(colVal);
            }
        }
        idxcol++;
        {
            short colVal = resultSet.getShort(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalDataScopeId(null);
            } else {
                buff.setOptionalDataScopeId(colVal);
            }
        }
        idxcol++;
        {
            short colVal = resultSet.getShort(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalViewAccessSecurityId(null);
            } else {
                buff.setOptionalViewAccessSecurityId(colVal);
            }
        }
        idxcol++;
        {
            short colVal = resultSet.getShort(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalEditAccessSecurityId(null);
            } else {
                buff.setOptionalEditAccessSecurityId(colVal);
            }
        }
        idxcol++;
        {
            short colVal = resultSet.getShort(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalViewAccessFrequencyId(null);
            } else {
                buff.setOptionalViewAccessFrequencyId(colVal);
            }
        }
        idxcol++;
        {
            short colVal = resultSet.getShort(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalEditAccessFrequencyId(null);
            } else {
                buff.setOptionalEditAccessFrequencyId(colVal);
            }
        }
        idxcol++;
        {
            long colVal = resultSet.getLong(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalPrevId(null);
            } else {
                buff.setOptionalPrevId(colVal);
            }
        }
        idxcol++;
        {
            long colVal = resultSet.getLong(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalNextId(null);
            } else {
                buff.setOptionalNextId(colVal);
            }
        }
        idxcol++;
        {
            String colVal = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalDbName(null);
            } else {
                buff.setOptionalDbName(colVal);
            }
        }
        idxcol++;
        {
            Calendar colVal = MSSBamPg8Schema.convertDateString(resultSet.getString(idxcol));
            if (resultSet.wasNull()) {
                buff.setOptionalInitValue(null);
            } else {
                buff.setOptionalInitValue(colVal);
            }
        }
        idxcol++;
        {
            Calendar colVal = MSSBamPg8Schema.convertDateString(resultSet.getString(idxcol));
            if (resultSet.wasNull()) {
                buff.setOptionalDefaultValue(null);
            } else {
                buff.setOptionalDefaultValue(colVal);
            }
        }
        idxcol++;
        {
            Calendar colVal = MSSBamPg8Schema.convertDateString(resultSet.getString(idxcol));
            if (resultSet.wasNull()) {
                buff.setOptionalMinValue(null);
            } else {
                buff.setOptionalMinValue(colVal);
            }
        }
        idxcol++;
        {
            Calendar colVal = MSSBamPg8Schema.convertDateString(resultSet.getString(idxcol));
            if (resultSet.wasNull()) {
                buff.setOptionalMaxValue(null);
            } else {
                buff.setOptionalMaxValue(colVal);
            }
        }
        idxcol++;
        {
            Calendar colVal = MSSBamPg8Schema.convertDateString(resultSet.getString(idxcol));
            if (resultSet.wasNull()) {
                buff.setOptionalNullValue(null);
            } else {
                buff.setOptionalNullValue(colVal);
            }
        }
        idxcol++;
        {
            Calendar colVal = MSSBamPg8Schema.convertDateString(resultSet.getString(idxcol));
            if (resultSet.wasNull()) {
                buff.setOptionalUnknownValue(null);
            } else {
                buff.setOptionalUnknownValue(colVal);
            }
        }
        idxcol++;
        buff.setRequiredRevision(resultSet.getInt(idxcol));
        return (buff);
    }

    public MSSBamDateDefBuff readDerived(MSSBamAuthorization Authorization, MSSBamAnyObjPKey PKey) {
        final String S_ProcName = "readDerived()";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        MSSBamDateDefBuff buff;
        long Id = PKey.getRequiredId();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE " + "dat.Id = " + Long.toString(Id) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            if (resultSet.next()) {
                classCode = resultSet.getString(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-buff response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        if (classCode.equals("DAT")) {
            buff = readBuff(Authorization, PKey);
        } else if (classCode.equals("TDAT")) {
            buff = schema.getTableTableDate().readBuffByIdIdx(Authorization, PKey.getRequiredId());
        } else if (classCode.equals("SDAT")) {
            buff = schema.getTableSchemaDate().readBuffByIdIdx(Authorization, PKey.getRequiredId());
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamDateDefBuff[] readAllDerived(MSSBamAuthorization Authorization) {
        final String S_ProcName = "readAllDerived";
        MSSBamDateDefBuff[] buffArray;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        String classCode;
        ArrayList<String> classCodeList = new ArrayList<String>();
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode;
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        for (int classCodeIdx = 0; classCodeIdx < classCodeList.size(); classCodeIdx++) {
            MSSBamDateDefBuff[] subList;
            classCode = classCodeList.get(classCodeIdx);
            if (classCode.equals("DAT")) {
                subList = readAllBuff(Authorization);
            } else if (classCode.equals("TDAT")) {
                subList = schema.getTableTableDate().readAllBuff(Authorization);
            } else if (classCode.equals("SDAT")) {
                subList = schema.getTableSchemaDate().readAllBuff(Authorization);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
            for (int idxSubList = 0; idxSubList < subList.length; idxSubList++) {
                resultList.add(subList[idxSubList]);
            }
        }
        buffArray = resultList.toArray(new MSSBamDateDefBuff[0]);
        return (buffArray);
    }

    public MSSBamDateDefBuff readDerivedByIdIdx(MSSBamAuthorization Authorization, long Id) {
        final String S_ProcName = "MSSBamPg8DateDefTable.readDerivedByIdIdx() ";
        MSSBamDateDefBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE " + "anyo.Id = " + Long.toString(Id) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            if (resultSet.next()) {
                classCode = resultSet.getString(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-buff response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        if (classCode.equals("DAT")) {
            buff = readBuffByIdIdx(Authorization, Id);
        } else if (classCode.equals("TDAT")) {
            buff = schema.getTableTableDate().readBuffByIdIdx(Authorization, Id);
        } else if (classCode.equals("SDAT")) {
            buff = schema.getTableSchemaDate().readBuffByIdIdx(Authorization, Id);
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamDateDefBuff[] readDerivedByTenantIdx(MSSBamAuthorization Authorization, long TenantId) {
        final String S_ProcName = "readDerivedByTenantIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE " + "anyo.TenantId = "
                    + Long.toString(TenantId) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByTenantIdx(Authorization, TenantId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByTenantIdx(Authorization,
                        TenantId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByTenantIdx(Authorization,
                        TenantId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByScopeIdx(MSSBamAuthorization Authorization, Long ScopeId) {
        final String S_ProcName = "readDerivedByScopeIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((ScopeId == null) ? "anyo.ScopeId is null " : "anyo.ScopeId = " + ScopeId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByScopeIdx(Authorization, ScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByScopeIdx(Authorization,
                        ScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByScopeIdx(Authorization,
                        ScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByAuthorIdx(MSSBamAuthorization Authorization, Long AuthorId) {
        final String S_ProcName = "readDerivedByAuthorIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((AuthorId == null) ? "anyo.AuthorId is null "
                            : "anyo.AuthorId = " + AuthorId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByAuthorIdx(Authorization, AuthorId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByAuthorIdx(Authorization,
                        AuthorId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByAuthorIdx(Authorization,
                        AuthorId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff readDerivedByUNameIdx(MSSBamAuthorization Authorization, Long ScopeId, String Name) {
        final String S_ProcName = "MSSBamPg8DateDefTable.readDerivedByUNameIdx() ";
        MSSBamDateDefBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((ScopeId == null) ? "anyo.ScopeId is null " : "anyo.ScopeId = " + ScopeId.toString() + " ")
                    + "AND " + "anyo.Name = " + MSSBamPg8Schema.getQuotedString(Name) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            if (resultSet.next()) {
                classCode = resultSet.getString(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-buff response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        if (classCode.equals("DAT")) {
            buff = readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else if (classCode.equals("TDAT")) {
            buff = schema.getTableTableDate().readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else if (classCode.equals("SDAT")) {
            buff = schema.getTableSchemaDate().readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamDateDefBuff[] readDerivedByVContIdx(MSSBamAuthorization Authorization, long ValueContainerId) {
        final String S_ProcName = "readDerivedByVContIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE " + "val.ValueContainerId = "
                    + Long.toString(ValueContainerId) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByVContIdx(Authorization, ValueContainerId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByVContIdx(Authorization,
                        ValueContainerId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByVContIdx(Authorization,
                        ValueContainerId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByDataScopeIdx(MSSBamAuthorization Authorization, Short DataScopeId) {
        final String S_ProcName = "readDerivedByDataScopeIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((DataScopeId == null) ? "val.DataScopeId is null "
                            : "val.DataScopeId = " + DataScopeId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByDataScopeIdx(Authorization, DataScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByDataScopeIdx(Authorization,
                        DataScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByDataScopeIdx(Authorization,
                        DataScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByVAccSecIdx(MSSBamAuthorization Authorization,
            Short ViewAccessSecurityId) {
        final String S_ProcName = "readDerivedByVAccSecIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((ViewAccessSecurityId == null) ? "val.ViewAccessSecurityId is null "
                            : "val.ViewAccessSecurityId = " + ViewAccessSecurityId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByVAccSecIdx(Authorization, ViewAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByVAccSecIdx(Authorization,
                        ViewAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByVAccSecIdx(Authorization,
                        ViewAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByVAccFreqIdx(MSSBamAuthorization Authorization,
            Short ViewAccessFrequencyId) {
        final String S_ProcName = "readDerivedByVAccFreqIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((ViewAccessFrequencyId == null) ? "val.ViewAccessFrequencyId is null "
                            : "val.ViewAccessFrequencyId = " + ViewAccessFrequencyId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByVAccFreqIdx(Authorization, ViewAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByVAccFreqIdx(Authorization,
                        ViewAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByVAccFreqIdx(Authorization,
                        ViewAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByEAccSecIdx(MSSBamAuthorization Authorization,
            Short EditAccessSecurityId) {
        final String S_ProcName = "readDerivedByEAccSecIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((EditAccessSecurityId == null) ? "val.EditAccessSecurityId is null "
                            : "val.EditAccessSecurityId = " + EditAccessSecurityId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByEAccSecIdx(Authorization, EditAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByEAccSecIdx(Authorization,
                        EditAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByEAccSecIdx(Authorization,
                        EditAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByEAccFreqIdx(MSSBamAuthorization Authorization,
            Short EditAccessFrequencyId) {
        final String S_ProcName = "readDerivedByEAccFreqIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((EditAccessFrequencyId == null) ? "val.EditAccessFrequencyId is null "
                            : "val.EditAccessFrequencyId = " + EditAccessFrequencyId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByEAccFreqIdx(Authorization, EditAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByEAccFreqIdx(Authorization,
                        EditAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByEAccFreqIdx(Authorization,
                        EditAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByPrevIdx(MSSBamAuthorization Authorization, Long PrevId) {
        final String S_ProcName = "readDerivedByPrevIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((PrevId == null) ? "val.PrevId is null " : "val.PrevId = " + PrevId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByPrevIdx(Authorization, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByPrevIdx(Authorization, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByPrevIdx(Authorization,
                        PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByNextIdx(MSSBamAuthorization Authorization, Long NextId) {
        final String S_ProcName = "readDerivedByNextIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE "
                    + ((NextId == null) ? "val.NextId is null " : "val.NextId = " + NextId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByNextIdx(Authorization, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByNextIdx(Authorization, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByNextIdx(Authorization,
                        NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByContPrevIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long PrevId) {
        final String S_ProcName = "readDerivedByContPrevIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE " + "val.ValueContainerId = "
                    + Long.toString(ValueContainerId) + " " + "AND "
                    + ((PrevId == null) ? "val.PrevId is null " : "val.PrevId = " + PrevId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByContPrevIdx(Authorization, ValueContainerId, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByContPrevIdx(Authorization,
                        ValueContainerId, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByContPrevIdx(Authorization,
                        ValueContainerId, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff[] readDerivedByContNextIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long NextId) {
        final String S_ProcName = "readDerivedByContNextIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ArrayList<String> classCodeList = new ArrayList<String>();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefDistinctClassCode + "WHERE " + "val.ValueContainerId = "
                    + Long.toString(ValueContainerId) + " " + "AND "
                    + ((NextId == null) ? "val.NextId is null " : "val.NextId = " + NextId.toString() + " ");
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            while (resultSet.next()) {
                classCode = resultSet.getString(1);
                classCodeList.add(classCode);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
        ArrayList<MSSBamDateDefBuff> resultList = new ArrayList<MSSBamDateDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DAT")) {
                MSSBamDateDefBuff[] subList = readBuffByContNextIdx(Authorization, ValueContainerId, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDAT")) {
                MSSBamTableDateBuff[] subList = schema.getTableTableDate().readBuffByContNextIdx(Authorization,
                        ValueContainerId, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDAT")) {
                MSSBamSchemaDateBuff[] subList = schema.getTableSchemaDate().readBuffByContNextIdx(Authorization,
                        ValueContainerId, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Did not expect ClassCode \"" + classCode + "\"");
            }
        }
        return (resultList.toArray(new MSSBamDateDefBuff[0]));

    }

    public MSSBamDateDefBuff readBuff(MSSBamAuthorization Authorization, MSSBamAnyObjPKey PKey) {
        final String S_ProcName = "readBuff";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        try {
            Connection cnx = schema.getCnx();
            long Id = PKey.getRequiredId();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + "anyo.Id = " + Long.toString(Id) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            if (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-buff response, " + resultSet.getRow() + " rows selected");
                }
                return (buff);
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readAllBuff(MSSBamAuthorization Authorization) {
        final String S_ProcName = "readAllBuff";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + "anyo.ClassCode = 'DAT' " + "ORDER BY "
                    + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff readBuffByIdIdx(MSSBamAuthorization Authorization, long Id) {
        final String S_ProcName = "readBuffByIdIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + "anyo.Id = " + Long.toString(Id) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            if (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-buff response, " + resultSet.getRow() + " rows selected");
                }
                return (buff);
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByTenantIdx(MSSBamAuthorization Authorization, long TenantId) {
        final String S_ProcName = "readBuffByTenantIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + "anyo.TenantId = " + Long.toString(TenantId) + " "
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByScopeIdx(MSSBamAuthorization Authorization, Long ScopeId) {
        final String S_ProcName = "readBuffByScopeIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((ScopeId == null) ? "anyo.ScopeId is null " : "anyo.ScopeId = " + ScopeId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByAuthorIdx(MSSBamAuthorization Authorization, Long AuthorId) {
        final String S_ProcName = "readBuffByAuthorIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + ((AuthorId == null) ? "anyo.AuthorId is null "
                    : "anyo.AuthorId = " + AuthorId.toString() + " ") + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff readBuffByUNameIdx(MSSBamAuthorization Authorization, Long ScopeId, String Name) {
        final String S_ProcName = "readBuffByUNameIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((ScopeId == null) ? "anyo.ScopeId is null " : "anyo.ScopeId = " + ScopeId.toString() + " ")
                    + "AND " + "anyo.Name = " + MSSBamPg8Schema.getQuotedString(Name) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            if (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-buff response, " + resultSet.getRow() + " rows selected");
                }
                return (buff);
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByVContIdx(MSSBamAuthorization Authorization, long ValueContainerId) {
        final String S_ProcName = "readBuffByVContIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + "val.ValueContainerId = "
                    + Long.toString(ValueContainerId) + " " + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByDataScopeIdx(MSSBamAuthorization Authorization, Short DataScopeId) {
        final String S_ProcName = "readBuffByDataScopeIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + ((DataScopeId == null) ? "val.DataScopeId is null "
                    : "val.DataScopeId = " + DataScopeId.toString() + " ") + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByVAccSecIdx(MSSBamAuthorization Authorization, Short ViewAccessSecurityId) {
        final String S_ProcName = "readBuffByVAccSecIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((ViewAccessSecurityId == null) ? "val.ViewAccessSecurityId is null "
                            : "val.ViewAccessSecurityId = " + ViewAccessSecurityId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByVAccFreqIdx(MSSBamAuthorization Authorization,
            Short ViewAccessFrequencyId) {
        final String S_ProcName = "readBuffByVAccFreqIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((ViewAccessFrequencyId == null) ? "val.ViewAccessFrequencyId is null "
                            : "val.ViewAccessFrequencyId = " + ViewAccessFrequencyId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByEAccSecIdx(MSSBamAuthorization Authorization, Short EditAccessSecurityId) {
        final String S_ProcName = "readBuffByEAccSecIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((EditAccessSecurityId == null) ? "val.EditAccessSecurityId is null "
                            : "val.EditAccessSecurityId = " + EditAccessSecurityId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByEAccFreqIdx(MSSBamAuthorization Authorization,
            Short EditAccessFrequencyId) {
        final String S_ProcName = "readBuffByEAccFreqIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((EditAccessFrequencyId == null) ? "val.EditAccessFrequencyId is null "
                            : "val.EditAccessFrequencyId = " + EditAccessFrequencyId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByPrevIdx(MSSBamAuthorization Authorization, Long PrevId) {
        final String S_ProcName = "readBuffByPrevIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((PrevId == null) ? "val.PrevId is null " : "val.PrevId = " + PrevId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByNextIdx(MSSBamAuthorization Authorization, Long NextId) {
        final String S_ProcName = "readBuffByNextIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE "
                    + ((NextId == null) ? "val.NextId is null " : "val.NextId = " + NextId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByContPrevIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long PrevId) {
        final String S_ProcName = "readBuffByContPrevIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + "val.ValueContainerId = "
                    + Long.toString(ValueContainerId) + " " + "AND "
                    + ((PrevId == null) ? "val.PrevId is null " : "val.PrevId = " + PrevId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff[] readBuffByContNextIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long NextId) {
        final String S_ProcName = "readBuffByContNextIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDateDefBuff + "WHERE " + "val.ValueContainerId = "
                    + Long.toString(ValueContainerId) + " " + "AND "
                    + ((NextId == null) ? "val.NextId is null " : "val.NextId = " + NextId.toString() + " ")
                    + "ORDER BY " + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamDateDefBuff> buffList = new ArrayList<MSSBamDateDefBuff>();
            while (resultSet.next()) {
                MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamDateDefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public void updateDateDef(MSSBamAuthorization Authorization, MSSBamDateDefBuff Buff) {
        final String S_ProcName = "updateDateDef";
        try {
            Connection cnx = schema.getCnx();
            long Id = Buff.getRequiredId();
            Calendar InitValue = Buff.getOptionalInitValue();
            Calendar DefaultValue = Buff.getOptionalDefaultValue();
            Calendar MinValue = Buff.getOptionalMinValue();
            Calendar MaxValue = Buff.getOptionalMaxValue();
            Calendar NullValue = Buff.getOptionalNullValue();
            Calendar UnknownValue = Buff.getOptionalUnknownValue();

            String sql = "UPDATE mssbam110.date_def " + "SET " + "Id = " + MSSBamPg8Schema.getInt64String(Id) + ", "
                    + "InitVal = to_timestamp( "
                    + ((InitValue != null) ? MSSBamPg8Schema.getDateString(InitValue) : "null")
                    + ", 'YYYY-MM-DD' ) " + ", " + "DefVal = to_timestamp( "
                    + ((DefaultValue != null) ? MSSBamPg8Schema.getDateString(DefaultValue) : "null")
                    + ", 'YYYY-MM-DD' ) " + ", " + "MinVal = to_timestamp( "
                    + ((MinValue != null) ? MSSBamPg8Schema.getDateString(MinValue) : "null") + ", 'YYYY-MM-DD' ) "
                    + ", " + "MaxVal = to_timestamp( "
                    + ((MaxValue != null) ? MSSBamPg8Schema.getDateString(MaxValue) : "null") + ", 'YYYY-MM-DD' ) "
                    + ", " + "NullValue = to_timestamp( "
                    + ((NullValue != null) ? MSSBamPg8Schema.getDateString(NullValue) : "null")
                    + ", 'YYYY-MM-DD' ) " + ", " + "UnknownVal = to_timestamp( "
                    + ((UnknownValue != null) ? MSSBamPg8Schema.getDateString(UnknownValue) : "null")
                    + ", 'YYYY-MM-DD' ) " + " " + "WHERE " + "Id = " + Long.toString(Id) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            int rowsAffected = stmt.executeUpdate(sql);
            if (rowsAffected != 1) {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 row to be affected by update, not " + rowsAffected);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public void deleteDateDef(MSSBamAuthorization Authorization, MSSBamDateDefBuff Buff) {
        final String S_ProcName = "deleteDateDef";
        try {
            Connection cnx = schema.getCnx();
            long Id = Buff.getRequiredId();
            Calendar InitValue = Buff.getOptionalInitValue();
            Calendar DefaultValue = Buff.getOptionalDefaultValue();
            Calendar MinValue = Buff.getOptionalMinValue();
            Calendar MaxValue = Buff.getOptionalMaxValue();
            Calendar NullValue = Buff.getOptionalNullValue();
            Calendar UnknownValue = Buff.getOptionalUnknownValue();

            String sql = "DELETE FROM mssbam110.date_def " + "WHERE " + "Id = " + Long.toString(Id) + " ";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            int rowsAffected = stmt.executeUpdate(sql);
            if (rowsAffected != 1) {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 row to be affected by delete, not " + rowsAffected);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamCursor openDateDefCursorAll(MSSBamAuthorization Authorization) {
        String sql = "SELECT " + "anyo.ClassCode, " + "dat.Id, "
                + "to_char( dat.InitVal, 'YYYY-MM-DD' ) AS InitVal, "
                + "to_char( dat.DefVal, 'YYYY-MM-DD' ) AS DefVal, "
                + "to_char( dat.MinVal, 'YYYY-MM-DD' ) AS MinVal, "
                + "to_char( dat.MaxVal, 'YYYY-MM-DD' ) AS MaxVal, "
                + "to_char( dat.NullValue, 'YYYY-MM-DD' ) AS NullValue, "
                + "to_char( dat.UnknownVal, 'YYYY-MM-DD' ) AS UnknownVal, " + "dat.Revision "
                + "FROM mssbam110.date_def AS dat " + "INNER JOIN mssbam110.any_obj anyo ON "

                + "dat.Id = anyo.Id " + "ORDER BY " + "anyo.Id ASC";
        MSSBamCursor cursor = new MSSBamPg8Cursor(Authorization, schema, sql);
        return (cursor);
    }

    public void closeDateDefCursor(MSSBamCursor Cursor) {
        try {
            Cursor.getResultSet().close();
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "closeDateDefCursor", e);
        }
    }

    public MSSBamDateDefBuff nextDateDefCursor(MSSBamCursor Cursor) {
        final String S_ProcName = "nextDateDefCursor";
        try {
            ResultSet resultSet = Cursor.getResultSet();
            if (!resultSet.next()) {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "No more results available");
            }
            MSSBamDateDefBuff buff = unpackDateDefResultSetToBuff(resultSet);
            return (buff);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamDateDefBuff prevDateDefCursor(MSSBamCursor Cursor) {
        int targetRowIdx = (Cursor.getRowIdx() > 1) ? Cursor.getRowIdx() - 1 : 1;
        MSSBamDateDefBuff buff = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextDateDefCursor(Cursor);
        }
        return (buff);
    }

    public MSSBamDateDefBuff firstDateDefCursor(MSSBamCursor Cursor) {
        int targetRowIdx = 1;
        MSSBamDateDefBuff buff = null;
        Cursor.reset();
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextDateDefCursor(Cursor);
        }
        return (buff);
    }

    public MSSBamDateDefBuff lastDateDefCursor(MSSBamCursor Cursor) {
        throw CFLib.getDefaultExceptionFactory().newNotImplementedYetException(getClass(), "lastDateDefCursor");
    }

    public MSSBamDateDefBuff nthDateDefCursor(MSSBamCursor Cursor, int Idx) {
        int targetRowIdx = Idx;
        MSSBamDateDefBuff buff = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextDateDefCursor(Cursor);
        }
        return (buff);
    }
}