Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#3 patch to catch sqlexception in initViews method

closed
John Currier
None
5
2010-09-29
2007-06-24
Greg Orlowski
No

If the schema for a single view cannot be inspected due to a permission issue (happened to me with an unused view that referenced an external db's tables, but I did not have permissions to drop the view on the server), an uncaught sqlexception is thrown that kills schemaspy.

You may want to rework my patch, but it would be good to have more fine-grained error handling in your initViews method so the run doesn't crash if a single view cannot be inspected. Rather, give a warning message and move on to the next view.

Discussion

  • John Currier
    John Currier
    2008-07-25

    Logged In: YES
    user_id=1264584
    Originator: NO

    Thanks Greg. I've updated the trunk with a merged version of our two approaches.

     
  • John Currier
    John Currier
    2008-07-25

    • assigned_to: nobody --> johncurrier
     
  • John Currier
    John Currier
    2010-08-17

    • status: open --> pending
     
    • status: pending --> closed
     
  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).