[cc /Apache lists] Hey Cynthia,
See this file: http://s.apache.org/Tds Pretty self-explanatory really. The left side is the Product Type name and the right side of the equals sign is the mapped Oracle table name. If you define a mapping in this file it will be used, otherwise the default ProductTypeName_reference and ProductTypeName_metadata will be used. To enable the catalog, per http://s.apache.org/Jkh Change: # catalog factory filemgr.catalog.factory=org.apache.oodt.cas.filemgr.catalog.LuceneCatalogFactory to: # catalog factory filemgr.catalog.factory=org.apache.oodt.cas.filemgr.catalog.MappedDataSourceCatalogFactory And then set: # mapped data source catalog configuration org.apache.oodt.cas.filemgr.catalog.mappeddatasource.mapFile=/path/to/ops.catalog.typemap.properties The existing data source properties (JDBC url, etc.) will be inherited from the default DataSourceCatalog properties. HTH! Cheers, Chris On Jun 4, 2012, at 3:29 PM, Wong, Cynthia L (388J) wrote: > Chris, > > That's good to know. Is there any example that shows how to use and set up > MappedDataSourceCatalog? However, we actually would like to avoid > maintaining the mapping. Can we apply MappedDataSourceCatalog only to the > long product type names and not other types? > > Thanks, > Cynthia > > > > On 6/4/12 3:00 PM, "Mattmann, Chris A (388J)" > <chris.a.mattm...@jpl.nasa.gov> wrote: > >> Hi Cynthia, >> >> Scope out the MappedDataSourceCatalog :) >> >> It will get you around this... >> >> Cheers, >> Chris >> >> On Jun 4, 2012, at 2:17 PM, Wong, Cynthia L (388J) wrote: >> >>> Hello, all, >>> >>> We've recently switched from MySQL to Oracle. Migrating the File >>> Catalog from MySQL to Oracle has triggered a problem. Oracle has a >>> limitation of 30 characters for table names. File Manager's >>> implementation assign table names as the following: >>> >>> [Product Type Name]_REFERENCE for tracking location references of the >>> stored files >>> [Product Type Name]_METADATA for metadata about stored files >>> >>> Note that "_REFERENCE" contains 10 characters already and therefore >>> there is a limitation of 20 characters for ProductTypeName. I'm >>> wondering if anyone has encountered this restriction. Is there a >>> workaround? >>> >>> Thanks, >>> Cynthia >>> >>> >> >> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> Chris Mattmann, Ph.D. >> Senior Computer Scientist >> NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA >> Office: 171-266B, Mailstop: 171-246 >> Email: chris.a.mattm...@nasa.gov >> WWW: http://sunset.usc.edu/~mattmann/ >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> Adjunct Assistant Professor, Computer Science Department >> University of Southern California, Los Angeles, CA 90089 USA >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> >> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Chris Mattmann, Ph.D. Senior Computer Scientist NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA Office: 171-266B, Mailstop: 171-246 Email: chris.a.mattm...@nasa.gov WWW: http://sunset.usc.edu/~mattmann/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Adjunct Assistant Professor, Computer Science Department University of Southern California, Los Angeles, CA 90089 USA ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++