ucGetSequenceInfo

Purpose

Applies To

Administration Methods

Signature

public Map ucGetSequenceInfo(
                Connection dbconn ) 

Notes

Example

public Map ucGetSequenceInfo(Connection dbconn) throws Exception {
        HashMap sequences = new HashMap();
        if (dbconn == null)throw new NullPointerException("Connection is null.");
        String sql =
            " select name, table_name, column_name, cache_size from ev_sequence 
               where name like '%$_ALT$_SEQ' escape '$'";
        PreparedStatement ps = null;
        ResultSet rs = null;
        List updateStatements;
        try {
            ps = dbconn.prepareStatement(sql);
            rs = ps.executeQuery();
            while (rs.next()) {
                String sequenceName = rs.getString("name");
                int pos = sequenceName.indexOf("_");
                String altIdPrefix = sequenceName.substring(0, pos);
                String tableName = rs.getString("table_name");
                String columnName = rs.getString("column_name");
                String cache = rs.getString("cache_size");
                if (tableName != null && columnName != null && "ITEM".equals(tableName) 
                   && "ALT_ID".equals(columnName)) {
                    StringBuffer cookedName = new StringBuffer("cast( ");
                    cookedName.append(Z.dbms.substr("ALT_ID", "4", "5"));
                    cookedName.append(" as numeric )");
                    sequences.put(sequenceName,
                                  getSequenceUpdateStatement(tableName, 
                                     cookedName.toString(), cache, sequenceName,
                        altIdPrefix));
                }
            }
        } catch (Exception e) {
            ErrorWriter.write(e, ErrorWriter.LOG);
            throw e;
        } finally {
            if (rs != null)try {
                rs.close();
            }
            catch (Exception basura) {}
            if (ps != null)try {
                ps.close();
            }
            catch (Exception basura) {}
        }
        return sequences;
    }