org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.bkv.search.objectmodel.AggregateSale#com.bkv.search.objectmodel.AggregateSale@6754d6]

The composite key of this table is reportDate and buyID. BuyId is a primary key of another table. Report date is a date/time field in sql server.

I set the date as a java.util.Date in my java bean. Am I getting this error because of the field type for the date?

I would guess that the Date object contains time part and that is not that is stored in DB. H simply cannot find record that conforms to the given key.

I have the same problem using a Long as Id ... have y tried to get the row by a query - in my case this is working - I don't kow why

A long-shot!!

Have you tried to set the date as a java.sql.Timestamp in your bean??

Some time ago I had some issues with dates and I think it was due to how Hibernate uses java.sql.Timestamp when returning object from the database. It’s worth a try!