Kris, Here <http://svn.biosimilarity.com/src/open/codesamples/trunk/hibernate/> is a link to the self-contained example that now uses just Java. i included the target dir in the repo to speed up investigation, but you can just blow that away and build from scratch. The example is currently written to Java1.6, but also exhibits the same behavior under Java1.5. To run the example
> svn co http://svn.biosimilarity.com/src/open/codesamples/trunk/hibernate ... > env PATH=<path-to-java1.6>:$PATH JAVA_HOME=<path-to-java1.6> mvn clean compile process-classes If you switch comment and decl at line 22 in src/main/java/maxb/hbex2/MySampleFuContainer.java then you see the error. The schema goes from create table lingo_production.MySampleFuContainer_table ( id_AbstractContainer varchar(255) not null, varchar(255) not null, uuid varchar(255), mysamplingmumble__idSuper varchar(255), primary key (id), unique (uuid) ); to create table lingo_production.MySampleFuContainer_table ( id_AbstractContainer varchar(255) not null, id varchar(255), mysamplingmumble_ tinyblob, uuid varchar(255), primary key (id_AbstractContainer), unique (id_AbstractContainer) ); Best wishes, --greg On Mon, Jun 22, 2009 at 1:38 PM, Meredith Gregory <lgreg.mered...@gmail.com>wrote: > Kris, > > Thanks for the suggestion. i've now got a tiny little example that compiles > on its own that illustrates the problem. Changing the inheritance strategy > to JOINED makes no difference. Hibernate still does the wrong thing. > > Best wishes, > > --greg > > > On Mon, Jun 22, 2009 at 8:55 AM, Kris Nuttycombe < > kris.nuttyco...@gmail.com> wrote: > >> This may be off the mark, but I'm wondering if the reason that you're >> having difficulty with the parallel inheritance hierarchy problem is >> not your use of TABLE_PER_CLASS inheritance. In my application, I have >> a similar construct, but I am using JOINED_TABLE inheritance. This >> allows for a normal foreign key relationship to be created in the >> database between C2_table and the base table for CThing, with the >> result that Hibernate will generate the query for CThing member as a >> union. Using table per class inheritance, I would expect Hibernate to >> need to synthesize an additional dtype field in C2_table along with >> the key column in order to enforce the uniqueness of the keys to the >> joined entities, and I don't believe that it does this. >> >> I'm not sure how the fact that the code is generated is particularly >> relevant; surely if it's possible to hand-write a successful solution, >> then your code generator could be made aware of how to construct a >> viable solution? >> >> Kris >> >> On Fri, Jun 19, 2009 at 8:47 PM, Meredith >> Gregory<lgreg.mered...@gmail.com> wrote: >> > All, >> > >> > i had a similar problem and found the source of the issues. Spse you >> have a >> > container hierarchy (CTop <- C2) side-by-side with a contained hierarchy >> > (CThing <- CThing1). The inheritance at the top of the container >> hierarchy, >> > CTop, causes hibernate to bail on tracking the relations and punt to >> > embedded values instead. Rewriting the top to be a @MappedSuperClass >> fixes >> > the problem in this specific case. However, if your hierarchy is deep, >> > you're screwed. >> > >> > If anybody has a suggestion for a workaround, i'm all ears. The problem >> is >> > that it would appear that both Mr Crowley and i are generating Java + >> JPA >> > code. So, the solution needs to be algorithmic and not 1-off. >> > >> > Perhaps the best solution is to find an alternative to hibernate as this >> is >> > a particularly irritating bug. >> > >> > Best wishes, >> > >> > --greg >> > >> > @Entity >> > @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) >> > abstract class CTop { >> > ... >> > @Id >> > @GeneratedValue(generator = "system-uuid") >> > @GenericGenerator(name = "system-uuid", strategy = "uuid") >> > private String id_CTop; >> > } >> > >> > @Entity >> > @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) >> > abstract class CThing { >> > ... >> > @Id >> > @GeneratedValue(generator = "system-uuid") >> > @GenericGenerator(name = "system-uuid", strategy = "uuid") >> > private String id_CThing; >> > } >> > >> > @Entity >> > @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) >> > @Table(name = "C2_table", catalog = "mydb_production", uniqueConstraints >> = { >> > @UniqueConstraint(columnNames = "uuid") }) >> > class C2 extends CTop { >> > CThing thing; >> > ... >> > @OneToOne >> > @JoinColumn >> > public CThing getThing() { >> > return this.thing; >> > } >> > public void setThing( CThing thing ) { >> > this.thing = thing; >> > } >> > >> > @Column(name = "uuid", unique = false, nullable = true, insertable = >> true, >> > updatable = true) >> > public String getUuid() { >> > return this.uuid; >> > } >> > >> > public void setUuid(String uuid) { >> > this.uuid = uuid; >> > } >> > >> > @Id >> > @GeneratedValue(generator = "system-uuid") >> > @GenericGenerator(name = "system-uuid", strategy = "uuid") >> > @Column(name = "id", unique = false, nullable = true, insertable = >> true, >> > updatable = true) >> > public String getId() { >> > return this.id; >> > } >> > >> > } >> > >> > @Entity >> > @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) >> > @Table(name = "CThing1_table", catalog = "mydb_production", >> > uniqueConstraints = { @UniqueConstraint(columnNames = "uuid") }) >> > class CThing1 extends CThing { >> > ... >> > // lots of ground type fields >> > >> > @Column(name = "uuid", unique = false, nullable = true, insertable = >> true, >> > updatable = true) >> > public String getUuid() { >> > return this.uuid; >> > } >> > >> > public void setUuid(String uuid) { >> > this.uuid = uuid; >> > } >> > >> > @Id >> > @GeneratedValue(generator = "system-uuid") >> > @GenericGenerator(name = "system-uuid", strategy = "uuid") >> > @Column(name = "id", unique = false, nullable = true, insertable = >> true, >> > updatable = true) >> > public String getId() { >> > return this.id; >> > } >> > >> > } >> > >> > >> > On Tue, Jun 16, 2009 at 1:45 PM, Derek Chen-Becker < >> j...@chen-becker.org> >> > wrote: >> >> >> >> John Nilsson wrote: >> >> > Hi, >> >> > >> >> > I think the showSql property has been deprecated in favor of log4j >> >> > loggers. >> >> > >> >> > If you set the log4j level to TRACE for org.hibernate you'll get >> >> > everything Hibernate has to say about what it is doing. Can't >> remember >> >> > which one it is, but I know one of the loggers will give you the >> >> > values used in queries at the TRACE level. >> >> >> >> Good to know. Thanks! >> >> >> > >> > >> > >> > -- >> > L.G. Meredith >> > Managing Partner >> > Biosimilarity LLC >> > 1219 NW 83rd St >> > Seattle, WA 98117 >> > >> > +1 206.650.3740 >> > >> > http://biosimilarity.blogspot.com >> > >> > > > > -- > L.G. Meredith > Managing Partner > Biosimilarity LLC > 1219 NW 83rd St > Seattle, WA 98117 > > +1 206.650.3740 > > http://biosimilarity.blogspot.com > -- L.G. Meredith Managing Partner Biosimilarity LLC 1219 NW 83rd St Seattle, WA 98117 +1 206.650.3740 http://biosimilarity.blogspot.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---
