8.3.11 executeLargeUpdate(String sql)
- Organization of this subsection
(1) Function
This method executes an SQL statement (other than a retrieval SQL statement) and returns the number of updated rows as a long value.
If it is possible that the number of updated rows might exceed Integer.MAX_VALUE, use the executeLargeUpdate(String sql) method instead of executeUpdate(String sql). If you use the executeUpdate(String sql) method, it will return 0 if the update count exceeds Integer.MAX_VALUE.
(2) Format
public synchronized long executeLargeUpdate(String sql) throws SQLException
(3) Arguments
- String sql
-
Specifies the SQL statement (other than a retrieval SQL statement) to be executed.
(4) Return value
If an INSERT, UPDATE, or DELETE statement was executed, the method returns the number of updated rows as long data. If any other SQL statement was executed, the method returns 0.
(5) Exceptions
For details about exceptions, see (5) Exceptions in 8.3.13 executeUpdate(String sql).