HQL Console runs out of memory when querying large objects

I have a persistance unit that is large over 250 objects.  Some objects are large and reference other objects.  When running within JBOSS AS  querying these large objects causes no issue and works fine and quick.   However, from HQL console, i allways run out of heap even when the result is a sinlg object.  I increased the heap max size to 1.5gb and still does not work.  Here is the exception, it seams like there is a bug in the HQL Console.  Here is the query:

select acct from AccountsEntity acct where acct.accountid='xxxxxxx'; 


this should return an empty set.  But still getting an exception here is the trace:

> select acct from AccountsEntity acct where acct.accountid ='xxxx'
java.lang.OutOfMemoryError: Java heap space
    at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:99)
    at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:393)
    at java.lang.StringBuilder.append(StringBuilder.java:120)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:208)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
4 comments
Comment actions Permalink

http://www.jetbrains.net/jira/browse/IDEADEV-33795

Fixed. Thank you very much for reporting.

Manuel Elaraj wrote:

I have a persistance unit that is large over 250 objects.  Some objects are large and reference other objects.  When running within JBOSS AS  querying these large objects causes no issue and works fine and quick.   However, from HQL console, i allways run out of heap even when the result is a sinlg
object.  I increased the heap max size to 1.5gb and still does not work.  Here is the exception, it seams like there is a bug in the HQL Console.  Here is the query:



this should return an empty set.  But still getting an exception here is the trace:

> select acct from AccountsEntity acct where acct.accountid ='xxxx'
java.lang.OutOfMemoryError: Java heap space
    at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:99)
    at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:393)
    at java.lang.StringBuilder.append(StringBuilder.java:120)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:208)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)
    at com.intellij.hibernate.console.HibernateConsoleMain.printColumnDefinition(HibernateConsoleMain.java:203)

0
Comment actions Permalink

Same problem for me, all questions fail with the Java heap space error...

0
Comment actions Permalink

Same problem for me also and this is really annoying. 
Should I go back to Idea 7.0.4 ?

0
Comment actions Permalink

I should add that I'm, running intellij 8.0.1

0

Please sign in to leave a comment.