Hi,
I have created an attribute in a component type which is extending SimpleCMSComponent. As it can contain very large data i defined it as below:
en<attribute qualifier="description" type="localized:java.lang.String">
<description>Description of purchase policy topic</description>
<modifiers read="true" write="true" search="true"
optional="true" />
<persistence type="property">
<columntype database="oracle">
<value>CLOB</value>
</columntype>
<columntype database="sap">
<value>NCLOB</value>
</columntype>
<columntype>
<value>HYBRIS.LONG_STRING</value>
</columntype>
</persistence>
</attribute>
In local I am using HSQL and in environment it will be SAP HANA. Similarly, I did this for another attribute "shortDescription" in item type Product.
Issue is that, the large content is getting save in attribute shortDescription of Product but it is given error when I am trying to save it in Component's attribute. Please let me know what am I doing wrong.
Error is:
INFO | jvm 1 | main | 2018/06/13 12:10:57.211 | Caused by: de.hybris.platform.servicelayer.exceptions.ModelSavingException: sql error saving EJBPropertyRowCache[itemPK:null,langPK:8796093055008,inDB:true,hasChanged:true,names:[description, title],values:[<p>We know this isn't the most interesting page of the Site, but these terms and policies are important and affect your legal rights. <span>PLEASE READ CAREFULLY.</span> </p> <p>The Terms of Use and Purchase Policy make up a legal Agreement between you (you or your) and Edgewell Personal Care Company and/or its affiliates (Edgewell, we, our, or us).</p>, Terms of use],changeList:{0}]:2053908843 for item 8796160525372 , query = UPDATE cmscomponentlp SET p_description = ? ,ITEMTYPEPK = ? WHERE ITEMPK = ? AND LANGPK = ? values = [<p>We know this isn't the most interesting page of the Site, but these terms and policies are important and affect your legal rights. <span>PLEASE READ CAREFULLY.</span> </p> <p>The Terms of Use and Purchase Policy make up a legal Agreement between you (you or your) and Edgewell Personal Care Company and/or its affiliates (Edgewell, we, our, or us).</p>, 8796140666962, 8796160525372, 8796093055008]java.sql.SQLDataException: data exception: string data, right truncation
Thanks.