[ https://jira.jboss.org/browse/JBIDE-7442?page=com.atlassian.jira.plugin.s... ] Vitali Yemialyanchyk updated JBIDE-7442: ---------------------------------------- Attachment: JBIDE-7442_20101029.txt -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/browse/JBIDE-7442?page=com.atlassian.jira.plugin.s... ] Vitali Yemialyanchyk commented on JBIDE-7442: --------------------------------------------- important snippet from our discussion related to the issue: Vitali Yemialyanchyk: i.e. there is a difference between HQL editor and QueryExporter - i.e. for the same ConsoleConfig -> HQL editor execute queries without problems but QueryExporter fail. maxcsaucdk: I do *not* want users to have this option. maxcsaucdk: not without a good reason. maxcsaucdk: and hql editor have long outstanding issue about having better session/tx management. maxcsaucdk: its not there because if we enabled transactions withiout stopping them we would have problems. maxcsaucdk: for query exporter there is a very limited timespan. Vitali Yemialyanchyk: ok your point is clear - but I did not understand your viewpoint for single query execution... how transaction could change something here... just example - just provide example? maxcsaucdk: an HQL query can result in mutliple selects maxcsaucdk: you want it to be read consistent maxcsaucdk: and if you run without transactions you are running with autocommit on which causes commits on Oracle even though you did not commit the tx. maxcsaucdk: i.e. "from MyClass" where MyClass is a superclass for multiple classes in tables will result in multiple selects and the read semantics will be non-tx'ional + performance will suffer since there on some db's will be forced transactions about each individual select. maxcsaucdk: hibernate tries to handle some of this but its *much* better to be explicit maxcsaucdk: hence why I do not want to encourage bad practices -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/browse/JBIDE-7442?page=com.atlassian.jira.plugin.s... ] Max Andersen resolved JBIDE-7442. --------------------------------- Resolution: Rejected queries should not be run without transactions. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira