No announcement yet.

Mysql reading Java Heap error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql reading Java Heap error

    Hi guys,
    I'm fetching the data from mysqlDB to build a ccda in mirthconnect. I'm fetching many data from the DB and parsing into ccda sections. When i fetch few data from sql the process is working fine. When i get more data mirth throws error as follows:

    Exception in thread "Timer-186" java.lang.OutOfMemoryError: Java heap space
    I serached the forum and increased the heap size from 512m to 1024m but still i receive the same error. How to handle this problem Im using mirth version

    Mirth Interface Engineer
    AWS DevOps

  • #2
    It really depends on how many rows your query returns. You can try setting Cache Results to no and setting the Fetch Size. You can also limit your queries so that you don't fetch so much data at once.