000037143 - Hibernate dialect errors observed in RSA Adaptive Authentication (on Premise) using Oracle 12c

Document created by RSA Customer Support Employee on Feb 1, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037143
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.3

 
IssueCustomer observed the error stack below in their aa_server.log and aa_server.admin.log continuously filling up the disk space

 

ERROR [http-/X.X.X.X:9080-5] [] [] [com.rsa.csd.servlet.filters.SessionCredentialsFilter] - <An error occured while trying to authentify a request: >
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ConfigResource: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Unable to determine Dialect to use [name=Oracle, majorVersion=12]; user must register resolver or explicitly set 'hibernate.dialect'
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)



 
ResolutionThis issue can be resolved by adding the following line in
/WEB-INF/classes/configs/d-config-datasource.xml for all applications such as AdaptiveAuthentication, AdaptiveAuthenticationAdmin. BackOffice, Case Management and Scheduler
 

<prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>



Example content in the file d-config-datasource.xml
 

<beans:prop xmlns:beans="http://www.springframework.org/schema/beans" key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</beans:prop>
                <prop key="hibernate.cache.use_second_level_cache">true</prop>
                <prop key="hibernate.cache.use_query_cache">true</prop>
                <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</prop>
                <prop key="hibernate.default_schema">$config{db.schemaName}</prop>
                <prop key="hibernate.validator.apply_to_ddl">false</prop>
                <prop key="hibernate.validator.autoregister_listeners">false</prop>
                <prop key="javax.persistence.validation.mode">NONE</prop>
                <prop key="hibernate.connection.release_mode">after_transaction</prop>
                <prop key="hibernate.jdbc.batch_size">30</prop>
            </props>
        </property>

Attachments

    Outcomes