[Hibernate-issues] [Hibernate-JIRA] Created: (HB-585) Queries with Session.createSQLQuery() require hard-coded table names

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-585


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-585
    Summary: Queries with Session.createSQLQuery() require hard-coded table names
       Type: Improvement

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1.1

   Assignee: 
   Reporter: Will Gayther

    Created: Sat, 27 Dec 2003 10:51 PM
    Updated: Sat, 27 Dec 2003 10:51 PM

Description:
The new sql queries run by calling Session.createSQLQuery() allow you to write an sql statement that refers to the properties of your objects, rather than having to remember or look up column names. Oddly though, they do require you to remember and hard-code the name of the table that stores the object(s) you're interested in, rather than letting you refer directly to the object you're interested in querying. For example:
"SELECT {cat.*} FROM CAT AS {cat} WHERE ROWNUM<10"
Notice that the table name "CAT" is hard-coded into the query. It would be much easier and abstract if I could refer to the name of the class rather than the name of the table. For example, like this:
"SELECT {cat.*} FROM {cat} AS {cat} WHERE ROWNUM<10"
Or, if that would add to much complication to the parser, than like this:
"SELECT {cat.*} FROM {table:cat} AS {cat} WHERE ROWNUM<10"

I've also discussed this issue somewhat on the forum:
http://forum.hibernate.org/viewtopic.php?p=2183641#2183641

What do you think?


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