[dtp-dev] Updated Generic JDBC Catalog Loader

[rcernich@xxxxxxxxxx]

Hey all,

I've updated the generic JDBC catalog loader to use the new catalog loader
classes.  As mentioned previously, these classes may be reused within other
catalog loaders that may not be able to extend the generic JDBC catalog
elements (e.g. if you've specialized a model element).  Note, some of the
cleanup code in the catalog loader classes is not complete (e.g. they don't
attempt to clean up any references to the objects being removed).

As part of this work, I've enhanced the generic JDBC catalog loader to
support loading of stored procedures and user defined functions.  There is
also support for user defined types, although this work is not yet complete
(they udt elements are created, but they are not yet populated with their
attribute definitions).  You should find that the generic functionality is
more complete, making it more usable.  Your results may vary depending on
how well your driver supports the JDBC catalog meta-data APIs.  Still to do
is add support for loading UDT attributes and super types and table super
tables.

I've also included updates to support the Catalog object that was recently
added to the base SQL model (the loader enhancements mentioned above work
with Catalog's).

I've tested the code on a variety of databases to verify that the old
functionality is still there and that the new functionality works.  Please
fill out a BZ against connectivity if you find any defects or regressions.

Have fun,
Rob