Hello, I have been trying to integrate hibernate 4 multi-tenancy support in our application but I get the below exception on executing an hql query java.lang.ArrayIndexOutOfBoundsException: 0 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.resultClassChecking(AbstractEntityManagerImpl.java:362) at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:344) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:344) at com.sun.proxy.$Proxy288.createQuery(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:291) at com.sun.proxy.$Proxy43.createQuery(Unknown Source) The hql query is - List<Field> fields = entityManager.createQuery("from " + Employee.class.getName() + " where " + getQueryForInClause("id", ids), Employee.class).getResultList(); On debugging hibernate source, I realize that this is because hibernate's *SessionFactory instance does not have any entityPersister instances* due to which the hql query does have any translator's. Is it because the Entity beans are not getting scanned? If so what could be the cause? The entityFactory spring is declared as below <property name="persistenceProviderClass" value="org.hibernate.jpa.HibernatePersistenceProvider"/><property name="persistenceXmlLocation" value="/com/software/persistence/persistence.xml"/><property name="jpaProperties"> <map> <entry key="hibernate.id.new_generator_mappings" value="true"/> <entry key="hibernate.cache.use_second_level_cache" value="false"/> <entry key="hibernate.dialect" value="com.software.persistence.ExtendedOracle10gDialect"/> <entry key="hibernate.jdbc.batch_size" value="10"/> <entry key="hibernate.jdbc.batch_versioned_data" value="true"/> <entry key="hibernate.jdbc.batch.builder" value="com.software.persistence.OracleBatchBuilder"/> <entry key="hibernate.multiTenancy" value="DATABASE"/> <entry key="hibernate.tenant_identifier_resolver" value="com.software.persistence.MultitenantIdentifierResolver"/> <entry key="hibernate.multi_tenant_connection_provider" value-ref="multiTenantConnectionProvider" /> </map></property> Thanks, Amit. P.S - Since I am not getting any traction on this on the hibernate user forum, I am re-posting this question on the dev forum. _______________________________________________ hibernate-dev mailing list hibernate-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev

From: "Jitu" <abjitu(a)gmail.com&gt; To: "amit shah" <amits.84(a)gmail.com&gt; Cc: "Hibernate" <hibernate-dev(a)lists.jboss.org&gt; Sent: Wednesday, July 1, 2015 10:06:53 AM Subject: Re: [hibernate-dev] Hibernate 4 Multi-tenancy Issue - No Entity Persisters Found I have tried hibernate 4 multi-tenancy with Spring. Please check if this helps you in anyway https://github.com/abjitu/multitenancy On Wed, Jul 1, 2015 at 10:35 PM, Jitu <abjitu(a)gmail.com&gt; wrote: > As per the exception. it looks like hibernate is not not able to find > querytranslator which means hibernate is not able to translate HQL query to > SQL query. So increase log level to TRACE and provide more logs. > > > On Wed, Jul 1, 2015 at 1:08 PM, amit shah <amits.84(a)gmail.com&gt; wrote: > >> Hello, >> >> I have been trying to integrate hibernate 4 multi-tenancy support in our >> application but I get the below exception on executing an hql query >> >> java.lang.ArrayIndexOutOfBoundsException: 0 >> at >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.resultClassChecking(AbstractEntityManagerImpl.java:362) >> at >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:344) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at >> org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:344) >> at com.sun.proxy.$Proxy288.createQuery(Unknown Source) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at >> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:291) >> at com.sun.proxy.$Proxy43.createQuery(Unknown Source) >> >> The hql query is - >> >> List<Field> fields = entityManager.createQuery("from " + >> Employee.class.getName() + >> " where " + getQueryForInClause("id", ids), >> Employee.class).getResultList(); >> >> On debugging hibernate source, I realize that this is because >> hibernate's *SessionFactory >> instance does not have any entityPersister instances* due to which the hql >> query does have any translator's. >> >> Is it because the Entity beans are not getting scanned? If so what could >> be >> the cause? >> >> The entityFactory spring is declared as below >> >> <property name="persistenceProviderClass" >> value="org.hibernate.jpa.HibernatePersistenceProvider"/><property >> name="persistenceXmlLocation" >> value="/com/software/persistence/persistence.xml"/><property >> name="jpaProperties"> >> <map> >> <entry key="hibernate.id.new_generator_mappings" value="true"/> >> <entry key="hibernate.cache.use_second_level_cache" >> value="false"/> >> <entry key="hibernate.dialect" >> value="com.software.persistence.ExtendedOracle10gDialect"/> >> <entry key="hibernate.jdbc.batch_size" value="10"/> >> <entry key="hibernate.jdbc.batch_versioned_data" value="true"/> >> <entry key="hibernate.jdbc.batch.builder" >> value="com.software.persistence.OracleBatchBuilder"/> >> <entry key="hibernate.multiTenancy" value="DATABASE"/> >> <entry key="hibernate.tenant_identifier_resolver" >> >> value="com.software.persistence.MultitenantIdentifierResolver"/> >> <entry key="hibernate.multi_tenant_connection_provider" >> value-ref="multiTenantConnectionProvider" /> >> </map></property> >> >> Thanks, >> Amit. >> P.S - Since I am not getting any traction on this on the hibernate user >> forum, I am re-posting this question on the dev forum. >> _______________________________________________ >> hibernate-dev mailing list >> hibernate-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/hibernate-dev >> > > _______________________________________________ hibernate-dev mailing list hibernate-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev