Yes, you can have several indexes. 'indexes' property is a collection: <property name="indexes"> <list> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg value="id"/> </bean> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg value="name"/> </bean> </list> </property>
Also note that if you provide query entities configuration in the XML, the annotations and setIndexedTypes do not take effect. Can this be the reason for your issue. As for getAll(), I'm not sure I understand. What so you mean by getting IDs dynamically? getAll method accepts a collection of keys, which you can obviously create on the fly. Can you clarify what's the issue here? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Getting-exception-in-SQL-Query-JOINS-tp6674p6723.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.