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

Java tutorial

Introduction

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

Source

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

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

/*
 *   CFAccDb2LUWAttachmentTable DB/2 LUW 10.5 Jdbc DbIO implementation
 *   for Attachment.
 */
public class CFAccDb2LUWAttachmentTable implements ICFAccAttachmentTable {
    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 stmtReadBuffByTenantIdx = null;
    protected PreparedStatement stmtReadBuffByContactIdx = null;
    protected PreparedStatement stmtReadBuffByUDescrIdx = null;
    protected PreparedStatement stmtReadBuffByMimeTypeIdx = null;
    protected PreparedStatement stmtDeleteByIdIdx = null;
    protected PreparedStatement stmtDeleteByTenantIdx = null;
    protected PreparedStatement stmtDeleteByContactIdx = null;
    protected PreparedStatement stmtDeleteByUDescrIdx = null;
    protected PreparedStatement stmtDeleteByMimeTypeIdx = null;

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

    public void createAttachment(CFAccAuthorization Authorization, CFAccAttachmentBuff Buff) {
        final String S_ProcName = "createAttachment";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        ResultSet resultSet = null;
        try {
            long TenantId = Buff.getRequiredTenantId();
            long ContactId = Buff.getRequiredContactId();
            String Description = Buff.getRequiredDescription();
            Integer MimeTypeId = Buff.getOptionalMimeTypeId();
            String Attachment = Buff.getRequiredAttachment();
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_create_attchmnt( ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?"
                    + ", " + "?" + ", " + "?" + " )";
            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++, "ATTC");
            stmtCreateByPKey.setLong(argIdx++, TenantId);
            stmtCreateByPKey.setLong(argIdx++, ContactId);
            stmtCreateByPKey.setString(argIdx++, Description);
            if (MimeTypeId != null) {
                stmtCreateByPKey.setInt(argIdx++, MimeTypeId.intValue());
            } else {
                stmtCreateByPKey.setNull(argIdx++, java.sql.Types.INTEGER);
            }
            stmtCreateByPKey.setString(argIdx++, Attachment);
            resultSet = stmtCreateByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAttachmentBuff createdBuff = unpackAttachmentResultSetToBuff(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.setRequiredAttachmentId(createdBuff.getRequiredAttachmentId());
                Buff.setRequiredContactId(createdBuff.getRequiredContactId());
                Buff.setRequiredDescription(createdBuff.getRequiredDescription());
                Buff.setOptionalMimeTypeId(createdBuff.getOptionalMimeTypeId());
                Buff.setRequiredAttachment(createdBuff.getRequiredAttachment());
                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_sqlSelectAttachmentDistinctClassCode = null;

    public String getSqlSelectAttachmentDistinctClassCode() {
        if (S_sqlSelectAttachmentDistinctClassCode == null) {
            S_sqlSelectAttachmentDistinctClassCode = "SELECT " + "DISTINCT attc.ClassCode " + "FROM "
                    + schema.getLowerSchemaDbName() + ".Attchmnt AS attc ";
        }
        return (S_sqlSelectAttachmentDistinctClassCode);
    }

    protected static String S_sqlSelectAttachmentBuff = null;

    public String getSqlSelectAttachmentBuff() {
        if (S_sqlSelectAttachmentBuff == null) {
            S_sqlSelectAttachmentBuff = "SELECT " + "attc.TenantId, " + "attc.AttachmentId, " + "attc.ContactId, "
                    + "attc.Description, " + "attc.MimeTypeId, " + "attc.Attachment, " + "attc.Revision " + "FROM "
                    + schema.getLowerSchemaDbName() + ".Attchmnt AS attc ";
        }
        return (S_sqlSelectAttachmentBuff);
    }

    protected CFAccAttachmentBuff unpackAttachmentResultSetToBuff(ResultSet resultSet) throws SQLException {
        final String S_ProcName = "unpackAttachmentResultSetToBuff";
        int idxcol = 1;
        CFAccAttachmentBuff buff = schema.getFactoryAttachment().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.setRequiredAttachmentId(resultSet.getLong(idxcol));
        idxcol++;
        buff.setRequiredContactId(resultSet.getLong(idxcol));
        idxcol++;
        buff.setRequiredDescription(resultSet.getString(idxcol));
        idxcol++;
        {
            int colVal = resultSet.getInt(idxcol);
            if (resultSet.wasNull()) {
                buff.setOptionalMimeTypeId(null);
            } else {
                buff.setOptionalMimeTypeId(colVal);
            }
        }
        idxcol++;
        buff.setRequiredAttachment(resultSet.getString(idxcol));
        idxcol++;

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

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

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

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

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

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

    }

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

    }

    public CFAccAttachmentBuff readDerivedByUDescrIdx(CFAccAuthorization Authorization, long TenantId,
            long ContactId, String Description) {
        final String S_ProcName = "CFAccDb2LUWAttachmentTable.readDerivedByUDescrIdx() ";
        CFAccAttachmentBuff buff;
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        buff = readBuffByUDescrIdx(Authorization, TenantId, ContactId, Description);
        return (buff);
    }

    public CFAccAttachmentBuff[] readDerivedByMimeTypeIdx(CFAccAuthorization Authorization, Integer MimeTypeId) {
        final String S_ProcName = "readDerivedByMimeTypeIdx";
        if (!schema.isTransactionOpen()) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                    "Transaction not open");
        }
        CFAccAttachmentBuff[] buffList = readBuffByMimeTypeIdx(Authorization, MimeTypeId);
        return (buffList);

    }

    public CFAccAttachmentBuff readBuff(CFAccAuthorization Authorization, CFAccAttachmentPKey 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 AttachmentId = PKey.getRequiredAttachmentId();
            final String sql = "CALL sp_read_attchmnt( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            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++, AttachmentId);
            resultSet = stmtReadBuffByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(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 CFAccAttachmentBuff lockBuff(CFAccAuthorization Authorization, CFAccAttachmentPKey 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 AttachmentId = PKey.getRequiredAttachmentId();
            final String sql = "CALL sp_lock_attchmnt( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
            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++, AttachmentId);
            resultSet = stmtLockBuffByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(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 CFAccAttachmentBuff[] 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_attchmnt_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<CFAccAttachmentBuff> buffList = new LinkedList<CFAccAttachmentBuff>();
            while (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAttachmentBuff[] retBuff = new CFAccAttachmentBuff[buffList.size()];
            Iterator<CFAccAttachmentBuff> 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 CFAccAttachmentBuff readBuffByIdIdx(CFAccAuthorization Authorization, long TenantId, long AttachmentId) {
        final String S_ProcName = "readBuffByIdIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_attchmnt_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++, AttachmentId);
            resultSet = stmtReadBuffByIdIdx.executeQuery();
            if (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(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 CFAccAttachmentBuff[] readBuffByTenantIdx(CFAccAuthorization Authorization, long TenantId) {
        final String S_ProcName = "readBuffByTenantIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_attchmnt_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<CFAccAttachmentBuff> buffList = new LinkedList<CFAccAttachmentBuff>();
            while (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAttachmentBuff[] retBuff = new CFAccAttachmentBuff[buffList.size()];
            Iterator<CFAccAttachmentBuff> 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 CFAccAttachmentBuff[] readBuffByContactIdx(CFAccAuthorization Authorization, long TenantId,
            long ContactId) {
        final String S_ProcName = "readBuffByContactIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_attchmnt_by_contactidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?"
                    + " )";
            if (stmtReadBuffByContactIdx == null) {
                stmtReadBuffByContactIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByContactIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByContactIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByContactIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByContactIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByContactIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtReadBuffByContactIdx.setLong(argIdx++, TenantId);
            stmtReadBuffByContactIdx.setLong(argIdx++, ContactId);
            resultSet = stmtReadBuffByContactIdx.executeQuery();
            List<CFAccAttachmentBuff> buffList = new LinkedList<CFAccAttachmentBuff>();
            while (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAttachmentBuff[] retBuff = new CFAccAttachmentBuff[buffList.size()];
            Iterator<CFAccAttachmentBuff> 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 CFAccAttachmentBuff readBuffByUDescrIdx(CFAccAuthorization Authorization, long TenantId, long ContactId,
            String Description) {
        final String S_ProcName = "readBuffByUDescrIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_attchmnt_by_udescridx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", "
                    + "?" + " )";
            if (stmtReadBuffByUDescrIdx == null) {
                stmtReadBuffByUDescrIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByUDescrIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByUDescrIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByUDescrIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByUDescrIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByUDescrIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtReadBuffByUDescrIdx.setLong(argIdx++, TenantId);
            stmtReadBuffByUDescrIdx.setLong(argIdx++, ContactId);
            stmtReadBuffByUDescrIdx.setString(argIdx++, Description);
            resultSet = stmtReadBuffByUDescrIdx.executeQuery();
            if (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(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 CFAccAttachmentBuff[] readBuffByMimeTypeIdx(CFAccAuthorization Authorization, Integer MimeTypeId) {
        final String S_ProcName = "readBuffByMimeTypeIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_read_attchmnt_by_mimetypeidx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
            if (stmtReadBuffByMimeTypeIdx == null) {
                stmtReadBuffByMimeTypeIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtReadBuffByMimeTypeIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByMimeTypeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtReadBuffByMimeTypeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtReadBuffByMimeTypeIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtReadBuffByMimeTypeIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecTenantId());
            if (MimeTypeId != null) {
                stmtReadBuffByMimeTypeIdx.setInt(argIdx++, MimeTypeId.intValue());
            } else {
                stmtReadBuffByMimeTypeIdx.setNull(argIdx++, java.sql.Types.INTEGER);
            }
            resultSet = stmtReadBuffByMimeTypeIdx.executeQuery();
            List<CFAccAttachmentBuff> buffList = new LinkedList<CFAccAttachmentBuff>();
            while (resultSet.next()) {
                CFAccAttachmentBuff buff = unpackAttachmentResultSetToBuff(resultSet);
                buffList.add(buff);
            }
            int idx = 0;
            CFAccAttachmentBuff[] retBuff = new CFAccAttachmentBuff[buffList.size()];
            Iterator<CFAccAttachmentBuff> 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 updateAttachment(CFAccAuthorization Authorization, CFAccAttachmentBuff Buff) {
        final String S_ProcName = "updateAttachment";
        if ("ATTC".equals(Buff.getClassCode())
                && (!schema.isTenantUser(Authorization, Buff.getRequiredTenantId(), "UpdateAttachment"))) {
            throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                    "Permission denied -- User not part of TSecGroup UpdateAttachment");
        }
        ResultSet resultSet = null;
        try {
            long TenantId = Buff.getRequiredTenantId();
            long AttachmentId = Buff.getRequiredAttachmentId();
            long ContactId = Buff.getRequiredContactId();
            String Description = Buff.getRequiredDescription();
            Integer MimeTypeId = Buff.getOptionalMimeTypeId();
            String Attachment = Buff.getRequiredAttachment();
            int Revision = Buff.getRequiredRevision();
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_update_attchmnt( ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?"
                    + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + " )";
            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++, "ATTC");
            stmtUpdateByPKey.setLong(argIdx++, TenantId);
            stmtUpdateByPKey.setLong(argIdx++, AttachmentId);
            stmtUpdateByPKey.setLong(argIdx++, ContactId);
            stmtUpdateByPKey.setString(argIdx++, Description);
            if (MimeTypeId != null) {
                stmtUpdateByPKey.setInt(argIdx++, MimeTypeId.intValue());
            } else {
                stmtUpdateByPKey.setNull(argIdx++, java.sql.Types.INTEGER);
            }
            stmtUpdateByPKey.setString(argIdx++, Attachment);
            stmtUpdateByPKey.setInt(argIdx++, Revision);
            resultSet = stmtUpdateByPKey.executeQuery();
            if (resultSet.next()) {
                CFAccAttachmentBuff updatedBuff = unpackAttachmentResultSetToBuff(resultSet);
                if (resultSet.next()) {
                    resultSet.last();
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
                }
                Buff.setRequiredContactId(updatedBuff.getRequiredContactId());
                Buff.setRequiredDescription(updatedBuff.getRequiredDescription());
                Buff.setOptionalMimeTypeId(updatedBuff.getOptionalMimeTypeId());
                Buff.setRequiredAttachment(updatedBuff.getRequiredAttachment());
                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 deleteAttachment(CFAccAuthorization Authorization, CFAccAttachmentBuff Buff) {
        final String S_ProcName = "deleteAttachment";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            long TenantId = Buff.getRequiredTenantId();
            long AttachmentId = Buff.getRequiredAttachmentId();

            final String sql = "CALL sp_delete_attchmnt( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?"
                    + " )";
            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++, AttachmentId);
            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 deleteAttachmentByIdIdx(CFAccAuthorization Authorization, long argTenantId, long argAttachmentId) {
        final String S_ProcName = "deleteAttachmentByIdIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_attchmnt_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++, argAttachmentId);
            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 deleteAttachmentByIdIdx(CFAccAuthorization Authorization, CFAccAttachmentPKey argKey) {
        deleteAttachmentByIdIdx(Authorization, argKey.getRequiredTenantId(), argKey.getRequiredAttachmentId());
    }

    public void deleteAttachmentByTenantIdx(CFAccAuthorization Authorization, long argTenantId) {
        final String S_ProcName = "deleteAttachmentByTenantIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_attchmnt_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 deleteAttachmentByTenantIdx(CFAccAuthorization Authorization,
            CFAccAttachmentByTenantIdxKey argKey) {
        deleteAttachmentByTenantIdx(Authorization, argKey.getRequiredTenantId());
    }

    public void deleteAttachmentByContactIdx(CFAccAuthorization Authorization, long argTenantId,
            long argContactId) {
        final String S_ProcName = "deleteAttachmentByContactIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_attchmnt_by_contactidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?"
                    + " )";
            if (stmtDeleteByContactIdx == null) {
                stmtDeleteByContactIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByContactIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByContactIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByContactIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByContactIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByContactIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtDeleteByContactIdx.setLong(argIdx++, argTenantId);
            stmtDeleteByContactIdx.setLong(argIdx++, argContactId);
            resultSet = stmtDeleteByContactIdx.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 deleteAttachmentByContactIdx(CFAccAuthorization Authorization,
            CFAccAttachmentByContactIdxKey argKey) {
        deleteAttachmentByContactIdx(Authorization, argKey.getRequiredTenantId(), argKey.getRequiredContactId());
    }

    public void deleteAttachmentByUDescrIdx(CFAccAuthorization Authorization, long argTenantId, long argContactId,
            String argDescription) {
        final String S_ProcName = "deleteAttachmentByUDescrIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_attchmnt_by_udescridx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?"
                    + ", " + "?" + " )";
            if (stmtDeleteByUDescrIdx == null) {
                stmtDeleteByUDescrIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByUDescrIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByUDescrIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByUDescrIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByUDescrIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByUDescrIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            stmtDeleteByUDescrIdx.setLong(argIdx++, argTenantId);
            stmtDeleteByUDescrIdx.setLong(argIdx++, argContactId);
            stmtDeleteByUDescrIdx.setString(argIdx++, argDescription);
            resultSet = stmtDeleteByUDescrIdx.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 deleteAttachmentByUDescrIdx(CFAccAuthorization Authorization,
            CFAccAttachmentByUDescrIdxKey argKey) {
        deleteAttachmentByUDescrIdx(Authorization, argKey.getRequiredTenantId(), argKey.getRequiredContactId(),
                argKey.getRequiredDescription());
    }

    public void deleteAttachmentByMimeTypeIdx(CFAccAuthorization Authorization, Integer argMimeTypeId) {
        final String S_ProcName = "deleteAttachmentByMimeTypeIdx";
        ResultSet resultSet = null;
        try {
            Connection cnx = schema.getCnx();
            final String sql = "CALL sp_delete_attchmnt_by_mimetypeidx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
            if (stmtDeleteByMimeTypeIdx == null) {
                stmtDeleteByMimeTypeIdx = cnx.prepareStatement(sql);
            }
            int argIdx = 1;
            stmtDeleteByMimeTypeIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByMimeTypeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecUserId().toString());
            stmtDeleteByMimeTypeIdx.setString(argIdx++,
                    (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
            stmtDeleteByMimeTypeIdx.setLong(argIdx++,
                    (Authorization == null) ? 0 : Authorization.getSecClusterId());
            stmtDeleteByMimeTypeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
            if (argMimeTypeId != null) {
                stmtDeleteByMimeTypeIdx.setInt(argIdx++, argMimeTypeId.intValue());
            } else {
                stmtDeleteByMimeTypeIdx.setNull(argIdx++, java.sql.Types.INTEGER);
            }
            resultSet = stmtDeleteByMimeTypeIdx.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 deleteAttachmentByMimeTypeIdx(CFAccAuthorization Authorization,
            CFAccAttachmentByMimeTypeIdxKey argKey) {
        deleteAttachmentByMimeTypeIdx(Authorization, argKey.getOptionalMimeTypeId());
    }

    public CFAccCursor openAttachmentCursorAll(CFAccAuthorization Authorization) {
        String sql = getSqlSelectAttachmentBuff() + "ORDER BY " + "attc.TenantId ASC" + ", "
                + "attc.AttachmentId ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

    public CFAccCursor openAttachmentCursorByTenantIdx(CFAccAuthorization Authorization, long TenantId) {
        String sql = getSqlSelectAttachmentBuff() + "WHERE " + "attc.TenantId = " + Long.toString(TenantId) + " "
                + "ORDER BY " + "attc.TenantId ASC" + ", " + "attc.AttachmentId ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

    public CFAccCursor openAttachmentCursorByContactIdx(CFAccAuthorization Authorization, long TenantId,
            long ContactId) {
        String sql = getSqlSelectAttachmentBuff() + "WHERE " + "attc.TenantId = " + Long.toString(TenantId) + " "
                + "AND " + "attc.ContactId = " + Long.toString(ContactId) + " " + "ORDER BY " + "attc.TenantId ASC"
                + ", " + "attc.AttachmentId ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

    public CFAccCursor openAttachmentCursorByMimeTypeIdx(CFAccAuthorization Authorization, Integer MimeTypeId) {
        String sql = getSqlSelectAttachmentBuff() + "WHERE "
                + ((MimeTypeId == null) ? "attc.MimeTypeId is null "
                        : "attc.MimeTypeId = " + MimeTypeId.toString() + " ")
                + "ORDER BY " + "attc.TenantId ASC" + ", " + "attc.AttachmentId ASC";
        CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql);
        return (cursor);
    }

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

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

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

    public CFAccAttachmentBuff firstAttachmentCursor(CFAccCursor Cursor) {
        int targetRowIdx = 1;
        CFAccAttachmentBuff buff = null;
        Cursor.reset();
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextAttachmentCursor(Cursor);
        }
        return (buff);
    }

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

    public CFAccAttachmentBuff nthAttachmentCursor(CFAccCursor Cursor, int Idx) {
        int targetRowIdx = Idx;
        CFAccAttachmentBuff buff = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            buff = nextAttachmentCursor(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_sqlSelectAttachmentDistinctClassCode = null;
        S_sqlSelectAttachmentBuff = 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 (stmtDeleteByTenantIdx != null) {
            try {
                stmtDeleteByTenantIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByTenantIdx = null;
        }
        if (stmtDeleteByContactIdx != null) {
            try {
                stmtDeleteByContactIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByContactIdx = null;
        }
        if (stmtDeleteByUDescrIdx != null) {
            try {
                stmtDeleteByUDescrIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByUDescrIdx = null;
        }
        if (stmtDeleteByMimeTypeIdx != null) {
            try {
                stmtDeleteByMimeTypeIdx.close();
            } catch (SQLException e) {
            }
            stmtDeleteByMimeTypeIdx = null;
        }
        if (stmtReadAllBuff != null) {
            try {
                stmtReadAllBuff.close();
            } catch (SQLException e) {
            }
            stmtReadAllBuff = null;
        }
        if (stmtReadBuffByIdIdx != null) {
            try {
                stmtReadBuffByIdIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByIdIdx = null;
        }
        if (stmtReadBuffByTenantIdx != null) {
            try {
                stmtReadBuffByTenantIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByTenantIdx = null;
        }
        if (stmtReadBuffByContactIdx != null) {
            try {
                stmtReadBuffByContactIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByContactIdx = null;
        }
        if (stmtReadBuffByUDescrIdx != null) {
            try {
                stmtReadBuffByUDescrIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByUDescrIdx = null;
        }
        if (stmtReadBuffByMimeTypeIdx != null) {
            try {
                stmtReadBuffByMimeTypeIdx.close();
            } catch (SQLException e) {
            }
            stmtReadBuffByMimeTypeIdx = null;
        }
    }
}