[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2934) ScrollableResults.get(int column) returns only the first character of a database column type char(10)

[Samir Jyoti (JIRA)]

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

Samir Jyoti commented on HHH-2934:
----------------------------------

A simple SQL  select query using the scroll() method to return ScrollableResults.

The query looks like this:

select status_table.status from status_table

where STATUS_TABLE CHARACTER(10) in the create table script.

so when you do ScrollableResults.get(1)  you only get 'S' for a status value of say 'SENT' in the database.

> ScrollableResults.get(int column) returns only the first character of a database column type char(10)
> -----------------------------------------------------------------------------------------------------
>
>                 Key: HHH-2934
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2934
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: query-sql
>    Affects Versions: 3.2.4.sp1
>         Environment: IBM DB2 8.1.7, 
>            Reporter: Samir Jyoti
>
> ScrollableResults.get(int column) returns only the first character of a database column type char(n) where n> 1 (say 10 or 18).
> So if your column has value 'SIMPSON   ' , it only returns 'S'.
> Had to warp the column with a DB2 SQL "VARCHAR" function to convert it into a String.

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