1. Derby
  2. DERBY-3954

dblook scripts cannot be relied on to recreate the permissions and schema objects of a database


    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s:,
    • Fix Version/s: None
    • Component/s: Tools
    • Urgency:


      The Tools Guide is unclear about what you can expect dblook to do for you. The top level section on dblook makes the modest claim that you can use dblook to view the schema of a database--no claim is made that the view is consistent or usable. However, the later section "Generating the DDL for a database" suggests that you can recreate your database using the script produced by dblook. It would not be unreasonable for a user to try to do this.

      However, the following problems mean that you can't rely on the script produced by dblook:

      1) No attempt is made to sort objects according to their dependencies. For instance, foreign key tables might be declared before the primary key tables which they reference.

      2) No attempt is made to interleave object creation with privilege and role grants and there is no support for setting the session to the correct user id and role needed to make the DDL succeed and register the correct dependencies.

      3) Bugs related to function resolution (see DERBY-3944, DERBY-3955, and DERBY-3953) mean that TABLE and VIEW DDL may fail.

        Issue Links


          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-3868 [ DERBY-3868 ]
          Kathey Marsden made changes -
          Component/s Tools [ 11414 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-3944 [ DERBY-3944 ]
          Myrna van Lunteren made changes -
          Affects Version/s [ 12313771 ]
          Affects Version/s [ 12313010 ]
          Kristian Waagan added a comment -

          Triaged July 3, 2009: Assigned normal urgency.

          Kristian Waagan added a comment - Triaged July 3, 2009: Assigned normal urgency.
          Kristian Waagan made changes -
          Urgency Normal
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Gavin made changes -
          Workflow jira [ 12446576 ] Default workflow, editable Closed status [ 12798787 ]


            • Assignee:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              1 Start watching this issue


              • Created: