Skip to Content
0
Jun 13, 2018 at 11:02 AM

What should be the type of attribute to hold long String value?

4358 Views

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.