Get persistence.xml file to query in Intellij Ultimate

Answered

I created a persistence.xml file after I generated a jHipster project and I keep getting this error whenever I try to query:

 

Second-level cache is used in the application, but property hibernate.cache.region.factory_class is not given; please either disable second level cache or set correct region factory using the hibernate.cache.region.factory_class setting and make sure the second level cache provider

`(hibernate-infinispan, e.g.) is available on the classpath.
[2017-05-29 09:30:38] at org.hibernate.cache.internal.NoCachingRegionFactory.buildEntityRegion(NoCachingRegionFactory.java:66)
[2017-05-29 09:30:38] at org.hibernate.cache.spi.RegionFactory.buildEntityRegion(RegionFactory.java:132)
[2017-05-29 09:30:38] at org.hibernate.internal.CacheImpl.determineEntityRegionAccessStrategy(CacheImpl.java:439)
[2017-05-29 09:30:38] at org.hibernate.metamodel.internal.MetamodelImpl.initialize(MetamodelImpl.java:120)
[2017-05-29 09:30:38] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:297)
[2017-05-29 09:30:38] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:445)
[2017-05-29 09:30:38] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:889)
[2017-05-29 09:30:38] at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
[2017-05-29 09:30:38] at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)`

 

I posted this on SOF but with no success. https://stackoverflow.com/questions/44217526/nocacheregionfactoryavailableexception-second-level-cache-is-used-in-the-applic?noredirect=1#comment75454186_44217526 

 

All my eneties are annotated with the following:

 

@Entity
@Table(name = "badge")
@Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
public class Badge implements Serializable {


persistence.xml

<?xml version="1.0" encoding="UTF-8"?>

<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"
version="2.1">
<!-- h2 -->

<persistence-unit name="h2" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
<properties>
<property name="hibernate.archive.autodetection" value="class" />
<property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
<property name="hibernate.connection.driver_class" value="org.h2.Driver" />
<property name="hibernate.connection.url" value="jdbc:h2:./drew/" />
<property name="hibernate.connection.user" value="sa" />
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.flushMode" value="FLUSH_AUTO" />
<property name="hibernate.hbm2ddl.auto" value="update" />
</properties>
</persistence-unit>

</persistence>
0
2 comments

It is known issue for Hibernate/JPA Console, please follow the https://youtrack.jetbrains.com/issue/IDEA-166811

0

It is a known issue so how can I fix it on my end? I am trying to run a complex query and need to test it. 

0

Please sign in to leave a comment.