Hi!

I know that this could be a little boring to You ;) but is possible to use Hibernate on tables without PK? Tables was designed without it and now I have a problem with this. The biggest table have 56 fields (not my design ;) so hand-made objects are dificult to create. I've tried to do so but HB descriptor requires ID field - and I cannot refator database ... any ideas or maybe ways to fix it up (without adding additional fields)

Write a SQL query that detects duplicates and filters them, then insert the result into a cleaned up table with a surrogate primary key field. Hibernate can not use this table, it would be actually dangerous to use it for critical data.

Yes, it is better to fix error than to find some workaround and it is never too late to add primary key .