18.8. JPA Cache Store The JPA (Java Persistence API) Cache Store stores cache entries in the database using a formal schema, which allows other applications to read the persisted data and load data provided by other applications into Red Hat JBoss Data Grid. The database should not be used by the other applications concurrently with JBoss Data Grid. Important In Red Hat JBoss Data Grid, JPA cache stores are only supported in Library mode. Report a bug 18.8.1. JPA Cache Store Sample XML Configuration (Library Mode) To configure JPA Cache Stores using XML in Red Hat JBoss Data Grid, add the following configuration to the infinispan.xml file: For details about the elements and parameters used in this sample configuration, see Section 18.2, "Cache Store Configuration Details (Library Mode)" . Report a bug 18.8.2. JPA Cache Store Sample Programmatic Configuration To configure JPA Cache Stores programatically in Red Hat JBoss Data Grid, use the following: The parameters used in this code sample are as follows: The persistenceUnitName parameter specifies the name of the JPA cache store in the configuration file ( persistence.xml ) that contains the JPA entity class. The entityClass parameter specifies the JPA entity class that is stored in this cache. Only one class can be specified for each configuration. Report a bug 18.8.3. Storing Metadata in the Database When storeMetadata is set to true (default value), meta information about the entries such as expiration, creation and modification timestamps, and versioning is stored in the database. JBoss Data Grid stores the metadata in an additional table named __ispn_metadata__ because the entity table has a fixed layout that cannot accommodate the metadata. The structure of this table depends on the database in use. Enable the automatic creation of this table using the same database as the test environment and then transfer the structure to the production database. Procedure 18.7. Configure persistence.xml for Metadata Entities Using Hibernate as the JPA implementation allows automatic creation of these tables using the property hibernate.hbm2ddl.auto in persistence.xml as follows: Declare the metadata entity class to the JPA provider by adding the following to persistence.xml : As outlined, metadata is always stored in a new table. If metadata information collection and storage is not required, set the storeMetadata attribute to false in the JPA Store configuration. Report a bug 18.8.4. Deploying JPA Cache Stores in Various Containers Red Hat JBoss Data Grid's JPA Cache Store implementations are deployed normally for all supported containers, except Red Hat JBoss Enterprise Application Platform. JBoss Data Grid's JBoss EAP modules contain the JPA cache store and related libraries (such as Hibernate). As a result, the relevant libraries are not packaged inside the application, but instead the application refers to the libraries in the JBoss EAP modules that have them installed. These modules are not required for containers other than JBoss EAP. As a result, all the relevant libraries are packaged in the application's WAR / EAR file, such as with the following Maven dependency: Procedure 18.8. Deploy JPA Cache Stores in JBoss EAP 6.3.x and earlier To add dependencies from the JBoss Data Grid modules to the application's classpath, provide the JBoss EAP deployer a list of dependencies in one of the following ways: Add a dependency configuration to the MANIFEST.MF file: Add a dependency configuration to the jboss-deployment-structure.xml file: Procedure 18.9. Deploy JPA Cache Stores in JBoss EAP 6.4 and later Add the following property in persistence.xml : Add the following dependencies to the jboss-deployment-structure.xml : Add any additional dependencies, such as additional JDG modules, are in use add these to the dependencies section in jboss-deployment-structure.xml . Important JPA Cache Store is not supported in Apache Karaf in JBoss Data Grid 6.6. Report a bug

Commands:
<namedCache name="users"> <!-- Insert additional configuration elements here --> <persistence passivation="false"> <jpaStore xmlns="urn:infinispan:config:jpa:6.0" shared="true" preload="true" persistenceUnitName="MyPersistenceUnit" entityClassName="org.infinispan.loaders.jpa.entity.User" /> </persistence> </namedCache>
Configuration cacheConfig = new ConfigurationBuilder().persistence() .addStore(JpaStoreConfigurationBuilder.class) .persistenceUnitName("org.infinispan.loaders.jpa.configurationTest") .entityClass(User.class) .build();
<property name="hibernate.hbm2ddl.auto" value="update"/>
<class>org.infinispan.persistence.jpa.impl.MetadataEntity</class>
<dependency> <groupId>org.infinispan</groupId> <artifactId>infinispan-cachestore-jpa</artifactId> <version>6.4.0.Final-redhat-4</version> </dependency>
Manifest-Version: 1.0 Dependencies: org.infinispan:jdg-6.6 services, org.infinispan.persistence.jpa:jdg-6.6 services
<jboss-deployment-structure xmlns="urn:jboss:deployment-structure:1.2"> <deployment> <dependencies> <module name="org.infinispan.persistence.jpa" slot="jdg-6.6" services="export"/> <module name="org.infinispan" slot="jdg-6.6" services="export"/> </dependencies> </deployment> </jboss-deployment-structure>
<persistence-unit> [...] <properties> <property name="jboss.as.jpa.providerModule" value="application" /> </properties> </persistence-unit>
<jboss-deployment-structure> <deployment> <dependencies> <module name="org.infinispan" slot="jdg-6.6"/> <module name="org.jgroups" slot="jdg-6.6"/> <module name="org.infinispan.persistence.jpa" slot="jdg-6.6" services="export"/> <module name="org.hibernate"/> </dependencies> </deployment> </jboss-deployment-structure>