7:20 a.m.
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
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
11:08 a.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12394976 ]
Max Andersen commented on JBIDE-1621:
-------------------------------------
eh yes...that all depends on your transaction level....are you sure this is not working as
expected.
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
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
11:47 a.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12394985 ]
Vitali Yemialyanchyk commented on JBIDE-1621:
---------------------------------------------
I don't sure is it working as expected - but I don't configure it specially.
Please look at attached project - if it a right place...
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
11:47 a.m.
New subject: [JBoss JIRA] Updated: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=all ]
Vitali Yemialyanchyk updated JBIDE-1621:
----------------------------------------
Attachment: querycache.zip
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
12:02 p.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12394993 ]
Max Andersen commented on JBIDE-1621:
-------------------------------------
the project is irrelevant. the quesiton is about what the transaction level of your
connection and database is...and wether you are actually using the exact same db.
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
12:25 p.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12394998 ]
Vitali Yemialyanchyk commented on JBIDE-1621:
---------------------------------------------
now I can't discuss it so deeply... Here I just point the problem from user point of
view. MySQL configuration is standard - installed by default. exact same db - certainly.
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
1:08 p.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12395007 ]
Max Andersen commented on JBIDE-1621:
-------------------------------------
users are kinda expected to understand transactions when using jdbc and/or hibernate.
what if you commit the tx you do inserts in; does the hql pick up the changes then ?
or what if you create another configuration pointing to the same db and run the query does
it pick it up then with or without the commit ?
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
1:26 p.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12395009 ]
Vitali Yemialyanchyk commented on JBIDE-1621:
---------------------------------------------
when I insert into the table I don't use transactions - I just run
INSERT INTO newtest.items SET name="xxx", description="dadada"
I don't try to create another new configuration - but I try -> Rebuild
Configuration -> and then get result as I expected to see.
So is bug or all here is OK?
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
2:01 p.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ 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
7:48 a.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12396338 ]
Vitali Yemialyanchyk commented on JBIDE-1621:
---------------------------------------------
May be here has a sence something as reconnect button?
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
7:54 a.m.
New subject: [JBoss JIRA] Commented: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=comments#action_12396344 ]
Max Andersen commented on JBIDE-1621:
-------------------------------------
close/open the session is what would make sense here.
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
5:30 a.m.
New subject: [JBoss JIRA] Closed: (JBIDE-1621) HQL Editor & Hibernate Criteria Editor - do not get DB updates
[ http://jira.jboss.com/jira/browse/JBIDE-1621?page=all ]
Max Andersen closed JBIDE-1621.
-------------------------------
Resolution: Rejected
this is expected behavior - create a new issue if there are some improvements we could
make in allowing session control.
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
6646
days inactive
6657
days old
jbosstools-issues@lists.jboss.org
11 comments
2 participants
participants (2)
-
Max Andersen (JIRA) -
Vitali Yemialyanchyk (JIRA)