Right now, I start a cluster remotely with an XML file. Then, I start another node locally and programmatically with C# that connects to an underlying Oracle database in order to load the cache with data. The entries in the cache are key-value pairs, where the key is an Associate ID and the value is the entire Associate object.
My objective is to be able to query the data in cache. The steps I've done so far was to annotate the fields in the value class definition with the @QuerySqlField annotation in Associate.cs , instantiate the QueryEntity in CacheConfiguration in Program.cs, and perform a query using SqlFieldsQuery in Program.cs
The error that I'm running into is:
'Failed to parse query. Table "DEFAULT" not found; SQL statement:
SELECT Associate_ID FROM default [42102-197]'
Am I running into this error because my entries are in key-value pairs? Do I need to organize the entries in my cache into a SQL table?