Paul Sturrock wrote:Its not juts Hibernate - a relational datamodel require primary keys. So what you've got is a broken data model because without a primary key it can't be relational, and this is why its difficult to use with an ORM.
Paul Sturrock wrote:You can fix this by defining a surrogate key.
Paul Sturrock wrote:
You can (possibly) work round this by mapping tables without primary keys to use all fields as a composite key. I say possibly because this requires all rows to be unique which may not be the case.
Actually I'm using HSQLDB and it does already some tables, and there is no PK in each table.
I never work on surrogate key and not even heard about that. could you please give me tips how to do..
Is there anything wrong with HSQLDB?
Here in this db all tables are read only
and no ID colimns (PK)