Re: UniqueKey field in schema.xml

2011-05-26 Thread Romi
Stefen, as u can see template="{torder.UID_PK},${torderattribute.UID_PK} " /> orderUID is a foreignkey for the table torderattribue which maps to UID_PK(pk) of torder. when i run the query "select UID_PK fro

Re: UniqueKey field in schema.xml

2011-05-26 Thread Romi
first, you're missing a $ Sign for the first Variable. second, why not just ? The -Tag has no ID, in case you're using the TemplateTransformer. I got my solution..thanks for it. but after looking your this reply..please make it clear: UID_PK is a column in my database table torderattribute, the

Re: UniqueKey field in schema.xml

2011-05-26 Thread Stefan Matheis
Romi, first, you're missing a $ Sign for the first Variable. second, why not just ? The -Tag has no ID, in case you're using the TemplateTransformer. Regards Stefan Am 26.05.2011 14:16, schrieb Romi: I tried it as : templat

Re: UniqueKey field in schema.xml

2011-05-26 Thread Romi
Thanks a lot :)...finally i made it, template transformer is doing exactly what i wanted to do. :) :) - Romi -- View this message in context: http://lucene.472066.n3.nabble.com/UniqueKey-field-in-schema-xml-tp2987807p2988608.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: UniqueKey field in schema.xml

2011-05-26 Thread Romi
I tried it as : template="{torder.UID_PK},${torderattribute.UID_PK} " /> But i suppose it is not correct because here i am not mapping UID_PK of torderattribute to any of field in schema.xml. can i add like

Re: UniqueKey field in schema.xml

2011-05-26 Thread Stefan Matheis
Romi, then you want to use the http://wiki.apache.org/solr/DataImportHandler#TemplateTransformer ? :) Regards Stefan Am 26.05.2011 13:17, schrieb Romi: i might have misspelled the question. this is the entry in my db-data-config.xml file: now i want combi

Re: UniqueKey field in schema.xml

2011-05-26 Thread Romi
i might have misspelled the question. this is the entry in my db-data-config.xml file: now i want combine UID_PK and UID for the uniqueKey of my indexing documet. i want to know how can i achieve this through schema.xml Thanks Romi - Romi -- View this mes

Re: UniqueKey field in schema.xml

2011-05-26 Thread François Schiettecatte
Here is some code: -- final String key1 = "1"; final String key2 = "2"; final String masterKey = key1 + ":" + key2; -- You need to combine the keys *before* you send them to Solr. François On May 26, 2011, at 7:02 AM, Romi wrote: > I am not getting how can i combine two keys in to a

Re: UniqueKey field in schema.xml

2011-05-26 Thread Romi
I am not getting how can i combine two keys in to a single string using some delimiter - Romi -- View this message in context: http://lucene.472066.n3.nabble.com/UniqueKey-field-in-schema-xml-tp2987807p2988284.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: UniqueKey field in schema.xml

2011-05-26 Thread François Schiettecatte
You concatenate the two keys into a single string, with some sort of delimiter between the two keys. François On May 26, 2011, at 6:05 AM, Romi wrote: > what do you mean by combine two fields customerID and ProductId. > what i tried is > 1. make both fields unique but it doesnot server my pur

Re: UniqueKey field in schema.xml

2011-05-26 Thread Romi
what do you mean by combine two fields customerID and ProductId. what i tried is 1. make both fields unique but it doesnot server my purpose 2. make a new field ID and copy both customerID , ProductId into ID using CopyField and now make ID as uniqueKey but i got a error saying: Document specifie

Re: UniqueKey field in schema.xml

2011-05-26 Thread pravesh
Create a new unique field for this purpose, like, "myUniqueField", then, just combine (product-id+cust-id) and post it to this new field. -- View this message in context: http://lucene.472066.n3.nabble.com/UniqueKey-field-in-schema-xml-tp2987807p2988098.html Sent from the Solr - User mailing list

UniqueKey field in schema.xml

2011-05-26 Thread Romi
suppose I have two tables in database, say product table and customer table.i want to make (productID,customerID) a uniqueKey for my indexing document. how can i achieve this. - Romi -- View this message in context: http://lucene.472066.n3.nabble.com/UniqueKey-field-in-schema-xml-tp2987807p2