Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
First Last Prev Next    This bug is not in your last search results.
Bug 1078270 - Dialect detection doesn't work for Oracle 12
Dialect detection doesn't work for Oracle 12
Status: ASSIGNED
Product: JBoss Enterprise Portal Platform 6
Classification: JBoss
Component: Documentation (Show other bugs)
6.2.0
Unspecified Unspecified
unspecified Severity unspecified
: GA
: 6.2.0
Assigned To: JPP Docs Team
: Documentation
Depends On:
Blocks:
  Show dependency tree / graph
 
Reported: 2014-03-19 10:05 EDT by Tomas Kyjovsky
Modified: 2014-09-29 07:11 EDT (History)
4 users (show)

See Also:
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: ---

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

  None (edit)
Description Tomas Kyjovsky 2014-03-19 10:05:29 EDT 
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 14:29:25 EDT 
FYI: https://hibernate.atlassian.net/browse/HHH-8852
Comment 3 Boleslaw Dawidowicz 2014-05-22 05:30:43 EDT 
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.
First Last Prev Next    This bug is not in your last search results.