Hi, I need to map the Elements contained in a OneToMany Collection (Set) in some class to one table, and Elements of the same Class Type contained in a OneToMany Collection (Set) in another class to another table. Know what I mean? The example on the Subscription/LineItem example from http://openjpa.apache.org/builds/1.0.2/apache-openjpa-1.0.2/docs/manual/ manual.html#ref_guide_mapping_jpa_onemany works (of course), but imagine another class that holds the same kind of LineItem classes.. another @OneToMany @ElementJoinColumn will lead to another inverse foreign key mapping, and the one and only SUB table will have two; not what I want. Now before somebody says RTFM ;) - I read about the @PersistentCollection(elementEmbedded=true) @ContainerTable (in the OpenJPA doc just above the link above, but the example on http://edocs.bea.com/kodo/docs41/full/html/ref_guide_mapping_ejb.html#re f_guide_mapping_ejb_coll_ex helped) and it indeed does the mapping as I'm expecting it... but also adds a weired unneccassyary additional column of type 'image' (on Sybase, a BLOB on Derby) named after the Collection field (e.g. items) - on the LINE_ITEM instead of on the SUB table! How do I get rid of that column? I noticed Kodo has an @ElementEmbeddedMapping that's not in OpenJPA, but from what I understand that's only to override stuff? That @PersistentCollection(elementEmbedded=true) already says the Elements should be embedded. So why that additional binary column? Or this kind of mapping impossible with OpenJPA (it's clearly possible - there is just an additional annoying column...) Is there a way to do the same differently? BTW: I'm assuming somebody who would for some reason have two collections of LineItem in the Subscription class (instead of from two different classes) would probably have a very similar mapping requirement. Thanks! Michael
____________________________________________________________ This email and any files transmitted with it are CONFIDENTIAL and intended solely for the use of the individual or entity to which they are addressed. Any unauthorized copying, disclosure, or distribution of the material within this email is strictly forbidden. Any views or opinions presented within this e-mail are solely those of the author and do not necessarily represent those of Odyssey Financial Technologies SA unless otherwise specifically stated. An electronic message is not binding on its sender. Any message referring to a binding engagement must be confirmed in writing and duly signed. If you have received this email in error, please notify the sender immediately and delete the original.
