Examples of HsqlName

Examples of org.hsqldb.HsqlNameManager.HsqlName

            // ----------------------------------------------------------------
            addColumn(t, "SPECIFIC_NAME", SQL_IDENTIFIER);        // 8


            // ----------------------------------------------------------------
            // order: PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME, SPECIFIC_NAME
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_PROCEDURES].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, new int[] {
                0, 1, 2, 8

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName

            addColumn(t, "NAME", SQL_IDENTIFIER);
            addColumn(t, "MAX_LEN", Type.SQL_INTEGER);
            addColumn(t, "DEFAULT_VALUE", SQL_IDENTIFIER);    // not null
            addColumn(t, "DESCRIPTION", SQL_IDENTIFIER);      // not null


            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_PRIMARYKEYS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName

            addColumn(t, "TABLE_CATALOG", SQL_IDENTIFIER);
            addColumn(t, "IS_DEFAULT", Type.SQL_BOOLEAN);


            // order: TABLE_SCHEM
            // true PK, as rows never have null TABLE_SCHEM
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_SCHEMAS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName


            // ------------------------------------------------------------
            // order TABLE_TYPE, TABLE_SCHEM and TABLE_NAME
            // added for unique: TABLE_CAT
            // false PK, as TABLE_SCHEM and/or TABLE_CAT may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_TABLES].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, new int[] {
                3, 1, 2, 0
            }, false);


            return t;
        }


        PersistentStore store = session.sessionData.getRowStore(t);


        // intermediate holders
        Iterator    tables;
        Table       table;
        Object[]    row;
        HsqlName    accessKey;
        DITableInfo ti;


        // column number mappings
        // JDBC 1
        final int itable_cat   = 0;

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName


            addColumn(t, "TABLE_TYPE", SQL_IDENTIFIER);    // not null


            // order: TABLE_TYPE
            // true PK
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_TABLETYPES].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName

            // ------------------------------------------
            addColumn(t, "INTERVAL_PRECISION", Type.SQL_INTEGER);


            // order:  DATA_TYPE, TYPE_NAME
            // true primary key
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_TYPEINFO].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, new int[] {
                1, 0

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName

            addColumn(t, "DATA_TYPE", Type.SQL_INTEGER);
            addColumn(t, "REMARKS", CHARACTER_DATA);
            addColumn(t, "BASE_TYPE", Type.SQL_SMALLINT);


            //
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_UDTS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, null, false);

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName

            addColumn(t, "TABLE_CAT", SQL_IDENTIFIER);
            addColumn(t, "TABLE_SCHEM", SQL_IDENTIFIER);
            addColumn(t, "TABLE_NAME", SQL_IDENTIFIER);          // not null


            // -----------------------------------------------------------------
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_VERSIONCOLUMNS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, null, false);

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName


        if (initialSchema != null) {
            return initialSchema;
        }


        HsqlName schema =
            granteeManager.database.schemaManager.findSchemaHsqlName(
                getNameString());


        if (schema == null) {
            return granteeManager.database.schemaManager

View Full Code Here

Examples of org.hsqldb.HsqlNameManager.HsqlName

            addColumn(t, "ADMIN", Type.SQL_BOOLEAN);
            addColumn(t, "INITIAL_SCHEMA", SQL_IDENTIFIER);


            // order: USER
            // true PK
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_USERS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, true);


            return t;
        }


        PersistentStore store = session.sessionData.getRowStore(t);


        // Intermediate holders
        HsqlArrayList users;
        User          user;
        Object[]      row;
        HsqlName      initialSchema;


        // Initialization
        users = database.getUserManager().listVisibleUsers(session);


        // Do it.

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.