Hibernate reports the following when attempting to use a stored procedure to implement load() or getNamedQuery:
[java] Exception in thread "main" java.lang.UnsupportedOperationException: org.hibernate.dialect.MySQLDialect does not support resultsets via stored procedures.
The MySQLDialiect file needs to be modified to reflect the MySQL5 capability of issuing stored procedures. The semantics of stored procedures in MySQL is most similar to that in SQLServer, so copying the relevent sections of the SQLServerDialect ought to be sufficient. I tried that and it seemed to work. Modified MySQLDialect is attached.
Done, with tests.