8.2.36 setHADBSQLHashTblSize(int areaSize)
- Organization of this subsection
(1) Function
This method sets for this Connection object the size of the hash table area.
The value set by this method is compatible with the adb_sql_exe_hashtbl_area_size operand in the client definition.
- Important
-
For the Statement or PreparedStatement object generated from the Connection object for which this method is specified, the size of the hash table area that is set by this method is applied until the Connection object is closed.
For details about how to use this method (how to change the size of the hash table area for each SQL statement to be executed), see (7) Examples in 8.2.37 setHADBSQLMaxRthdNum(int rthdNum).
(2) Format
public void setHADBSQLHashTblSize(int areaSize) throws SQLException
(3) Arguments
- int areaSize
-
Specifies in megabytes the size of the hash table area to be set.
(4) Return value
None.
(5) Exceptions
The JDBC driver throws an SQLException in the following cases:
-
The Connection object is closed.
-
An invalid value is specified in areaSize.
(6) Notes
-
This is an HADB-specific method provided by the AdbConnection interface. For details about the execution method, see 12.2 Wrapper interface.
-
For the size of the hash table area specified by using the setHADBSQLHashTblSize method, the previously set value is not inherited if the Connection object is pooled and then reused. This is the same case as when the setHADBSQLHashTblSize method has not been executed.
-
Even if the setHADBSQLHashTblSize method is used to set the size of the hash table area again, the new setting is not applied to the Statement or PreparedStatement object that has already been generated.
-
For details about how the size of the hash table area is determined, see the explanation of the adb_sql_exe_hashtbl_area_size operand in 2.2.3 Operands related to performance.