hybris 定义 long String

 Caused by: de.hybris.platform.persistence.hjmp.HJMPException: org.springframework.jdbc.UncategorizedSQLException: query; uncategorized SQLException for SQL []; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "HYBRISDEV"."ORDERS"."P_SAPMSG"

如果在hybris 中定义了普通的String类型，你可能会碰到以上错误。

 

解决办法如下：

<itemtype code="HtmlTextComponent" jaloclass="my.package.jalo.component.HtmlTextComponent"
        autocreate="true" generate="true" extends="SimpleCMSComponent">
        <attributes>
                <attribute type="localized:java.lang.String" qualifier="htmlText">
                        <persistence type="property">
                                <columntype database="oracle">
                                        <value>CLOB</value>
                                </columntype>
                                <columntype database="sap">
                                        <value>NCLOB</value>
                                </columntype>
                                <columntype database="mysql">
                                        <value>MEDIUMTEXT</value>
                                </columntype>
                                <columntype database="hsqldb">
                                        <value>LONGVARCHAR</value>
                                </columntype>
                                <columntype>
                                        <value>HYBRIS.LONG_STRING</value>
                                </columntype>
                        </persistence>
                        <description>Component html text</description>
                </attribute>
        </attributes>   
</itemtype>