CachedSqlEntityProcessor not adding fields

[Luis Lebolo]

Hi All,

I'm trying to use CachedSqlEntityProcessor in one of my sub-entities, but
the field never gets populated. I'm using Solr 4.4. The field is a
multi-valued field:

The relevant part of my data-config.xml looks like:



 <!-- This is the root entitiy -->
<entity name="model" query="select * from models" >
 <field column="MODEL_ID" name="id" />
<field column="MODEL_NAME" name="name" />
 <field column="GENDER" name="gender" />
<field column="DESCRIPTION" name="description" />
 <entity name="entity" query="select e.ENTITY_TYPE_ID, et.ENTITY_TYPE from
entities e inner join entity_types et on et.ENTITY_TYPE_ID =
e.ENTITY_TYPE_ID where e.ENTITY_ID = '${model.MODEL_ID}'">
 <field column="ENTITY_TYPE_ID" name="entityTypeId" />
<field column="ENTITY_TYPE" name="entityType" />
 </entity>

<entity name="alias" query="select MODEL_ID as ALIAS_MODEL_ID, ALIAS_NAME
from model_aliases" processor="CachedSqlEntityProcessor"
cacheKey="ALIAS_MODEL_ID" cacheLookup="model.MODEL_ID">
 <field column="ALIAS_NAME" name="aliases" />
</entity>

                        ...
</entity>



Let me know if you need more info. Any ideas appreciated!

Thanks,
Luis