![]() If the table contains localized properties (having values in different languages), these values are stored separately from the main item type table. This is now solely relying on the hjmpTS column It used to be for optimistic locking covering the *PROPS tables. Generic audit tables are created for all item type tables automatically (the feature is available in 6.6+).Įach item type table has at least the following columns: For example, localized values tables are created if you have at least one localized attribute. Their names are specified in the ‘deployment’ tag, so the database tables can be of any name chosen by the developer.Īctually, in this process some of other tables are created or updated too. These tables are created automatically from *-items.xml during the system init or update process. The major part of the list of hybris database tables is item type tables. There is a table prefix configured for the instance. The generated files are executed as a batch using Spring Core JDBC. ![]() DDL – with CREATE statements (tables and indexes).The generator uses the information loaded from the XML model definitions. The schema is created as a set of SQL files in the temporary directory using Apache DDLUtils SQLBuilder. Hybris creates tables during the initialization and update processes. Hybris database internals Creating tables The explanations below are important for troubleshooting and to early detect the data issues. Otherwise, you will definitely have issues with the caching subsystem. Use the hybris data access APIs in all situations when you need to modify things. Summary Don’t write to the database directly in hybris. You will see that SAP Hybris Commerce is not a black box with hidden algorithms and logic under the hood. ![]() Looking at the underlying data model you will understand the processes better. Analyzing the data is also extremely helpful with data integrity issues. For example, direct access to the database may show that your system has a lot of unused items, and it affects the performance. However, understanding of the internal structure is very useful in troubleshooting and low-level data analysis. So basically the information about the specific attributes and table names is not used by developers directly. It means that you can’t (you are not recommended to) write to the database directly. You know that SAP Hybris Commerce has a powerful type system built on top of the database layer. I explain system tables and attributes, their purpose and meaning. The purpose of this document is to shed a light on the internal data structures used by SAP Hybris Commerce.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |