Hibernate version:
Hibernate 3.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():
N/A

Full stack trace of any exception that occurs:
N/A

Name and version of the database you are using:
Oracle 9i AND MySQL 4.x.x

The generated SQL (show_sql=true):
N/A

Debug level Hibernate log excerpt:
N/A

I had the impression that no other generator than "sequence" was supported idbag's collection-id (The samples in the reference doc only show "sequence" generator, same for HIA).

Because we use (local) MySQL database for developement and testing I tryed and test "native" as the generator...and it works !

Can an authorized persons here can confirm me that "native" IS indeed supported as the generator for idbag's <collection-id> element under Hibernate 3.1 ?

TIA.

Pascal Jacob

---Continued---

"native" generator for idbag's collection-id is ok only with Oracle (9i).

When used with MySQL, Hibernate will produce an exception when persisting new instances of the association entity:






In searching for another generator that would work with both Oracle and MySQL, I have switched from "native" to "increment" for (unit)testing while we are developping the product as I understand that "increment" is not safe when the database is shared by multiple clients.

So the current mater of fact is:
Fact 1) idbag only work (safely) with "sequence" generator.
Fact 2) "sequence" générator is not available under MySQL.
Conclusion) idbag can not be used when the target database is MySQL.

I'm correct ?
Is there an alternative to idbag that I can use to map a ternary association where one of the three foreign key can be null ?

Please help [ I will rate ;-) ]

Pascal Jacob