net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW.CFAccDb2LUWAccountTable.java Source code

Java tutorial

Introduction

Here is the source code for net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW.CFAccDb2LUWAccountTable.java

Source

// Description: Java 7 DB/2 LUW 10.5 Jdbc DbIO implementation for Account.

/*
 *   MSS Code Factory Accounting Business Application Model
 *
 *   Copyright (c) 2014 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/>.
 *   
 *      This source code incorporates modified modules originally licensed
 *      under the Apache 2.0 license by MSS Code Factory including CFSecurity
 *      (net-sourceforge-msscodefactory-2.0-cfsecurity.xml),
 *      CFInternet (net-sourceforge-msscodefactory-2.0-cfinternet.xml), and
 *      CFCrm 2.0 (net-sourceforge-msscodefactory-2.0-cfcrm.xml), with all of the
 *      required models being available as part of the MSS Code Factory 1.11
 *      distribution source and install zips.
 *   
 *      You can download installations of MSS Code Factory 1.11 from
 *      http://msscodefactory.sourceforge.net/
 *   
 * ***********************************************************************
 *
 *   Code manufactured by MSS Code Factory
 */

package net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW;

import java.math.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import net.sourceforge.msscodefactory.cflib.v1_11.CFLib.*;
import org.apache.commons.codec.binary.Base64;
import net.sourceforge.msscodefactory.cfacc.v2_0.CFAcc.*;

/*
 *   CFAccDb2LUWAccountTable DB/2 LUW 10.5 Jdbc DbIO implementation
 *   for Account.
 */
public class CFAccDb2LUWAccountTable implements ICFAccAccountTable {
    private CFAccDb2LUWSchema schema;
    protected PreparedStatement stmtReadBuffByPKey = null;
    protected PreparedStatement stmtLockBuffByPKey = null;
    protected PreparedStatement stmtCreateByPKey = null;
    protected PreparedStatement stmtUpdateByPKey = null;
    protected PreparedStatement stmtDeleteByPKey = null;
    protected PreparedStatement stmtReadAllBuff = null;
    protected PreparedStatement stmtReadBuffByIdIdx = null;
    protected PreparedStatement stmtReadBuffByUCodeIdx = null;
    protected PreparedStatement stmtReadBuffByTenantIdx = null;
    protected PreparedStatement stmtReadBuffByRollupAcctIdx = null;
    protected PreparedStatement stmtReadBuffByCcyIdx = null;
    protected PreparedStatement stmtDeleteByIdIdx = null;
    protected PreparedStatement stmtDeleteByUCodeIdx = null;
    protected PreparedStatement stmtDeleteByTenantIdx = null;
    protected PreparedStatement stmtDeleteByRollupAcctIdx = null;
    protected PreparedStatement stmtDeleteByCcyIdx = null;

    public CFAccDb2LUWAccountTable(CFAccDb2LUWSchema argSchema) {
        schema = argSchema;
    }

    public void createAccount(CFAccAuthorization Authorization, CFAccAccountBuff Buff) {
        final String S_ProcName = "createAccount";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ResultSet resultSet = null;
        try {
            long TenantId = Buff.getRequiredTenantId();
            String AccountCode = Buff.getRequiredAccountCode();
            String Description = Buff.getRequiredDescription();
            short CurrencyId = Buff.getRequiredCurrencyId();
            BigDecimal Balance = Buff.getRequiredBalance();
            Long RollupTenantId = Buff.getOptionalRollupTenantId();
            Long RollupAccountId = Buff.getOptionalRollupAccountId();
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_create_acct( ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + ", "
                    + "?" + ", " + "?" + ", " + "?" + ", " + "?" + " )";
            if (stmtCreateByPKey == null) {
                stmtCreateByPKey = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtCreateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtCreateByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtCreateByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtCreateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtCreateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtCreateByPKey.setString(argIdx++, "ACCT");
            stmtCreateByPKey.setLong(argIdx++, TenantId);
            stmtCreateByPKey.setString(argIdx++, AccountCode);
            stmtCreateByPKey.setString(argIdx++, Description);
            stmtCreateByPKey.setShort(argIdx++, CurrencyId);
            stmtCreateByPKey.setBigDecimal(argIdx++, Balance);
            if (RollupTenantId != null) {
                stmtCreateByPKey.setLong(argIdx++, RollupTenantId.longValue());
            } else {
                stmtCreateByPKey.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            if (RollupAccountId != null) {
                stmtCreateByPKey.setLong(argIdx++, RollupAccountId.longValue());
            } else {
                stmtCreateByPKey.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            resultSet = stmtCreateByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAccountBuff createdBuff = unpackAccountResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
                Buff.setRequiredTenantId(createdBuff.getRequiredTenantId());
                Buff.setRequiredId(createdBuff.getRequiredId());
                Buff.setRequiredAccountCode(createdBuff.getRequiredAccountCode());
                Buff.setRequiredDescription(createdBuff.getRequiredDescription());
                Buff.setRequiredCurrencyId(createdBuff.getRequiredCurrencyId());
                Buff.setRequiredBalance(createdBuff.getRequiredBalance());
                Buff.setOptionalRollupTenantId(createdBuff.getOptionalRollupTenantId());
                Buff.setOptionalRollupAccountId(createdBuff.getOptionalRollupAccountId());
                Buff.setRequiredRevision(createdBuff.getRequiredRevision());
                Buff.setCreatedByUserId(createdBuff.getCreatedByUserId());
                Buff.setCreatedAt(createdBuff.getCreatedAt());
                Buff.setUpdatedByUserId(createdBuff.getUpdatedByUserId());
                Buff.setUpdatedAt(createdBuff.getUpdatedAt());
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected a single-record response, " + resultSet.getRow() + " rows selected");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    protected static String S_sqlSelectAccountDistinctClassCode = null;

    public String getSqlSelectAccountDistinctClassCode() {
        if (S_sqlSelectAccountDistinctClassCode == null) {
            S_sqlSelectAccountDistinctClassCode = "SELECT " + "DISTINCT acct.ClassCode " + "FROM "
                    + schema.getLowerSchemaDbName() + ".acct AS acct ";
        }
        return (S_sqlSelectAccountDistinctClassCode);
    }

    protected static String S_sqlSelectAccountBuff = null;

    public String getSqlSelectAccountBuff() {
        if (S_sqlSelectAccountBuff == null) {
            S_sqlSelectAccountBuff = "SELECT " + "acct.TenantId, " + "acct.Id, " + "acct.AccountCode, "
                    + "acct.Description, " + "acct.CurrencyId, " + "acct.Balance, " + "acct.RollupTenantId, "
                    + "acct.RollupAccountId, " + "acct.Revision " + "FROM " + schema.getLowerSchemaDbName()
                    + ".acct AS acct ";
        }
        return (S_sqlSelectAccountBuff);
    }

    protected CFAccAccountBuff unpackAccountResultSetToBuff(ResultSet resultSet) throws SQLException {
        final String S_ProcName = "unpackAccountResultSetToBuff";
        int idxcol = 1;
        CFAccAccountBuff buff = schema.getFactoryAccount().newBuff();
        {
            String colString = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setCreatedByUserId(null);
            } else if ((colString == null) || (colString.length() <= 0)) {
                buff.setCreatedByUserId(null);
            } else {
                buff.setCreatedByUserId(UUID.fromString(colString));
            }
            idxcol++;

            colString = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setCreatedAt(null);
            } else if ((colString == null) || (colString.length() <= 0)) {
                buff.setCreatedAt(null);
            } else {
                buff.setCreatedAt(CFAccDb2LUWSchema.convertTimestampString(colString));
            }
            idxcol++;
            colString = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setUpdatedByUserId(null);
            } else if ((colString == null) || (colString.length() <= 0)) {
                buff.setUpdatedByUserId(null);
            } else {
                buff.setUpdatedByUserId(UUID.fromString(colString));
            }
            idxcol++;

            colString = resultSet.getString(idxcol);
            if (resultSet.wasNull()) {
                buff.setUpdatedAt(null);
            } else if ((colString == null) || (colString.length() <= 0)) {
                buff.setUpdatedAt(null);
            } else {
                buff.setUpdatedAt(CFAccDb2LUWSchema.convertTimestampString(colString));
            }
            idxcol++;
        }
        buff.setRequiredTenantId(resultSet.getLong(idxcol));
        idxcol++;
        buff.setRequiredId(resultSet.getLong(idxcol));
        idxcol++;
        buff.setRequiredAccountCode(resultSet.getString(idxcol));
        idxcol++;
        buff.setRequiredDescription(resultSet.getString(idxcol));
        idxcol++;
        buff.setRequiredCurrencyId(resultSet.getShort(idxcol));
        idxcol++;
        buff.setRequiredBalance(resultSet.getBigDecimal(idxcol));
        idxcol++;
        {
            long colVal = resultSet.getLong(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalRollupTenantId(null);
            } else {
                buff.setOptionalRollupTenantId(colVal);
            }
        }
        idxcol++;
        {
            long colVal = resultSet.getLong(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalRollupAccountId(null);
            } else {
                buff.setOptionalRollupAccountId(colVal);
            }
        }
        idxcol++;

        buff.setRequiredRevision(resultSet.getInt(idxcol));
        return (buff);
    }

    public CFAccAccountBuff readDerived(CFAccAuthorization Authorization, CFAccAccountPKey PKey) {
        final String S_ProcName = "readDerived";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        CFAccAccountBuff buff;
        buff = readBuff(Authorization, PKey);
        return (buff);
    }

    public CFAccAccountBuff lockDerived(CFAccAuthorization Authorization, CFAccAccountPKey PKey) {
        final String S_ProcName = "lockDerived";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        CFAccAccountBuff buff;
        buff = lockBuff(Authorization, PKey);
        return (buff);
    }

    public CFAccAccountBuff[] readAllDerived(CFAccAuthorization Authorization) {
        final String S_ProcName = "readAllDerived";
        CFAccAccountBuff[] buffArray;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        buffArray = readAllBuff(Authorization);
        return (buffArray);
    }

    public CFAccAccountBuff readDerivedByIdIdx(CFAccAuthorization Authorization, long TenantId, long Id) {
        final String S_ProcName = "CFAccDb2LUWAccountTable.readDerivedByIdIdx() ";
        CFAccAccountBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        buff = readBuffByIdIdx(Authorization, TenantId, Id);
        return (buff);
    }

    public CFAccAccountBuff readDerivedByUCodeIdx(CFAccAuthorization Authorization, long TenantId,
            String AccountCode) {
        final String S_ProcName = "CFAccDb2LUWAccountTable.readDerivedByUCodeIdx() ";
        CFAccAccountBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        buff = readBuffByUCodeIdx(Authorization, TenantId, AccountCode);
        return (buff);
    }

    public CFAccAccountBuff[] readDerivedByTenantIdx(CFAccAuthorization Authorization, long TenantId) {
        final String S_ProcName = "readDerivedByTenantIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        CFAccAccountBuff[] buffList = readBuffByTenantIdx(Authorization, TenantId);
        return (buffList);

    }

    public CFAccAccountBuff[] readDerivedByRollupAcctIdx(CFAccAuthorization Authorization, Long RollupTenantId,
            Long RollupAccountId) {
        final String S_ProcName = "readDerivedByRollupAcctIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        CFAccAccountBuff[] buffList = readBuffByRollupAcctIdx(Authorization, RollupTenantId, RollupAccountId);
        return (buffList);

    }

    public CFAccAccountBuff[] readDerivedByCcyIdx(CFAccAuthorization Authorization, short CurrencyId) {
        final String S_ProcName = "readDerivedByCcyIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        CFAccAccountBuff[] buffList = readBuffByCcyIdx(Authorization, CurrencyId);
        return (buffList);

    }

    public CFAccAccountBuff readBuff(CFAccAuthorization Authorization, CFAccAccountPKey PKey) {
        final String S_ProcName = "readBuff";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            long TenantId = PKey.getRequiredTenantId();
            long Id = PKey.getRequiredId();
            final String sql = "CALL sp_read_acct( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            if (stmtReadBuffByPKey == null) {
                stmtReadBuffByPKey = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtReadBuffByPKey.setLong(argIdx++, TenantId);
            stmtReadBuffByPKey.setLong(argIdx++, Id);
            resultSet = stmtReadBuffByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
                return (buff);
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public CFAccAccountBuff lockBuff(CFAccAuthorization Authorization, CFAccAccountPKey PKey) {
        final String S_ProcName = "lockBuff";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            long TenantId = PKey.getRequiredTenantId();
            long Id = PKey.getRequiredId();
            final String sql = "CALL sp_lock_acct( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            if (stmtLockBuffByPKey == null) {
                stmtLockBuffByPKey = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtLockBuffByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtLockBuffByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtLockBuffByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtLockBuffByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtLockBuffByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtLockBuffByPKey.setLong(argIdx++, TenantId);
            stmtLockBuffByPKey.setLong(argIdx++, Id);
            resultSet = stmtLockBuffByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
                return (buff);
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public CFAccAccountBuff[] readAllBuff(CFAccAuthorization Authorization) {
        final String S_ProcName = "readAllBuff";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_acct_all( ?, ?, ?, ?, ? )";
            if (stmtReadAllBuff == null) {
                stmtReadAllBuff = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadAllBuff.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadAllBuff.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadAllBuff.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadAllBuff.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadAllBuff.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            resultSet = stmtReadAllBuff.executeQuery();
            List<CFAccAccountBuff> buffList = new LinkedList<CFAccAccountBuff>();
            while (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAccountBuff[] retBuff = new CFAccAccountBuff[buffList.size()];
            Iterator<CFAccAccountBuff> iter = buffList.iterator();
            while (iter.hasNext()) {
                retBuff[idx++] = iter.next();
            }
            return (retBuff);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public CFAccAccountBuff readBuffByIdIdx(CFAccAuthorization Authorization, long TenantId, long Id) {
        final String S_ProcName = "readBuffByIdIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_acct_by_ididx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            if (stmtReadBuffByIdIdx == null) {
                stmtReadBuffByIdIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByIdIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByIdIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByIdIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByIdIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByIdIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtReadBuffByIdIdx.setLong(argIdx++, TenantId);
            stmtReadBuffByIdIdx.setLong(argIdx++, Id);
            resultSet = stmtReadBuffByIdIdx.executeQuery();
            if (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
                return (buff);
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public CFAccAccountBuff readBuffByUCodeIdx(CFAccAuthorization Authorization, long TenantId,
            String AccountCode) {
        final String S_ProcName = "readBuffByUCodeIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_acct_by_ucodeidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            if (stmtReadBuffByUCodeIdx == null) {
                stmtReadBuffByUCodeIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByUCodeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByUCodeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByUCodeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByUCodeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByUCodeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtReadBuffByUCodeIdx.setLong(argIdx++, TenantId);
            stmtReadBuffByUCodeIdx.setString(argIdx++, AccountCode);
            resultSet = stmtReadBuffByUCodeIdx.executeQuery();
            if (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
                return (buff);
            } else {
                return (null);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public CFAccAccountBuff[] readBuffByTenantIdx(CFAccAuthorization Authorization, long TenantId) {
        final String S_ProcName = "readBuffByTenantIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_acct_by_tenantidx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
            if (stmtReadBuffByTenantIdx == null) {
                stmtReadBuffByTenantIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByTenantIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByTenantIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByTenantIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByTenantIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByTenantIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtReadBuffByTenantIdx.setLong(argIdx++, TenantId);
            resultSet = stmtReadBuffByTenantIdx.executeQuery();
            List<CFAccAccountBuff> buffList = new LinkedList<CFAccAccountBuff>();
            while (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAccountBuff[] retBuff = new CFAccAccountBuff[buffList.size()];
            Iterator<CFAccAccountBuff> iter = buffList.iterator();
            while (iter.hasNext()) {
                retBuff[idx++] = iter.next();
            }
            return (retBuff);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public CFAccAccountBuff[] readBuffByRollupAcctIdx(CFAccAuthorization Authorization, Long RollupTenantId,
            Long RollupAccountId) {
        final String S_ProcName = "readBuffByRollupAcctIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_acct_by_rollupacctidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            if (stmtReadBuffByRollupAcctIdx == null) {
                stmtReadBuffByRollupAcctIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByRollupAcctIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByRollupAcctIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByRollupAcctIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByRollupAcctIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByRollupAcctIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecTenantId());
            if (RollupTenantId != null) {
                stmtReadBuffByRollupAcctIdx.setLong(argIdx++, RollupTenantId.longValue());
            } else {
                stmtReadBuffByRollupAcctIdx.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            if (RollupAccountId != null) {
                stmtReadBuffByRollupAcctIdx.setLong(argIdx++, RollupAccountId.longValue());
            } else {
                stmtReadBuffByRollupAcctIdx.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            resultSet = stmtReadBuffByRollupAcctIdx.executeQuery();
            List<CFAccAccountBuff> buffList = new LinkedList<CFAccAccountBuff>();
            while (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAccountBuff[] retBuff = new CFAccAccountBuff[buffList.size()];
            Iterator<CFAccAccountBuff> iter = buffList.iterator();
            while (iter.hasNext()) {
                retBuff[idx++] = iter.next();
            }
            return (retBuff);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public CFAccAccountBuff[] readBuffByCcyIdx(CFAccAuthorization Authorization, short CurrencyId) {
        final String S_ProcName = "readBuffByCcyIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_acct_by_ccyidx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
            if (stmtReadBuffByCcyIdx == null) {
                stmtReadBuffByCcyIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByCcyIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByCcyIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByCcyIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByCcyIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByCcyIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtReadBuffByCcyIdx.setShort(argIdx++, CurrencyId);
            resultSet = stmtReadBuffByCcyIdx.executeQuery();
            List<CFAccAccountBuff> buffList = new LinkedList<CFAccAccountBuff>();
            while (resultSet.next()) {
                CFAccAccountBuff buff = unpackAccountResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAccountBuff[] retBuff = new CFAccAccountBuff[buffList.size()];
            Iterator<CFAccAccountBuff> iter = buffList.iterator();
            while (iter.hasNext()) {
                retBuff[idx++] = iter.next();
            }
            return (retBuff);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void updateAccount(CFAccAuthorization Authorization, CFAccAccountBuff Buff) {
        final String S_ProcName = "updateAccount";
        if ("ACCT".equals(Buff.getClassCode())
                && (!schema.isTenantUser(Authorization, Buff.getRequiredTenantId(), "UpdateAccount"))) {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Permission denied -- User not part of TSecGroup UpdateAccount");
        }
        ResultSet resultSet = null;
        try {
            long TenantId = Buff.getRequiredTenantId();
            long Id = Buff.getRequiredId();
            String AccountCode = Buff.getRequiredAccountCode();
            String Description = Buff.getRequiredDescription();
            short CurrencyId = Buff.getRequiredCurrencyId();
            BigDecimal Balance = Buff.getRequiredBalance();
            Long RollupTenantId = Buff.getOptionalRollupTenantId();
            Long RollupAccountId = Buff.getOptionalRollupAccountId();
            int Revision = Buff.getRequiredRevision();
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_update_acct( ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + ", "
                    + "?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + " )";
            if (stmtUpdateByPKey == null) {
                stmtUpdateByPKey = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtUpdateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtUpdateByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtUpdateByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtUpdateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtUpdateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtUpdateByPKey.setString(argIdx++, "ACCT");
            stmtUpdateByPKey.setLong(argIdx++, TenantId);
            stmtUpdateByPKey.setLong(argIdx++, Id);
            stmtUpdateByPKey.setString(argIdx++, AccountCode);
            stmtUpdateByPKey.setString(argIdx++, Description);
            stmtUpdateByPKey.setShort(argIdx++, CurrencyId);
            stmtUpdateByPKey.setBigDecimal(argIdx++, Balance);
            if (RollupTenantId != null) {
                stmtUpdateByPKey.setLong(argIdx++, RollupTenantId.longValue());
            } else {
                stmtUpdateByPKey.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            if (RollupAccountId != null) {
                stmtUpdateByPKey.setLong(argIdx++, RollupAccountId.longValue());
            } else {
                stmtUpdateByPKey.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            stmtUpdateByPKey.setInt(argIdx++, Revision);
            resultSet = stmtUpdateByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAccountBuff updatedBuff = unpackAccountResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
                Buff.setRequiredAccountCode(updatedBuff.getRequiredAccountCode());
                Buff.setRequiredDescription(updatedBuff.getRequiredDescription());
                Buff.setRequiredCurrencyId(updatedBuff.getRequiredCurrencyId());
                Buff.setRequiredBalance(updatedBuff.getRequiredBalance());
                Buff.setOptionalRollupTenantId(updatedBuff.getOptionalRollupTenantId());
                Buff.setOptionalRollupAccountId(updatedBuff.getOptionalRollupAccountId());
                Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected a single-record response, " + resultSet.getRow() + " rows selected");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void deleteAccount(CFAccAuthorization Authorization, CFAccAccountBuff Buff) {
        final String S_ProcName = "deleteAccount";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            long TenantId = Buff.getRequiredTenantId();
            long Id = Buff.getRequiredId();

            final String sql = "CALL sp_delete_acct( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " )";
            if (stmtDeleteByPKey == null) {
                stmtDeleteByPKey = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByPKey.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtDeleteByPKey.setLong(argIdx++, TenantId);
            stmtDeleteByPKey.setLong(argIdx++, Id);
            stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
            ;
            resultSet = stmtDeleteByPKey.executeQuery();
            if (resultSet.next()) {
                int deleteFlag = resultSet.getInt(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 record result set to be returned by delete, not 0 rows");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void deleteAccountByIdIdx(CFAccAuthorization Authorization, long argTenantId, long argId) {
        final String S_ProcName = "deleteAccountByIdIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_acct_by_ididx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            if (stmtDeleteByIdIdx == null) {
                stmtDeleteByIdIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByIdIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByIdIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByIdIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByIdIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByIdIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtDeleteByIdIdx.setLong(argIdx++, argTenantId);
            stmtDeleteByIdIdx.setLong(argIdx++, argId);
            resultSet = stmtDeleteByIdIdx.executeQuery();
            if (resultSet.next()) {
                int deleteFlag = resultSet.getInt(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 record result set to be returned by delete, not 0 rows");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void deleteAccountByIdIdx(CFAccAuthorization Authorization, CFAccAccountPKey argKey) {
        deleteAccountByIdIdx(Authorization, argKey.getRequiredTenantId(), argKey.getRequiredId());
    }

    public void deleteAccountByUCodeIdx(CFAccAuthorization Authorization, long argTenantId, String argAccountCode) {
        final String S_ProcName = "deleteAccountByUCodeIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_acct_by_ucodeidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            if (stmtDeleteByUCodeIdx == null) {
                stmtDeleteByUCodeIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByUCodeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByUCodeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByUCodeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByUCodeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByUCodeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtDeleteByUCodeIdx.setLong(argIdx++, argTenantId);
            stmtDeleteByUCodeIdx.setString(argIdx++, argAccountCode);
            resultSet = stmtDeleteByUCodeIdx.executeQuery();
            if (resultSet.next()) {
                int deleteFlag = resultSet.getInt(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 record result set to be returned by delete, not 0 rows");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void deleteAccountByUCodeIdx(CFAccAuthorization Authorization, CFAccAccountByUCodeIdxKey argKey) {
        deleteAccountByUCodeIdx(Authorization, argKey.getRequiredTenantId(), argKey.getRequiredAccountCode());
    }

    public void deleteAccountByTenantIdx(CFAccAuthorization Authorization, long argTenantId) {
        final String S_ProcName = "deleteAccountByTenantIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_acct_by_tenantidx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
            if (stmtDeleteByTenantIdx == null) {
                stmtDeleteByTenantIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByTenantIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByTenantIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByTenantIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByTenantIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByTenantIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtDeleteByTenantIdx.setLong(argIdx++, argTenantId);
            resultSet = stmtDeleteByTenantIdx.executeQuery();
            if (resultSet.next()) {
                int deleteFlag = resultSet.getInt(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 record result set to be returned by delete, not 0 rows");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void deleteAccountByTenantIdx(CFAccAuthorization Authorization, CFAccAccountByTenantIdxKey argKey) {
        deleteAccountByTenantIdx(Authorization, argKey.getRequiredTenantId());
    }

    public void deleteAccountByRollupAcctIdx(CFAccAuthorization Authorization, Long argRollupTenantId,
            Long argRollupAccountId) {
        final String S_ProcName = "deleteAccountByRollupAcctIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_acct_by_rollupacctidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?"
                    + " )";
            if (stmtDeleteByRollupAcctIdx == null) {
                stmtDeleteByRollupAcctIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByRollupAcctIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByRollupAcctIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByRollupAcctIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByRollupAcctIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByRollupAcctIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecTenantId());
            if (argRollupTenantId != null) {
                stmtDeleteByRollupAcctIdx.setLong(argIdx++, argRollupTenantId.longValue());
            } else {
                stmtDeleteByRollupAcctIdx.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            if (argRollupAccountId != null) {
                stmtDeleteByRollupAcctIdx.setLong(argIdx++, argRollupAccountId.longValue());
            } else {
                stmtDeleteByRollupAcctIdx.setNull(argIdx++, java.sql.Types.BIGINT);
            }
            resultSet = stmtDeleteByRollupAcctIdx.executeQuery();
            if (resultSet.next()) {
                int deleteFlag = resultSet.getInt(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 record result set to be returned by delete, not 0 rows");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void deleteAccountByRollupAcctIdx(CFAccAuthorization Authorization,
            CFAccAccountByRollupAcctIdxKey argKey) {
        deleteAccountByRollupAcctIdx(Authorization, argKey.getOptionalRollupTenantId(),
                argKey.getOptionalRollupAccountId());
    }

    public void deleteAccountByCcyIdx(CFAccAuthorization Authorization, short argCurrencyId) {
        final String S_ProcName = "deleteAccountByCcyIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_acct_by_ccyidx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
            if (stmtDeleteByCcyIdx == null) {
                stmtDeleteByCcyIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByCcyIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByCcyIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByCcyIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByCcyIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByCcyIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtDeleteByCcyIdx.setShort(argIdx++, argCurrencyId);
            resultSet = stmtDeleteByCcyIdx.executeQuery();
            if (resultSet.next()) {
                int deleteFlag = resultSet.getInt(1);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "Expected 1 record result set to be returned by delete, not 0 rows");
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public void deleteAccountByCcyIdx(CFAccAuthorization Authorization, CFAccAccountByCcyIdxKey argKey) {
        deleteAccountByCcyIdx(Authorization, argKey.getRequiredCurrencyId());
    }

    public CFAccCursor openAccountCursorAll(CFAccAuthorization Authorization) {
        String sql = getSqlSelectAccountBuff() + "ORDER BY " + "acct.TenantId ASC" + ", " + "acct.Id ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

    public CFAccCursor openAccountCursorByTenantIdx(CFAccAuthorization Authorization, long TenantId) {
        String sql = getSqlSelectAccountBuff() + "WHERE " + "acct.TenantId = " + Long.toString(TenantId) + " "
                + "ORDER BY " + "acct.TenantId ASC" + ", " + "acct.Id ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

    public CFAccCursor openAccountCursorByRollupAcctIdx(CFAccAuthorization Authorization, Long RollupTenantId,
            Long RollupAccountId) {
        String sql = getSqlSelectAccountBuff() + "WHERE "
                + ((RollupTenantId == null) ? "acct.RollupTenantId is null "
                        : "acct.RollupTenantId = " + RollupTenantId.toString() + " ")
                + "AND "
                + ((RollupAccountId == null) ? "acct.RollupAccountId is null "
                        : "acct.RollupAccountId = " + RollupAccountId.toString() + " ")
                + "ORDER BY " + "acct.TenantId ASC" + ", " + "acct.Id ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

    public CFAccCursor openAccountCursorByCcyIdx(CFAccAuthorization Authorization, short CurrencyId) {
        String sql = getSqlSelectAccountBuff() + "WHERE " + "acct.CurrencyId = " + Short.toString(CurrencyId) + " "
                + "ORDER BY " + "acct.TenantId ASC" + ", " + "acct.Id ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

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

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

    public CFAccAccountBuff prevAccountCursor(CFAccCursor Cursor) {
        int targetRowIdx = (Cursor.getRowIdx() > 1) ? Cursor.getRowIdx() - 1 : 1;
        CFAccAccountBuff buff = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextAccountCursor(Cursor);
        }
        return (buff);
    }

    public CFAccAccountBuff firstAccountCursor(CFAccCursor Cursor) {
        int targetRowIdx = 1;
        CFAccAccountBuff buff = null;
        Cursor.reset();
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextAccountCursor(Cursor);
        }
        return (buff);
    }

    public CFAccAccountBuff lastAccountCursor(CFAccCursor Cursor) {
        throw CFLib.getDefaultExceptionFactory().newNotImplementedYetException(getClass(), "lastAccountCursor");
    }

    public CFAccAccountBuff nthAccountCursor(CFAccCursor Cursor, int Idx) {
        int targetRowIdx = Idx;
        CFAccAccountBuff buff = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextAccountCursor(Cursor);
        }
        return (buff);
    }

    /**
     *   Release the prepared statements.
     *   <p>
     *   When the schema changes connections, the prepared statements
     *   have to be released because they contain connection-specific
     *   information for most databases.
     */
    public void releasePreparedStatements() {
        final String S_ProcName = "releasePreparedStatements";
        S_sqlSelectAccountDistinctClassCode = null;
        S_sqlSelectAccountBuff = null;

        if (stmtReadBuffByPKey != null) {
            try {
                stmtReadBuffByPKey.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByPKey = null;
        }
        if (stmtReadAllBuff != null) {
            try {
                stmtReadAllBuff.close();
            } catch (SQLException e) {
            }
            stmtReadAllBuff = null;
        }
        if (stmtLockBuffByPKey != null) {
            try {
                stmtLockBuffByPKey.close();
            } catch (SQLException e) {
            }
            stmtLockBuffByPKey = null;
        }
        if (stmtCreateByPKey != null) {
            try {
                stmtCreateByPKey.close();
            } catch (SQLException e) {
            }
            stmtCreateByPKey = null;
        }
        if (stmtUpdateByPKey != null) {
            try {
                stmtUpdateByPKey.close();
            } catch (SQLException e) {
            }
            stmtUpdateByPKey = null;
        }
        if (stmtDeleteByPKey != null) {
            try {
                stmtDeleteByPKey.close();
            } catch (SQLException e) {
            }
            stmtDeleteByPKey = null;
        }
        if (stmtDeleteByIdIdx != null) {
            try {
                stmtDeleteByIdIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByIdIdx = null;
        }
        if (stmtDeleteByUCodeIdx != null) {
            try {
                stmtDeleteByUCodeIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByUCodeIdx = null;
        }
        if (stmtDeleteByTenantIdx != null) {
            try {
                stmtDeleteByTenantIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByTenantIdx = null;
        }
        if (stmtDeleteByRollupAcctIdx != null) {
            try {
                stmtDeleteByRollupAcctIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByRollupAcctIdx = null;
        }
        if (stmtDeleteByCcyIdx != null) {
            try {
                stmtDeleteByCcyIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByCcyIdx = null;
        }
        if (stmtReadAllBuff != null) {
            try {
                stmtReadAllBuff.close();
            } catch (SQLException e) {
            }
            stmtReadAllBuff = null;
        }
        if (stmtReadBuffByIdIdx != null) {
            try {
                stmtReadBuffByIdIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByIdIdx = null;
        }
        if (stmtReadBuffByUCodeIdx != null) {
            try {
                stmtReadBuffByUCodeIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByUCodeIdx = null;
        }
        if (stmtReadBuffByTenantIdx != null) {
            try {
                stmtReadBuffByTenantIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByTenantIdx = null;
        }
        if (stmtReadBuffByRollupAcctIdx != null) {
            try {
                stmtReadBuffByRollupAcctIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByRollupAcctIdx = null;
        }
        if (stmtReadBuffByCcyIdx != null) {
            try {
                stmtReadBuffByCcyIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByCcyIdx = null;
        }
    }
}