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

Java tutorial

Introduction

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

Source

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

/*
 *   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.*;

/*
 *   MSSBamPg8UInt64DefTable PostgreSQL Jdbc DbIO implementation
 *   for UInt64Def.
 *
 *   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 MSSBamPg8UInt64DefTable implements IMSSBamUInt64DefTable {
    private MSSBamPg8Schema schema;

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

    public void createUInt64Def(MSSBamAuthorization Authorization, MSSBamUInt64DefBuff Buff) {
        final String S_ProcName = "createUInt64Def ";
        try {
            Connection cnx = schema.getCnx();
            long Id = Buff.getRequiredId();
            BigInteger InitValue = Buff.getOptionalInitValue();
            BigInteger DefaultValue = Buff.getOptionalDefaultValue();
            BigInteger MinValue = Buff.getOptionalMinValue();
            BigInteger MaxValue = Buff.getOptionalMaxValue();
            BigInteger NullValue = Buff.getOptionalNullValue();
            BigInteger UnknownValue = Buff.getOptionalUnknownValue();
            String sql = "INSERT INTO mssbam110.uint64_def( " + "id, " + "initval, " + "defval, " + "minval, "
                    + "maxval, " + "nullvalue, " + "unknownval" + " )" + "VALUES ( " + Id + ", "
                    + ((InitValue == null) ? "null" : InitValue.toString()) + ", "
                    + ((DefaultValue == null) ? "null" : DefaultValue.toString()) + ", "
                    + ((MinValue == null) ? "null" : MinValue.toString()) + ", "
                    + ((MaxValue == null) ? "null" : MaxValue.toString()) + ", "
                    + ((NullValue == null) ? "null" : NullValue.toString()) + ", "
                    + ((UnknownValue == null) ? "null" : UnknownValue.toString()) + " )";
            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_sqlSelectUInt64DefDistinctClassCode = "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.uint64_def u64 ON " + "u64.Id = anyo.Id ";

    public final static String S_sqlSelectUInt64DefBuff = "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, " + "u64.InitVal, " + "u64.DefVal, " + "u64.MinVal, "
            + "u64.MaxVal, " + "u64.NullValue, " + "u64.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.uint64_def u64 ON " + "u64.Id = anyo.Id ";

    protected MSSBamUInt64DefBuff unpackUInt64DefResultSetToBuff(ResultSet resultSet) throws SQLException {
        final String S_ProcName = "unpackUInt64DefResultSetToBuff";
        int idxcol = 1;
        String classCode = resultSet.getString(idxcol);
        idxcol++;
        MSSBamUInt64DefBuff buff;
        if (classCode.equals("U64")) {
            buff = schema.getFactoryUInt64Def().newBuff();
        } else if (classCode.equals("TU64")) {
            buff = schema.getFactoryTableUInt64().newBuff();
        } else if (classCode.equals("SU64")) {
            buff = schema.getFactorySchemaUInt64().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++;
        {
            String strval = resultSet.getString(idxcol);
            if (resultSet.wasNull() || (strval == null) || (strval.length() <= 0)) {
                buff.setOptionalInitValue(null);
            } else {
                BigInteger bival = new BigInteger(strval);
                buff.setOptionalInitValue(bival);
            }
        }
        idxcol++;
        {
            String strval = resultSet.getString(idxcol);
            if (resultSet.wasNull() || (strval == null) || (strval.length() <= 0)) {
                buff.setOptionalDefaultValue(null);
            } else {
                BigInteger bival = new BigInteger(strval);
                buff.setOptionalDefaultValue(bival);
            }
        }
        idxcol++;
        {
            String strval = resultSet.getString(idxcol);
            if (resultSet.wasNull() || (strval == null) || (strval.length() <= 0)) {
                buff.setOptionalMinValue(null);
            } else {
                BigInteger bival = new BigInteger(strval);
                buff.setOptionalMinValue(bival);
            }
        }
        idxcol++;
        {
            String strval = resultSet.getString(idxcol);
            if (resultSet.wasNull() || (strval == null) || (strval.length() <= 0)) {
                buff.setOptionalMaxValue(null);
            } else {
                BigInteger bival = new BigInteger(strval);
                buff.setOptionalMaxValue(bival);
            }
        }
        idxcol++;
        {
            String strval = resultSet.getString(idxcol);
            if (resultSet.wasNull() || (strval == null) || (strval.length() <= 0)) {
                buff.setOptionalNullValue(null);
            } else {
                BigInteger bival = new BigInteger(strval);
                buff.setOptionalNullValue(bival);
            }
        }
        idxcol++;
        {
            String strval = resultSet.getString(idxcol);
            if (resultSet.wasNull() || (strval == null) || (strval.length() <= 0)) {
                buff.setOptionalUnknownValue(null);
            } else {
                BigInteger bival = new BigInteger(strval);
                buff.setOptionalUnknownValue(bival);
            }
        }
        idxcol++;
        buff.setRequiredRevision(resultSet.getInt(idxcol));
        return (buff);
    }

    public MSSBamUInt64DefBuff readDerived(MSSBamAuthorization Authorization, MSSBamAnyObjPKey PKey) {
        final String S_ProcName = "readDerived()";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        MSSBamUInt64DefBuff buff;
        long Id = PKey.getRequiredId();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefDistinctClassCode + "WHERE " + "u64.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("U64")) {
            buff = readBuff(Authorization, PKey);
        } else if (classCode.equals("TU64")) {
            buff = schema.getTableTableUInt64().readBuffByIdIdx(Authorization, PKey.getRequiredId());
        } else if (classCode.equals("SU64")) {
            buff = schema.getTableSchemaUInt64().readBuffByIdIdx(Authorization, PKey.getRequiredId());
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamUInt64DefBuff[] readAllDerived(MSSBamAuthorization Authorization) {
        final String S_ProcName = "readAllDerived";
        MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode;
            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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        for (int classCodeIdx = 0; classCodeIdx < classCodeList.size(); classCodeIdx++) {
            MSSBamUInt64DefBuff[] subList;
            classCode = classCodeList.get(classCodeIdx);
            if (classCode.equals("U64")) {
                subList = readAllBuff(Authorization);
            } else if (classCode.equals("TU64")) {
                subList = schema.getTableTableUInt64().readAllBuff(Authorization);
            } else if (classCode.equals("SU64")) {
                subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]);
        return (buffArray);
    }

    public MSSBamUInt64DefBuff readDerivedByIdIdx(MSSBamAuthorization Authorization, long Id) {
        final String S_ProcName = "MSSBamPg8UInt64DefTable.readDerivedByIdIdx() ";
        MSSBamUInt64DefBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefDistinctClassCode + "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("U64")) {
            buff = readBuffByIdIdx(Authorization, Id);
        } else if (classCode.equals("TU64")) {
            buff = schema.getTableTableUInt64().readBuffByIdIdx(Authorization, Id);
        } else if (classCode.equals("SU64")) {
            buff = schema.getTableSchemaUInt64().readBuffByIdIdx(Authorization, Id);
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByTenantIdx(Authorization, TenantId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByTenantIdx(Authorization,
                        TenantId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByScopeIdx(Authorization, ScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByScopeIdx(Authorization,
                        ScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByAuthorIdx(Authorization, AuthorId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByAuthorIdx(Authorization,
                        AuthorId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff readDerivedByUNameIdx(MSSBamAuthorization Authorization, Long ScopeId, String Name) {
        final String S_ProcName = "MSSBamPg8UInt64DefTable.readDerivedByUNameIdx() ";
        MSSBamUInt64DefBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefDistinctClassCode + "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("U64")) {
            buff = readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else if (classCode.equals("TU64")) {
            buff = schema.getTableTableUInt64().readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else if (classCode.equals("SU64")) {
            buff = schema.getTableSchemaUInt64().readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByVContIdx(Authorization, ValueContainerId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByVContIdx(Authorization,
                        ValueContainerId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByDataScopeIdx(Authorization, DataScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByDataScopeIdx(Authorization,
                        DataScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64()
                        .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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByVAccSecIdx(Authorization, ViewAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByVAccSecIdx(Authorization,
                        ViewAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByVAccFreqIdx(Authorization, ViewAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByVAccFreqIdx(Authorization,
                        ViewAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64()
                        .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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByEAccSecIdx(Authorization, EditAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByEAccSecIdx(Authorization,
                        EditAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByEAccFreqIdx(Authorization, EditAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByEAccFreqIdx(Authorization,
                        EditAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64()
                        .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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByPrevIdx(Authorization, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByPrevIdx(Authorization,
                        PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByNextIdx(Authorization, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByNextIdx(Authorization,
                        NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64().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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByContPrevIdx(Authorization, ValueContainerId, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByContPrevIdx(Authorization,
                        ValueContainerId, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64()
                        .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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefDistinctClassCode + "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<MSSBamUInt64DefBuff> resultList = new ArrayList<MSSBamUInt64DefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("U64")) {
                MSSBamUInt64DefBuff[] subList = readBuffByContNextIdx(Authorization, ValueContainerId, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TU64")) {
                MSSBamTableUInt64Buff[] subList = schema.getTableTableUInt64().readBuffByContNextIdx(Authorization,
                        ValueContainerId, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SU64")) {
                MSSBamSchemaUInt64Buff[] subList = schema.getTableSchemaUInt64()
                        .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 MSSBamUInt64DefBuff[0]));

    }

    public MSSBamUInt64DefBuff 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_sqlSelectUInt64DefBuff + "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()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(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 MSSBamUInt64DefBuff[] 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_sqlSelectUInt64DefBuff + "WHERE " + "anyo.ClassCode = 'U64' " + "ORDER BY "
                    + "anyo.Id ASC";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery(sql);
            List<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff readBuffByIdIdx(MSSBamAuthorization Authorization, long Id) {
        final String S_ProcName = "readBuffByIdIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(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 MSSBamUInt64DefBuff[] readBuffByTenantIdx(MSSBamAuthorization Authorization, long TenantId) {
        final String S_ProcName = "readBuffByTenantIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByScopeIdx(MSSBamAuthorization Authorization, Long ScopeId) {
        final String S_ProcName = "readBuffByScopeIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByAuthorIdx(MSSBamAuthorization Authorization, Long AuthorId) {
        final String S_ProcName = "readBuffByAuthorIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff readBuffByUNameIdx(MSSBamAuthorization Authorization, Long ScopeId, String Name) {
        final String S_ProcName = "readBuffByUNameIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(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 MSSBamUInt64DefBuff[] readBuffByVContIdx(MSSBamAuthorization Authorization, long ValueContainerId) {
        final String S_ProcName = "readBuffByVContIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByDataScopeIdx(MSSBamAuthorization Authorization, Short DataScopeId) {
        final String S_ProcName = "readBuffByDataScopeIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByVAccSecIdx(MSSBamAuthorization Authorization,
            Short ViewAccessSecurityId) {
        final String S_ProcName = "readBuffByVAccSecIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByVAccFreqIdx(MSSBamAuthorization Authorization,
            Short ViewAccessFrequencyId) {
        final String S_ProcName = "readBuffByVAccFreqIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByEAccSecIdx(MSSBamAuthorization Authorization,
            Short EditAccessSecurityId) {
        final String S_ProcName = "readBuffByEAccSecIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByEAccFreqIdx(MSSBamAuthorization Authorization,
            Short EditAccessFrequencyId) {
        final String S_ProcName = "readBuffByEAccFreqIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByPrevIdx(MSSBamAuthorization Authorization, Long PrevId) {
        final String S_ProcName = "readBuffByPrevIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByNextIdx(MSSBamAuthorization Authorization, Long NextId) {
        final String S_ProcName = "readBuffByNextIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByContPrevIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long PrevId) {
        final String S_ProcName = "readBuffByContPrevIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

    public MSSBamUInt64DefBuff[] readBuffByContNextIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long NextId) {
        final String S_ProcName = "readBuffByContNextIdx";
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectUInt64DefBuff + "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<MSSBamUInt64DefBuff> buffList = new ArrayList<MSSBamUInt64DefBuff>();
            while (resultSet.next()) {
                MSSBamUInt64DefBuff buff = unpackUInt64DefResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            return (buffList.toArray(new MSSBamUInt64DefBuff[0]));
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        }
    }

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

            String sql = "UPDATE mssbam110.uint64_def " + "SET " + "Id = " + MSSBamPg8Schema.getInt64String(Id)
                    + ", " + "InitVal = "
                    + ((InitValue != null) ? MSSBamPg8Schema.getUInt64String(InitValue) : "null") + ", "
                    + "DefVal = "
                    + ((DefaultValue != null) ? MSSBamPg8Schema.getUInt64String(DefaultValue) : "null") + ", "
                    + "MinVal = " + ((MinValue != null) ? MSSBamPg8Schema.getUInt64String(MinValue) : "null") + ", "
                    + "MaxVal = " + ((MaxValue != null) ? MSSBamPg8Schema.getUInt64String(MaxValue) : "null") + ", "
                    + "NullValue = " + ((NullValue != null) ? MSSBamPg8Schema.getUInt64String(NullValue) : "null")
                    + ", " + "UnknownVal = "
                    + ((UnknownValue != null) ? MSSBamPg8Schema.getUInt64String(UnknownValue) : "null") + " "
                    + "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 deleteUInt64Def(MSSBamAuthorization Authorization, MSSBamUInt64DefBuff Buff) {
        final String S_ProcName = "deleteUInt64Def";
        try {
            Connection cnx = schema.getCnx();
            long Id = Buff.getRequiredId();
            BigInteger InitValue = Buff.getOptionalInitValue();
            BigInteger DefaultValue = Buff.getOptionalDefaultValue();
            BigInteger MinValue = Buff.getOptionalMinValue();
            BigInteger MaxValue = Buff.getOptionalMaxValue();
            BigInteger NullValue = Buff.getOptionalNullValue();
            BigInteger UnknownValue = Buff.getOptionalUnknownValue();

            String sql = "DELETE FROM mssbam110.uint64_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 openUInt64DefCursorAll(MSSBamAuthorization Authorization) {
        String sql = "SELECT " + "anyo.ClassCode, " + "u64.Id, " + "u64.InitVal, " + "u64.DefVal, " + "u64.MinVal, "
                + "u64.MaxVal, " + "u64.NullValue, " + "u64.UnknownVal, " + "u64.Revision "
                + "FROM mssbam110.uint64_def AS u64 " + "INNER JOIN mssbam110.any_obj anyo ON "

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

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

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

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

    public MSSBamUInt64DefBuff firstUInt64DefCursor(MSSBamCursor Cursor) {
        int targetRowIdx = 1;
        MSSBamUInt64DefBuff buff = null;
        Cursor.reset();
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextUInt64DefCursor(Cursor);
        }
        return (buff);
    }

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

    public MSSBamUInt64DefBuff nthUInt64DefCursor(MSSBamCursor Cursor, int Idx) {
        int targetRowIdx = Idx;
        MSSBamUInt64DefBuff buff = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextUInt64DefCursor(Cursor);
        }
        return (buff);
    }
}