Bug 1078270

Summary:	Dialect detection doesn't work for Oracle 12
Product:	[JBoss] JBoss Enterprise Portal Platform 6	Reporter:	Tomas Kyjovsky <tkyjovsk>
Component:	Documentation	Assignee:	JPP Docs Team <jpp-docs>
Status:	ASSIGNED ---	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	6.2.0	CC:	bdawidow, epp-bugs, theute, vramik
Target Milestone:	GA	Keywords:	Documentation
Target Release:	6.2.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Known Issue
Doc Text:	Note on Oracle 12 support: The Hibernate version shipped with JBoss Portal 6.2.x doesn't correctly auto-detect Oracle 12 databases, which could cause exceptions during the boot of JBoss Portal. In order to use this database, the following needs to be done: - - For the JCR component, which deals with the permanent storage for the JBoss Portal data, the property "gatein.jcr.datasource.dialect" needs to be set to "org.hibernate.dialect.Oracle10gDialect", on the file "$JBOSS_PORTAL_HOME/standalone/configuration/gatein/configuration.properties" - - For the Identity Management component, which deals with the credentials for the registered users of JBoss Portal, the property "hibernate.dialect" needs to be set to "org.hibernate.dialect.Oracle10gDialect" on the file "$JBOSS_PORTAL_HOME/gatein/gatein.ear/portal.war/WEB-INF/conf/organization/idm-configuration.xml" The Oracle 10 Dialect can be used without issues with an Oracle 12 database.	Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Tomas Kyjovsky 2014-03-19 14:05:29 UTC

Description of problem:

org.hibernate.HibernateException: Unable to determine Dialect to use [name=Oracle, majorVersion=12]; user must register resolver or explicitly set 'hibernate.dialect'


Version-Release number of selected component (if applicable):
Oracle 12
JDBC driver: Oracle 12.1.0.1.0 JDBC 4.0 
Hibernate 4.2.10.Final


Steps to Reproduce:
1. configure portal with Oracle 12 datasources
2. start portal


Additional info:
Workaround - explicitly set the dialect to "org.hibernate.dialect.Oracle10gDialect".
 - configuration.properties - set property gatein.jcr.datasource.dialect
 - idm-configuration.xml - add hibernate property "hibernate.dialect"

Comment 2 vramik 2014-03-19 18:29:25 UTC

FYI: https://hibernate.atlassian.net/browse/HHH-8852

Comment 3 Boleslaw Dawidowicz 2014-05-22 09:30:43 UTC

Jared assigning to you as it doesn't require any additional activity from the Eng side