[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4464) PostgreSQLDialect does not support resultsets via stored procedures

[Hasitha Wijesekara (JIRA)]

PostgreSQLDialect does not support resultsets via stored procedures
-------------------------------------------------------------------

                 Key: HHH-4464
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4464
             Project: Hibernate Core
          Issue Type: Improvement
          Components: query-sql
    Affects Versions: 3.2.0.ga
         Environment: Hibernate 3.2.0.ga , PostgreSQL 8.3
            Reporter: Hasitha Wijesekara
         Attachments: PostgreSQLDialect-Issue.bmp

When executing PostgreSQL  function following error occurred.
org.hibernate.dialect.PostgreSQLDialect does not support resultsets via stored procedures.

But when we execute same function using MySQL5Dialect, this error does not occur.

We use following NamedQuery for that,

<sql-query name="callFunction" callable="true">
			{call visualdata.getEmpFullName(100) }
</sql-query>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira