Hi Mike, On Apr 4, 2012, at 1:00 PM, Starch, Michael D (388L) wrote:
> All, > > I am currently working on designing a catalog implementation that interacts > with an oracle database for use with the filemanager component. The current > version uses sql that is inline with the java code. However, a recent need > for maintenance to this SQL has highlighted the need to pull the sql into > separate files for easier maintenance. > > What is the preferred way in oodt to store such information and load it? There is a class called SqlScript, here: http://s.apache.org/4As You could feasibly leverage that, but I agree with Brian, in that approach it certainly does make it harder to unit test. Would it be easier to simply factor the SQL out into an abstract interface of MetKeys, static final Strings, and then to reference that in the ColumnOrientedCatalog? Cheers, Chris ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Chris Mattmann, Ph.D. Senior Computer Scientist NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA Office: 171-266B, Mailstop: 171-246 Email: [email protected] WWW: http://sunset.usc.edu/~mattmann/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Adjunct Assistant Professor, Computer Science Department University of Southern California, Los Angeles, CA 90089 USA ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
