Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Alexey Truntov
Liferay on Weblogic cluster
December 29, 2011 3:38 AM
Answer

Alexey Truntov

Rank: New Member

Posts: 22

Join Date: July 15, 2011

Recent Posts

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:

 1Caused 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
 2        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
 3        at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:135)
 4        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 5        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 6        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 7        at java.lang.reflect.Method.invoke(Method.java:616)
 8        at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
 9        at $Proxy293.get(Unknown Source)
10        at com.liferay.counter.service.persistence.CounterFinderImpl._obtainIncrement(CounterFinderImpl.java:366)
11        ... 114 more
12Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter]
13        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
14        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
15        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
16        at org.hibernate.loader.Loader.loadEntity(Loader.java:1937)
17        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
18        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
19        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
20        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
21        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
22        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
23        at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403)
24        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155)
25        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
26        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1065)
27        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1056)
28        at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:131)
29        ... 121 more
30Caused 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
1transaction.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
RE: Liferay on Weblogic cluster
June 25, 2013 4:02 PM
Answer

liferay learner

Rank: New Member

Posts: 3

Join Date: March 11, 2013

Recent Posts

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.