Infinispan preload data from database table
How to preload data to infinispan local cache? I have a pre-existing application table that has key value pairs. I want infinispan to cache the data in the table and when i read/write data to cache, i want the underlying table to be in sync. Is it possible with infinispan?
Infinispan stores the entries in SQL DB in a marshalled form (as there is no generic mapping between POJOs and SQL), and also needs to keep some metadata along. That's why the JDBC stores can't access existing DB structure.
There's also the JPA store which uses Hibernate ORM to access the DB and "marshall" the entries according to the JPA specification. So this may be an option for you.