> (Please let me know if I'm speaking out my ass (again...)) > I seem to recall someone mentioning that hypersql allows two columns in > a table to have the same name. This is not normally allowed in SQL > databases, right? > If your test case only tests against hypersql, then it will probably > give a false positive result.
I use postgres on my server for this exact reason. > I filed bug 530437 > (http://sourceforge.net/tracker/?func=detail&aid=530437&group_id=22866&atid=376685) > because I ran into a similar problem using postgresql which complains > about the relationship table that has two columns with the same name. > Now in my case it is a many-to-many self-relationship, but a one-to-many > self-relationship also needs to have a separate relationship table, right? > > --Andrew > I read you bug report and it should be fairly easy to fix. First, I just need to get my tax info to my accountant. As for a one-to-many self-relationship needing a separate table, this is wrong. It should work fine with a foreign key. -dain _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user