Does anyone have an example of using this with SQL Server varchar or XML
field?

??

<dataConfig>
    <dataSource />
    <document>
        <entity name="y" query="select * from y where xid=${x.id}">
            <entity name="x" processor="XPathEntityProcessor"
forEach="/the/record/xpath" url="${y.xml_name}">
                <field column="full_name" xpath="/field/xpath"/>
            </entity>
        </entity>
    </document>
</dataConfig>



On 2/16/11 2:17 AM, "Stefan Matheis" <matheis.ste...@googlemail.com> wrote:

>What about using
>http://wiki.apache.org/solr/DataImportHandler#XPathEntityProcessor ?
>
>On Wed, Feb 16, 2011 at 10:08 AM, Bill Bell <billnb...@gmail.com> wrote:
>> I am using DIH.
>>
>> I am trying to take a column in a SQL Server database that returns an
>>XML
>> string and use Xpath to get data out of it.
>>
>> I noticed that Xpath works with external files, how do I get it to work
>>with
>> a database?
>>
>> I need something like "//insur[5][@name='Blue Cross']"
>>
>> Thanks.
>>
>>
>>


Reply via email to