Execution of a prepared statement with large parameter sets may lead to an internal server error

Detail name	Value
Changelog Number	6075
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.0, EXASolution 5.0.0
Fix Versions	EXASolution 5.0.22, EXASOL 6.0.9
Resolution Date	2018-06-14

Problem Description

After executing a prepared statement with large parameter sets (>128 MB) with the JDBC or ADO.NET driver, you may get the following exception message during the next command:

Successfully reconnected after internal server error, transaction was rolled back.

Workaround

• Limit data sets prepared statements to less than 100 MB per call to execute()
• Use the ODBC driver instead of JDBC or ADO.NET.