lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Noble Paul നോബിള്‍ नोब्ळ् <noble.p...@corp.aol.com>
Subject Re: Use the same SQL Field in Dataimporthandler twice?
Date Tue, 09 Jun 2009 04:19:02 GMT
On Tue, Jun 9, 2009 at 12:41 AM, gateway0<reiterworld@yahoo.de> wrote:
>
> Thanks for your answer.
>
> "${db.tableA.id}" that specifies the sql query that the Dataimporthandler
> should Use the sql field "id" in table "tableA" located in Database "db".

The naming convention does not work like that.

if the entity name is 'tableA' then the field 'id' is addressed as 'tableA.id'

As I said earlier, if you could privide mw with the entire
data-config.xml it would be more helpful

>
> like in the example from the Solr Wiki:
> "
> <entity name="item_category" query="select CATEGORY_ID from item_category
> where item_id='${item.ID}'">
> "
>
> It´s strange I know but when I use something other than "id" as the foreign
> key for the query everything works!
>
> like:
> "${db.tableA.anotherid}"
>
>
>
> Noble Paul നോബിള്‍  नोब्ळ्-2 wrote:
>>
>> what is ${db.tableA.id} ?
>>
>> I think there is something extra in that
>>
>> can you paste the whole data-config.xml?
>>
>> can you paste
>>
>> On Sun, Jun 7, 2009 at 1:09 AM, gateway0<reiterworld@yahoo.de> wrote:
>>>
>>> Hi,
>>>
>>> I tried to do the following:
>>>
>>> "
>>> <field column="id" name="db_id"/>
>>>
>>> <entity name="comment" dataSource="db" query="select com_text from
>>> comment
>>> where ftype=1 and fid='${db.tableA.id}' ">
>>>        <field column="com_text" name="comment"/>
>>> </entity>
>>> "
>>>
>>> So I use the SQL Table Field "id" twice once for "db_id" in my index and
>>> for
>>> the sql query as "fid=id".
>>>
>>> That doesn´t work!
>>>
>>> But when I change the query from "fid=id" to like "fid=otherkey" it does
>>> work!
>>> Like:
>>> "
>>> <field column="id" name="db_id"/>
>>>
>>> <entity name="comment" dataSource="db" query="select com_text from
>>> comment
>>> where ftype=1 and fid='${db.tableA.otherkey}' ">
>>>        <field column="com_text" name="comment"/>
>>> </entity>
>>> "
>>>
>>> Is there any other kind of a workaround so I can use the SQL Field "id"
>>> twice as I wanted to? Thanks
>>>
>>> kind regards, Sebastian
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23904968.html
>>> Sent from the Solr - User mailing list archive at Nabble.com.
>>>
>>>
>>
>>
>>
>> --
>> -----------------------------------------------------
>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23930286.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>



-- 
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com

Mime
View raw message