Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


When using Mysql with a large set of data an OutOfMemoryError error is raised.



By Default, the MySQL JDBC Driver retrieves all results in memory, which can be the cause of OOM issues when working with large sets of data.

See ResultSet paragraph at http://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html  for further information.

The solution is to indicate to the driver to process the row one by one, like explained in the MySql documentation.

To do that, set the fetch_size to the minimal Integer value. It can be done dynamically with the following rhino expression :



Knowledge Base

Suggest a new Article!