[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-2168) SQLQuery - use rowIndex for scalar queries

SQLQuery - use rowIndex for scalar queries ------------------------------------------ Key: HHH-2168 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2168 Project: Hibernate3 Type: Improvement

Components: query-sql Versions: 3.2.0.ga Environment: Hibernate 3.2.0.ga Oracle 10g Database Reporter: Luiz dos Santos Faias Junior Priority: Minor

When org.hibernate.SQLQuery is used the default column types are java.sql.Date and java.math.BigDecimal. If I need to specify the types I use addScalar for all columns, but if I'm making a report probably there will be a few columns I want the default type. So my suggestion is to create a method : addScalar(java.lang.String columnAlias, org.hibernate.type.Type type, int columnIndex); or addScalar(int columnIndex, org.hibernate.type.Type type); Example : SQLQuery query = session.createSQLQuery( " select user_id, user_name, last_login from users " ); where last_login should be a java.sql.Timestamp. I want the first and second columns to use the default type ( int and String ), and the third column I want to specify Timestamp instead of java.sql.Date So I could only write : query.addScalar("last_login", Hibernate,.TIMESTAMP, 2); or addScalar(2, Hibernate.TIMESTAMP); (using the columnIndex). thanks, Luiz Faias São Paulo - Brasil