net.sourceforge.msscodefactory.cfsecurity.v2_1.CFSecurityDb2LUW.CFSecurityDb2LUWSchema.java Source code

Java tutorial

Introduction

Here is the source code for net.sourceforge.msscodefactory.cfsecurity.v2_1.CFSecurityDb2LUW.CFSecurityDb2LUWSchema.java

Source

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

/*
 *   CF Security Core Implementation
 *
 *   Copyright (c) 2014 Mark Sobkow
 *   
 *      Licensed under the Apache License, Version 2.0 (the "License");
 *      you may not use this file except in compliance with the License.
 *      You may obtain a copy of the License at
 *   
 *          http://www.apache.org/licenses/LICENSE-2.0
 *   
 *      Unless required by applicable law or agreed to in writing, software
 *      distributed under the License is distributed on an "AS IS" BASIS,
 *      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *      See the License for the specific language governing permissions and
 *      limitations under the License.
 *   
 * ***********************************************************************
 *
 *   Code manufactured by MSS Code Factory
 */

package net.sourceforge.msscodefactory.cfsecurity.v2_1.CFSecurityDb2LUW;

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.v2_1.CFLib.*;
import org.apache.commons.codec.binary.Base64;
import net.sourceforge.msscodefactory.cfsecurity.v2_1.CFSecurity.*;

public class CFSecurityDb2LUWSchema extends CFSecuritySchema {
    protected Connection cnx;
    protected boolean inTransaction;
    protected PreparedStatement stmtSelectNextServiceTypeIdGen = null;
    protected PreparedStatement stmtSelectNextClusterIdGen = null;
    protected PreparedStatement stmtSelectNextTenantIdGen = null;
    protected PreparedStatement stmtSelectIsSystemUser = null;
    protected PreparedStatement stmtSelectIsClusterUser = null;
    protected PreparedStatement stmtSelectIsTenantUser = null;

    public CFSecurityDb2LUWSchema() {
        super();
        cnx = null;
        inTransaction = false;
        tableAuditAction = new CFSecurityDb2LUWAuditActionTable(this);
        tableCluster = new CFSecurityDb2LUWClusterTable(this);
        tableHostNode = new CFSecurityDb2LUWHostNodeTable(this);
        tableISOCountry = new CFSecurityDb2LUWISOCountryTable(this);
        tableISOCountryCurrency = new CFSecurityDb2LUWISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFSecurityDb2LUWISOCountryLanguageTable(this);
        tableISOCurrency = new CFSecurityDb2LUWISOCurrencyTable(this);
        tableISOLanguage = new CFSecurityDb2LUWISOLanguageTable(this);
        tableISOTimezone = new CFSecurityDb2LUWISOTimezoneTable(this);
        tableSecApp = new CFSecurityDb2LUWSecAppTable(this);
        tableSecDevice = new CFSecurityDb2LUWSecDeviceTable(this);
        tableSecForm = new CFSecurityDb2LUWSecFormTable(this);
        tableSecGroup = new CFSecurityDb2LUWSecGroupTable(this);
        tableSecGroupForm = new CFSecurityDb2LUWSecGroupFormTable(this);
        tableSecGroupInclude = new CFSecurityDb2LUWSecGroupIncludeTable(this);
        tableSecGroupMember = new CFSecurityDb2LUWSecGroupMemberTable(this);
        tableSecSession = new CFSecurityDb2LUWSecSessionTable(this);
        tableSecUser = new CFSecurityDb2LUWSecUserTable(this);
        tableService = new CFSecurityDb2LUWServiceTable(this);
        tableServiceType = new CFSecurityDb2LUWServiceTypeTable(this);
        tableTSecGroup = new CFSecurityDb2LUWTSecGroupTable(this);
        tableTSecGroupInclude = new CFSecurityDb2LUWTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFSecurityDb2LUWTSecGroupMemberTable(this);
        tableTenant = new CFSecurityDb2LUWTenantTable(this);
    }

    public CFSecurityDb2LUWSchema(CFSecurityConfigurationFile conf) {
        super(conf);
        cnx = null;
        inTransaction = false;
        tableAuditAction = new CFSecurityDb2LUWAuditActionTable(this);
        tableCluster = new CFSecurityDb2LUWClusterTable(this);
        tableHostNode = new CFSecurityDb2LUWHostNodeTable(this);
        tableISOCountry = new CFSecurityDb2LUWISOCountryTable(this);
        tableISOCountryCurrency = new CFSecurityDb2LUWISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFSecurityDb2LUWISOCountryLanguageTable(this);
        tableISOCurrency = new CFSecurityDb2LUWISOCurrencyTable(this);
        tableISOLanguage = new CFSecurityDb2LUWISOLanguageTable(this);
        tableISOTimezone = new CFSecurityDb2LUWISOTimezoneTable(this);
        tableSecApp = new CFSecurityDb2LUWSecAppTable(this);
        tableSecDevice = new CFSecurityDb2LUWSecDeviceTable(this);
        tableSecForm = new CFSecurityDb2LUWSecFormTable(this);
        tableSecGroup = new CFSecurityDb2LUWSecGroupTable(this);
        tableSecGroupForm = new CFSecurityDb2LUWSecGroupFormTable(this);
        tableSecGroupInclude = new CFSecurityDb2LUWSecGroupIncludeTable(this);
        tableSecGroupMember = new CFSecurityDb2LUWSecGroupMemberTable(this);
        tableSecSession = new CFSecurityDb2LUWSecSessionTable(this);
        tableSecUser = new CFSecurityDb2LUWSecUserTable(this);
        tableService = new CFSecurityDb2LUWServiceTable(this);
        tableServiceType = new CFSecurityDb2LUWServiceTypeTable(this);
        tableTSecGroup = new CFSecurityDb2LUWTSecGroupTable(this);
        tableTSecGroupInclude = new CFSecurityDb2LUWTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFSecurityDb2LUWTSecGroupMemberTable(this);
        tableTenant = new CFSecurityDb2LUWTenantTable(this);
        setDbSchemaName(conf.getDbDatabase());
    }

    public CFSecurityDb2LUWSchema(String argJndiName) {
        super(argJndiName);
        cnx = null;
        inTransaction = false;
        tableAuditAction = new CFSecurityDb2LUWAuditActionTable(this);
        tableCluster = new CFSecurityDb2LUWClusterTable(this);
        tableHostNode = new CFSecurityDb2LUWHostNodeTable(this);
        tableISOCountry = new CFSecurityDb2LUWISOCountryTable(this);
        tableISOCountryCurrency = new CFSecurityDb2LUWISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFSecurityDb2LUWISOCountryLanguageTable(this);
        tableISOCurrency = new CFSecurityDb2LUWISOCurrencyTable(this);
        tableISOLanguage = new CFSecurityDb2LUWISOLanguageTable(this);
        tableISOTimezone = new CFSecurityDb2LUWISOTimezoneTable(this);
        tableSecApp = new CFSecurityDb2LUWSecAppTable(this);
        tableSecDevice = new CFSecurityDb2LUWSecDeviceTable(this);
        tableSecForm = new CFSecurityDb2LUWSecFormTable(this);
        tableSecGroup = new CFSecurityDb2LUWSecGroupTable(this);
        tableSecGroupForm = new CFSecurityDb2LUWSecGroupFormTable(this);
        tableSecGroupInclude = new CFSecurityDb2LUWSecGroupIncludeTable(this);
        tableSecGroupMember = new CFSecurityDb2LUWSecGroupMemberTable(this);
        tableSecSession = new CFSecurityDb2LUWSecSessionTable(this);
        tableSecUser = new CFSecurityDb2LUWSecUserTable(this);
        tableService = new CFSecurityDb2LUWServiceTable(this);
        tableServiceType = new CFSecurityDb2LUWServiceTypeTable(this);
        tableTSecGroup = new CFSecurityDb2LUWTSecGroupTable(this);
        tableTSecGroupInclude = new CFSecurityDb2LUWTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFSecurityDb2LUWTSecGroupMemberTable(this);
        tableTenant = new CFSecurityDb2LUWTenantTable(this);
    }

    public CFSecurityDb2LUWSchema(Connection argCnx) {
        super();
        cnx = argCnx;
        inTransaction = false;
        tableAuditAction = new CFSecurityDb2LUWAuditActionTable(this);
        tableCluster = new CFSecurityDb2LUWClusterTable(this);
        tableHostNode = new CFSecurityDb2LUWHostNodeTable(this);
        tableISOCountry = new CFSecurityDb2LUWISOCountryTable(this);
        tableISOCountryCurrency = new CFSecurityDb2LUWISOCountryCurrencyTable(this);
        tableISOCountryLanguage = new CFSecurityDb2LUWISOCountryLanguageTable(this);
        tableISOCurrency = new CFSecurityDb2LUWISOCurrencyTable(this);
        tableISOLanguage = new CFSecurityDb2LUWISOLanguageTable(this);
        tableISOTimezone = new CFSecurityDb2LUWISOTimezoneTable(this);
        tableSecApp = new CFSecurityDb2LUWSecAppTable(this);
        tableSecDevice = new CFSecurityDb2LUWSecDeviceTable(this);
        tableSecForm = new CFSecurityDb2LUWSecFormTable(this);
        tableSecGroup = new CFSecurityDb2LUWSecGroupTable(this);
        tableSecGroupForm = new CFSecurityDb2LUWSecGroupFormTable(this);
        tableSecGroupInclude = new CFSecurityDb2LUWSecGroupIncludeTable(this);
        tableSecGroupMember = new CFSecurityDb2LUWSecGroupMemberTable(this);
        tableSecSession = new CFSecurityDb2LUWSecSessionTable(this);
        tableSecUser = new CFSecurityDb2LUWSecUserTable(this);
        tableService = new CFSecurityDb2LUWServiceTable(this);
        tableServiceType = new CFSecurityDb2LUWServiceTypeTable(this);
        tableTSecGroup = new CFSecurityDb2LUWTSecGroupTable(this);
        tableTSecGroupInclude = new CFSecurityDb2LUWTSecGroupIncludeTable(this);
        tableTSecGroupMember = new CFSecurityDb2LUWTSecGroupMemberTable(this);
        tableTenant = new CFSecurityDb2LUWTenantTable(this);
        try {
            cnx.setAutoCommit(false);
            cnx.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
            cnx.rollback();
        } catch (SQLException e) {
            throw CFLib.getDefaultExceptionFactory().newDbException(getClass(),
                    "CFSecurityDb2LUWSchema-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) {
            try {
                Class.forName("com.ibm.db2.jcc.DB2Driver");
            } catch (ClassNotFoundException e) {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "connect",
                        "Could not load IBM DB/2 LUW 10.5 driver", e);
            }
            String dbServer = configuration.getDbServer();
            int dbPort = configuration.getDbPort();
            String dbDatabase = configuration.getDbDatabase();
            String dbUserName = configuration.getDbUserName();
            String dbPassword = configuration.getDbPassword();
            String url = "jdbc:db2://" + 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();
                setDbSchemaName(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 PooledConnection for ConnectionPoolDataSource \""
                                    + 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-userpw";
        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) {
            try {
                Class.forName("com.ibm.db2.jcc.DB2Driver");
            } catch (ClassNotFoundException e) {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "connect",
                        "Could not load IBM DB/2 LUW 10.5 driver", e);
            }
            String dbServer = configuration.getDbServer();
            int dbPort = configuration.getDbPort();
            String dbDatabase = configuration.getDbDatabase();
            String dbUserName = username;
            String dbPassword = password;
            String url = "jdbc:db2://" + 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();
                setDbSchemaName(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();
                    }
                    releasePreparedStatements();
                    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(CFSecurityAuthorization Authorization) {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "isSystemUser",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            final String sql = "SELECT sp_is_system_user( ? ) as IsSystemUser FROM sysibm.sysdummy1";
            if (stmtSelectIsSystemUser == null) {
                stmtSelectIsSystemUser = cnx.prepareStatement(sql);
            }
            stmtSelectIsSystemUser.setString(1, Authorization.getSecUserId().toString());
            resultSet = stmtSelectIsSystemUser.executeQuery();
            int resultFlag;
            if (resultSet.next()) {
                resultFlag = resultSet.getInt(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "isSystemUser",
                        "Query of sp_is_system_user() did not return a result row");
            }
            resultSet.close();
            if (resultFlag == 0) {
                return (false);
            } else {
                return (true);
            }
        } 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(CFSecurityAuthorization Authorization, long clusterId, String groupName) {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "isClusterUser",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            final String sql = "SELECT sp_is_cluster_user( ?, ?, ? ) as IsClusterUser FROM sysibm.sysdummy1";
            if (stmtSelectIsClusterUser == null) {
                stmtSelectIsClusterUser = cnx.prepareStatement(sql);
            }
            stmtSelectIsClusterUser.setLong(1, clusterId);
            stmtSelectIsClusterUser.setString(2, groupName);
            stmtSelectIsClusterUser.setString(3, Authorization.getSecUserId().toString());
            resultSet = stmtSelectIsClusterUser.executeQuery();
            int resultFlag;
            if (resultSet.next()) {
                resultFlag = resultSet.getInt(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "isClusterUser",
                        "Query of sp_is_cluster_user() did not return a result row");
            }
            resultSet.close();
            if (resultFlag == 0) {
                return (false);
            } else {
                return (true);
            }
        } 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(CFSecurityAuthorization Authorization, long tenantId, String groupName) {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "isTenantUser",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            final String sql = "SELECT sp_is_tenant_user( ?, ?, ? ) as IsTenantUser FROM sysibm.sysdummy1";
            if (stmtSelectIsTenantUser == null) {
                stmtSelectIsTenantUser = cnx.prepareStatement(sql);
            }
            stmtSelectIsTenantUser.setLong(1, tenantId);
            stmtSelectIsTenantUser.setString(2, groupName);
            stmtSelectIsTenantUser.setString(3, Authorization.getSecUserId().toString());
            resultSet = stmtSelectIsTenantUser.executeQuery();
            int resultFlag;
            if (resultSet.next()) {
                resultFlag = resultSet.getInt(1);
            } else {
                throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), "isTenantUser",
                        "Query of sp_is_tenant_user() did not return a result row");
            }
            resultSet.close();
            if (resultFlag == 0) {
                return (false);
            } else {
                return (true);
            }
        } 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 {
            final String sql = "call sf_next_servicetypeidgen()";
            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 sf_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 long nextClusterIdGen() {
        if (!inTransaction) {
            throw CFLib.getDefaultExceptionFactory().newUsageException(getClass(), "nextClusterIdGen",
                    "Not in a transaction");
        }
        ResultSet resultSet = null;
        try {
            final String sql = "call sf_next_clusteridgen()";
            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 sf_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 {
            final String sql = "call sf_next_tenantidgen()";
            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 sf_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 UUID nextSecSessionIdGen() {
        UUID retval = UUID.randomUUID();
        return (retval);
    }

    public UUID nextSecUserIdGen() {
        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 (stmtSelectNextServiceTypeIdGen != null) {
            try {
                stmtSelectNextServiceTypeIdGen.close();
            } catch (SQLException e) {
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            }
            stmtSelectNextServiceTypeIdGen = null;
        }
        if (stmtSelectNextClusterIdGen != null) {
            try {
                stmtSelectNextClusterIdGen.close();
            } catch (SQLException e) {
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            }
            stmtSelectNextClusterIdGen = null;
        }
        if (stmtSelectNextTenantIdGen != null) {
            try {
                stmtSelectNextTenantIdGen.close();
            } catch (SQLException e) {
                throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
            }
            stmtSelectNextTenantIdGen = null;
        }

        if ((tableAuditAction != null) && (tableAuditAction instanceof CFSecurityDb2LUWAuditActionTable)) {
            CFSecurityDb2LUWAuditActionTable table = (CFSecurityDb2LUWAuditActionTable) tableAuditAction;
            table.releasePreparedStatements();
        }
        if ((tableCluster != null) && (tableCluster instanceof CFSecurityDb2LUWClusterTable)) {
            CFSecurityDb2LUWClusterTable table = (CFSecurityDb2LUWClusterTable) tableCluster;
            table.releasePreparedStatements();
        }
        if ((tableHostNode != null) && (tableHostNode instanceof CFSecurityDb2LUWHostNodeTable)) {
            CFSecurityDb2LUWHostNodeTable table = (CFSecurityDb2LUWHostNodeTable) tableHostNode;
            table.releasePreparedStatements();
        }
        if ((tableISOCountry != null) && (tableISOCountry instanceof CFSecurityDb2LUWISOCountryTable)) {
            CFSecurityDb2LUWISOCountryTable table = (CFSecurityDb2LUWISOCountryTable) tableISOCountry;
            table.releasePreparedStatements();
        }
        if ((tableISOCountryCurrency != null)
                && (tableISOCountryCurrency instanceof CFSecurityDb2LUWISOCountryCurrencyTable)) {
            CFSecurityDb2LUWISOCountryCurrencyTable table = (CFSecurityDb2LUWISOCountryCurrencyTable) tableISOCountryCurrency;
            table.releasePreparedStatements();
        }
        if ((tableISOCountryLanguage != null)
                && (tableISOCountryLanguage instanceof CFSecurityDb2LUWISOCountryLanguageTable)) {
            CFSecurityDb2LUWISOCountryLanguageTable table = (CFSecurityDb2LUWISOCountryLanguageTable) tableISOCountryLanguage;
            table.releasePreparedStatements();
        }
        if ((tableISOCurrency != null) && (tableISOCurrency instanceof CFSecurityDb2LUWISOCurrencyTable)) {
            CFSecurityDb2LUWISOCurrencyTable table = (CFSecurityDb2LUWISOCurrencyTable) tableISOCurrency;
            table.releasePreparedStatements();
        }
        if ((tableISOLanguage != null) && (tableISOLanguage instanceof CFSecurityDb2LUWISOLanguageTable)) {
            CFSecurityDb2LUWISOLanguageTable table = (CFSecurityDb2LUWISOLanguageTable) tableISOLanguage;
            table.releasePreparedStatements();
        }
        if ((tableISOTimezone != null) && (tableISOTimezone instanceof CFSecurityDb2LUWISOTimezoneTable)) {
            CFSecurityDb2LUWISOTimezoneTable table = (CFSecurityDb2LUWISOTimezoneTable) tableISOTimezone;
            table.releasePreparedStatements();
        }
        if ((tableSecApp != null) && (tableSecApp instanceof CFSecurityDb2LUWSecAppTable)) {
            CFSecurityDb2LUWSecAppTable table = (CFSecurityDb2LUWSecAppTable) tableSecApp;
            table.releasePreparedStatements();
        }
        if ((tableSecDevice != null) && (tableSecDevice instanceof CFSecurityDb2LUWSecDeviceTable)) {
            CFSecurityDb2LUWSecDeviceTable table = (CFSecurityDb2LUWSecDeviceTable) tableSecDevice;
            table.releasePreparedStatements();
        }
        if ((tableSecForm != null) && (tableSecForm instanceof CFSecurityDb2LUWSecFormTable)) {
            CFSecurityDb2LUWSecFormTable table = (CFSecurityDb2LUWSecFormTable) tableSecForm;
            table.releasePreparedStatements();
        }
        if ((tableSecGroup != null) && (tableSecGroup instanceof CFSecurityDb2LUWSecGroupTable)) {
            CFSecurityDb2LUWSecGroupTable table = (CFSecurityDb2LUWSecGroupTable) tableSecGroup;
            table.releasePreparedStatements();
        }
        if ((tableSecGroupForm != null) && (tableSecGroupForm instanceof CFSecurityDb2LUWSecGroupFormTable)) {
            CFSecurityDb2LUWSecGroupFormTable table = (CFSecurityDb2LUWSecGroupFormTable) tableSecGroupForm;
            table.releasePreparedStatements();
        }
        if ((tableSecGroupInclude != null)
                && (tableSecGroupInclude instanceof CFSecurityDb2LUWSecGroupIncludeTable)) {
            CFSecurityDb2LUWSecGroupIncludeTable table = (CFSecurityDb2LUWSecGroupIncludeTable) tableSecGroupInclude;
            table.releasePreparedStatements();
        }
        if ((tableSecGroupMember != null) && (tableSecGroupMember instanceof CFSecurityDb2LUWSecGroupMemberTable)) {
            CFSecurityDb2LUWSecGroupMemberTable table = (CFSecurityDb2LUWSecGroupMemberTable) tableSecGroupMember;
            table.releasePreparedStatements();
        }
        if ((tableSecSession != null) && (tableSecSession instanceof CFSecurityDb2LUWSecSessionTable)) {
            CFSecurityDb2LUWSecSessionTable table = (CFSecurityDb2LUWSecSessionTable) tableSecSession;
            table.releasePreparedStatements();
        }
        if ((tableSecUser != null) && (tableSecUser instanceof CFSecurityDb2LUWSecUserTable)) {
            CFSecurityDb2LUWSecUserTable table = (CFSecurityDb2LUWSecUserTable) tableSecUser;
            table.releasePreparedStatements();
        }
        if ((tableService != null) && (tableService instanceof CFSecurityDb2LUWServiceTable)) {
            CFSecurityDb2LUWServiceTable table = (CFSecurityDb2LUWServiceTable) tableService;
            table.releasePreparedStatements();
        }
        if ((tableServiceType != null) && (tableServiceType instanceof CFSecurityDb2LUWServiceTypeTable)) {
            CFSecurityDb2LUWServiceTypeTable table = (CFSecurityDb2LUWServiceTypeTable) tableServiceType;
            table.releasePreparedStatements();
        }
        if ((tableTSecGroup != null) && (tableTSecGroup instanceof CFSecurityDb2LUWTSecGroupTable)) {
            CFSecurityDb2LUWTSecGroupTable table = (CFSecurityDb2LUWTSecGroupTable) tableTSecGroup;
            table.releasePreparedStatements();
        }
        if ((tableTSecGroupInclude != null)
                && (tableTSecGroupInclude instanceof CFSecurityDb2LUWTSecGroupIncludeTable)) {
            CFSecurityDb2LUWTSecGroupIncludeTable table = (CFSecurityDb2LUWTSecGroupIncludeTable) tableTSecGroupInclude;
            table.releasePreparedStatements();
        }
        if ((tableTSecGroupMember != null)
                && (tableTSecGroupMember instanceof CFSecurityDb2LUWTSecGroupMemberTable)) {
            CFSecurityDb2LUWTSecGroupMemberTable table = (CFSecurityDb2LUWTSecGroupMemberTable) tableTSecGroupMember;
            table.releasePreparedStatements();
        }
        if ((tableTenant != null) && (tableTenant instanceof CFSecurityDb2LUWTenantTable)) {
            CFSecurityDb2LUWTenantTable table = (CFSecurityDb2LUWTenantTable) tableTenant;
            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(CFSecurityDb2LUWSchema.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 ("'Y'");
            } else {
                return ("'N'");
            }
        }
    }

    public static String getBoolString(boolean val) {
        if (val) {
            return ("'Y'");
        } else {
            return ("'N'");
        }
    }

    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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.class, "getNullableByte",
                    e);
        }
    }

    public static String getQuotedDateString(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.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);
            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));
            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);
            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));
            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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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(CFSecurityDb2LUWSchema.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));
        }
    }
}