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.

     **/
    private void create_10_3_system_procedures_SYSIBM(
        TransactionController   tc)
        throws StandardException {
        //create 10.3 functions used by LOB methods.
        UUID schema_uuid = getSysIBMSchemaDescriptor().getUUID();
        {
            UUID routine_uuid = null;
            String[] arg_names = null;


            TypeDescriptor[] arg_types = null;


            routine_uuid = createSystemProcedureOrFunction(
                "CLOBCREATELOCATOR",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER, Integer.MAX_VALUE),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR"};


            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER)};


            routine_uuid = createSystemProcedureOrFunction(
                "CLOBRELEASELOCATOR",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                null,
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","SEARCHSTR","POS"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "CLOBGETPOSITIONFROMSTRING",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT, Limits.DB2_LOB_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","SEARCHLOCATOR","POS"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "CLOBGETPOSITIONFROMLOCATOR",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT, Limits.DB2_LOB_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "CLOBGETLENGTH",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT, Limits.DB2_LOB_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","POS","LEN"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "CLOBGETSUBSTRING",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, Limits.DB2_VARCHAR_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","POS","LEN","REPLACESTR"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "CLOBSETSTRING",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                null,
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","LEN"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "CLOBTRUNCATE",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                null,
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }


        //Now create the Stored procedures required for BLOB
        {
            UUID routine_uuid = null;
            String[] arg_names = null;


            TypeDescriptor[] arg_types = null;


            routine_uuid = createSystemProcedureOrFunction(
                "BLOBCREATELOCATOR",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER, Integer.MAX_VALUE),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR"};


            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER)};


            routine_uuid = createSystemProcedureOrFunction(
                "BLOBRELEASELOCATOR",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                null,
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","SEARCHBYTES","POS"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARBINARY),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "BLOBGETPOSITIONFROMBYTES",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT, Limits.DB2_LOB_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","SEARCHLOCATOR","POS"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "BLOBGETPOSITIONFROMLOCATOR",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT, Limits.DB2_LOB_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "BLOBGETLENGTH",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT, Limits.DB2_LOB_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","POS","LEN"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "BLOBGETBYTES",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARBINARY, Limits.DB2_VARCHAR_MAXWIDTH),
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","POS","LEN","REPLACEBYTES"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.BIGINT),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.INTEGER),
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARBINARY)
            };
            routine_uuid = createSystemProcedureOrFunction(
                "BLOBSETBYTES",
                schema_uuid,
                arg_names,
                arg_types,
                0,
                0,
                RoutineAliasInfo.CONTAINS_SQL,
                null,
                tc,
                "org.apache.derby.impl.jdbc.LOBStoredProcedure");
        }
        {
            UUID routine_uuid = null;
            String[] arg_names = {"LOCATOR","LEN"};


            // procedure argument types
            TypeDescriptor[] arg_types = {
                DataTypeDescriptor.getBuiltInDataTypeDescriptor(

View Full Code Here

        // not modified during the creation of the routine
        TypeDescriptor varchar128 =
            DataTypeDescriptor.getBuiltInDataTypeDescriptor(
                    Types.VARCHAR, 128);


        UUID  sysUtilUUID = getSystemUtilSchemaDescriptor().getUUID();
        /* SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(IN SCHEMANAME  VARCHAR(128), 
         * IN TABLENAME    VARCHAR(128), IN FILENAME VARCHAR(32672) , 
         * IN COLUMNDELIMITER CHAR(1),  IN CHARACTERDELIMITER CHAR(1) ,  
         * IN CODESET VARCHAR(128), IN LOBSFILENAME VARCHAR(32672) )
         */

View Full Code Here

     * 
     * If we have a special trigger vti, then we branch off and get
     * its rcl from the trigger table that is waiting for us in
     * the compiler context.
     */
    UUID triggerTableId;
    if ((triggerTableId = getSpecialTriggerVTITableName(lcc, newInvocation.getJavaClassName())) != null)  
    {
      TableDescriptor td = getDataDictionary().getTableDescriptor(triggerTableId);
      resultColumns = genResultColList(td);

View Full Code Here

    }


    DataDescriptorGenerator ddg = dd.getDataDescriptorGenerator();


    String  id_S;
    UUID    id;
    String  schemaId_S;
    UUID    schemaId;
    String  name;
    long     generationId;
    DataValueDescriptor  col;


    SchemaDescriptor  schemaDescriptor;

View Full Code Here

        "Wrong number of columns for a SYSDEPENDS row");
    }


    DataValueDescriptor  col;
    String        dependentIDstring;
    UUID        dependentUUID;
    DependableFinder  dependentBloodhound;
    String        providerIDstring;
    UUID        providerUUID;
    DependableFinder  providerBloodhound;


    /* 1st column is DEPENDENTID (UUID - char(36)) */
    col = row.getColumn(SYSDEPENDS_DEPENDENTID);
    dependentIDstring = col.getString();

View Full Code Here

      {
        continue;
      }


      TableDescriptor  pktd = refcd.getTableDescriptor();
      UUID pkuuid = refcd.getIndexId();
      ConglomerateDescriptor pkIndexConglom = pktd.getConglomerateDescriptor(pkuuid);


      TableDescriptor refTd = cd.getTableDescriptor();
      fkVector.addElement(new FKInfo(
                  fkNames,              // foreign key names

View Full Code Here


    char        cAliasType;
    char        cNameSpace;
    DataValueDescriptor  col;
    String        aliasID;
    UUID        aliasUUID;
    String        aliasName;
    String        javaClassName;
    String        sAliasType;
    String        sNameSpace;
    String        typeStr;
    boolean        systemAlias = false;
    AliasInfo      aliasInfo = null;


    /* 1st column is ALIASID (UUID - char(36)) */
    col = row.getColumn(SYSALIASES_ALIASID);
    aliasID = col.getString();
    aliasUUID = getUUIDFactory().recreateUUID(aliasID);


    /* 2nd column is ALIAS (varchar(128)) */
    col = row.getColumn(SYSALIASES_ALIAS);
    aliasName = col.getString();


    /* 3rd column is SCHEMAID (UUID - char(36)) */
    col = row.getColumn(SYSALIASES_SCHEMAID);
    UUID schemaUUID = col.isNull() ? null : getUUIDFactory().recreateUUID(col.getString());


    /* 4th column is JAVACLASSNAME (longvarchar) */
    col = row.getColumn(SYSALIASES_JAVACLASSNAME);
    javaClassName = col.getString();

View Full Code Here

    initInfo( COLUMN_COUNT, TABLENAME_STRING, indexColumnPositions, indexUniqueness, uuids);
  }


  public ExecRow makeRow(TupleDescriptor td, TupleDescriptor parent) throws StandardException
  {
    UUID oid;
        String routinePermID = null;
        DataValueDescriptor grantee = null;
        DataValueDescriptor grantor = null;
        String routineID = null;
        
        if( td == null)
        {
            grantee = getNullAuthorizationID();
            grantor = getNullAuthorizationID();
        }
        else
        {
            RoutinePermsDescriptor rpd = (RoutinePermsDescriptor) td;
            oid = rpd.getUUID();
            if ( oid == null )
            {
        oid = getUUIDFactory().createUUID();
        rpd.setUUID(oid);
            }
            routinePermID = oid.toString();
            grantee = getAuthorizationID( rpd.getGrantee());
            grantor = getAuthorizationID( rpd.getGrantor());
            if( rpd.getRoutineUUID() != null)
                routineID = rpd.getRoutineUUID().toString();
        }

View Full Code Here

        if( SanityManager.DEBUG)
            SanityManager.ASSERT( row.nColumns() == COLUMN_COUNT,
                                  "Wrong size row passed to SYSROUTINEPERMSRowFactory.buildDescriptor");


        String routinePermsUUIDString = row.getColumn(ROUTINEPERMSID_COL_NUM).getString();
        UUID routinePermsUUID = getUUIDFactory().recreateUUID(routinePermsUUIDString);
        String aliasUUIDString = row.getColumn( ALIASID_COL_NUM).getString();
        UUID aliasUUID = getUUIDFactory().recreateUUID(aliasUUIDString);


        RoutinePermsDescriptor routinePermsDesc =
          new RoutinePermsDescriptor( dataDictionary,
                    getAuthorizationID( row, GRANTEE_COL_NUM),
                    getAuthorizationID( row, GRANTOR_COL_NUM),

View Full Code Here

    DataValueDescriptor    col;
    DataDescriptorGenerator ddg;
    ReferencedColumns  referencedColumns;
    String        constraintText;
    String        constraintUUIDString;
    UUID        constraintUUID;


    ddg = dd.getDataDescriptorGenerator();


    /* 1st column is CONSTRAINTID (UUID - char(36)) */
    col = row.getColumn(SYSCHECKS_CONSTRAINTID);

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.