Sure:
data-config Xml
===============
<dataConfig>
<dataSource driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@xxxxx" user="remedy" password="yyyyy"/>
<document name="remedy">
<entity name="log" transformer="ClobTransformer" query="SELECT
mylog_ato, name_char, dsc FROM log_tbl">
<field column="mylog_ato" name="log_no" />
<field column="name_char" name="short_desc" />
<field column="dsc" clob="true" name="description" />
</entity>
</document>
</dataConfig>
===========
A search result on the field short_desc:
--------------------------------------
<doc>
<float name="score">1.8670129</float>
<str name="description">oracle.sql.c...@155e3ab</str>
<int name="log_no">4486</int>
<str name="short_desc">Develop Rating functionality for QIN</str>
<date name="timestamp">2009-04-03T11:47:32.635Z</date>
</doc>
Noble Paul നോബിള് नोब्ळ् wrote:
>
> There is something else wrong with your setup.
>
> can you just paste the whole data-config.xml
>
> --Noble
>
> On Fri, Apr 3, 2009 at 5:39 PM, ashokc <ash...@qualcomm.com> wrote:
>>
>> Noble,
>> I put in a few 'System.out.println' statements in the
>> ClobTransformer.java
>> file & remade the war. But I see none of these prints coming up in my
>> 'catalina.out' file. Is that the right file to be looking at?
>>
>> As an aside, is 'catalina.out' the ONLY log file for SOLR? I turned on
>> the
>> logging to 'FINE' for everything. Also, these settings seem to go away
>> when
>> Tomcat is restarted.
>> - ashok
>>
>> Noble Paul നോബിള് नोब्ळ् wrote:
>>>
>>> yeah, ant dist will give you the .war file you may need . just drop it
>>> in and you are set to go. or if you can hook up a debugger to a
>>> running Solr that is the easiest
>>> --Noble
>>>
>>> On Fri, Apr 3, 2009 at 9:35 AM, ashokc <ash...@qualcomm.com> wrote:
>>>>
>>>> That would require me to recompile (with ant/maven scripts?) the source
>>>> and
>>>> replace the jar for DIH, right? I can try - for the first time.
>>>> - ashok
>>>>
>>>> Noble Paul നോബിള് नोब्ळ् wrote:
>>>>>
>>>>> This looks strange. Apparently the Transformer did not get applied. Is
>>>>> it possible for you to debug ClobTransformer adding(System.out.println
>>>>> into ClobTransformer may help)
>>>>>
>>>>> On Fri, Apr 3, 2009 at 6:04 AM, ashokc <ash...@qualcomm.com> wrote:
>>>>>>
>>>>>> Correcting my earlier post. It lost some lines some how.
>>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I have set up to import some oracle clob columns with DIH. I am using
>>>>>> the
>>>>>> latest nightly release. My config says,
>>>>>>
>>>>>>
>>>>>> <entity name="log" transformer="ClobTransformer"
>>>>>> ...
>>>>>>
>>>>>> <field column="description" clob="true" name="description" />
>>>>>> ....
>>>>>>
>>>>>> </entity>
>>>>>>
>>>>>> But it does not seem to turn this clob into a String. The search
>>>>>> results
>>>>>> show:
>>>>>>
>>>>>> <doc>
>>>>>> <float name="score">1.8670129</float>
>>>>>> <str name="description">oracle.sql.c...@aed3a5</str>
>>>>>> <int name="log_no">4486</int>
>>>>>> </doc>
>>>>>>
>>>>>> Any pointers on why I do not get the 'string' out of the clob for
>>>>>> indexing?
>>>>>> Is the nightly war NOT the right one to use?
>>>>>>
>>>>>> Thanks for your help.
>>>>>>
>>>>>> - ashok
>>>>>>
>>>>>>
>>>>>>
>>>>>> ashokc wrote:
>>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I have set up to import some oracle clob columns with DIH. I am
>>>>>>> using
>>>>>>> the
>>>>>>> latest nightly release. My config says,
>>>>>>>
>>>>>>> <entity name="description" transformer="ClobTransformer" ... <field
>>>>>>> column="description" clob="true" />
>>>>>>> ....
>>>>>>>
>>>>>>> </entity>
>>>>>>>
>>>>>>> But it does not seem to turn this clob into a String. The search
>>>>>>> results
>>>>>>> show:
>>>>>>>
>>>>>>> <doc>
>>>>>>> <float name="score">1.8670129</float>
>>>>>>> <str name="description">oracle.sql.c...@aed3a5</str>
>>>>>>> <int name="log_no">4486</int>
>>>>>>> </doc>
>>>>>>>
>>>>>>> Any pointers on why I do not get the 'string' out of the clob for
>>>>>>> indexing? Is the nightly war NOT the right one to use?
>>>>>>>
>>>>>>> Thanks for your help.
>>>>>>>
>>>>>>> - ashok
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> View this message in context:
>>>>>> http://www.nabble.com/Oracle-Clob-column-with-DIH-does-not-turn-to-String-tp22859837p22859865.html
>>>>>> Sent from the Solr - User mailing list archive at Nabble.com.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> --Noble Paul
>>>>>
>>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Oracle-Clob-column-with-DIH-does-not-turn-to-String-tp22859837p22861630.html
>>>> Sent from the Solr - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> --Noble Paul
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Oracle-Clob-column-with-DIH-does-not-turn-to-String-tp22859837p22867161.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> --Noble Paul
>
>
--
View this message in context:
http://www.nabble.com/Oracle-Clob-column-with-DIH-does-not-turn-to-String-tp22859837p22872184.html
Sent from the Solr - User mailing list archive at Nabble.com.
