Liferay on Weblogic cluster

[Alexey Truntov, geändert vor 12 Jahren.]

Hello.

We have Liferay application deployed on Weblogic server and DB on Oracle. When deployed on standalone server it's working fine with datasource set up on weblogic services with oracle.jdbc.xa.client.OracleXADataSource driver. But when starting Liferay app on cluster environment we get an error:

Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counte
        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
        at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:135)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
        at $Proxy293.get(Unknown Source)
        at com.liferay.counter.service.persistence.CounterFinderImpl._obtainIncrement(CounterFinderImpl.java:366)
        ... 114 more
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter]
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1937)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
        at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1065)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1056)
        at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:131)
        ... 121 more
Caused by: java.sql.SQLException: Due to vendor limitations, setting transaction isolation for "Oracle XA" JDBC XA driver is not supported.

We've tried to set

transaction.isolation.portal=-1

but it doesn't helped, still same error, so we had to switch to standart oracle.jdbc.driver.OracleDriver.

I suggest that Liferay app tries to set some transaction isolation level explicitly, any thoughts on how to overcome this problem using OracleXADataSource driver?

[liferay learner, geändert vor 10 Jahren.]

Hi Alexey,
Were you able to find a solution for this issue? The documentation with respect to deployment on production weblogic instances is either really bad and non-existent. The book does not help as well.