[jbosstools-issues] [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates

[Max Andersen (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12395017 ] 
            
Max Andersen commented on JBIDE-1621:
-------------------------------------

this is expected behavior if you are using InnoDB databases:

REPEATABLE READ: The default isolation level for InnoDB tables. Within a transaction, all reads are consistent.

this is because we are using the same session for queries and thus the same connection.



> HQL Editor & Hibernate Criteria Editor - do not get DB updates
> --------------------------------------------------------------
>
>                 Key: JBIDE-1621
>                 URL: http://jira.jboss.com/jira/browse/JBIDE-1621
>             Project: Tools (JBoss Tools)
>          Issue Type: Bug
>          Components: Hibernate
>            Reporter: Vitali Yemialyanchyk
>         Assigned To: Vitali Yemialyanchyk
>            Priority: Minor
>         Attachments: querycache.zip
>
>
> items table has 2 rows;
> I create query in HQL Editor (the same for Hibernate Criteria Editor):
> from mapping.querycache.Item
> and get 2 items in the "Hibernate Query Result". After that I use MySQL Query Browser and insert 1 more row into the table - so the table has 3 rows.
> I execute the query in HQL Editor one more time - and get the same 2 rows - if I restart eclipse workspace and run the query onece again - I get 3 rows.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira