net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlSchema.java Source code

Java tutorial

Introduction

Here is the source code for net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlSchema.java

Source

// Description: Java 7 PostgreSQL Jdbc DbIO implementation for CFAcc.

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

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

public class CFAccPgSqlSchema extends CFAccSchema {
    protected Connection cnx;
    protected boolean inTransaction;
    protected PreparedStatement stmtSelectIsSystemUser = null;
    protected PreparedStatement stmtSelectIsClusterUser = null;
    protected PreparedStatement stmtSelectIsTenantUser = null;
    protected PreparedStatement stmtSelectNextServiceTypeIdGen = null;
    protected PreparedStatement stmtSelectNextMimeTypeIdGen = null;
    protected PreparedStatement stmtSelectNextClusterIdGen = null;
    protected PreparedStatement stmtSelectNextTenantIdGen = null;
    protected PreparedStatement stmtSelectNextAccountIdGen = null;

    public CFAccPgSqlSchema() {
        super();
        cnx = null;
        inTransaction = false;
        tableAccount = new CFAccPgSqlAccountTable(this);
        tableAccountConfig = new CFAccPgSqlAccountConfigTable(this);
        tableAccountContact = new CFAccPgSqlAccountContactTable(this);
        tableAccountEntry = new CFAccPgSqlAccountEntryTable(this);
        tableAddress = new CFAccPgSqlAddressTable(this);
        tableAddressTag = new CFAccPgSqlAddressTagTable(this);
        tableAttachment = new CFAccPgSqlAttachmentTable(this);
        tableAttachmentTag = new CFAccPgSqlAttachmentTagTable(this);
        tableAuditAction = new CFAccPgSqlAuditActionTable(this);
        tableCluster = new CFAccPgSqlClusterTable(this);
        tableContact = new CFAccPgSqlContactTable(this);
        tableContactList = new CFAccPgSqlContactListTable(this);
        tableContactTag = new CFAccPgSqlContactTagTable(this);
        tableContactURL = new CFAccPgSqlContactURLTable(this);
        tableDomain = new CFAccPgSqlDomainTable(this);
        tableDomainBase = new CFAccPgSqlDomainBaseTable(this);
        tableHostNode = new CFAccPgSqlHostNodeTable(this);
        tableISOCountry = new CFAccPgSqlISOCountryTable(this);
        tableISOCountryCurrency = new CFAccPgSqlISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFAccPgSqlISOCountryLanguageTable(this);
        tableISOCurrency = new CFAccPgSqlISOCurrencyTable(this);
        tableISOLanguage = new CFAccPgSqlISOLanguageTable(this);
        tableISOTimezone = new CFAccPgSqlISOTimezoneTable(this);
        tableMajorVersion = new CFAccPgSqlMajorVersionTable(this);
        tableMemo = new CFAccPgSqlMemoTable(this);
        tableMemoTag = new CFAccPgSqlMemoTagTable(this);
        tableMimeType = new CFAccPgSqlMimeTypeTable(this);
        tableMinorVersion = new CFAccPgSqlMinorVersionTable(this);
        tablePhone = new CFAccPgSqlPhoneTable(this);
        tablePhoneTag = new CFAccPgSqlPhoneTagTable(this);
        tableProjectBase = new CFAccPgSqlProjectBaseTable(this);
        tableRealProject = new CFAccPgSqlRealProjectTable(this);
        tableSecApp = new CFAccPgSqlSecAppTable(this);
        tableSecForm = new CFAccPgSqlSecFormTable(this);
        tableSecGroup = new CFAccPgSqlSecGroupTable(this);
        tableSecGroupForm = new CFAccPgSqlSecGroupFormTable(this);
        tableSecGroupInclude = new CFAccPgSqlSecGroupIncludeTable(this);
        tableSecGroupMember = new CFAccPgSqlSecGroupMemberTable(this);
        tableSecSession = new CFAccPgSqlSecSessionTable(this);
        tableSecUser = new CFAccPgSqlSecUserTable(this);
        tableService = new CFAccPgSqlServiceTable(this);
        tableServiceType = new CFAccPgSqlServiceTypeTable(this);
        tableSubProject = new CFAccPgSqlSubProjectTable(this);
        tableTSecGroup = new CFAccPgSqlTSecGroupTable(this);
        tableTSecGroupInclude = new CFAccPgSqlTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFAccPgSqlTSecGroupMemberTable(this);
        tableTag = new CFAccPgSqlTagTable(this);
        tableTenant = new CFAccPgSqlTenantTable(this);
        tableTld = new CFAccPgSqlTldTable(this);
        tableTopDomain = new CFAccPgSqlTopDomainTable(this);
        tableTopProject = new CFAccPgSqlTopProjectTable(this);
        tableURLProtocol = new CFAccPgSqlURLProtocolTable(this);
        tableVersion = new CFAccPgSqlVersionTable(this);
    }

    public CFAccPgSqlSchema(CFAccConfigurationFile conf) {
        super(conf);
        cnx = null;
        inTransaction = false;
        tableAccount = new CFAccPgSqlAccountTable(this);
        tableAccountConfig = new CFAccPgSqlAccountConfigTable(this);
        tableAccountContact = new CFAccPgSqlAccountContactTable(this);
        tableAccountEntry = new CFAccPgSqlAccountEntryTable(this);
        tableAddress = new CFAccPgSqlAddressTable(this);
        tableAddressTag = new CFAccPgSqlAddressTagTable(this);
        tableAttachment = new CFAccPgSqlAttachmentTable(this);
        tableAttachmentTag = new CFAccPgSqlAttachmentTagTable(this);
        tableAuditAction = new CFAccPgSqlAuditActionTable(this);
        tableCluster = new CFAccPgSqlClusterTable(this);
        tableContact = new CFAccPgSqlContactTable(this);
        tableContactList = new CFAccPgSqlContactListTable(this);
        tableContactTag = new CFAccPgSqlContactTagTable(this);
        tableContactURL = new CFAccPgSqlContactURLTable(this);
        tableDomain = new CFAccPgSqlDomainTable(this);
        tableDomainBase = new CFAccPgSqlDomainBaseTable(this);
        tableHostNode = new CFAccPgSqlHostNodeTable(this);
        tableISOCountry = new CFAccPgSqlISOCountryTable(this);
        tableISOCountryCurrency = new CFAccPgSqlISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFAccPgSqlISOCountryLanguageTable(this);
        tableISOCurrency = new CFAccPgSqlISOCurrencyTable(this);
        tableISOLanguage = new CFAccPgSqlISOLanguageTable(this);
        tableISOTimezone = new CFAccPgSqlISOTimezoneTable(this);
        tableMajorVersion = new CFAccPgSqlMajorVersionTable(this);
        tableMemo = new CFAccPgSqlMemoTable(this);
        tableMemoTag = new CFAccPgSqlMemoTagTable(this);
        tableMimeType = new CFAccPgSqlMimeTypeTable(this);
        tableMinorVersion = new CFAccPgSqlMinorVersionTable(this);
        tablePhone = new CFAccPgSqlPhoneTable(this);
        tablePhoneTag = new CFAccPgSqlPhoneTagTable(this);
        tableProjectBase = new CFAccPgSqlProjectBaseTable(this);
        tableRealProject = new CFAccPgSqlRealProjectTable(this);
        tableSecApp = new CFAccPgSqlSecAppTable(this);
        tableSecForm = new CFAccPgSqlSecFormTable(this);
        tableSecGroup = new CFAccPgSqlSecGroupTable(this);
        tableSecGroupForm = new CFAccPgSqlSecGroupFormTable(this);
        tableSecGroupInclude = new CFAccPgSqlSecGroupIncludeTable(this);
        tableSecGroupMember = new CFAccPgSqlSecGroupMemberTable(this);
        tableSecSession = new CFAccPgSqlSecSessionTable(this);
        tableSecUser = new CFAccPgSqlSecUserTable(this);
        tableService = new CFAccPgSqlServiceTable(this);
        tableServiceType = new CFAccPgSqlServiceTypeTable(this);
        tableSubProject = new CFAccPgSqlSubProjectTable(this);
        tableTSecGroup = new CFAccPgSqlTSecGroupTable(this);
        tableTSecGroupInclude = new CFAccPgSqlTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFAccPgSqlTSecGroupMemberTable(this);
        tableTag = new CFAccPgSqlTagTable(this);
        tableTenant = new CFAccPgSqlTenantTable(this);
        tableTld = new CFAccPgSqlTldTable(this);
        tableTopDomain = new CFAccPgSqlTopDomainTable(this);
        tableTopProject = new CFAccPgSqlTopProjectTable(this);
        tableURLProtocol = new CFAccPgSqlURLProtocolTable(this);
        tableVersion = new CFAccPgSqlVersionTable(this);
        setSchemaDbName(conf.getDbDatabase());
    }

    public CFAccPgSqlSchema(String argJndiName) {
        super(argJndiName);
        cnx = null;
        inTransaction = false;
        tableAccount = new CFAccPgSqlAccountTable(this);
        tableAccountConfig = new CFAccPgSqlAccountConfigTable(this);
        tableAccountContact = new CFAccPgSqlAccountContactTable(this);
        tableAccountEntry = new CFAccPgSqlAccountEntryTable(this);
        tableAddress = new CFAccPgSqlAddressTable(this);
        tableAddressTag = new CFAccPgSqlAddressTagTable(this);
        tableAttachment = new CFAccPgSqlAttachmentTable(this);
        tableAttachmentTag = new CFAccPgSqlAttachmentTagTable(this);
        tableAuditAction = new CFAccPgSqlAuditActionTable(this);
        tableCluster = new CFAccPgSqlClusterTable(this);
        tableContact = new CFAccPgSqlContactTable(this);
        tableContactList = new CFAccPgSqlContactListTable(this);
        tableContactTag = new CFAccPgSqlContactTagTable(this);
        tableContactURL = new CFAccPgSqlContactURLTable(this);
        tableDomain = new CFAccPgSqlDomainTable(this);
        tableDomainBase = new CFAccPgSqlDomainBaseTable(this);
        tableHostNode = new CFAccPgSqlHostNodeTable(this);
        tableISOCountry = new CFAccPgSqlISOCountryTable(this);
        tableISOCountryCurrency = new CFAccPgSqlISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFAccPgSqlISOCountryLanguageTable(this);
        tableISOCurrency = new CFAccPgSqlISOCurrencyTable(this);
        tableISOLanguage = new CFAccPgSqlISOLanguageTable(this);
        tableISOTimezone = new CFAccPgSqlISOTimezoneTable(this);
        tableMajorVersion = new CFAccPgSqlMajorVersionTable(this);
        tableMemo = new CFAccPgSqlMemoTable(this);
        tableMemoTag = new CFAccPgSqlMemoTagTable(this);
        tableMimeType = new CFAccPgSqlMimeTypeTable(this);
        tableMinorVersion = new CFAccPgSqlMinorVersionTable(this);
        tablePhone = new CFAccPgSqlPhoneTable(this);
        tablePhoneTag = new CFAccPgSqlPhoneTagTable(this);
        tableProjectBase = new CFAccPgSqlProjectBaseTable(this);
        tableRealProject = new CFAccPgSqlRealProjectTable(this);
        tableSecApp = new CFAccPgSqlSecAppTable(this);
        tableSecForm = new CFAccPgSqlSecFormTable(this);
        tableSecGroup = new CFAccPgSqlSecGroupTable(this);
        tableSecGroupForm = new CFAccPgSqlSecGroupFormTable(this);
        tableSecGroupInclude = new CFAccPgSqlSecGroupIncludeTable(this);
        tableSecGroupMember = new CFAccPgSqlSecGroupMemberTable(this);
        tableSecSession = new CFAccPgSqlSecSessionTable(this);
        tableSecUser = new CFAccPgSqlSecUserTable(this);
        tableService = new CFAccPgSqlServiceTable(this);
        tableServiceType = new CFAccPgSqlServiceTypeTable(this);
        tableSubProject = new CFAccPgSqlSubProjectTable(this);
        tableTSecGroup = new CFAccPgSqlTSecGroupTable(this);
        tableTSecGroupInclude = new CFAccPgSqlTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFAccPgSqlTSecGroupMemberTable(this);
        tableTag = new CFAccPgSqlTagTable(this);
        tableTenant = new CFAccPgSqlTenantTable(this);
        tableTld = new CFAccPgSqlTldTable(this);
        tableTopDomain = new CFAccPgSqlTopDomainTable(this);
        tableTopProject = new CFAccPgSqlTopProjectTable(this);
        tableURLProtocol = new CFAccPgSqlURLProtocolTable(this);
        tableVersion = new CFAccPgSqlVersionTable(this);
    }

    public CFAccPgSqlSchema(Connection argCnx) {
        super();
        cnx = argCnx;
        inTransaction = false;
        tableAccount = new CFAccPgSqlAccountTable(this);
        tableAccountConfig = new CFAccPgSqlAccountConfigTable(this);
        tableAccountContact = new CFAccPgSqlAccountContactTable(this);
        tableAccountEntry = new CFAccPgSqlAccountEntryTable(this);
        tableAddress = new CFAccPgSqlAddressTable(this);
        tableAddressTag = new CFAccPgSqlAddressTagTable(this);
        tableAttachment = new CFAccPgSqlAttachmentTable(this);
        tableAttachmentTag = new CFAccPgSqlAttachmentTagTable(this);
        tableAuditAction = new CFAccPgSqlAuditActionTable(this);
        tableCluster = new CFAccPgSqlClusterTable(this);
        tableContact = new CFAccPgSqlContactTable(this);
        tableContactList = new CFAccPgSqlContactListTable(this);
        tableContactTag = new CFAccPgSqlContactTagTable(this);
        tableContactURL = new CFAccPgSqlContactURLTable(this);
        tableDomain = new CFAccPgSqlDomainTable(this);
        tableDomainBase = new CFAccPgSqlDomainBaseTable(this);
        tableHostNode = new CFAccPgSqlHostNodeTable(this);
        tableISOCountry = new CFAccPgSqlISOCountryTable(this);
        tableISOCountryCurrency = new CFAccPgSqlISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFAccPgSqlISOCountryLanguageTable(this);
        tableISOCurrency = new CFAccPgSqlISOCurrencyTable(this);
        tableISOLanguage = new CFAccPgSqlISOLanguageTable(this);
        tableISOTimezone = new CFAccPgSqlISOTimezoneTable(this);
        tableMajorVersion = new CFAccPgSqlMajorVersionTable(this);
        tableMemo = new CFAccPgSqlMemoTable(this);
        tableMemoTag = new CFAccPgSqlMemoTagTable(this);
        tableMimeType = new CFAccPgSqlMimeTypeTable(this);
        tableMinorVersion = new CFAccPgSqlMinorVersionTable(this);
        tablePhone = new CFAccPgSqlPhoneTable(this);
        tablePhoneTag = new CFAccPgSqlPhoneTagTable(this);
        tableProjectBase = new CFAccPgSqlProjectBaseTable(this);
        tableRealProject = new CFAccPgSqlRealProjectTable(this);
        tableSecApp = new CFAccPgSqlSecAppTable(this);
        tableSecForm = new CFAccPgSqlSecFormTable(this);
        tableSecGroup = new CFAccPgSqlSecGroupTable(this);
        tableSecGroupForm = new CFAccPgSqlSecGroupFormTable(this);
        tableSecGroupInclude = new CFAccPgSqlSecGroupIncludeTable(this);
        tableSecGroupMember = new CFAccPgSqlSecGroupMemberTable(this);
        tableSecSession = new CFAccPgSqlSecSessionTable(this);
        tableSecUser = new CFAccPgSqlSecUserTable(this);
        tableService = new CFAccPgSqlServiceTable(this);
        tableServiceType = new CFAccPgSqlServiceTypeTable(this);
        tableSubProject = new CFAccPgSqlSubProjectTable(this);
        tableTSecGroup = new CFAccPgSqlTSecGroupTable(this);
        tableTSecGroupInclude = new CFAccPgSqlTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFAccPgSqlTSecGroupMemberTable(this);
        tableTag = new CFAccPgSqlTagTable(this);
        tableTenant = new CFAccPgSqlTenantTable(this);
        tableTld = new CFAccPgSqlTldTable(this);
        tableTopDomain = new CFAccPgSqlTopDomainTable(this);
        tableTopProject = new CFAccPgSqlTopProjectTable(this);
        tableURLProtocol = new CFAccPgSqlURLProtocolTable(this);
        tableVersion = new CFAccPgSqlVersionTable(this);
        try {
            cnx.setAutoCommit(false);
            cnx.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
            cnx.rollback();
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "CFAccPgSqlSchema-constructor", e);
        }
    }

    public Connection getCnx() {
        return (cnx);
    }

    public boolean isConnected() {
        final String S_ProcName = "isConnected";
        boolean retval;
        if (cnx == null) {
            retval = false;
        } else {
            try {
                if (cnx.isClosed()) {
                    retval = false;
                    cnx = null;
                    releasePreparedStatements();
                } else {
                    retval = true;
                }
            } catch (SQLException e) {
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            }
        }
        return (retval);
    }

    public boolean connect() {
        final String S_ProcName = "connect";
        if (cnx != null) {
            return (false);
        }

        if (configuration != null) {
            String dbServer = configuration.getDbServer();
            int dbPort = configuration.getDbPort();
            String dbDatabase = configuration.getDbDatabase();
            String dbUserName = configuration.getDbUserName();
            String dbPassword = configuration.getDbPassword();
            String url = "jdbc:postgresql://" + dbServer + ":" + Integer.toString(dbPort) + "/" + dbDatabase;
            Properties props = new Properties();
            props.setProperty("user", dbUserName);
            props.setProperty("password", dbPassword);
            try {
                cnx = DriverManager.getConnection(url, props);
                cnx.setAutoCommit(false);
                cnx.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
                cnx.rollback();
                setSchemaDbName(dbDatabase);
            } catch (SQLException e) {
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            }
            return (true);
        }
        if (jndiName != null) {
            try {
                Context ctx = new InitialContext();
                DataSource ds = (DataSource) ctx.lookup(jndiName);
                if (ds == null) {
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Could not get resolve DataSource \"" + jndiName + "\"");
                }
                cnx = ds.getConnection();
                if (cnx == null) {
                    throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                            "Could not get Connection from DataSource \"" + jndiName + "\"");
                }
                cnx.setAutoCommit(false);
                cnx.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
                cnx.rollback();
            } catch (NamingException e) {
                cnx = null;
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName,
                        "NamingException " + e.getMessage(), e);
            } catch (SQLException e) {
                cnx = null;
                inTransaction = false;
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            }
            return (true);
        }
        throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                "Neither configurationFile nor jndiName found, do not know how to connect to database");
    }

    public boolean connect(String username, String password) {
        final String S_ProcName = "connect";
        if (cnx != null) {
            return (false);
        }
        if ((username == null) || (username.length() <= 0)) {
            throw CFLib.getDefaultExceptionFactory().newNullArgumentException(getClass(), S_ProcName, 1,
                    "username");
        }
        if (password == null) {
            throw CFLib.getDefaultExceptionFactory().newNullArgumentException(getClass(), S_ProcName, 1,
                    "password");
        }

        if (configuration != null) {
            String dbServer = configuration.getDbServer();
            int dbPort = configuration.getDbPort();
            String dbDatabase = configuration.getDbDatabase();
            String dbUserName = username;
            String dbPassword = password;
            String url = "jdbc:postgresql://" + dbServer + ":" + Integer.toString(dbPort) + "/" + dbDatabase;
            Properties props = new Properties();
            props.setProperty("user", dbUserName);
            props.setProperty("password", dbPassword);
            try {
                cnx = DriverManager.getConnection(url, props);
                cnx.setAutoCommit(false);
                cnx.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
                cnx.rollback();
                setSchemaDbName(dbDatabase);
            } catch (SQLException e) {
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            }
            return (true);
        }
        throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), S_ProcName,
                "configurationFile not found, do not know how to connect to database");
    }

    public boolean connect(String clustername, String tenantname, String secUserName, String dbUserName,
            String dbPassword) {
        boolean retval = connect(dbUserName, dbPassword);
        return (retval);
    }

    public void disconnect(boolean doCommit) {
        final String S_ProcName = "disconnect";
        if (cnx != null) {
            try {
                if (!cnx.isClosed()) {
                    if (doCommit) {
                        cnx.commit();
                    } else {
                        cnx.rollback();
                    }
                    cnx.close();
                }
            } catch (SQLException e) {
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            } finally {
                cnx = null;
            }
        }
        releasePreparedStatements();
    }

    public boolean isTransactionOpen() {
        return (inTransaction);
    }

    public boolean beginTransaction() {
        if (inTransaction) {
            return (false);
        }
        try {
            String sql = "begin transaction";
            Statement stmt = cnx.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            stmt.execute(sql);
            inTransaction = true;
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "beginTransaction", e);
        }
        return (inTransaction);
    }

    public void commit() {
        try {
            cnx.commit();
            inTransaction = false;
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "commit", e);
        }
    }

    public void rollback() {
        try {
            cnx.rollback();
            inTransaction = false;
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "rollback", e);
        }
    }

    public boolean isSystemUser(CFAccAuthorization Authorization) {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "isSystemUser",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_is_system_user( ? ) as IsSystemUser";
            if (stmtSelectIsSystemUser == null) {
                stmtSelectIsSystemUser = cnx.prepareStatement(sql);
            }
            stmtSelectIsSystemUser.setString(1, Authorization.getSecUserId().toString());
            resultSet = stmtSelectIsSystemUser.executeQuery();
            boolean resultFlag;
            if (resultSet.next()) {
                resultFlag = resultSet.getBoolean(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "isSystemUser",
                        "Query of sp_is_system_user() did not return a result row");
            }
            resultSet.close();
            return (resultFlag);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "isSystemUser", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public boolean isClusterUser(CFAccAuthorization Authorization, long clusterId, String groupName) {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "isClusterUser",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_is_cluster_user( ?, ?, ? ) as IsClusterUser";
            if (stmtSelectIsClusterUser == null) {
                stmtSelectIsClusterUser = cnx.prepareStatement(sql);
            }
            stmtSelectIsClusterUser.setLong(1, clusterId);
            stmtSelectIsClusterUser.setString(2, groupName);
            stmtSelectIsClusterUser.setString(3, Authorization.getSecUserId().toString());
            resultSet = stmtSelectIsClusterUser.executeQuery();
            boolean resultFlag;
            if (resultSet.next()) {
                resultFlag = resultSet.getBoolean(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "isClusterUser",
                        "Query of sp_is_cluster_user() did not return a result row");
            }
            resultSet.close();
            return (resultFlag);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "isClusterUser", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public boolean isTenantUser(CFAccAuthorization Authorization, long tenantId, String groupName) {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "isTenantUser",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_is_tenant_user( ?, ?, ? ) as IsTenantUser";
            if (stmtSelectIsTenantUser == null) {
                stmtSelectIsTenantUser = cnx.prepareStatement(sql);
            }
            stmtSelectIsTenantUser.setLong(1, tenantId);
            stmtSelectIsTenantUser.setString(2, groupName);
            stmtSelectIsTenantUser.setString(3, Authorization.getSecUserId().toString());
            resultSet = stmtSelectIsTenantUser.executeQuery();
            boolean resultFlag;
            if (resultSet.next()) {
                resultFlag = resultSet.getBoolean(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "isTenantUser",
                        "Query of sp_is_tenant_user() did not return a result row");
            }
            resultSet.close();
            return (resultFlag);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "isTenantUser", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public int nextServiceTypeIdGen() {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "nextServiceTypeIdGen",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_next_servicetypeidgen() as NextServiceTypeIdGen";
            if (stmtSelectNextServiceTypeIdGen == null) {
                stmtSelectNextServiceTypeIdGen = cnx.prepareStatement(sql);
            }
            resultSet = stmtSelectNextServiceTypeIdGen.executeQuery();
            int nextId;
            if (resultSet.next()) {
                nextId = resultSet.getInt(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "nextServiceTypeIdGen",
                        "Query of sp_next_servicetypeidgen() did not return a result row");
            }
            resultSet.close();
            return (nextId);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "nextServiceTypeIdGen", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public int nextMimeTypeIdGen() {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "nextMimeTypeIdGen",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_next_mimetypeidgen() as NextMimeTypeIdGen";
            if (stmtSelectNextMimeTypeIdGen == null) {
                stmtSelectNextMimeTypeIdGen = cnx.prepareStatement(sql);
            }
            resultSet = stmtSelectNextMimeTypeIdGen.executeQuery();
            int nextId;
            if (resultSet.next()) {
                nextId = resultSet.getInt(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "nextMimeTypeIdGen",
                        "Query of sp_next_mimetypeidgen() did not return a result row");
            }
            resultSet.close();
            return (nextId);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "nextMimeTypeIdGen", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public long nextClusterIdGen() {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "nextClusterIdGen",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_next_clusteridgen() as NextClusterIdGen";
            if (stmtSelectNextClusterIdGen == null) {
                stmtSelectNextClusterIdGen = cnx.prepareStatement(sql);
            }
            resultSet = stmtSelectNextClusterIdGen.executeQuery();
            long nextId;
            if (resultSet.next()) {
                nextId = resultSet.getLong(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "nextClusterIdGen",
                        "Query of sp_next_clusteridgen() did not return a result row");
            }
            resultSet.close();
            return (nextId);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "nextClusterIdGen", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public long nextTenantIdGen() {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "nextTenantIdGen",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_next_tenantidgen() as NextTenantIdGen";
            if (stmtSelectNextTenantIdGen == null) {
                stmtSelectNextTenantIdGen = cnx.prepareStatement(sql);
            }
            resultSet = stmtSelectNextTenantIdGen.executeQuery();
            long nextId;
            if (resultSet.next()) {
                nextId = resultSet.getLong(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "nextTenantIdGen",
                        "Query of sp_next_tenantidgen() did not return a result row");
            }
            resultSet.close();
            return (nextId);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "nextTenantIdGen", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public long nextAccountIdGen() {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "nextAccountIdGen",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            String sql = "SELECT " + lowerSchemaDbName + ".sp_next_accountidgen() as NextAccountIdGen";
            if (stmtSelectNextAccountIdGen == null) {
                stmtSelectNextAccountIdGen = cnx.prepareStatement(sql);
            }
            resultSet = stmtSelectNextAccountIdGen.executeQuery();
            long nextId;
            if (resultSet.next()) {
                nextId = resultSet.getLong(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "nextAccountIdGen",
                        "Query of sp_next_accountidgen() did not return a result row");
            }
            resultSet.close();
            return (nextId);
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "nextAccountIdGen", e);
        } finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (SQLException e) {
                }
                resultSet = null;
            }
        }
    }

    public UUID nextSecSessionIdGen() {
        UUID retval = UUID.randomUUID();
        return (retval);
    }

    public UUID nextSecUserIdGen() {
        UUID retval = UUID.randomUUID();
        return (retval);
    }

    public UUID nextAccountEntryIdGen() {
        UUID retval = UUID.randomUUID();
        return (retval);
    }

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

        if (stmtSelectIsSystemUser != null) {
            try {
                stmtSelectIsSystemUser.close();
            } catch (SQLException e) {
            }
            stmtSelectIsSystemUser = null;
        }
        if (stmtSelectIsClusterUser != null) {
            try {
                stmtSelectIsClusterUser.close();
            } catch (SQLException e) {
            }
            stmtSelectIsClusterUser = null;
        }
        if (stmtSelectIsTenantUser != null) {
            try {
                stmtSelectIsTenantUser.close();
            } catch (SQLException e) {
            }
            stmtSelectIsTenantUser = null;
        }
        if (stmtSelectNextServiceTypeIdGen != null) {
            try {
                stmtSelectNextServiceTypeIdGen.close();
            } catch (SQLException e) {
            }
            stmtSelectNextServiceTypeIdGen = null;
        }
        if (stmtSelectNextMimeTypeIdGen != null) {
            try {
                stmtSelectNextMimeTypeIdGen.close();
            } catch (SQLException e) {
            }
            stmtSelectNextMimeTypeIdGen = null;
        }
        if (stmtSelectNextClusterIdGen != null) {
            try {
                stmtSelectNextClusterIdGen.close();
            } catch (SQLException e) {
            }
            stmtSelectNextClusterIdGen = null;
        }
        if (stmtSelectNextTenantIdGen != null) {
            try {
                stmtSelectNextTenantIdGen.close();
            } catch (SQLException e) {
            }
            stmtSelectNextTenantIdGen = null;
        }
        if (stmtSelectNextAccountIdGen != null) {
            try {
                stmtSelectNextAccountIdGen.close();
            } catch (SQLException e) {
            }
            stmtSelectNextAccountIdGen = null;
        }

        if ((tableAccount != null) && (tableAccount instanceof CFAccPgSqlAccountTable)) {
            CFAccPgSqlAccountTable table = (CFAccPgSqlAccountTable) tableAccount;
            table.releasePreparedStatements();
        }
        if ((tableAccountConfig != null) && (tableAccountConfig instanceof CFAccPgSqlAccountConfigTable)) {
            CFAccPgSqlAccountConfigTable table = (CFAccPgSqlAccountConfigTable) tableAccountConfig;
            table.releasePreparedStatements();
        }
        if ((tableAccountContact != null) && (tableAccountContact instanceof CFAccPgSqlAccountContactTable)) {
            CFAccPgSqlAccountContactTable table = (CFAccPgSqlAccountContactTable) tableAccountContact;
            table.releasePreparedStatements();
        }
        if ((tableAccountEntry != null) && (tableAccountEntry instanceof CFAccPgSqlAccountEntryTable)) {
            CFAccPgSqlAccountEntryTable table = (CFAccPgSqlAccountEntryTable) tableAccountEntry;
            table.releasePreparedStatements();
        }
        if ((tableAddress != null) && (tableAddress instanceof CFAccPgSqlAddressTable)) {
            CFAccPgSqlAddressTable table = (CFAccPgSqlAddressTable) tableAddress;
            table.releasePreparedStatements();
        }
        if ((tableAddressTag != null) && (tableAddressTag instanceof CFAccPgSqlAddressTagTable)) {
            CFAccPgSqlAddressTagTable table = (CFAccPgSqlAddressTagTable) tableAddressTag;
            table.releasePreparedStatements();
        }
        if ((tableAttachment != null) && (tableAttachment instanceof CFAccPgSqlAttachmentTable)) {
            CFAccPgSqlAttachmentTable table = (CFAccPgSqlAttachmentTable) tableAttachment;
            table.releasePreparedStatements();
        }
        if ((tableAttachmentTag != null) && (tableAttachmentTag instanceof CFAccPgSqlAttachmentTagTable)) {
            CFAccPgSqlAttachmentTagTable table = (CFAccPgSqlAttachmentTagTable) tableAttachmentTag;
            table.releasePreparedStatements();
        }
        if ((tableAuditAction != null) && (tableAuditAction instanceof CFAccPgSqlAuditActionTable)) {
            CFAccPgSqlAuditActionTable table = (CFAccPgSqlAuditActionTable) tableAuditAction;
            table.releasePreparedStatements();
        }
        if ((tableCluster != null) && (tableCluster instanceof CFAccPgSqlClusterTable)) {
            CFAccPgSqlClusterTable table = (CFAccPgSqlClusterTable) tableCluster;
            table.releasePreparedStatements();
        }
        if ((tableContact != null) && (tableContact instanceof CFAccPgSqlContactTable)) {
            CFAccPgSqlContactTable table = (CFAccPgSqlContactTable) tableContact;
            table.releasePreparedStatements();
        }
        if ((tableContactList != null) && (tableContactList instanceof CFAccPgSqlContactListTable)) {
            CFAccPgSqlContactListTable table = (CFAccPgSqlContactListTable) tableContactList;
            table.releasePreparedStatements();
        }
        if ((tableContactTag != null) && (tableContactTag instanceof CFAccPgSqlContactTagTable)) {
            CFAccPgSqlContactTagTable table = (CFAccPgSqlContactTagTable) tableContactTag;
            table.releasePreparedStatements();
        }
        if ((tableContactURL != null) && (tableContactURL instanceof CFAccPgSqlContactURLTable)) {
            CFAccPgSqlContactURLTable table = (CFAccPgSqlContactURLTable) tableContactURL;
            table.releasePreparedStatements();
        }
        if ((tableDomain != null) && (tableDomain instanceof CFAccPgSqlDomainTable)) {
            CFAccPgSqlDomainTable table = (CFAccPgSqlDomainTable) tableDomain;
            table.releasePreparedStatements();
        }
        if ((tableDomainBase != null) && (tableDomainBase instanceof CFAccPgSqlDomainBaseTable)) {
            CFAccPgSqlDomainBaseTable table = (CFAccPgSqlDomainBaseTable) tableDomainBase;
            table.releasePreparedStatements();
        }
        if ((tableHostNode != null) && (tableHostNode instanceof CFAccPgSqlHostNodeTable)) {
            CFAccPgSqlHostNodeTable table = (CFAccPgSqlHostNodeTable) tableHostNode;
            table.releasePreparedStatements();
        }
        if ((tableISOCountry != null) && (tableISOCountry instanceof CFAccPgSqlISOCountryTable)) {
            CFAccPgSqlISOCountryTable table = (CFAccPgSqlISOCountryTable) tableISOCountry;
            table.releasePreparedStatements();
        }
        if ((tableISOCountryCurrency != null)
                && (tableISOCountryCurrency instanceof CFAccPgSqlISOCountryCurrencyTable)) {
            CFAccPgSqlISOCountryCurrencyTable table = (CFAccPgSqlISOCountryCurrencyTable) tableISOCountryCurrency;
            table.releasePreparedStatements();
        }
        if ((tableISOCountryLanguage != null)
                && (tableISOCountryLanguage instanceof CFAccPgSqlISOCountryLanguageTable)) {
            CFAccPgSqlISOCountryLanguageTable table = (CFAccPgSqlISOCountryLanguageTable) tableISOCountryLanguage;
            table.releasePreparedStatements();
        }
        if ((tableISOCurrency != null) && (tableISOCurrency instanceof CFAccPgSqlISOCurrencyTable)) {
            CFAccPgSqlISOCurrencyTable table = (CFAccPgSqlISOCurrencyTable) tableISOCurrency;
            table.releasePreparedStatements();
        }
        if ((tableISOLanguage != null) && (tableISOLanguage instanceof CFAccPgSqlISOLanguageTable)) {
            CFAccPgSqlISOLanguageTable table = (CFAccPgSqlISOLanguageTable) tableISOLanguage;
            table.releasePreparedStatements();
        }
        if ((tableISOTimezone != null) && (tableISOTimezone instanceof CFAccPgSqlISOTimezoneTable)) {
            CFAccPgSqlISOTimezoneTable table = (CFAccPgSqlISOTimezoneTable) tableISOTimezone;
            table.releasePreparedStatements();
        }
        if ((tableMajorVersion != null) && (tableMajorVersion instanceof CFAccPgSqlMajorVersionTable)) {
            CFAccPgSqlMajorVersionTable table = (CFAccPgSqlMajorVersionTable) tableMajorVersion;
            table.releasePreparedStatements();
        }
        if ((tableMemo != null) && (tableMemo instanceof CFAccPgSqlMemoTable)) {
            CFAccPgSqlMemoTable table = (CFAccPgSqlMemoTable) tableMemo;
            table.releasePreparedStatements();
        }
        if ((tableMemoTag != null) && (tableMemoTag instanceof CFAccPgSqlMemoTagTable)) {
            CFAccPgSqlMemoTagTable table = (CFAccPgSqlMemoTagTable) tableMemoTag;
            table.releasePreparedStatements();
        }
        if ((tableMimeType != null) && (tableMimeType instanceof CFAccPgSqlMimeTypeTable)) {
            CFAccPgSqlMimeTypeTable table = (CFAccPgSqlMimeTypeTable) tableMimeType;
            table.releasePreparedStatements();
        }
        if ((tableMinorVersion != null) && (tableMinorVersion instanceof CFAccPgSqlMinorVersionTable)) {
            CFAccPgSqlMinorVersionTable table = (CFAccPgSqlMinorVersionTable) tableMinorVersion;
            table.releasePreparedStatements();
        }
        if ((tablePhone != null) && (tablePhone instanceof CFAccPgSqlPhoneTable)) {
            CFAccPgSqlPhoneTable table = (CFAccPgSqlPhoneTable) tablePhone;
            table.releasePreparedStatements();
        }
        if ((tablePhoneTag != null) && (tablePhoneTag instanceof CFAccPgSqlPhoneTagTable)) {
            CFAccPgSqlPhoneTagTable table = (CFAccPgSqlPhoneTagTable) tablePhoneTag;
            table.releasePreparedStatements();
        }
        if ((tableProjectBase != null) && (tableProjectBase instanceof CFAccPgSqlProjectBaseTable)) {
            CFAccPgSqlProjectBaseTable table = (CFAccPgSqlProjectBaseTable) tableProjectBase;
            table.releasePreparedStatements();
        }
        if ((tableRealProject != null) && (tableRealProject instanceof CFAccPgSqlRealProjectTable)) {
            CFAccPgSqlRealProjectTable table = (CFAccPgSqlRealProjectTable) tableRealProject;
            table.releasePreparedStatements();
        }
        if ((tableSecApp != null) && (tableSecApp instanceof CFAccPgSqlSecAppTable)) {
            CFAccPgSqlSecAppTable table = (CFAccPgSqlSecAppTable) tableSecApp;
            table.releasePreparedStatements();
        }
        if ((tableSecForm != null) && (tableSecForm instanceof CFAccPgSqlSecFormTable)) {
            CFAccPgSqlSecFormTable table = (CFAccPgSqlSecFormTable) tableSecForm;
            table.releasePreparedStatements();
        }
        if ((tableSecGroup != null) && (tableSecGroup instanceof CFAccPgSqlSecGroupTable)) {
            CFAccPgSqlSecGroupTable table = (CFAccPgSqlSecGroupTable) tableSecGroup;
            table.releasePreparedStatements();
        }
        if ((tableSecGroupForm != null) && (tableSecGroupForm instanceof CFAccPgSqlSecGroupFormTable)) {
            CFAccPgSqlSecGroupFormTable table = (CFAccPgSqlSecGroupFormTable) tableSecGroupForm;
            table.releasePreparedStatements();
        }
        if ((tableSecGroupInclude != null) && (tableSecGroupInclude instanceof CFAccPgSqlSecGroupIncludeTable)) {
            CFAccPgSqlSecGroupIncludeTable table = (CFAccPgSqlSecGroupIncludeTable) tableSecGroupInclude;
            table.releasePreparedStatements();
        }
        if ((tableSecGroupMember != null) && (tableSecGroupMember instanceof CFAccPgSqlSecGroupMemberTable)) {
            CFAccPgSqlSecGroupMemberTable table = (CFAccPgSqlSecGroupMemberTable) tableSecGroupMember;
            table.releasePreparedStatements();
        }
        if ((tableSecSession != null) && (tableSecSession instanceof CFAccPgSqlSecSessionTable)) {
            CFAccPgSqlSecSessionTable table = (CFAccPgSqlSecSessionTable) tableSecSession;
            table.releasePreparedStatements();
        }
        if ((tableSecUser != null) && (tableSecUser instanceof CFAccPgSqlSecUserTable)) {
            CFAccPgSqlSecUserTable table = (CFAccPgSqlSecUserTable) tableSecUser;
            table.releasePreparedStatements();
        }
        if ((tableService != null) && (tableService instanceof CFAccPgSqlServiceTable)) {
            CFAccPgSqlServiceTable table = (CFAccPgSqlServiceTable) tableService;
            table.releasePreparedStatements();
        }
        if ((tableServiceType != null) && (tableServiceType instanceof CFAccPgSqlServiceTypeTable)) {
            CFAccPgSqlServiceTypeTable table = (CFAccPgSqlServiceTypeTable) tableServiceType;
            table.releasePreparedStatements();
        }
        if ((tableSubProject != null) && (tableSubProject instanceof CFAccPgSqlSubProjectTable)) {
            CFAccPgSqlSubProjectTable table = (CFAccPgSqlSubProjectTable) tableSubProject;
            table.releasePreparedStatements();
        }
        if ((tableTSecGroup != null) && (tableTSecGroup instanceof CFAccPgSqlTSecGroupTable)) {
            CFAccPgSqlTSecGroupTable table = (CFAccPgSqlTSecGroupTable) tableTSecGroup;
            table.releasePreparedStatements();
        }
        if ((tableTSecGroupInclude != null) && (tableTSecGroupInclude instanceof CFAccPgSqlTSecGroupIncludeTable)) {
            CFAccPgSqlTSecGroupIncludeTable table = (CFAccPgSqlTSecGroupIncludeTable) tableTSecGroupInclude;
            table.releasePreparedStatements();
        }
        if ((tableTSecGroupMember != null) && (tableTSecGroupMember instanceof CFAccPgSqlTSecGroupMemberTable)) {
            CFAccPgSqlTSecGroupMemberTable table = (CFAccPgSqlTSecGroupMemberTable) tableTSecGroupMember;
            table.releasePreparedStatements();
        }
        if ((tableTag != null) && (tableTag instanceof CFAccPgSqlTagTable)) {
            CFAccPgSqlTagTable table = (CFAccPgSqlTagTable) tableTag;
            table.releasePreparedStatements();
        }
        if ((tableTenant != null) && (tableTenant instanceof CFAccPgSqlTenantTable)) {
            CFAccPgSqlTenantTable table = (CFAccPgSqlTenantTable) tableTenant;
            table.releasePreparedStatements();
        }
        if ((tableTld != null) && (tableTld instanceof CFAccPgSqlTldTable)) {
            CFAccPgSqlTldTable table = (CFAccPgSqlTldTable) tableTld;
            table.releasePreparedStatements();
        }
        if ((tableTopDomain != null) && (tableTopDomain instanceof CFAccPgSqlTopDomainTable)) {
            CFAccPgSqlTopDomainTable table = (CFAccPgSqlTopDomainTable) tableTopDomain;
            table.releasePreparedStatements();
        }
        if ((tableTopProject != null) && (tableTopProject instanceof CFAccPgSqlTopProjectTable)) {
            CFAccPgSqlTopProjectTable table = (CFAccPgSqlTopProjectTable) tableTopProject;
            table.releasePreparedStatements();
        }
        if ((tableURLProtocol != null) && (tableURLProtocol instanceof CFAccPgSqlURLProtocolTable)) {
            CFAccPgSqlURLProtocolTable table = (CFAccPgSqlURLProtocolTable) tableURLProtocol;
            table.releasePreparedStatements();
        }
        if ((tableVersion != null) && (tableVersion instanceof CFAccPgSqlVersionTable)) {
            CFAccPgSqlVersionTable table = (CFAccPgSqlVersionTable) tableVersion;
            table.releasePreparedStatements();
        }
    }

    public static String getQuotedString(String val) {
        if (val == null) {
            return ("null");
        } else {
            char c;
            StringBuilder quoted = new StringBuilder();
            quoted.append("'");
            int len = val.length();
            for (int i = 0; i < len; i++) {
                if (val.charAt(i) == '\'') {
                    quoted.append("''");
                } else if (val.charAt(i) == '\\') {
                    quoted.append("'||E'\\\\'||'");
                } else {
                    c = val.charAt(i);
                    if ((c == '0') || (c == '1') || (c == '2') || (c == '3') || (c == '4') || (c == '5')
                            || (c == '6') || (c == '7') || (c == '8') || (c == '9') || (c == 'a') || (c == 'b')
                            || (c == 'c') || (c == 'd') || (c == 'e') || (c == 'f') || (c == 'g') || (c == 'h')
                            || (c == 'i') || (c == 'j') || (c == 'k') || (c == 'l') || (c == 'm') || (c == 'n')
                            || (c == 'o') || (c == 'p') || (c == 'q') || (c == 'r') || (c == 's') || (c == 't')
                            || (c == 'u') || (c == 'v') || (c == 'w') || (c == 'x') || (c == 'y') || (c == 'z')
                            || (c == 'A') || (c == 'B') || (c == 'C') || (c == 'D') || (c == 'E') || (c == 'F')
                            || (c == 'G') || (c == 'H') || (c == 'I') || (c == 'J') || (c == 'K') || (c == 'L')
                            || (c == 'M') || (c == 'N') || (c == 'O') || (c == 'P') || (c == 'Q') || (c == 'R')
                            || (c == 'S') || (c == 'T') || (c == 'U') || (c == 'V') || (c == 'W') || (c == 'X')
                            || (c == 'Y') || (c == 'Z') || (c == ' ') || (c == '\t') || (c == '\r') || (c == '\n')
                            || (c == '`') || (c == '~') || (c == '!') || (c == '@') || (c == '#') || (c == '$')
                            || (c == '%') || (c == '^') || (c == '&') || (c == '*') || (c == '(') || (c == ')')
                            || (c == '-') || (c == '_') || (c == '=') || (c == '+') || (c == '[') || (c == ']')
                            || (c == '{') || (c == '}') || (c == '|') || (c == ';') || (c == ':') || (c == '"')
                            || (c == '<') || (c == '>') || (c == ',') || (c == '.') || (c == '/') || (c == '?')) {
                        quoted.append(c);
                    } else {
                        //                  Syslog.warn("\t\t\tReplacing invalid character '" + c + "' with space");
                        quoted.append(' ');
                    }
                }
            }
            quoted.append("'");
            return (quoted.toString());
        }
    }

    public static String getNullableString(ResultSet reader, int colidx) {
        try {
            String val = reader.getString(colidx);
            if (reader.wasNull()) {
                return (null);
            } else {
                return (val);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(CFAccPgSqlSchema.class, "getNullableString", e);
        }
    }

    public static String getBlobString(byte[] val) {
        if (val == null) {
            return ("null");
        } else {
            return ("'" + Base64.encodeBase64(val).toString() + "'");
        }
    }

    public static String getBoolString(Boolean val) {
        if (val == null) {
            return ("null");
        } else {
            if (val) {
                return ("true");
            } else {
                return ("false");
            }
        }
    }

    public static String getBoolString(boolean val) {
        if (val) {
            return ("true");
        } else {
            return ("false");
        }
    }

    public static String getInt16String(Short val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getInt16String(short val) {
        return (Short.toString(val));
    }

    public static String getInt32String(Integer val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getInt32String(int val) {
        return (Integer.toString(val));
    }

    public static String getInt64String(Long val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getInt64String(long val) {
        return (Long.toString(val));
    }

    public static String getUInt16String(Integer val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getUInt16String(int val) {
        return (Integer.toString(val));
    }

    public static String getUInt32String(Long val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getUInt32String(long val) {
        return (Long.toString(val));
    }

    public static String getUInt64String(BigDecimal val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getFloatString(Float val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getFloatString(float val) {
        return (Float.toString(val));
    }

    public static String getDoubleString(Double val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static String getDoubleString(double val) {
        return (Double.toString(val));
    }

    public static String getNumberString(BigDecimal val) {
        if (val == null) {
            return ("null");
        } else {
            return (val.toString());
        }
    }

    public static Integer getNullableInt32(ResultSet reader, int colidx) {
        try {
            int val = reader.getInt(colidx);
            if (reader.wasNull()) {
                return (null);
            } else {
                return (new Integer(val));
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(CFAccPgSqlSchema.class, "getNullableInt32", e);
        }
    }

    public static Short getNullableInt16(ResultSet reader, int colidx) {
        try {
            short val = reader.getShort(colidx);
            if (reader.wasNull()) {
                return (null);
            } else {
                return (new Short(val));
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(CFAccPgSqlSchema.class, "getNullableInt64", e);
        }
    }

    public static Integer getNullableUInt16(ResultSet reader, int colidx) {
        try {
            int val = reader.getInt(colidx);
            if (reader.wasNull()) {
                return (null);
            } else {
                return (new Integer(val));
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(CFAccPgSqlSchema.class, "getNullableUInt16", e);
        }
    }

    public static Long getNullableUInt32(ResultSet reader, int colidx) {
        try {
            long val = reader.getLong(colidx);
            if (reader.wasNull()) {
                return (null);
            } else {
                return (new Long(val));
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(CFAccPgSqlSchema.class, "getNullableUInt32", e);
        }
    }

    public static BigDecimal getNullableUInt64(ResultSet reader, int colidx) {
        try {
            String strval = reader.getString(colidx);
            if (reader.wasNull() || (strval == null) || (strval.length() <= 0)) {
                return (null);
            } else {
                BigDecimal retval = new BigDecimal(strval);
                return (retval);
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(CFAccPgSqlSchema.class, "getNullableUInt64", e);
        }
    }

    public static Byte getNullableByte(ResultSet reader, int colidx) {
        try {
            byte val = reader.getByte(colidx);
            if (reader.wasNull()) {
                return (null);
            } else {
                return (new Byte(val));
            }
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(CFAccPgSqlSchema.class, "getNullableByte", e);
        }
    }

    public static String getQuotedDateString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            StringBuffer buff = new StringBuffer("'");
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", val.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", val.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", val.get(Calendar.DAY_OF_MONTH));
            buff.append("'");
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getQuotedTimeString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            StringBuffer buff = new StringBuffer("'");
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$02d", val.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", val.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", val.get(Calendar.SECOND));
            buff.append("'");
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getQuotedTimestampString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            StringBuffer buff = new StringBuffer("'");
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", val.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", val.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", val.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", val.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", val.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", val.get(Calendar.SECOND));
            buff.append("'");
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getQuotedTZDateString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            StringBuffer buff = new StringBuffer("'");
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            buff.append("'");
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getQuotedTZTimeString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            StringBuffer buff = new StringBuffer("'");
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            buff.append("'");
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getQuotedTZTimestampString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            StringBuffer buff = new StringBuffer("'");
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            buff.append("'");
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getDateString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            StringBuffer buff = new StringBuffer();
            Formatter fmt = new Formatter(buff);
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getTimeString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            StringBuffer buff = new StringBuffer();
            Formatter fmt = new Formatter(buff);
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getTimestampString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            StringBuffer buff = new StringBuffer();
            Formatter fmt = new Formatter(buff);
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getTZDateString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            StringBuffer buff = new StringBuffer();
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getTZTimeString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            StringBuffer buff = new StringBuffer();
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getTZTimestampString(Calendar val) {
        if (val == null) {
            return ("null");
        } else {
            Calendar db = CFLibDbUtil.getDbServerCalendar(val);
            StringBuffer buff = new StringBuffer();
            Formatter fmt = new Formatter(buff);
            fmt.format("%1$04d", db.get(Calendar.YEAR));
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.MONTH) + 1);
            buff.append("-");
            fmt.format("%1$02d", db.get(Calendar.DAY_OF_MONTH));
            buff.append(" ");
            fmt.format("%1$02d", db.get(Calendar.HOUR_OF_DAY));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.MINUTE));
            buff.append(":");
            fmt.format("%1$02d", db.get(Calendar.SECOND));
            fmt.close();
            return (buff.toString());
        }
    }

    public static String getUuidString(UUID val) {
        if (val == null) {
            return ("null");
        } else {
            return ("'" + val.toString() + "'");
        }
    }

    public static Calendar convertDateString(String val) {
        if ((val == null) || (val.length() == 0)) {
            return (null);
        } else if (val.length() != 10) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class, "convertDateString",
                    "Value must be in YYYY-MM-DD format, \"" + val + "\" is invalid");
        } else if (((val.charAt(0) >= '0') && (val.charAt(0) <= '9'))
                && ((val.charAt(1) >= '0') && (val.charAt(1) <= '9'))
                && ((val.charAt(2) >= '0') && (val.charAt(2) <= '9'))
                && ((val.charAt(3) >= '0') && (val.charAt(3) <= '9')) && (val.charAt(4) == '-')
                && ((val.charAt(5) >= '0') && (val.charAt(5) <= '1'))
                && ((val.charAt(6) >= '0') && (val.charAt(6) <= '9')) && (val.charAt(7) == '-')
                && ((val.charAt(8) >= '0') && (val.charAt(8) <= '3'))
                && ((val.charAt(9) >= '0') && (val.charAt(9) <= '9'))) {
            /*
             *   NOTE:
             *      .Net uses substring( startcol, lengthOfSubstring )
             *      Java uses substring( startcol, endcol ) and does not
             *         include charAt( endcol );
             */
            int year = Integer.parseInt(val.substring(0, 4));
            int month = Integer.parseInt(val.substring(5, 7));
            int day = Integer.parseInt(val.substring(8, 10));
            Calendar retval = new GregorianCalendar(CFLibDbUtil.getDbServerTimeZone());
            retval.set(Calendar.YEAR, year);
            retval.set(Calendar.MONTH, month - 1);
            retval.set(Calendar.DAY_OF_MONTH, day);
            retval.set(Calendar.HOUR_OF_DAY, 0);
            retval.set(Calendar.MINUTE, 0);
            retval.set(Calendar.SECOND, 0);
            Calendar local = new GregorianCalendar();
            local.setTimeInMillis(retval.getTimeInMillis());
            return (local);
        } else {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class, "convertDateString",
                    "Value must be in YYYY-MM-DD format, \"" + val + "\" is invalid");
        }
    }

    public static Calendar convertTimeString(String val) {
        if ((val == null) || (val.length() == 0)) {
            return (null);
        } else if (val.length() != 8) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class, "convertTimeString",
                    "Value must be in HH24:MI:SS format, \"" + val + "\" is invalid");
        } else if (((val.charAt(0) >= '0') && (val.charAt(0) <= '2'))
                && ((val.charAt(1) >= '0') && (val.charAt(1) <= '9')) && (val.charAt(2) == ':')
                && ((val.charAt(3) >= '0') && (val.charAt(3) <= '5'))
                && ((val.charAt(4) >= '0') && (val.charAt(4) <= '9')) && (val.charAt(5) == ':')
                && ((val.charAt(6) >= '0') && (val.charAt(6) <= '5'))
                && ((val.charAt(7) >= '0') && (val.charAt(7) <= '9'))) {
            /*
             *   NOTE:
             *      .Net uses substring( startcol, lengthOfSubstring )
             *      Java uses substring( startcol, endcol ) and does not
             *         include charAt( endcol );
             */
            int hour = Integer.parseInt(val.substring(0, 2));
            int minute = Integer.parseInt(val.substring(3, 5));
            int second = Integer.parseInt(val.substring(6, 8));
            Calendar retval = new GregorianCalendar(CFLibDbUtil.getDbServerTimeZone());
            retval.set(Calendar.YEAR, 2000);
            retval.set(Calendar.MONTH, 0);
            retval.set(Calendar.DAY_OF_MONTH, 1);
            retval.set(Calendar.HOUR_OF_DAY, hour);
            retval.set(Calendar.MINUTE, minute);
            retval.set(Calendar.SECOND, second);
            Calendar local = new GregorianCalendar();
            local.setTimeInMillis(retval.getTimeInMillis());
            return (local);
        } else {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class, "convertTimeString",
                    "Value must be in HH24:MI:SS format \"" + val + "\" is invalid");
        }
    }

    public static Calendar convertTimestampString(String val) {
        if ((val == null) || (val.length() == 0)) {
            return (null);
        } else if (val.length() != 19) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTimestampString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        } else if (((val.charAt(0) >= '0') && (val.charAt(0) <= '9'))
                && ((val.charAt(1) >= '0') && (val.charAt(1) <= '9'))
                && ((val.charAt(2) >= '0') && (val.charAt(2) <= '9'))
                && ((val.charAt(3) >= '0') && (val.charAt(3) <= '9')) && (val.charAt(4) == '-')
                && ((val.charAt(5) >= '0') && (val.charAt(5) <= '1'))
                && ((val.charAt(6) >= '0') && (val.charAt(6) <= '9')) && (val.charAt(7) == '-')
                && ((val.charAt(8) >= '0') && (val.charAt(8) <= '3'))
                && ((val.charAt(9) >= '0') && (val.charAt(9) <= '9')) && (val.charAt(10) == ' ')
                && ((val.charAt(11) >= '0') && (val.charAt(11) <= '2'))
                && ((val.charAt(12) >= '0') && (val.charAt(12) <= '9')) && (val.charAt(13) == ':')
                && ((val.charAt(14) >= '0') && (val.charAt(14) <= '5'))
                && ((val.charAt(15) >= '0') && (val.charAt(15) <= '9')) && (val.charAt(16) == ':')
                && ((val.charAt(17) >= '0') && (val.charAt(17) <= '5'))
                && ((val.charAt(18) >= '0') && (val.charAt(18) <= '9'))) {
            /*
             *   NOTE:
             *      .Net uses substring( startcol, lengthOfSubstring )
             *      Java uses substring( startcol, endcol ) and does not
             *         include charAt( endcol );
             */
            int year = Integer.parseInt(val.substring(0, 4));
            int month = Integer.parseInt(val.substring(5, 7));
            int day = Integer.parseInt(val.substring(8, 10));
            int hour = Integer.parseInt(val.substring(11, 13));
            int minute = Integer.parseInt(val.substring(14, 16));
            int second = Integer.parseInt(val.substring(17, 19));
            Calendar retval = new GregorianCalendar(CFLibDbUtil.getDbServerTimeZone());
            retval.set(Calendar.YEAR, year);
            retval.set(Calendar.MONTH, month - 1);
            retval.set(Calendar.DAY_OF_MONTH, day);
            retval.set(Calendar.HOUR_OF_DAY, hour);
            retval.set(Calendar.MINUTE, minute);
            retval.set(Calendar.SECOND, second);
            Calendar local = new GregorianCalendar();
            local.setTimeInMillis(retval.getTimeInMillis());
            return (local);
        } else {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTimestampString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        }
    }

    public static Calendar convertTZDateString(String val) {
        if ((val == null) || (val.length() == 0)) {
            return (null);
        } else if (val.length() != 19) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTZDateString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        } else if (((val.charAt(0) >= '0') && (val.charAt(0) <= '9'))
                && ((val.charAt(1) >= '0') && (val.charAt(1) <= '9'))
                && ((val.charAt(2) >= '0') && (val.charAt(2) <= '9'))
                && ((val.charAt(3) >= '0') && (val.charAt(3) <= '9')) && (val.charAt(4) == '-')
                && ((val.charAt(5) >= '0') && (val.charAt(5) <= '1'))
                && ((val.charAt(6) >= '0') && (val.charAt(6) <= '9')) && (val.charAt(7) == '-')
                && ((val.charAt(8) >= '0') && (val.charAt(8) <= '3'))
                && ((val.charAt(9) >= '0') && (val.charAt(9) <= '9')) && (val.charAt(10) == ' ')
                && ((val.charAt(11) >= '0') && (val.charAt(11) <= '2'))
                && ((val.charAt(12) >= '0') && (val.charAt(12) <= '9')) && (val.charAt(13) == ':')
                && ((val.charAt(14) >= '0') && (val.charAt(14) <= '5'))
                && ((val.charAt(15) >= '0') && (val.charAt(15) <= '9')) && (val.charAt(16) == ':')
                && ((val.charAt(17) >= '0') && (val.charAt(17) <= '5'))
                && ((val.charAt(18) >= '0') && (val.charAt(18) <= '9'))) {
            /*
             *   NOTE:
             *      .Net uses substring( startcol, lengthOfSubstring )
             *      Java uses substring( startcol, endcol ) and does not
             *         include charAt( endcol );
             */
            int year = Integer.parseInt(val.substring(0, 4));
            int month = Integer.parseInt(val.substring(5, 7));
            int day = Integer.parseInt(val.substring(8, 10));
            int hour = Integer.parseInt(val.substring(11, 13));
            int minute = Integer.parseInt(val.substring(14, 16));
            int second = Integer.parseInt(val.substring(17, 19));
            Calendar retval = new GregorianCalendar(CFLibDbUtil.getDbServerTimeZone());
            retval.set(Calendar.YEAR, year);
            retval.set(Calendar.MONTH, month - 1);
            retval.set(Calendar.DAY_OF_MONTH, day);
            retval.set(Calendar.HOUR_OF_DAY, hour);
            retval.set(Calendar.MINUTE, minute);
            retval.set(Calendar.SECOND, second);
            Calendar utc = CFLibDbUtil.getUTCCalendar(retval);
            return (utc);
        } else {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTZDateString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        }
    }

    public static Calendar convertTZTimeString(String val) {
        if ((val == null) || (val.length() == 0)) {
            return (null);
        } else if (val.length() != 19) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTZTimeString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        } else if (((val.charAt(0) >= '0') && (val.charAt(0) <= '9'))
                && ((val.charAt(1) >= '0') && (val.charAt(1) <= '9'))
                && ((val.charAt(2) >= '0') && (val.charAt(2) <= '9'))
                && ((val.charAt(3) >= '0') && (val.charAt(3) <= '9')) && (val.charAt(4) == '-')
                && ((val.charAt(5) >= '0') && (val.charAt(5) <= '1'))
                && ((val.charAt(6) >= '0') && (val.charAt(6) <= '9')) && (val.charAt(7) == '-')
                && ((val.charAt(8) >= '0') && (val.charAt(8) <= '3'))
                && ((val.charAt(9) >= '0') && (val.charAt(9) <= '9')) && (val.charAt(10) == ' ')
                && ((val.charAt(11) >= '0') && (val.charAt(11) <= '2'))
                && ((val.charAt(12) >= '0') && (val.charAt(12) <= '9')) && (val.charAt(13) == ':')
                && ((val.charAt(14) >= '0') && (val.charAt(14) <= '5'))
                && ((val.charAt(15) >= '0') && (val.charAt(15) <= '9')) && (val.charAt(16) == ':')
                && ((val.charAt(17) >= '0') && (val.charAt(17) <= '5'))
                && ((val.charAt(18) >= '0') && (val.charAt(18) <= '9'))) {
            /*
             *   NOTE:
             *      .Net uses substring( startcol, lengthOfSubstring )
             *      Java uses substring( startcol, endcol ) and does not
             *         include charAt( endcol );
             */
            int year = Integer.parseInt(val.substring(0, 4));
            int month = Integer.parseInt(val.substring(5, 7));
            int day = Integer.parseInt(val.substring(8, 10));
            int hour = Integer.parseInt(val.substring(11, 13));
            int minute = Integer.parseInt(val.substring(14, 16));
            int second = Integer.parseInt(val.substring(17, 19));
            Calendar retval = new GregorianCalendar(CFLibDbUtil.getDbServerTimeZone());
            retval.set(Calendar.YEAR, year);
            retval.set(Calendar.MONTH, month - 1);
            retval.set(Calendar.DAY_OF_MONTH, day);
            retval.set(Calendar.HOUR_OF_DAY, hour);
            retval.set(Calendar.MINUTE, minute);
            retval.set(Calendar.SECOND, second);
            Calendar utc = CFLibDbUtil.getUTCCalendar(retval);
            return (utc);
        } else {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTZTimeString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        }
    }

    public static Calendar convertTZTimestampString(String val) {
        if ((val == null) || (val.length() == 0)) {
            return (null);
        } else if (val.length() != 19) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTZTimestampString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        } else if (((val.charAt(0) >= '0') && (val.charAt(0) <= '9'))
                && ((val.charAt(1) >= '0') && (val.charAt(1) <= '9'))
                && ((val.charAt(2) >= '0') && (val.charAt(2) <= '9'))
                && ((val.charAt(3) >= '0') && (val.charAt(3) <= '9')) && (val.charAt(4) == '-')
                && ((val.charAt(5) >= '0') && (val.charAt(5) <= '1'))
                && ((val.charAt(6) >= '0') && (val.charAt(6) <= '9')) && (val.charAt(7) == '-')
                && ((val.charAt(8) >= '0') && (val.charAt(8) <= '3'))
                && ((val.charAt(9) >= '0') && (val.charAt(9) <= '9')) && (val.charAt(10) == ' ')
                && ((val.charAt(11) >= '0') && (val.charAt(11) <= '2'))
                && ((val.charAt(12) >= '0') && (val.charAt(12) <= '9')) && (val.charAt(13) == ':')
                && ((val.charAt(14) >= '0') && (val.charAt(14) <= '5'))
                && ((val.charAt(15) >= '0') && (val.charAt(15) <= '9')) && (val.charAt(16) == ':')
                && ((val.charAt(17) >= '0') && (val.charAt(17) <= '5'))
                && ((val.charAt(18) >= '0') && (val.charAt(18) <= '9'))) {
            /*
             *   NOTE:
             *      .Net uses substring( startcol, lengthOfSubstring )
             *      Java uses substring( startcol, endcol ) and does not
             *         include charAt( endcol );
             */
            int year = Integer.parseInt(val.substring(0, 4));
            int month = Integer.parseInt(val.substring(5, 7));
            int day = Integer.parseInt(val.substring(8, 10));
            int hour = Integer.parseInt(val.substring(11, 13));
            int minute = Integer.parseInt(val.substring(14, 16));
            int second = Integer.parseInt(val.substring(17, 19));
            Calendar retval = new GregorianCalendar(CFLibDbUtil.getDbServerTimeZone());
            retval.set(Calendar.YEAR, year);
            retval.set(Calendar.MONTH, month - 1);
            retval.set(Calendar.DAY_OF_MONTH, day);
            retval.set(Calendar.HOUR_OF_DAY, hour);
            retval.set(Calendar.MINUTE, minute);
            retval.set(Calendar.SECOND, second);
            Calendar utc = CFLibDbUtil.getUTCCalendar(retval);
            return (utc);
        } else {
            throw CFLib.getDefaultExceptionFactory().newUsageException(CFAccPgSqlSchema.class,
                    "convertTZTimestampString",
                    "Value must be in YYYY-MM-DD HH24:MI:SS format \"" + val + "\" is invalid");
        }
    }

    public static UUID convertUuidString(String val) {
        if ((val == null) || (val.length() == 0)) {
            return (null);
        } else {
            return (UUID.fromString(val));
        }
    }
}