[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-491) createSQLQuery should support joined-subclass

[<no...@at...>]

The following comment has been added to this issue:

     Author: Joe Kelly
    Created: Tue, 19 Apr 2005 11:56 AM
       Body:
Any update on this issue? I am using createSQLQuery() to execute a recursive query (using DB2's "WITH <common-table-expression>" syntax), which is not supported in HQL (AFAIK). 

It does NOT work with * in the select clause -- I get bad column name exceptions from the JDBC driver. It DOES if I explicitly list the columns I want returned but this is inconvenient and makes the code break if I add/delete/rename columns.
---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HB-491?page=comments#action_17213

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HB-491

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-491
    Summary: createSQLQuery should support joined-subclass
       Type: Improvement

     Status: Unassigned
   Priority: Minor

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1 final

   Assignee: 
   Reporter: Max Rydahl Andersen

    Created: Sat, 22 Nov 2003 1:28 PM
    Updated: Tue, 19 Apr 2005 11:56 AM

Description:
select .... from persons {person}, customers {(Customer)person} where .... 


where Customer is a <joined-subclass> of Person. 


http://forum.hibernate.org/viewtopic.php?t=925439&highlight=createsqlquery+joined


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira