Can you tell us more about the procedure and the data it returns? Does the procedure work OK ouside of Hibernate? Is the key that identifies each row in the results set (wbUserGrpId) unique within the result set?
There is your problem. Hibernate maps relational data. Relational data by definition must have a unique identifier: any entity without a primary key cannot be uniquely indentified and so cannot form part of a relationship. So every mapped object must have a primary key. Can you cahnge your procedure so it uniquely identifies each row, possibly by returning a surrogate key with each result? [ December 15, 2006: Message edited by: Paul Sturrock ]
Joined: Jan 30, 2006
I made the changes to the proc and workign fine....thanks
subject: Problem with Sybase stored proc in hibernate