SAP Knowledge Base Article - Preview

2357967 - How to change index on the specified column in a custom property table

Symptom

From the OOTB hybris Platform, it is possible to specify one deployment for multiple custom Property tables, in core-advanced-deployment.xml, like below:

<package name="de.hybris.jakarta.session.property">
 <object name="Property">
  <object-mapping>
   <table name="Props"/>
   <table name="TypeSystemProps"/>
   <table name="ProductProps"/>
   <table name="UserProps"/>
   <table name="UserGroupProps"/>
   <table name="AddressProps"/>
   <table name="OrderProps"/>
   <table name="OrderEntryProps"/>
   <table name="MediaProps"/>
   <index name="ITEMPK">
    <index-key attribute="itemPK"/>
   </index>
   <index name="NAMEIDX">
    <index-key attribute="name"/>
   </index>
   <index name="REALNAMEIDX">
    <index-key attribute="realName"/>
   </index>
  </object-mapping>
        <attribute name="itemPK" type="HYBRIS.PK" primkey-field="true">
            <attribute-mapping persistence-name="ITEMPK" null-allowed="false"/>
        </attribute>
        <attribute name="itemTypePK" type="HYBRIS.PK" >
            <attribute-mapping persistence-name="ITEMTYPEPK" null-allowed="false"/>
        </attribute>
        <attribute name="name" type="java.lang.String" primkey-field="true">
            <attribute-mapping persistence-name="NAME" null-allowed="false"/>
        </attribute>
        <attribute name="langPK" type="HYBRIS.PK" primkey-field="true">
            <attribute-mapping  persistence-name="LANGPK" null-allowed="false"/>
        </attribute>
        <attribute name="realName" type="java.lang.String">
            <attribute-mapping persistence-name="REALNAME"/>
        </attribute>
        <attribute name="type1" type="int">
            <attribute-mapping persistence-name="TYPE1"/>
        </attribute>
        <attribute name="valueString1" type="HYBRIS.LONG_STRING">
            <attribute-mapping persistence-name="VALUESTRING1"/>
        </attribute>
        <attribute name="value1" type="java.io.Serializable">
            <attribute-mapping persistence-name="VALUE1"/>
            <attribute-mapping database="oracle" persistence-name="VALUE1" persistence-type="BLOB"/>
        </attribute>
 </object>
</package>

And it is also allowed to specify index information in the definition of the property tables.

However, if customer wants to have different configuration, like different Index, in particular property table, the default definition of property tables is not able to do so. 


Read more...

Environment

All versions of SAP Hybris Commerce Suite

Product

SAP Commerce all versions

Keywords

KBA , CEC-COM-CPS-COR , CPS Core (SAP Commerce) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.