Collection « MySQL « JPA Q&A

  1. JPA Q&A
  2. MySQL
  3. Collection




1. Collections with MySQL MyIsam    forum.hibernate.org

Hi there, I am using hibernate 2.1 in a webapp running in Tomcat and MySQL 4.0.14 (MyISAM) for persistent storage. My questions is, I used SchemaExport to generate all relational schemas - without any errors. However, the ForeignKey constraints added by hibernate seem to be ignored by the DBMS. No cascade options work for me :( I would very much like ...

2. Using MySQL, need to qualify on two collection sizes    forum.hibernate.org

I've read the FAQ at http://www.hibernate.org/118.html that describes how to place a condition on a collection size using MySQL (which does not support subqueries). My problem is that I have to qualify by two collection sizes. Briefly, I have a Parent object that has two collections - childset1 and childset2 (both are implemented as separate tables that have a many-to-one back ...