[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-894) Hibernate Dynamic SQL Preview doesn't work unless first word is "select" (lower-case)

[Joseph Marques (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-894?page=comments#action_26295 ] 

Joseph Marques commented on HBX-894:
------------------------------------

OK, so I can occassionally reproduce this - but not consistently.  I'm going to be on the lookout for what sequence of events causes the error.

Like you said, it's probably not something with Hibernate at all.  However, I found that when I was able to reproduce it the one time this morning, that all I had to do to get the generated SQL was to add a space character to the beginning of the query.  Maybe I could have added a space character anywhere in the query?  Who knows...

The point is that maybe it doesn't have to do with case sensitivity at all.  Perhaps it's a more general phenomenon pertaining to what key events you listen for to pass the query over to hibernate.  And perhaps I just hit a key event that isn't being listened for - so the generated sql view was empty.

Anyway, like i said, I'll be on the lookout and open a new case (and link it to this one) if I can figure out what's going on.

> Hibernate Dynamic SQL Preview doesn't work unless first word is "select" (lower-case)
> -------------------------------------------------------------------------------------
>
>          Key: HBX-894
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-894
>      Project: Hibernate Tools
>         Type: New Feature

>     Versions: 3.2beta8
>     Reporter: Joseph Marques

>
>
> "select e.prop from entity e" will correctly generate sql
> "SELECT e.prop from entity e" will not
> So it seems that the case sensitive nature of the syntax highlighting in the HQL editor also extends to correlated features in other views.  This could be relaxed for more flexibility in style and greater usability.

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