[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2742) Columns in resultset of stored procedure call are being aliassed

[Martin van Dijken (JIRA)]

Columns in resultset of stored procedure call are being aliassed
----------------------------------------------------------------

                 Key: HHH-2742
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2742
             Project: Hibernate3
          Issue Type: Bug
    Affects Versions: 3.2.2
         Environment: Hibernate version 3.2.2, Sybase 
            Reporter: Martin van Dijken


I have a call to a stored procedure that returns a result set, mapped as:

<sql-query name="loadUser" callable="true">
  <return class="User">
    <return-property name="id" column="userId"/>
    <return-property name="fullName" column="usersFullNameAsCitedWhenRegistering"/>
  </return>
  <query-param name="userId" type="long"/>
  {call loadUser(:userId)}
</sql-query>

I get the error:

invalid column name 'usersFul5_12_0_'

It looks like although I mapped the field fullName in my user object to the field usersFullNameAsCitedWhenRegistering in the resultset, Hibernate is determining that usersFullNameAsCitedWhenRegistering is too long and aliasses that to usersFul5_12_0_. The resultset however does not contain usersFul5_12_0_.

Can this be fixed somehow? If (probably) not, can you please document this in the "calling stored procedure section" to save others a few hours of searching?

-- 
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