SQLBatch

Default value: false.

File: configuration file.

Context: DatabaseManager, Database.

If this parameter is set to “true”, DODS will use SQLBatch, feature of JDBC PrepareStatement Object, during database operations.

Warning

If you set this parameter to true, and parameter *.Connection.MaxPreparedStatements has low value, you may get errors at runtime - JDBC driver complaining about closed statements.

SQLBatch depends heavily on PreparedStatements cache (whose size is set with MaxPreparedStatements), and if it's not big enough some of batched statements may be closed by cache algorithm.