Hibernate DialectFactory cannot determine "hibernate.dialect" for PostgresPlus 9.2 (EnterpriseDB). ... org.hibernate.HibernateException: Unable to determine Dialect to use [name=EnterpriseDB, majorVersion=9]; user must register resolver or explicitly set 'hibernate.dialect' at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:105) [hibernate-core-4.1.6.Final.jar:4.1.6.Final] at ... As a workaroud, IDM datasource dialect may be set manually to "org.hibernate.dialect.PostgresPlusDialect".
We'll need to check if this can be fixed by Hibernate upgrade (Vlasta tried with 4.2.1 already). If there is no easy fix it should be documented as a known issue with workaround to set the dialect manually.
I've tried to run the JPP ER02 with the configuration used in the QA: https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.1/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_postgresplus92/ The exception described above wasn't raised even if I changed the configuration to: gatein.jcr.datasource.dialect=auto Instead of this problem, there is a new one and is related to the jdbc driver: https://bugzilla.redhat.com/show_bug.cgi?id=979528 Switching the hibernate version to 4.2.2 didn't affect this bug in any way. By switching I mean replacing these libs in modules: ./modules/system/layers/base/org/hibernate/main/hibernate-entitymanager-4.2.0.Final-redhat-1.jar ./modules/system/layers/base/org/hibernate/main/hibernate-core-4.2.0.Final-redhat-1.jar ./modules/system/layers/base/org/hibernate/main/hibernate-infinispan-4.2.0.Final-redhat-1.jar ./modules/system/layers/base/org/hibernate/envers/main/hibernate-envers-4.2.0.Final-redhat-1.jar
I was using the "edb-jdbc14.jar" driver.
I still reproduced this issue with ER2 (and also with the latest gatein-master). I still get the "Unable to determine Dialect to use [name=EnterpriseDB, majorVersion=9]" exception if I don't set the dialect for JCR datasource explicitly.
FYI: https://hibernate.atlassian.net/browse/HHH-8349
I've inspected this bug again and configured it to pg+ from scratch. I was able to reproduce the issue and I'm getting the same error as tkyjovsky. After specifying the dialect in: gatein/gatein.ear/portal.war/WEB-INF/conf/organization/idm-configuration.xml by adding <property name="hibernate.dialect" value="org.hibernate.dialect.PostgresPlusDialect"/> I'm not getting the dialect error anymore, and I have this one instead: https://bugzilla.redhat.com/show_bug.cgi?id=979528 Switching the hibernate version to 4.2.2 didn't affect this bug in any way.
Tomas Kyjovsky <tkyjovsk> updated the status of jira GTNPORTAL-2960 to Resolved