We are building an application which will answer API calls by running the input parameters through a rules engine.
Rules will are stored in RDBMS, We are thinking of caching the rules in Infinispan cache.
Rule updates will also be routed through the Infinispan Cache (write-behind).
We are thinking of running Inifinispan cluster and connect to it using hot rod.
For write-behind, since JDBC Cache store doesnt seem to support custom schema, we thought of using JPA CacheStore.
However looks like JPA CacheStore only works in embedded mode and not in remote mode.
Can someone suggest alternative configuration for infinispan, we dont want to run infinispan in embedded mode as our application with rules engine is already
To utilise a custom JDBC schema you will have to create your own store implementation as detailed here and then deploy it to the server. To aid users when creating custom stores we have created the store-archetype. Furthermore, I recommend that you take a look at the JdbcStringBasedStore to get an idea of how a JDBC store can be implemented.