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>