Hello
i am fighting with cacheImpl="SortedMapBackedCache".
I want to refactor my ugly entities and so i try out sub-entities with
caching.
My Problem is that my cached subquery do not return any values from the
select. but why?
thats my entity
<entity name="en1" pk="id" transformer="DateFormatTransformer"
query="SELECT id, product FROM table WHERE product = 'abc'">
<entity name="en2" pk="id" transformer="DateFormatTransformer"
cacheImpl="SortedMapBackedCache"
query=" SELECT id, code FROM table2"
where="id = '${en1.id}'"/>
</entity>
this is very fast an clear and nice... but it does not work. all from table2
is not coming to my index =(
BUT if i remove the line with "cacheImpl="SortedMapBackedCache" all data is
present, but every row is selecte each by each.
i thought that this construct, hopefully replace my ugly big join-query in a
single entity!?
--
View this message in context:
http://lucene.472066.n3.nabble.com/DIH-cacheImpl-SortedMapBackedCache-empty-rows-from-sub-entity-tp4162316.html
Sent from the Solr - User mailing list archive at Nabble.com.
