Examples of org.apache.derby.catalog.UUID

org.apache.derby.catalog.UUID
An interface for accessing Cloudscape UUIDs, unique identifiers.
The values in the system catalog held in ID columns with a type of CHAR(36) are the string representations of these UUIDs.
A UUID implements equals() and hashCode based on value equality.

      */
      int[] columnsToSet = new int[2];
      columnsToSet[0] = SYSCOLUMNSRowFactory.SYSCOLUMNS_COLUMNDATATYPE;
      columnsToSet[1] = SYSCOLUMNSRowFactory.SYSCOLUMNS_COLUMNDEFAULT;


      UUID uuid = spsd.getUUID();


      for (int index = 0; index < params.length; index++)
      {
        int parameterId = index + 1;

View Full Code Here

  public void dropStoredDependency(DependencyDescriptor dd,
                  TransactionController tc )
        throws StandardException
  {
    ExecIndexRow      keyRow1 = null;
    UUID          dependentID = dd.getUUID();
    UUID          providerID = dd.getProviderID();
    DataValueDescriptor    dependentIDOrderable = getIDValueAsCHAR(dependentID);
    TabInfoImpl          ti = getNonCoreTI(SYSDEPENDS_CATALOG_NUM);


    /* Use dependentIDOrderable in both start 
     * and stop position for index 1 scan.

View Full Code Here

    CatalogRowFactory  crf = ti.getCatalogRowFactory();


    String        name = ti.getTableName();
    long        conglomId = ti.getHeapConglomerate();
    SystemColumn[]    columnList = crf.buildColumnList();
    UUID        heapUUID = crf.getCanonicalHeapUUID();
    String        heapName = crf.getCanonicalHeapName();
    TableDescriptor    td;
    UUID        toid;
    ColumnDescriptor  cd;
    int          columnCount;
    SystemColumn    column;


    // add table to the data dictionary

View Full Code Here

    throws StandardException                  
  {
    TabInfoImpl ti = coreInfo[SYSCOLUMNS_CORE_NUM];
    ExecIndexRow keyRow = null;
    ExecRow row;
    UUID tableUUID = td.getUUID();


    keyRow = (ExecIndexRow)exFactory.getIndexableRow(2);
    keyRow.setColumn(1, getIDValueAsCHAR(tableUUID));
      keyRow.setColumn(2, new SQLChar(columnName));
    return ti.getRowLocation(tc, keyRow,

View Full Code Here

                                                    //  CONTAINS_SQL
                                                    //  NO_SQL
                true,                               // true - calledOnNullInput
                return_type);


    UUID routine_uuid = getUUIDFactory().createUUID();
        AliasDescriptor ads = 
            new AliasDescriptor(
                this,
                routine_uuid,
                routine_name,

View Full Code Here

    short                   routine_sql_control,
    TypeDescriptor          return_type,
    TransactionController   tc)
        throws StandardException
    {
        UUID routine_uuid = createSystemProcedureOrFunction(routine_name,
        schema_uuid, arg_names, arg_types,
        num_out_param, num_result_sets, routine_sql_control,
        return_type, tc, "org.apache.derby.catalog.SystemProcedures");
        return routine_uuid;
    }

View Full Code Here

    {
        /*
    ** SYSCS_UTIL routines.
    */


    UUID routine_uuid = null;
        // used to put procedure into the SYSCS_UTIL schema
    UUID sysUtilUUID = getSystemUtilSchemaDescriptor().getUUID();




        // void SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
        //     varchar(128), varchar(Limits.DB2_VARCHAR_MAXWIDTH))
        {


            // procedure argument names
            String[] arg_names = {
                "KEY", 
                "VALUE"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, 128),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, Limits.DB2_VARCHAR_MAXWIDTH)
            };


            createSystemProcedureOrFunction(
                "SYSCS_SET_DATABASE_PROPERTY",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.MODIFIES_SQL_DATA,
                (TypeDescriptor) null,
                tc);
        }




        // void SYSCS_UTIL.SYSCS_COMPRESS_TABLE(varchar(128), varchar(128), SMALLINT)
        {
            // procedure argument names
            String[] arg_names = {"SCHEMANAME", "TABLENAME", "SEQUENTIAL"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, 128),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, 128),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.SMALLINT)


            };


            routine_uuid = createSystemProcedureOrFunction(
                "SYSCS_COMPRESS_TABLE",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.MODIFIES_SQL_DATA,
                (TypeDescriptor) null,
                tc);


      createRoutinePermPublicDescriptor(routine_uuid, tc);
        }


        // void SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()
        {
            createSystemProcedureOrFunction(
                "SYSCS_CHECKPOINT_DATABASE",
                sysUtilUUID,
                null,
                null,
        0,
        0,
                RoutineAliasInfo.CONTAINS_SQL,
                (TypeDescriptor) null,
                tc);
        }


        // void SYSCS_UTIL.SYSCS_FREEZE_DATABASE()
        {
            createSystemProcedureOrFunction(
                "SYSCS_FREEZE_DATABASE",
                sysUtilUUID,
                null,
                null,
        0,
        0,
                RoutineAliasInfo.CONTAINS_SQL,
                (TypeDescriptor) null,
                tc);
        }


        // void SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()
        {
            createSystemProcedureOrFunction(
                "SYSCS_UNFREEZE_DATABASE",
                sysUtilUUID,
                null,
                null,
        0,
        0,
                RoutineAliasInfo.CONTAINS_SQL,
                (TypeDescriptor) null,
                tc);
        }


        // void SYSCS_UTIL.SYSCS_BACKUP_DATABASE(varchar Limits.DB2_VARCHAR_MAXWIDTH)
        {
            // procedure argument names
            String[] arg_names = {"BACKUPDIR"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, Limits.DB2_VARCHAR_MAXWIDTH)
            };


            createSystemProcedureOrFunction(
                "SYSCS_BACKUP_DATABASE",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.MODIFIES_SQL_DATA,
                (TypeDescriptor) null,
                tc);
        }


        // void SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE(
        //     varchar Limits.DB2_VARCHAR_MAXWIDTH, smallint)
        {
            // procedure argument names
            String[] arg_names = {"BACKUPDIR", "DELETE_ARCHIVED_LOG_FILES"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, Limits.DB2_VARCHAR_MAXWIDTH),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.SMALLINT)
            };


            createSystemProcedureOrFunction(
                "SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.MODIFIES_SQL_DATA,
                (TypeDescriptor) null,
                tc);
        }


        // void SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(smallint)
        {
            // procedure argument names
            String[] arg_names = {"DELETE_ARCHIVED_LOG_FILES"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.SMALLINT)
            };


            createSystemProcedureOrFunction(
                "SYSCS_DISABLE_LOG_ARCHIVE_MODE",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.MODIFIES_SQL_DATA,
                (TypeDescriptor) null,
                tc);
        }


        // void SYSCS_UTIL.SYSCS_SET_RUNTIMESTTISTICS(smallint)
        {
            // procedure argument names
            String[] arg_names = {"ENABLE"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.SMALLINT)
            };


            routine_uuid = createSystemProcedureOrFunction(
                "SYSCS_SET_RUNTIMESTATISTICS",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.CONTAINS_SQL,
                (TypeDescriptor) null,
                tc);


      createRoutinePermPublicDescriptor(routine_uuid, tc);
        }


        // void SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(smallint)
        {
            // procedure argument names
            String[] arg_names = {"ENABLE"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.SMALLINT)
            };


            routine_uuid = createSystemProcedureOrFunction(
                "SYSCS_SET_STATISTICS_TIMING",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.CONTAINS_SQL,
                (TypeDescriptor) null,
                tc);


      createRoutinePermPublicDescriptor(routine_uuid, tc);
        }




        // SYSCS_UTIL functions
        //
        // TODO (mikem) - 
        // the following need to be functions when that is supported.
        // until then calling them will not work.


        // VARCHAR(Limits.DB2_VARCHAR_MAXWIDTH) 
        // SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(varchar(128))


        {
            // procedure argument names
            String[] arg_names = {"KEY"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, 128)
            };


            createSystemProcedureOrFunction(
                "SYSCS_GET_DATABASE_PROPERTY",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.READS_SQL_DATA,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, Limits.DB2_VARCHAR_MAXWIDTH),
                tc);
        }


        // SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(varchar(128), varchar(128))
        {
            // procedure argument names
            String[] arg_names = {"SCHEMANAME", "TABLENAME"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, 128),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, 128)
            };


            createSystemProcedureOrFunction(
                "SYSCS_CHECK_TABLE",
                sysUtilUUID,
                arg_names,
                arg_types,
        0,
        0,
                RoutineAliasInfo.READS_SQL_DATA,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                tc);
        }


        // CLOB SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()
        {


            routine_uuid = createSystemProcedureOrFunction(
                "SYSCS_GET_RUNTIMESTATISTICS",
                sysUtilUUID,
                null,
                null,
        0,
        0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, Limits.DB2_VARCHAR_MAXWIDTH),


                /*
                TODO - mikem, wants to be a CLOB, but don't know how to do 
                that yet.  Testing it with varchar for now.
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.CLOB, Limits.DB2_LOB_MAXWIDTH),
                */
                tc);


      createRoutinePermPublicDescriptor(routine_uuid, tc);
        }




        /*
    ** SQLJ routine.
    */


    UUID sqlJUUID = 
            getSchemaDescriptor(
                SchemaDescriptor.STD_SQLJ_SCHEMA_NAME, tc, true).getUUID();


    // SQLJ.INSTALL_JAR(URL VARCHAR(??), JAR VARCHAR(128), DEPLOY INT)
    {

View Full Code Here

        /*
    ** SYSIBM routines.
    */


        // used to put procedure into the SYSIBM schema
    UUID sysIBMUUID = getSysIBMSchemaDescriptor().getUUID();




        // SYSIBM.SQLCAMESSAGE(
        {

View Full Code Here

      if (SanityManager.DEBUG) {
      SanityManager.ASSERT((ad != null), "Failed to get AliasDescriptor" 
                      + " of the routine");
      }
      
      UUID routineUUID = ad.getUUID();
      createRoutinePermPublicDescriptor(routineUUID, tc, authorizationID);
    }

View Full Code Here

    TransactionController   tc,
    UUID                    sysUtilUUID)
    throws StandardException
    {


    UUID routine_uuid = null;


        // void SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(
        //     IN SCHEMANAME        VARCHAR(128), 
        //     IN TABLENAME         VARCHAR(128),
        //     IN PURGE_ROWS        SMALLINT,

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.derby.catalog.UUID

org.apache.derby.iapi.sql.depend.DependableList

org.apache.derby.iapi.sql.dictionary.RoutinePermsDescriptor

org.apache.derby.iapi.sql.dictionary.TableDescriptor

org.apache.derby.iapi.sql.dictionary.TriggerDescriptor

org.apache.derby.iapi.types.SQLBoolean

org.apache.derby.impl.db.BasicDatabase

org.apache.derby.impl.services.daemon.IndexStatisticsDaemonImpl

org.apache.derby.impl.sql.catalog.DataDictionaryImpl

org.apache.derby.impl.sql.catalog.DropDependencyFilter

org.apache.derby.impl.sql.catalog.PermissionsCacheable

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.