Consider constructing the id concatenating an extra string for each
document . You can construct that field using the TeplateTransformer.
in the entity owners keep the id as
<field column="id" name="id" template="owners-${owners.id}"/>
and in vets
<field column="id" name="id" template="vets-${vets.id}"/>
or anything else which can make it unique
--Noble
On Fri, May 30, 2008 at 10:05 AM, Shalin Shekhar Mangar
<[EMAIL PROTECTED]> wrote:
> That will happen only if id is the uniqueKey in Solr and the id coming
> from both your tables have same values. In that case, they will
> overwrite each other. You will need a separate uniqueKey (on other
> than id field).
>
> On Fri, May 30, 2008 at 6:34 AM, Julio Castillo <[EMAIL PROTECTED]> wrote:
>> Thanks Shalin,
>> I tried putting everything under the same document (two different unrelated
>> entities), and got a bit further.
>>
>> My problem now appears to be both of them stepping on each other due to "id"
>> conflicts. Currently my id is defined in my schema as
>> <field name="id" type="long" indexed="true" stored="true" required="true"/>
>>
>> Do I have to create a new "id" field?
>>
>> Thanks
>>
>> ** julio
>>
>> -----Original Message-----
>> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, May 29, 2008 11:40 AM
>> To: solr-user@lucene.apache.org
>> Subject: Re: How to describe 2 entities in dataConfig for the DataImporter?
>>
>> Hi Julio,
>>
>> The first data-config is correct.
>>
>> You're running DataImportHandler in debug mode which creates only the first
>> 10 documents by default. You can also add count=N to index only the first N
>> documents. But this is intended only for debugging purposes. If you want to
>> do a full-import just use /dataimport?command=full-import. By default, a
>> full-import automatically cleans and commits.
>>
>> Hope that helps.
>>
>> On Thu, May 29, 2008 at 11:42 PM, Julio Castillo <[EMAIL PROTECTED]>
>> wrote:
>>> I have 2 dB tables unrelated to each other that I want to index.
>>>
>>> I have tried 2 approaches for specifying them in my data-config.xml file.
>>> None of them seem to work (it seems I can only get data for the first
>>> one listed).
>>>
>>> CASE 1)
>>> <dataConfig>
>>> <document name="test">
>>> <entity name="owners" pk="id" query="....">
>>> <field column="id" name="id"/>
>>> <field column=name" name="userName"/>
>>> </entity>
>>> <entity name="vets" pk="id" query="....">
>>> <field column="id" name="id"/>
>>> <field column=name" name="userName"/>
>>> </entity>
>>> </document>
>>> </dataConfig>
>>>
>>> CASE 2)
>>> <dataConfig>
>>> <document name="test-1">
>>> <entity name="owners" pk="id" query="....">
>>> <field column="id" name="id"/>
>>> <field column=name" name="userName"/>
>>> </entity>
>>> </document>
>>> <document name="test-2">
>>> <entity name="vets" pk="id" query="....">
>>> <field column="id" name="id"/>
>>> <field column=name" name="userName"/>
>>> </entity>
>>> </document>
>>> </dataConfig>
>>>
>>> I ran the dataImporter as follows
>>> http://localhost:2455/solr/dataimport?command=full-import&debug=on&ver
>>> bose=t
>>> rue&clean=true&commit=true
>>>
>>> After running Case 1 the output only shows documents under entity:owners.
>>> And an empty reference to entity:vets (no data).
>>>
>>> After running Case 2, the output only shows documents under entity:owners.
>>> No references to entity:vets.
>>>
>>> In either case, I have commented out the entity:owners and I do see
>>> the entity:vets data then.
>>>
>>> Thanks for your assistance
>>>
>>> Julio Castillo
>>>
>>>
>>
>>
>>
>> --
>> Regards,
>> Shalin Shekhar Mangar.
>>
>>
>
>
>
> --
> Regards,
> Shalin Shekhar Mangar.
>
--
--Noble Paul
