Examples of HsqlArrayList

org.hsqldb.lib.HsqlArrayList
Intended as an asynchronous alternative to Vector. Use HsqlLinkedList instead if its better suited. @author dnordahl@users @version 1.9.0 @since 1.7.0
org.hsqldb_voltpatches.lib.HsqlArrayList
Intended as an asynchronous alternative to Vector. Use HsqlLinkedList instead if its better suited. @author dnordahl@users @version 1.9.0 @since 1.7.0

Examples of org.hsqldb.lib.HsqlArrayList

        return result;
    }


    private void addAllJoinedColumns(Expression e) {


        HsqlArrayList list = new HsqlArrayList();


        for (int i = 0; i < rangeVariables.length; i++) {
            rangeVariables[i].addTableColumns(list);
        }


        Expression[] nodes = new Expression[list.size()];


        list.toArray(nodes);


        e.nodes = nodes;
    }

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

                    return Result.newErrorResult(e, sql);
                }
            }
            case StatementTypes.DECLARE_SESSION_TABLE : {
                Table         table           = (Table) parameters[0];
                HsqlArrayList tempConstraints = (HsqlArrayList) parameters[1];
                StatementDMQL statement       = (StatementDMQL) parameters[2];


                try {
                    if (tempConstraints != null) {
                        table =

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

        Expression[]   updateExpressions;
        int[]          columnMap;
        boolean[]      columnCheckList;
        OrderedHashSet targetSet    = new OrderedHashSet();
        LongDeque      colIndexList = new LongDeque();
        HsqlArrayList  exprList     = new HsqlArrayList();
        RangeVariable[] rangeVariables = {
            readSimpleRangeVariable(StatementTypes.UPDATE_WHERE) };
        Table table     = rangeVariables[0].rangeTable;
        Table baseTable = table.getBaseTable();


        readThis(Tokens.SET);
        readSetClauseList(rangeVariables, targetSet, colIndexList, exprList);


        columnMap = new int[colIndexList.size()];


        colIndexList.toArray(columnMap);


        Expression[] targets = new Expression[targetSet.size()];


        targetSet.toArray(targets);


        for (int i = 0; i < targets.length; i++) {
            this.resolveOuterReferencesAndTypes(outerRanges, targets[i]);
        }


        columnCheckList   = table.getColumnCheckList(columnMap);
        updateExpressions = new Expression[exprList.size()];


        exprList.toArray(updateExpressions);


        Expression condition = null;


        if (token.tokenType == Tokens.WHERE) {
            read();

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

        Table         table;
        RangeVariable targetRange;
        RangeVariable sourceRange;
        Expression    mergeCondition;
        Expression[]  targets           = null;
        HsqlArrayList updateList        = new HsqlArrayList();
        Expression[]  updateExpressions = Expression.emptyArray;
        HsqlArrayList insertList        = new HsqlArrayList();
        Expression    insertExpression  = null;


        read();
        readThis(Tokens.INTO);


        targetRange = readSimpleRangeVariable(StatementTypes.MERGE);
        table       = targetRange.rangeTable;


        readThis(Tokens.USING);


        sourceRange = readTableOrSubquery();


        // parse ON search conditions
        readThis(Tokens.ON);


        mergeCondition = XreadBooleanValueExpression();


        if (mergeCondition.getDataType() != Type.SQL_BOOLEAN) {
            throw Error.error(ErrorCode.X_42568);
        }


        RangeVariable[] fullRangeVars   = new RangeVariable[] {
            sourceRange, targetRange
        };
        RangeVariable[] sourceRangeVars = new RangeVariable[]{ sourceRange };
        RangeVariable[] targetRangeVars = new RangeVariable[]{ targetRange };


        // parse WHEN clause(s) and convert lists to arrays
        insertColumnMap       = table.getColumnMap();
        insertColumnCheckList = table.getNewColumnCheckList();


        OrderedHashSet updateTargetSet    = new OrderedHashSet();
        OrderedHashSet insertColNames     = new OrderedHashSet();
        LongDeque      updateColIndexList = new LongDeque();


        readMergeWhen(updateColIndexList, insertColNames, updateTargetSet,
                      insertList, updateList, targetRangeVars, sourceRange);


        if (insertList.size() > 0) {
            int colCount = insertColNames.size();


            if (colCount != 0) {
                insertColumnMap = table.getColumnIndexes(insertColNames);
                insertColumnCheckList =
                    table.getColumnCheckList(insertColumnMap);
            }


            insertExpression = (Expression) insertList.get(0);


            setParameterTypes(insertExpression, table, insertColumnMap);
        }


        if (updateList.size() > 0) {

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

                    SchemaObject.PROCEDURE);


            if (routineSchema != null) {
                read();


                HsqlArrayList list = new HsqlArrayList();


                readThis(Tokens.OPENBRACKET);


                if (token.tokenType == Tokens.CLOSEBRACKET) {
                    read();
                } else {
                    while (true) {
                        Expression e = XreadValueExpression();


                        list.add(e);


                        if (token.tokenType == Tokens.COMMA) {
                            read();
                        } else {
                            readThis(Tokens.CLOSEBRACKET);


                            break;
                        }
                    }
                }


                Expression[] arguments = new Expression[list.size()];


                list.toArray(arguments);


                Routine routine =
                    routineSchema.getSpecificRoutine(arguments.length);


                compileContext.addProcedureCall(routine);

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

        throw Error.runtimeError(ErrorCode.U_S0500, "Logger");
    }


    public String[] getPropertiesSQL() {


        HsqlArrayList list = new HsqlArrayList();
        StringBuffer  sb   = new StringBuffer();


        sb.append("SET DATABASE ").append(Tokens.T_UNIQUE).append(' ');
        sb.append(Tokens.T_NAME).append(' ').append(database.getUniqueName());
        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_GC).append(' ');
        sb.append(propGC);
        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_DEFAULT).append(' ');
        sb.append(Tokens.T_RESULT).append(' ').append(Tokens.T_MEMORY);
        sb.append(' ').append(Tokens.T_ROWS).append(' ');
        sb.append(database.getResultMaxMemoryRows());
        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_EVENT).append(' ');
        sb.append(Tokens.T_LOG).append(' ').append(Tokens.T_LEVEL);
        sb.append(' ').append(propEventLogLevel);
        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_SQL).append(' ');
        sb.append(Tokens.T_REFERENCES).append(' ');
        sb.append(database.sqlEnforceRefs ? Tokens.T_TRUE
                                          : Tokens.T_FALSE);
        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_SQL).append(' ');
        sb.append(Tokens.T_SIZE).append(' ');
        sb.append(database.sqlEnforceSize ? Tokens.T_TRUE
                                          : Tokens.T_FALSE);
        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_SQL).append(' ');
        sb.append(Tokens.T_NAMES).append(' ');
        sb.append(database.sqlEnforceNames ? Tokens.T_TRUE
                                           : Tokens.T_FALSE);
        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_TRANSACTION);
        sb.append(' ').append(Tokens.T_CONTROL).append(' ');


        switch (database.txManager.getTransactionControl()) {


            case TransactionManager.MVCC :
                sb.append(Tokens.T_MVCC);
                break;


            case TransactionManager.MVLOCKS :
                sb.append(Tokens.T_MVLOCKS);
                break;


            case TransactionManager.LOCKS :
                sb.append(Tokens.T_LOCKS);
                break;
        }


        list.add(sb.toString());
        sb.setLength(0);
        sb.append("SET DATABASE ").append(Tokens.T_DEFAULT).append(' ');
        sb.append(Tokens.T_ISOLATION).append(' ').append(Tokens.T_LEVEL);
        sb.append(' ');


        switch (database.getDefaultIsolationLevel()) {


            case SessionInterface.TX_READ_COMMITTED :
                sb.append(Tokens.T_READ).append(' ').append(
                    Tokens.T_COMMITTED);
                break;


            case SessionInterface.TX_SERIALIZABLE :
                sb.append(Tokens.T_SERIALIZABLE);
                break;
        }


        list.add(sb.toString());
        sb.setLength(0);


        if (hasPersistence()) {
            if (database.schemaManager.getDefaultTableType()
                    == TableBase.CACHED_TABLE) {
                list.add("SET DATABASE DEFAULT TABLE TYPE CACHED");
            }


            int     delay  = propWriteDelay;
            boolean millis = delay > 0 && delay < 1000;


            if (millis) {
                if (delay < 20) {
                    delay = 20;
                }
            } else {
                delay /= 1000;
            }


            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_WRITE).append(' ');
            sb.append(Tokens.T_DELAY).append(' ').append(delay);


            if (millis) {
                sb.append(' ').append(Tokens.T_MILLIS);
            }


            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_BACKUP);
            sb.append(' ').append(Tokens.T_INCREMENT).append(' ');
            sb.append(propIncrementBackup ? Tokens.T_TRUE
                                          : Tokens.T_FALSE);
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_CACHE);
            sb.append(' ').append(Tokens.T_SIZE).append(' ');
            sb.append(propCacheMaxSize / 1024);
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_CACHE);
            sb.append(' ').append(Tokens.T_ROWS).append(' ');
            sb.append(propCacheMaxRows);
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_SCALE);
            sb.append(' ').append(propCacheFileScale);
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_LOB).append(' ').append(
                Tokens.T_SCALE);
            sb.append(' ').append(getLobFileScale());
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_DEFRAG);
            sb.append(' ').append(propCacheDefragLimit);
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_NIO);
            sb.append(' ').append(propNioDataFile ? Tokens.T_TRUE
                                                  : Tokens.T_FALSE);
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_LOG).append(' ');
            sb.append(propLogData ? Tokens.T_TRUE
                                  : Tokens.T_FALSE);
            list.add(sb.toString());
            sb.setLength(0);
            sb.append("SET FILES ").append(Tokens.T_LOG).append(' ');
            sb.append(Tokens.T_SIZE).append(' ').append(propLogSize);
            list.add(sb.toString());
            sb.setLength(0);
            /*
            if (propTempDirectoryPath != null) {
                sb.append("SET FILES ").append(Tokens.T_TEMP).append(' ');
                sb.append(Tokens.T_PATH).append(' ');
                sb.append(propTempDirectoryPath);
                list.add(sb.toString());
                sb.setLength(0);
            }
            */
            sb.append("SET DATABASE ").append(Tokens.T_TEXT).append(' ');
            sb.append(Tokens.T_TABLE).append(' ').append(Tokens.T_DEFAULTS);
            sb.append(' ').append('\'');
            sb.append(propTextSourceDefault).append('\'');
            list.add(sb.toString());
            sb.setLength(0);
        }


        String[] array = new String[list.size()];


        list.toArray(array);


        return array;
    }

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

    Statement compileSetStatement(RangeVariable rangeVars[]) {


        read();


        OrderedHashSet targetSet    = new OrderedHashSet();
        HsqlArrayList  exprList     = new HsqlArrayList();
        LongDeque      colIndexList = new LongDeque();


        readSetClauseList(rangeVars, targetSet, colIndexList, exprList);


        if (exprList.size() > 1) {
            throw Error.error(ErrorCode.X_42602);
        }


        Expression expression = (Expression) exprList.get(0);


        if (expression.getDegree() != targetSet.size()) {
            throw Error.error(ErrorCode.X_42546, Tokens.T_SET);
        }

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

        read();


        Expression[]   updateExpressions;
        int[]          columnMap;
        OrderedHashSet targetSet = new OrderedHashSet();
        HsqlArrayList  exprList  = new HsqlArrayList();
        RangeVariable[] targetRangeVars = new RangeVariable[]{
            rangeVars[TriggerDef.NEW_ROW] };
        LongDeque colIndexList = new LongDeque();


        readSetClauseList(targetRangeVars, targetSet, colIndexList, exprList);


        columnMap = new int[colIndexList.size()];


        colIndexList.toArray(columnMap);


        Expression[] targets = new Expression[targetSet.size()];


        targetSet.toArray(targets);


        for (int i = 0; i < targets.length; i++) {
            this.resolveOuterReferencesAndTypes(RangeVariable.emptyArray,
                                                targets[i]);
        }


        updateExpressions = new Expression[exprList.size()];


        exprList.toArray(updateExpressions);
        resolveUpdateExpressions(table, rangeVars, columnMap,
                                 updateExpressions, RangeVariable.emptyArray);


        StatementDMQL cs = new StatementSet(session, targets, table,
                                            rangeVars, columnMap,

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList


*/
    private Object[] readLocalDeclarationList(Routine routine,
            StatementCompound context) {


        HsqlArrayList list = new HsqlArrayList();


        while (token.tokenType == Tokens.DECLARE) {
            Object var = readLocalVariableDeclarationOrNull();


            if (var == null) {
                var = compileLocalHandlerDeclarationOrNull(routine, context);
            }


            if (var instanceof ColumnSchema[]) {
                list.addAll((Object[]) var);
            } else {
                list.add(var);
            }
        }


        Object[] declarations = new Object[list.size()];


        list.toArray(declarations);


        return declarations;
    }

View Full Code Here

Examples of org.hsqldb.lib.HsqlArrayList

                    .ConstraintTypes.PRIMARY_KEY) {
                resolved.add(c.getName());
            }
        }


        HsqlArrayList list = new HsqlArrayList();


        list.add(getSQL());


        if (!isTemp && !isText && hasIdentityColumn()) {
            list.add(NumberSequence.getRestartSQL(this));
        }


        for (int i = 0; i < indexList.length; i++) {
            if (!indexList[i].isConstraint()
                    && indexList[i].getColumnCount() > 0) {
                list.add(indexList[i].getSQL());
            }
        }


        String[] array = new String[list.size()];


        list.toArray(array);


        return array;
    }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.