topic Re: Persistent Class and Deep Structures in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/persistent-class-and-deep-structures/m-p/4260011#M1016689 <HTML><HEAD></HEAD><BODY><P>Hi Mike,</P><P></P><P>no you can't do this because the persistent object essentially has a one-to-one mapping to a database table, and the database does not support deep structures.</P><P></P><P>What you can do, is define your data model to support the deep structure, for example a table for header records, then other tables for item records, and even another one for a one-to-many mapping to an item record - or even many-to-many mappings. Then you generate persistent objects for each database table.</P><P></P><P>Now you build a utility class that handles all the interaction with the persistent objects. This class abstracts the actual interaction with the persistent objects and you design it's interface to support your deep structures. This class should also implement transactional locking and data integrity.</P><P></P><P>Cheers</P><P>Graham Robbo</P></BODY></HTML> Tue, 12 Aug 2008 01:55:41 GMT GrahamRobbo 2008-08-12T01:55:41Z Persistent Class and Deep Structures https://community.sap.com/t5/application-development-and-automation-discussions/persistent-class-and-deep-structures/m-p/4260010#M1016688 <HTML><HEAD></HEAD><BODY><P>Can I Include Deep Structures in a persistent class?</P><P>If so, will the get/sets als be created for the lower level fields?</P></BODY></HTML> Mon, 11 Aug 2008 20:19:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/persistent-class-and-deep-structures/m-p/4260010#M1016688 mike_mcinerney 2008-08-11T20:19:25Z Re: Persistent Class and Deep Structures https://community.sap.com/t5/application-development-and-automation-discussions/persistent-class-and-deep-structures/m-p/4260011#M1016689 <HTML><HEAD></HEAD><BODY><P>Hi Mike,</P><P></P><P>no you can't do this because the persistent object essentially has a one-to-one mapping to a database table, and the database does not support deep structures.</P><P></P><P>What you can do, is define your data model to support the deep structure, for example a table for header records, then other tables for item records, and even another one for a one-to-many mapping to an item record - or even many-to-many mappings. Then you generate persistent objects for each database table.</P><P></P><P>Now you build a utility class that handles all the interaction with the persistent objects. This class abstracts the actual interaction with the persistent objects and you design it's interface to support your deep structures. This class should also implement transactional locking and data integrity.</P><P></P><P>Cheers</P><P>Graham Robbo</P></BODY></HTML> Tue, 12 Aug 2008 01:55:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/persistent-class-and-deep-structures/m-p/4260011#M1016689 GrahamRobbo 2008-08-12T01:55:41Z