[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4108) Invalid result in native query

[Simon Kulessa (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=43054#comment-43054 ] 

Simon Kulessa commented on HHH-4108:
------------------------------------

The bug still exists in 3.6.6 with MySQL 5.5.

> Invalid result in native query
> ------------------------------
>
>                 Key: HHH-4108
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4108
>             Project: Hibernate Core
>          Issue Type: Bug
>    Affects Versions: 3.3.2
>         Environment: 3.3.2, MySQL 5.1
>            Reporter: Oleksandr Fedorenko
>            Priority: Critical
>
> We have the native query executed with entity manager, example :
> Query query = entityManager.createNativeQuery(sqlString);
> List result = query.getResultList();
> The returned result is an array of objects that has projection values.
> When table column has type CHAR(N) , the result value is always instance of java.lang.Character and here we have only first character of database field and the rest characters are lost.
> It is supposed to have result of java.lang.String class here.
> When the column is altered to VARCHAR(N), the result is java.lang.String.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira