No, not at all. It's an issue relating to what the data represents. The company I worked for many years had a ORMS system that worked like this for example.
I have thousands of suppliers each of which is an entity Each supplier can have multiple billing addresses and multiple delivery addresses and multiple users who each in turn can have multiple billing and delivery addresses ... not to mention postal addresses. If I look at how JPA works it makes the assumption that if you have entity relationships then any change to a related entity that requires a change to subordinate entities will cause those subordinate entities to be updated (merged/persisted etc) Now move into the realm of fortune 500 companies and smaller, most of the master data is in the ERP not in the JPA apps that we may build. JPA should have a mechanism that allows the developer to only join "MASTER ENITIES" (those where the source of truth is the ERP for instance) instead I have to use REFRESH which to be honest baffles me as a term. Not having a shot at OpenJPA at all, more at the JPA standard because these issues were well and truly put to bed in he late 90's now in the late 2000s I feel we have gone back 10 years in the spec. Anyway I don't pretend to be an expert on OpenJPA or JPA at all, just putting in my 2c worth... also not blowing the trumpet of my former employer's ORMS system .... I sued them a year ago and am hoping they'll go bust. -----Original Message----- From: Daryl Stultz [mailto:da...@6degrees.com] Sent: Friday, 14 August 2009 10:24 PM To: users@openjpa.apache.org Subject: Re: Delete or merge, update or merge ? On Thu, Aug 13, 2009 at 1:13 PM, C N Davies <c...@cndavies.com> wrote: > The model relationships should manage all aspects of the model. Suppose you had A with children B where the collection of B is hundreds of thousands or more. How would you go about deleting a set of them that met certain criteria? Load in the whole set as objects and iterate over them? -- Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com mailto:da...@6degrees.com