Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Tom Mahy
Expando value maximum length ?
December 11, 2012 4:31 AM
Answer

Tom Mahy

Rank: Junior Member

Posts: 38

Join Date: May 2, 2012

Recent Posts

Hi,

Liferay 6.1 GA2
Mysql 5.1

So im creating an expando value with type ExpandoColumnConstants.STRING_ARRAY
If my value is really long than i get the exception :

 1
 213:25:08,287 ERROR [liferay/scheduler_dispatch-69][JDBCExceptionReporter:76] Data truncation: Data too long for column 'data_' at row 1
 313:25:08,291 ERROR [liferay/scheduler_dispatch-69][JDBCExceptionReporter:76] Data truncation: Data too long for column 'data_' at row 1
 4com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.DataException: Could not execute JDBC batch update
 5    at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:193)
 6    at com.liferay.portlet.expando.service.persistence.ExpandoValuePersistenceImpl.updateImpl(ExpandoValuePersistenceImpl.java:495)
 7    at com.liferay.portlet.expando.service.persistence.ExpandoValuePersistenceImpl.updateImpl(ExpandoValuePersistenceImpl.java:1)
 8    at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:257)
 9    at com.liferay.portlet.expando.service.impl.ExpandoValueLocalServiceImpl.doAddValue(ExpandoValueLocalServiceImpl.java:2015)
10    at com.liferay.portlet.expando.service.impl.ExpandoValueLocalServiceImpl.addValue(ExpandoValueLocalServiceImpl.java:54)
11    at sun.reflect.GeneratedMethodAccessor453.invoke(Unknown Source)
12    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13    at java.lang.reflect.Method.invoke(Method.java:597)
14    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
15    at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
16    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
17    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
18    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
19    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
20    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
21    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
22    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
23    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
24    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
25    at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
26    at $Proxy144.addValue(Unknown Source)
27    at com.liferay.portlet.expando.service.impl.ExpandoValueLocalServiceImpl.addValue(ExpandoValueLocalServiceImpl.java:552)
28    at sun.reflect.GeneratedMethodAccessor1145.invoke(Unknown Source)
29    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
30    at java.lang.reflect.Method.invoke(Method.java:597)
31    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
32    at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
33    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
34    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
35    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
36    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
37    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
38    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
39    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
40    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
41    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
42    at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
43    at $Proxy144.addValue(Unknown Source)
44    at com.liferay.portlet.expando.service.impl.ExpandoValueLocalServiceImpl.addValue(ExpandoValueLocalServiceImpl.java:458)
45    at sun.reflect.GeneratedMethodAccessor1144.invoke(Unknown Source)
46    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
47    at java.lang.reflect.Method.invoke(Method.java:597)
48    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
49    at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
50    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
51    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
52    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
53    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
54    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
55    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
56    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
57    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
58    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
59    at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
60    at $Proxy144.addValue(Unknown Source)
61    at com.liferay.portlet.expando.service.ExpandoValueLocalServiceUtil.addValue(ExpandoValueLocalServiceUtil.java:425)
62    at be.etnic.cerbere.sync.OrganisationSync.buildExpando(OrganisationSync.java:225)
63    at be.etnic.cerbere.sync.OrganisationSync.buildExpandoBridge(OrganisationSync.java:162)
64    at be.etnic.cerbere.sync.OrganisationSync.getOrganisationStructure(OrganisationSync.java:120)
65    at be.etnic.cerbere.sync.OrganisationSync.getOrganisationStructure(OrganisationSync.java:125)
66    at be.etnic.cerbere.sync.OrganisationSync.getOrganisationStructure(OrganisationSync.java:125)
67    at be.etnic.cerbere.sync.OrganisationSync.getOrganisationStructure(OrganisationSync.java:125)
68    at be.etnic.cerbere.sync.OrganisationSync.start(OrganisationSync.java:62)
69    at be.etnic.cerbere.Sync.receive(Sync.java:57)
70    at sun.reflect.GeneratedMethodAccessor637.invoke(Unknown Source)
71    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
72    at java.lang.reflect.Method.invoke(Method.java:597)
73    at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:67)
74    at $Proxy563.receive(Unknown Source)
75    at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receiv


Is there a way to add bigger values ?
Tom Mahy
RE: Expando value maximum length ?
December 11, 2012 5:08 AM
Answer

Tom Mahy

Rank: Junior Member

Posts: 38

Join Date: May 2, 2012

Recent Posts

alter table ExpandoValue change data_ data_ TEXT;