Derby
  1. Derby
  2. DERBY-6022

Add a system procedure for (un)registering optional packages of Derby tools.

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: 10.10.1.1
    • Component/s: SQL, Tools
    • Labels:
      None
    • Urgency:
      Normal

      Description

      Now that vararg routines have been added to Derby (see DERBY-3069), I would like to add a new vararg system procedure for registering and unregistering optional packages of Derby tools. For starters, these would be tools which aren't checked into the Derby codeline but are just attached to various JIRAs. These tools are:

      o DBMDWrapper (DERBY-3973 and DERBY-5967) - This tool creates functions and table functions for all of the DatabaseMetaData methods so that you can write complicated queries which join and filter JDBC metadata.

      o ForeignTableVTI (DERBY-4962) - This tool creates views against foreign databases so that you can bulk-import foreign data into Derby without indirecting through csv files.

      It also may be possible to use this approach to expose the log and data file reading tools attached to DERBY-5195 and DERBY-5201.

      The new system procedure would look like this:

      create procedure syscs_util.syscs_register_tool
      (
      toolName varchar( 32672 ),
      boolean register,
      optionalArgs varchar( 32672 ) ...
      )
      language java parameter style derby modifies sql data
      external name 'willFigureOutWhereToPutThis';

      The arguments would have these meanings:

      o toolName - A name specific to the tool.

      o register - True means "register the tool" and false means "unregister the tool".

      o optionalArgs - Each tool could have its own variable set of additional configuration parameters.

      By default, only the DBO could run this procedure. The DBO could grant execute permission to other users.

      The known tool names and their optional parameters would be documented in the Derby Reference Manual in the section on syscs_util.syscs_register_tool.

      I am thinking that we should put the optional tools themselves in derbytools.jar. We might want to document all of the optional tools in the Tools Guide, although I can see arguments for documenting some tools in the Admin Guide.

      I would appreciate other people's thoughts about this proposal.

      Thanks,
      -Rick

      1. derby-6022-01-aa-registerToolProc.diff
        17 kB
        Rick Hillegas
      2. derby-6022-02-aa-dbmdWrapper.diff
        50 kB
        Rick Hillegas
      3. derby-6022-03-aa-foreignDBviews.diff
        49 kB
        Rick Hillegas
      4. derby-6022-04-aa-customTool.diff
        19 kB
        Rick Hillegas
      5. derby-6022-05-aa-schemaNotCreatedYet.diff
        2 kB
        Rick Hillegas
      6. derby-6022-06-aa-optimizerTracing.diff
        4 kB
        Rick Hillegas
      7. derby-6022-07-aa-optimizerTracingWithLogFile.diff
        3 kB
        Rick Hillegas

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-5201 [ DERBY-5201 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-3973 [ DERBY-3973 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-5195 [ DERBY-5195 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-5967 [ DERBY-5967 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-4962 [ DERBY-4962 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-3069 [ DERBY-3069 ]
          Rick Hillegas made changes -
          Attachment derby-6022-01-aa-registerToolProc.diff [ 12562908 ]
          Rick Hillegas made changes -
          Attachment derby-6022-02-aa-dbmdWrapper.diff [ 12562958 ]
          Rick Hillegas made changes -
          Attachment derby-6022-03-aa-foreignDBviews.diff [ 12563980 ]
          Rick Hillegas made changes -
          Attachment derby-6022-04-aa-customTool.diff [ 12564191 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-6040 [ DERBY-6040 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4415 [ DERBY-4415 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-6042 [ DERBY-6042 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Attachment derby-6022-06-aa-optimizerTracing.diff [ 12572825 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-837 [ DERBY-837 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Link This issue relates to DERBY-6211 [ DERBY-6211 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-6219 [ DERBY-6219 ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.10.1.1 [ 12321550 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4945 [ DERBY-4945 ]
          Gavin made changes -
          Workflow jira [ 12743291 ] Default workflow, editable Closed status [ 12802677 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development