Support for MySQL5 stored procedures

Description

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.

Environment

MySQL 5.0

Activity

Show:
GavinG
December 8, 2005, 4:41 AM

Done, with tests.

Fixed

Assignee

GavinG

Reporter

guy harrison

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure