5 Replies Latest reply on Oct 20, 2016 4:14 AM by Vladimir Dzhuvinov

    New SQL cache store based on jOOQ

    Vladimir Dzhuvinov Novice

      We recently published a new Infinispan cache store for SQL databases that is an alternative to the existing JPA and JDBC stores.

       

      It is based on jOOQ and ideal for situations when you want to set up an Infinispan cache store for an existing SQL database. It also works for cases when POJO keys / values are getting stored into Infinispan, and they cannot be annotated or transformed for some reason with Hibernate into the desired structure / format.

       

      The Maven coordinates and the complete configuration instructions are given in the JavaDocs:

       

      http://www.javadoc.io/doc/com.nimbusds/infinispan-sql-cache-store/

       

      At present only MySQL, PostgreSQL and H2 are supported.