oracle 12c installation and after unknown Oracle major version [11]

[cengiz gunes, modificado hace 7 años.]

Hi ,
database changed from 10g (10.2.0.4 version) to 12c(12.1.0.2.0) 64 bit.
jboss 4.0.5 Ga(zion)
liferay 4.3.4
tomcat 5.5.23, java JDK 7
win server 2003

web app. run with run.bat file,
there are *.properties file:
a.properties into application configuration
applivation web url=....

b.propertiesinto database to link defination

driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@...:1521:...    
username=ENC(...)    
password=ENC(...)

c.properties hibernate :

hibernate.cglib.use_reflection_optimizer = false
hibernate.show_sql  = true
hibernate.format_sql = true
hibernate.hbm2ddl.auto=none
hibernate.connection.driver_class = oracle.jdbc.driver.OracleDriver
hibernate.connection.username     = ENC(...)
hibernate.connection.password     = ENC(...)
hibernate.default_schema          = ENC(...)
hibernate.connection.url          = jdbc:oracle:thin:@...:...
hibernate.dialect                 = org.hibernate.dialect.OracleDialect.Oracle10gDialect

I tested run run.bat after move war file outof related directory
I get same error into log

lifearay database is open schema in to toad tested also ping database ip is connect

How can I solve? thanks alot.

I get error log file:

ERROR [com.liferay.portal.spring.hibernate.DynamicDialect] org.hibernate.HibernateException: unknown Oracle major version [11]
org.hibernate.HibernateException: unknown Oracle major version [11]
at org.hibernate.dialect.DialectFactory$1.getDialectClass(DialectFactory.java:135)
	at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:65)
	at com.liferay.portal.spring.hibernate.DynamicDialect.<init>(DynamicDialect.java:97)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at java.lang.Class.newInstance(Class.java:379)
	at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:78)
	at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:42)
	at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
	at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:805)
	at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:745)
	at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:134)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1198)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:427)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:267)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:110)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:857)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:423)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:267)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:110)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:857)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:423)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:267)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:110)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:857)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:423)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:733)
	at com.liferay.portal.bean.BeanLocatorImpl.locate(BeanLocatorImpl.java:60)

at com.liferay.portal.kernel.bean.BeanLocatorUtil.locate(BeanLocatorUtil.java:51)
	at com.liferay.portal.service.CompanyLocalServiceFactory._getFactory(CompanyLocalServiceFactory.java:70)
	at com.liferay.portal.service.CompanyLocalServiceFactory.getService(CompanyLocalServiceFactory.java:53)
	at com.liferay.portal.service.CompanyLocalServiceUtil.getCompanies(CompanyLocalServiceUtil.java:105)
	at com.liferay.portal.util.PortalInstances._getCompanyIdByVirtualHost(PortalInstances.java:193)
	at com.liferay.portal.util.PortalInstances._getCompanyId(PortalInstances.java:146)
	at com.liferay.portal.util.PortalInstances.getCompanyId(PortalInstances.java:79)
	at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.doFilter(VirtualHostFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.liferay.portal.servlet.filters.sessionid.SessionIdFilter.doFilter(SessionIdFilter.java:85)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:745)
2016-06-29 09:20:05,792 ERROR [com.liferay.portal.util.PortalInstances] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.service.CompanyLocalServiceFactory' defined in class path resource [META-INF/portal-spring.xml]: Cannot resolve reference to bean 'com.liferay.portal.service.CompanyLocalService.transaction' while setting bean property 'service'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.service.CompanyLocalService.transaction' defined in class path resource [META-INF/portal-spring.xml]: Cannot resolve reference to bean 'liferayTransactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTransactionManager' defined in class path resource [META-INF/data-source-spring.xml]: Cannot resolve reference to bean 'liferaySessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/data-source-spring.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Could not instantiate dialect class
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.service.CompanyLocalServiceFactory' defined in class path resource [META-INF/portal-spring.xml]: Cannot resolve reference to bean 'com.liferay.portal.service.CompanyLocalService.transaction' while setting bean property 'service'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.service.CompanyLocalService.transaction' defined in class path resource [META-INF/portal-spring.xml]: Cannot resolve reference to bean 'liferayTransactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTransactionManager' defined in class path resource [META-INF/data-source-spring.xml]: Cannot resolve reference to bean 'liferaySessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/data-source-spring.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Could not instantiate dialect class
Caused by: 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.service.CompanyLocalService.transaction' defined in class path resource [META-INF/portal-spring.xml]: Cannot resolve reference to bean 'liferayTransactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTransactionManager' defined in class path resource [META-INF/data-source-spring.xml]: Cannot resolve reference to bean 'liferaySessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/data-source-spring.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Could not instantiate dialect class
Caused by: 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTransactionManager' defined in class path resource [META-INF/data-source-spring.xml]: Cannot resolve reference to bean 'liferaySessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/data-source-spring.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Could not instantiate dialect class
Caused by: 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/data-source-spring.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Could not instantiate dialect class
Caused by: 
org.hibernate.HibernateException: Could not instantiate dialect class
</init>

[David H Nebinger, modificado hace 7 años.]

Hibernate doesn't know about the version of Oracle you're using.

Specify the dialect is oracle 10 and you should be fine.

[cengiz gunes, modificado hace 7 años.]

Application also is run Oracle 11g in this configuration, but does not return again 10g from 12c at customer server side. Hibernate 3.0 is using. I think update hipernate from 3.0 to 5.2 final. This setting, does it solve this problem? Thank you my question for your answer.

[David H Nebinger, modificado hace 7 años.]

No, you should not change Liferay's version of hibernate. Set the dialect to an older supported version.

[cengiz gunes, modificado hace 7 años.]

I put this code for dialect setting in hibernate.properties but it does not change and run app. how to set dialect another way for run on Oracle 12 c together all old version of liferay,jboss,java, tomcat and hibernate?

hibernate.dialect                 = org.hibernate.dialect.OracleDialect.Oracle10gDialect

Thank you for your answer.

[cengiz gunes, modificado hace 7 años.]

update oracle 12c so, update jdk 8, hibernate 5.2,spring framework 4.3.1 also jars from jdk 7, hibernate 3. war file does not work with run.bat file that it gives error, so I will update jboss to eap 7.0 from jboss 4.0.5 ga, but there is liferay 4.3.4 in jboss 4.0.5. can liferay 4.3.4 work in jboss 7.0. which liferay versions supported jboss 6.3.3. and above? (ı am not using maven)

[cengiz gunes, modificado hace 7 años.]

ı found this link. https://web.liferay.com/services/support/compatibility-matrix

[cengiz gunes, modificado hace 7 años.]

also Liferay Portal CE supported jboss eap 6.4 or 7.0 with jdk 8 , oracle 12c?