Bug 1078270 - Dialect detection doesn't work for Oracle 12
Summary: Dialect detection doesn't work for Oracle 12
Keywords:
Status: ASSIGNED
Alias: None
Product: JBoss Enterprise Portal Platform 6
Classification: JBoss
Component: Documentation
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: GA
: 6.2.0
Assignee: JPP Docs Team
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-03-19 14:05 UTC by Tomas Kyjovsky
Modified: 2014-09-29 11:11 UTC (History)
4 users (show)

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.
Clone Of:
Environment:
Last Closed:
Type: Bug
Embargoed:

Attachments (Terms of Use)

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
Note You need to log in before you can comment on or make changes to this bug.