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

Introduction

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

Source

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

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

/*
 *   MSSBamPg8DoubleDefTable PostgreSQL Jdbc DbIO implementation
 *   for DoubleDef.
 *
 *   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 MSSBamPg8DoubleDefTable implements IMSSBamDoubleDefTable {
    private MSSBamPg8Schema schema;

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

    public void createDoubleDef(MSSBamAuthorization Authorization, MSSBamDoubleDefBuff Buff) {
        final String S_ProcName = "createDoubleDef ";
        try {
            Connection cnx = schema.getCnx();
            long Id = Buff.getRequiredId();
            Double InitValue = Buff.getOptionalInitValue();
            Double DefaultValue = Buff.getOptionalDefaultValue();
            Double MinValue = Buff.getOptionalMinValue();
            Double MaxValue = Buff.getOptionalMaxValue();
            Double NullValue = Buff.getOptionalNullValue();
            Double UnknownValue = Buff.getOptionalUnknownValue();
            String sql = "INSERT INTO mssbam110.double_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_sqlSelectDoubleDefDistinctClassCode = "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.double_def dbl ON " + "dbl.Id = anyo.Id ";

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

    protected MSSBamDoubleDefBuff unpackDoubleDefResultSetToBuff(ResultSet resultSet) throws SQLException {
        final String S_ProcName = "unpackDoubleDefResultSetToBuff";
        int idxcol = 1;
        String classCode = resultSet.getString(idxcol);
        idxcol++;
        MSSBamDoubleDefBuff buff;
        if (classCode.equals("DBL")) {
            buff = schema.getFactoryDoubleDef().newBuff();
        } else if (classCode.equals("TDBL")) {
            buff = schema.getFactoryTableDouble().newBuff();
        } else if (classCode.equals("SDBL")) {
            buff = schema.getFactorySchemaDouble().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++;
        {
            double colVal = resultSet.getDouble(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalInitValue(null);
            } else {
                buff.setOptionalInitValue(colVal);
            }
        }
        idxcol++;
        {
            double colVal = resultSet.getDouble(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalDefaultValue(null);
            } else {
                buff.setOptionalDefaultValue(colVal);
            }
        }
        idxcol++;
        {
            double colVal = resultSet.getDouble(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalMinValue(null);
            } else {
                buff.setOptionalMinValue(colVal);
            }
        }
        idxcol++;
        {
            double colVal = resultSet.getDouble(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalMaxValue(null);
            } else {
                buff.setOptionalMaxValue(colVal);
            }
        }
        idxcol++;
        {
            double colVal = resultSet.getDouble(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalNullValue(null);
            } else {
                buff.setOptionalNullValue(colVal);
            }
        }
        idxcol++;
        {
            double colVal = resultSet.getDouble(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalUnknownValue(null);
            } else {
                buff.setOptionalUnknownValue(colVal);
            }
        }
        idxcol++;
        buff.setRequiredRevision(resultSet.getInt(idxcol));
        return (buff);
    }

    public MSSBamDoubleDefBuff readDerived(MSSBamAuthorization Authorization, MSSBamAnyObjPKey PKey) {
        final String S_ProcName = "readDerived()";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        MSSBamDoubleDefBuff buff;
        long Id = PKey.getRequiredId();
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDoubleDefDistinctClassCode + "WHERE " + "dbl.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("DBL")) {
            buff = readBuff(Authorization, PKey);
        } else if (classCode.equals("TDBL")) {
            buff = schema.getTableTableDouble().readBuffByIdIdx(Authorization, PKey.getRequiredId());
        } else if (classCode.equals("SDBL")) {
            buff = schema.getTableSchemaDouble().readBuffByIdIdx(Authorization, PKey.getRequiredId());
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamDoubleDefBuff[] readAllDerived(MSSBamAuthorization Authorization) {
        final String S_ProcName = "readAllDerived";
        MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode;
            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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        for (int classCodeIdx = 0; classCodeIdx < classCodeList.size(); classCodeIdx++) {
            MSSBamDoubleDefBuff[] subList;
            classCode = classCodeList.get(classCodeIdx);
            if (classCode.equals("DBL")) {
                subList = readAllBuff(Authorization);
            } else if (classCode.equals("TDBL")) {
                subList = schema.getTableTableDouble().readAllBuff(Authorization);
            } else if (classCode.equals("SDBL")) {
                subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]);
        return (buffArray);
    }

    public MSSBamDoubleDefBuff readDerivedByIdIdx(MSSBamAuthorization Authorization, long Id) {
        final String S_ProcName = "MSSBamPg8DoubleDefTable.readDerivedByIdIdx() ";
        MSSBamDoubleDefBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDoubleDefDistinctClassCode + "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("DBL")) {
            buff = readBuffByIdIdx(Authorization, Id);
        } else if (classCode.equals("TDBL")) {
            buff = schema.getTableTableDouble().readBuffByIdIdx(Authorization, Id);
        } else if (classCode.equals("SDBL")) {
            buff = schema.getTableSchemaDouble().readBuffByIdIdx(Authorization, Id);
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByTenantIdx(Authorization, TenantId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByTenantIdx(Authorization,
                        TenantId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByScopeIdx(Authorization, ScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByScopeIdx(Authorization,
                        ScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByAuthorIdx(Authorization, AuthorId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByAuthorIdx(Authorization,
                        AuthorId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff readDerivedByUNameIdx(MSSBamAuthorization Authorization, Long ScopeId, String Name) {
        final String S_ProcName = "MSSBamPg8DoubleDefTable.readDerivedByUNameIdx() ";
        MSSBamDoubleDefBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        String classCode;
        try {
            Connection cnx = schema.getCnx();
            String sql = S_sqlSelectDoubleDefDistinctClassCode + "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("DBL")) {
            buff = readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else if (classCode.equals("TDBL")) {
            buff = schema.getTableTableDouble().readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else if (classCode.equals("SDBL")) {
            buff = schema.getTableSchemaDouble().readBuffByUNameIdx(Authorization, ScopeId, Name);
        } else {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Did not expect ClassCode \"" + classCode + "\"");
        }
        return (buff);
    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByVContIdx(Authorization, ValueContainerId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByVContIdx(Authorization,
                        ValueContainerId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByDataScopeIdx(Authorization, DataScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByDataScopeIdx(Authorization,
                        DataScopeId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble()
                        .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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByVAccSecIdx(Authorization, ViewAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByVAccSecIdx(Authorization,
                        ViewAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByVAccFreqIdx(Authorization, ViewAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByVAccFreqIdx(Authorization,
                        ViewAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble()
                        .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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByEAccSecIdx(Authorization, EditAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByEAccSecIdx(Authorization,
                        EditAccessSecurityId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByEAccFreqIdx(Authorization, EditAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByEAccFreqIdx(Authorization,
                        EditAccessFrequencyId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble()
                        .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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByPrevIdx(Authorization, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByPrevIdx(Authorization,
                        PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByNextIdx(Authorization, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByNextIdx(Authorization,
                        NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble().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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByContPrevIdx(Authorization, ValueContainerId, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByContPrevIdx(Authorization,
                        ValueContainerId, PrevId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble()
                        .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 MSSBamDoubleDefBuff[0]));

    }

    public MSSBamDoubleDefBuff[] 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_sqlSelectDoubleDefDistinctClassCode + "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<MSSBamDoubleDefBuff> resultList = new ArrayList<MSSBamDoubleDefBuff>();
        ListIterator<String> classCodeIter = classCodeList.listIterator();
        while (classCodeIter.hasNext()) {
            classCode = classCodeIter.next();
            if (classCode.equals("DBL")) {
                MSSBamDoubleDefBuff[] subList = readBuffByContNextIdx(Authorization, ValueContainerId, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("TDBL")) {
                MSSBamTableDoubleBuff[] subList = schema.getTableTableDouble().readBuffByContNextIdx(Authorization,
                        ValueContainerId, NextId);
                for (int subListIdx = 0; subListIdx < subList.length; subListIdx++) {
                    resultList.add(subList[subListIdx]);
                }
            } else if (classCode.equals("SDBL")) {
                MSSBamSchemaDoubleBuff[] subList = schema.getTableSchemaDouble()
                        .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 MSSBamDoubleDefBuff[0]));

    }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    public MSSBamDoubleDefBuff firstDoubleDefCursor(MSSBamCursor Cursor) {
        int targetRowIdx = 1;
        MSSBamDoubleDefBuff buff = null;
        Cursor.reset();
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextDoubleDefCursor(Cursor);
        }
        return (buff);
    }

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

    public MSSBamDoubleDefBuff nthDoubleDefCursor(MSSBamCursor Cursor, int Idx) {
        int targetRowIdx = Idx;
        MSSBamDoubleDefBuff buff = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextDoubleDefCursor(Cursor);
        }
        return (buff);
    }
}