Mailing-List: contact dev-help@oodt.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@oodt.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: "Mattmann, Chris A (388J)" <chris.a.mattmann@jpl.nasa.gov>
To: "<oodt-dev@list.jpl.nasa.gov>" <oodt-dev@list.jpl.nasa.gov>
CC: "user@oodt.apache.org" <user@oodt.apache.org>,
        "<dev@oodt.apache.org>"
	<dev@oodt.apache.org>
Subject: Re: [oodt-dev] Limitation using Oracle as Data Source for File
 Manager
Thread-Topic: [oodt-dev] Limitation using Oracle as Data Source for File
 Manager
Thread-Index: 
 AQHNQpdh6RQOZ7AARkuWOZ28V6fCAJbrKviAgAAIVACAAG2oAIAAk+GAgAHT3oCAAALGAA==
Date: Wed, 6 Jun 2012 17:56:11 +0000
Message-ID: <25B8F9BD-7907-4D42-8683-1848439CD749@jpl.nasa.gov>
References: <CBF4DE8E.135DD%clwong@jpl.nasa.gov>
In-Reply-To: <CBF4DE8E.135DD%clwong@jpl.nasa.gov>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-ID: <C275ACF52D978B44A27DC327FDDBBBCF@ad.jpl>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hi Cynthia,

Did you check out the inheritance hierarchy for the MappedDataSourceCatalog=
 in code?
I believe it sub-classes DataSourceCatalog, so therein lies the answer.

I'm assuming also that you are talking about the to-be-contributed work in =
OODT-393 [1]
that Michael Starch proposed. That hasn't been contributed to Apache yet, b=
ut I think
Michael is working on it. You may want to comment on that issue and ping hi=
m.

Thanks!

Cheers,
Chris

[1] http://issues.apache.org/jira/browse/OODT-393

On Jun 6, 2012, at 10:46 AM, Wong, Cynthia L (388J) wrote:

> Chris,
>=20
> Another question comes up. If I apply MappedDataSourceCatalog, will this
> work with the flat database tables implementation aka
> ColumnBasedDataSourceCatalog?
>=20
> Thanks,
> Cynthia
>=20
>=20
>=20
> On 6/5/12 6:51 AM, "Wong, Cynthia L (388J)" <cynthia.l.wong@jpl.nasa.gov>
> wrote:
>=20
>> Chris,
>>=20
>> Thank you for looking up the information. This does provide a solution
>> that I'm looking for.
>>=20
>> Cynthia
>>=20
>> On 6/4/12 10:03 PM, "Mattmann, Chris A (388J)"
>> <chris.a.mattmann@jpl.nasa.gov> wrote:
>>=20
>>> [cc /Apache lists]
>>>=20
>>> Hey Cynthia,
>>>=20
>>> See this file:=20
>>>=20
>>> http://s.apache.org/Tds
>>>=20
>>> 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.
>>>=20
>>> To enable the catalog, per http://s.apache.org/Jkh
>>>=20
>>> Change:
>>>=20
>>> # catalog factory
>>> filemgr.catalog.factory=3Dorg.apache.oodt.cas.filemgr.catalog.LuceneCat=
alog
>>> F
>>> actory
>>>=20
>>> to:
>>>=20
>>> # catalog factory
>>> filemgr.catalog.factory=3Dorg.apache.oodt.cas.filemgr.catalog.MappedDat=
aSou
>>> r
>>> ceCatalogFactory
>>>=20
>>> And then set:
>>>=20
>>> # mapped data source catalog configuration
>>> org.apache.oodt.cas.filemgr.catalog.mappeddatasource.mapFile=3D/path/to=
/ops
>>> .
>>> catalog.typemap.properties
>>>=20
>>> The existing data source properties (JDBC url, etc.) will be inherited
>>> from the default
>>> DataSourceCatalog properties.
>>>=20
>>> HTH!
>>>=20
>>> Cheers,
>>> Chris
>>>=20
>>>=20
>>> On Jun 4, 2012, at 3:29 PM, Wong, Cynthia L (388J) wrote:
>>>=20
>>>> Chris,
>>>>=20
>>>> That's good to know. Is there any example that shows how to use and se=
t
>>>> 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?
>>>>=20
>>>> Thanks,
>>>> Cynthia
>>>>=20
>>>>=20
>>>>=20
>>>> On 6/4/12 3:00 PM, "Mattmann, Chris A (388J)"
>>>> <chris.a.mattmann@jpl.nasa.gov> wrote:
>>>>=20
>>>>> Hi Cynthia,
>>>>>=20
>>>>> Scope out the MappedDataSourceCatalog :)
>>>>>=20
>>>>> It will get you around this...
>>>>>=20
>>>>> Cheers,
>>>>> Chris
>>>>>=20
>>>>> On Jun 4, 2012, at 2:17 PM, Wong, Cynthia L (388J) wrote:
>>>>>=20
>>>>>> Hello, all,
>>>>>>=20
>>>>>> 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:
>>>>>>=20
>>>>>> [Product Type Name]_REFERENCE for tracking location references of th=
e
>>>>>> stored files
>>>>>> [Product Type Name]_METADATA for metadata about stored files
>>>>>>=20
>>>>>> 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?
>>>>>>=20
>>>>>> Thanks,
>>>>>> Cynthia
>>>>>>=20
>>>>>>=20
>>>>>=20
>>>>>=20
>>>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>>> Chris Mattmann, Ph.D.
>>>>> Senior Computer Scientist
>>>>> NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
>>>>> Office: 171-266B, Mailstop: 171-246
>>>>> Email: chris.a.mattmann@nasa.gov
>>>>> WWW:   http://sunset.usc.edu/~mattmann/
>>>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>>> Adjunct Assistant Professor, Computer Science Department
>>>>> University of Southern California, Los Angeles, CA 90089 USA
>>>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>>>=20
>>>>>=20
>>>>=20
>>>>=20
>>>=20
>>>=20
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>> Chris Mattmann, Ph.D.
>>> Senior Computer Scientist
>>> NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
>>> Office: 171-266B, Mailstop: 171-246
>>> Email: chris.a.mattmann@nasa.gov
>>> WWW:   http://sunset.usc.edu/~mattmann/
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>> Adjunct Assistant Professor, Computer Science Department
>>> University of Southern California, Los Angeles, CA 90089 USA
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>=20
>>>=20
>>=20
>=20
>=20


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Chris Mattmann, Ph.D.
Senior Computer Scientist
NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
Office: 171-266B, Mailstop: 171-246
Email: chris.a.mattmann@nasa.gov
WWW:   http://sunset.usc.edu/~mattmann/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Adjunct Assistant Professor, Computer Science Department
University of Southern California, Los Angeles, CA 90089 USA
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++