I managed to do that by using TemplateTransformer
<document>
<entity name="company"..... transformer="TemplateTransformer">
<field column="id" name="id" template="company-${company.id}" />
...
<entity name="item"..... transformer="TemplateTransformer">
<field column="id" name="id" template="item-${item.id}" />
...
</document>
Only problem is that delta import fails to perform delete to the
index. It seems that TemplateTransformer is not used when performing
delete so delete by id doesn't work.
2011/1/4 yu shen <shenyu...@gmail.com>:
> Hi All,
>
> I have a dataimporthandler config file as below. It contains multiple
> entities:
> <dataConfig>
> <dataSource name="jdbc" driver="com.mysql.jdbc.Driver"
>
> url="jdbc:mysql://localhost:1521/changan?useUnicode=true&characterEncoding=utf8&autoReconnect=true"...
> />
> <document>
> <entity name="item" dataSource="jdbc" pk="id" query="...">
> <entity name="company" dataSource="jdbc" pk="id" query="">
> ....
> </document>
> </dataConfig>
>
> All data are from a database. Problem is item/company and other entity all
> have the field 'id', with value start from 1 to n. In this case,
> item/company etc. will step into each other.
> Is there a way to prevent is from happening. Such as designate different
> entity to different partition.
>
> One way I can think of is to seperate different entity to different
> instance, which is not ideal solution IMO.
>
> Would some one point me to a reference? And also give some instructions?
>
