Class JdbcCallableStatement

Page Summary

TheJdbcCallableStatement class in Apps Script provides functionality for interacting with callable statements in a JDBC database connection.
It includes methods for batch processing, executing SQL statements, handling parameters (setting input and registering/retrieving output), and retrieving results and metadata.
The class also provides methods to manage statement properties and configurations, such as setting fetch size, query timeout, and closing the statement.
All methods described require authorization with thehttps://www.googleapis.com/auth/script.external_request scope for external database interaction.

JdbcCallableStatement

A JDBCCallableStatement. For documentation of this class, seejava.sql.CallableStatement.

Methods

Method	Return type	Brief description
`addBatch()`	`void`	For documentation of this method, see`java.sql.PreparedStatement#addBatch()`.
`addBatch(sql)`	`void`	For documentation of this method, see`java.sql.Statement#addBatch(String)`.
`cancel()`	`void`	For documentation of this method, see`java.sql.Statement#cancel()`.
`clearBatch()`	`void`	For documentation of this method, see`java.sql.Statement#clearBatch()`.
`clearParameters()`	`void`	For documentation of this method, see`java.sql.PreparedStatement#clearParameters()`.
`clearWarnings()`	`void`	For documentation of this method, see`java.sql.Statement#clearWarnings()`.
`close()`	`void`	For documentation of this method, see`java.sql.Statement#close()`.
`execute()`	`Boolean`	For documentation of this method, see`java.sql.PreparedStatement#execute()`.
`execute(sql)`	`Boolean`	For documentation of this method, see`java.sql.Statement#execute(String)`.
`execute(sql, autoGeneratedKeys)`	`Boolean`	For documentation of this method, see`java.sql.Statement#execute(String, int)`.
`execute(sql, columnIndexes)`	`Boolean`	For documentation of this method, see`java.sql.Statement#execute(String, int[])`.
`execute(sql, columnNames)`	`Boolean`	For documentation of this method, see`java.sql.Statement#execute(String, String[])`.
`executeBatch()`	`Integer[]`	For documentation of this method, see`java.sql.Statement#executeBatch()`.
`executeBatch(parameters)`	`Integer[]`	Submits a batch of commands to the database for execution and if all commands executesuccessfully, returns an array of update counts.
`executeQuery()`	`JdbcResultSet`	For documentation of this method, see`java.sql.PreparedStatement#executeQuery()`.
`executeQuery(sql)`	`JdbcResultSet`	For documentation of this method, see`java.sql.Statement#executeQuery(String)`.
`executeUpdate()`	`Integer`	For documentation of this method, see`java.sql.PreparedStatement#executeUpdate()`.
`executeUpdate(sql)`	`Integer`	For documentation of this method, see`java.sql.Statement#executeUpdate(String)`.
`executeUpdate(sql, autoGeneratedKeys)`	`Integer`	For documentation of this method, see`java.sql.Statement#executeUpdate(String, int)`.
`executeUpdate(sql, columnIndexes)`	`Integer`	For documentation of this method, see`java.sql.Statement#executeUpdate(String, int[])`.
`executeUpdate(sql, columnNames)`	`Integer`	For documentation of this method, see`java.sql.Statement#executeUpdate(String, String[])`.
`getArray(parameterIndex)`	`JdbcArray`	For documentation of this method, see`java.sql.CallableStatement#getArray(int)`.
`getArray(parameterName)`	`JdbcArray`	For documentation of this method, see`java.sql.CallableStatement#getArray(String)`.
`getBigDecimal(parameterIndex)`	`BigNumber`	For documentation of this method, see`java.sql.CallableStatement#getBigDecimal(int)`.
`getBigDecimal(parameterName)`	`BigNumber`	For documentation of this method, see`java.sql.CallableStatement#getBigDecimal(String)`.
`getBlob(parameterIndex)`	`JdbcBlob`	For documentation of this method, see`java.sql.CallableStatement#getBlob(int)`.
`getBlob(parameterName)`	`JdbcBlob`	For documentation of this method, see`java.sql.CallableStatement#getBlob(String)`.
`getBoolean(parameterIndex)`	`Boolean`	For documentation of this method, see`java.sql.CallableStatement#getBoolean(int)`.
`getBoolean(parameterName)`	`Boolean`	For documentation of this method, see`java.sql.CallableStatement#getBoolean(String)`.
`getByte(parameterIndex)`	`Byte`	For documentation of this method, see`java.sql.CallableStatement#getByte(int)`.
`getByte(parameterName)`	`Byte`	For documentation of this method, see`java.sql.CallableStatement#getByte(String)`.
`getBytes(parameterIndex)`	`Byte[]`	For documentation of this method, see`java.sql.CallableStatement#getBytes(int)`.
`getBytes(parameterName)`	`Byte[]`	For documentation of this method, see`java.sql.CallableStatement#getBytes(String)`.
`getClob(parameterIndex)`	`JdbcClob`	For documentation of this method, see`java.sql.CallableStatement#getClob(int)`.
`getClob(parameterName)`	`JdbcClob`	For documentation of this method, see`java.sql.CallableStatement#getClob(String)`.
`getConnection()`	`JdbcConnection`	For documentation of this method, see`java.sql.Statement#getConnection()`.
`getDate(parameterIndex)`	`JdbcDate`	For documentation of this method, see`java.sql.CallableStatement#getDate(int)`.
`getDate(parameterIndex, timeZone)`	`JdbcDate`	For documentation of this method, see`java.sql.CallableStatement#getDate(int, Calendar)`.
`getDate(parameterName)`	`JdbcDate`	For documentation of this method, see`java.sql.CallableStatement#getDate(String)`.
`getDate(parameterName, timeZone)`	`JdbcDate`	For documentation of this method, see`java.sql.CallableStatement#getDate(String, Calendar)`.
`getDouble(parameterIndex)`	`Number`	For documentation of this method, see`java.sql.CallableStatement#getDouble(int)`.
`getDouble(parameterName)`	`Number`	For documentation of this method, see`java.sql.CallableStatement#getDouble(String)`.
`getFetchDirection()`	`Integer`	For documentation of this method, see`java.sql.Statement#getFetchDirection()`.
`getFetchSize()`	`Integer`	For documentation of this method, see`java.sql.Statement#getFetchSize()`.
`getFloat(parameterIndex)`	`Number`	For documentation of this method, see`java.sql.CallableStatement#getFloat(int)`.
`getFloat(parameterName)`	`Number`	For documentation of this method, see`java.sql.CallableStatement#getFloat(String)`.
`getGeneratedKeys()`	`JdbcResultSet`	For documentation of this method, see`java.sql.Statement#getGeneratedKeys()`.
`getInt(parameterIndex)`	`Integer`	For documentation of this method, see`java.sql.CallableStatement#getInt(int)`.
`getInt(parameterName)`	`Integer`	For documentation of this method, see`java.sql.CallableStatement#getInt(String)`.
`getLong(parameterIndex)`	`Integer`	For documentation of this method, see`java.sql.CallableStatement#getLong(int)`.
`getLong(parameterName)`	`Integer`	For documentation of this method, see`java.sql.CallableStatement#getLong(String)`.
`getMaxFieldSize()`	`Integer`	For documentation of this method, see`java.sql.Statement#getMaxFieldSize()`.
`getMaxRows()`	`Integer`	For documentation of this method, see`java.sql.Statement#getMaxRows()`.
`getMetaData()`	`JdbcResultSetMetaData`	For documentation of this method, see`java.sql.PreparedStatement#getMetaData()`.
`getMoreResults()`	`Boolean`	For documentation of this method, see`java.sql.Statement#getMoreResults()`.
`getMoreResults(current)`	`Boolean`	For documentation of this method, see`java.sql.Statement#getMoreResults(int)`.
`getNClob(parameterIndex)`	`JdbcClob`	For documentation of this method, see`java.sql.CallableStatement#getNClob(int)`.
`getNClob(parameterName)`	`JdbcClob`	For documentation of this method, see`java.sql.CallableStatement#getNClob(String)`.
`getNString(parameterIndex)`	`String`	For documentation of this method, see`java.sql.CallableStatement#getNString(int)`.
`getNString(parameterName)`	`String`	For documentation of this method, see`java.sql.CallableStatement#getNString(String)`.
`getObject(parameterIndex)`	`Object`	For documentation of this method, see`java.sql.CallableStatement#getObject(int)`.
`getObject(parameterName)`	`Object`	For documentation of this method, see`java.sql.CallableStatement#getObject(String)`.
`getParameterMetaData()`	`JdbcParameterMetaData`	For documentation of this method, see`java.sql.PreparedStatement#getParameterMetaData()`.
`getQueryTimeout()`	`Integer`	For documentation of this method, see`java.sql.Statement#getQueryTimeout()`.
`getRef(parameterIndex)`	`JdbcRef`	For documentation of this method, see`java.sql.CallableStatement#getRef(int)`.
`getRef(parameterName)`	`JdbcRef`	For documentation of this method, see`java.sql.CallableStatement#getRef(String)`.
`getResultSet()`	`JdbcResultSet`	For documentation of this method, see`java.sql.Statement#getResultSet()`.
`getResultSetConcurrency()`	`Integer`	For documentation of this method, see`java.sql.Statement#getResultSetConcurrency()`.
`getResultSetHoldability()`	`Integer`	For documentation of this method, see`java.sql.Statement#getResultSetHoldability()`.
`getResultSetType()`	`Integer`	For documentation of this method, see`java.sql.Statement#getResultSetType()`.
`getRowId(parameterIndex)`	`JdbcRowId`	For documentation of this method, see`java.sql.CallableStatement#getRowId(int)`.
`getRowId(parameterName)`	`JdbcRowId`	For documentation of this method, see`java.sql.CallableStatement#getRowId(String)`.
`getSQLXML(parameterIndex)`	`JdbcSQLXML`	For documentation of this method, see`java.sql.CallableStatement#getSQLXML(int)`.
`getSQLXML(parameterName)`	`JdbcSQLXML`	For documentation of this method, see`java.sql.CallableStatement#getSQLXML(String)`.
`getShort(parameterIndex)`	`Integer`	For documentation of this method, see`java.sql.CallableStatement#getShort(int)`.
`getShort(parameterName)`	`Integer`	For documentation of this method, see`java.sql.CallableStatement#getShort(String)`.
`getString(parameterIndex)`	`String`	For documentation of this method, see`java.sql.CallableStatement#getString(int)`.
`getString(parameterName)`	`String`	For documentation of this method, see`java.sql.CallableStatement#getString(String)`.
`getTime(parameterIndex)`	`JdbcTime`	For documentation of this method, see`java.sql.CallableStatement#getTime(int)`.
`getTime(parameterIndex, timeZone)`	`JdbcTime`	For documentation of this method, see`java.sql.CallableStatement#getTime(int, Calendar)`.
`getTime(parameterName)`	`JdbcTime`	For documentation of this method, see`java.sql.CallableStatement#getTime(String)`.
`getTime(parameterName, timeZone)`	`JdbcTime`	For documentation of this method, see`java.sql.CallableStatement#getTime(String, Calendar)`.
`getTimestamp(parameterIndex)`	`JdbcTimestamp`	For documentation of this method, see`java.sql.CallableStatement#getTimestamp(int)`.
`getTimestamp(parameterIndex, timeZone)`	`JdbcTimestamp`	For documentation of this method, see`java.sql.CallableStatement#getTimestamp(int, Calendar)`.
`getTimestamp(parameterName)`	`JdbcTimestamp`	For documentation of this method, see`java.sql.CallableStatement#getTimestamp(String)`.
`getTimestamp(parameterName, timeZone)`	`JdbcTimestamp`	For documentation of this method, see`java.sql.CallableStatement#getTimestamp(String, Calendar)`.
`getURL(parameterIndex)`	`String`	For documentation of this method, see`java.sql.CallableStatement#getURL(int)`.
`getURL(parameterName)`	`String`	For documentation of this method, see`java.sql.CallableStatement#getURL(String)`.
`getUpdateCount()`	`Integer`	For documentation of this method, see`java.sql.Statement#getUpdateCount()`.
`getWarnings()`	`String[]`	For documentation of this method, see`java.sql.Statement#getWarnings()`.
`isClosed()`	`Boolean`	For documentation of this method, see`java.sql.Statement#isClosed()`.
`isPoolable()`	`Boolean`	For documentation of this method, see`java.sql.Statement#isPoolable()`.
`registerOutParameter(parameterIndex, sqlType)`	`void`	For documentation of this method, see`java.sql.CallableStatement#registerOutParameter(int, int)`.
`registerOutParameter(parameterIndex, sqlType, scale)`	`void`	For documentation of this method, see`java.sql.CallableStatement#registerOutParameter(int, int, int)`.
`registerOutParameter(parameterIndex, sqlType, typeName)`	`void`	For documentation of this method, see`java.sql.CallableStatement#registerOutParameter(int, int, String)`.
`registerOutParameter(parameterName, sqlType)`	`void`	For documentation of this method, see`java.sql.CallableStatement#registerOutParameter(String, int)`.
`registerOutParameter(parameterName, sqlType, scale)`	`void`	For documentation of this method, see`java.sql.CallableStatement#registerOutParameter(String, int, int)`.
`registerOutParameter(parameterName, sqlType, typeName)`	`void`	For documentation of this method, see`java.sql.CallableStatement#registerOutParameter(String, int, String)`.
`setArray(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setArray(int, Array)`.
`setBigDecimal(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setBigDecimal(int, BigDecimal)`.
`setBigDecimal(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setBigDecimal(String, BigDecimal)`.
`setBlob(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setBlob(int, Clob)`.
`setBlob(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setBlob(String, Blob)`.
`setBoolean(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setBoolean(int, boolean)`.
`setBoolean(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setBoolean(String, boolean)`.
`setByte(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setByte(int, byte)`.
`setByte(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setByte(String, byte)`.
`setBytes(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setBytes(int, byte[])`.
`setBytes(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setBytes(String, byte[])`.
`setClob(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setClob(int, Clob)`.
`setClob(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setBlob(String, Clob)`.
`setCursorName(name)`	`void`	For documentation of this method, see`java.sql.Statement#setCursorName(String)`.
`setDate(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setDate(int, Date)`.
`setDate(parameterIndex, x, timeZone)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setDate(int, Date, Calendar)`.
`setDate(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setDate(String, Date)`.
`setDate(parameterName, x, timeZone)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setDate(String, Date, Calendar)`.
`setDouble(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setDouble(int, double)`.
`setDouble(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setDouble(String, double)`.
`setEscapeProcessing(enable)`	`void`	For documentation of this method, see`java.sql.Statement#setEscapeProcessing(boolean)`.
`setFetchDirection(direction)`	`void`	For documentation of this method, see`java.sql.Statement#setFetchDirection(int)`.
`setFetchSize(rows)`	`void`	For documentation of this method, see`java.sql.Statement#setFetchSize(int)`.
`setFloat(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setFloat(int, float)`.
`setFloat(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setFloat(String, float)`.
`setInt(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setInt(int, int)`.
`setInt(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setInt(String, int)`.
`setLong(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setLong(int, long)`.
`setLong(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setLong(String, long)`.
`setMaxFieldSize(max)`	`void`	For documentation of this method, see`java.sql.Statement#setMaxFieldSize(int)`.
`setMaxRows(max)`	`void`	For documentation of this method, see`java.sql.Statement#setMaxRows(int)`.
`setNClob(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setNClob(int, NClob)`.
`setNClob(parameterName, value)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setNClob(String, NClob)`.
`setNString(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setNString(int, String)`.
`setNString(parameterName, value)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setNString(String, String)`.
`setNull(parameterIndex, sqlType)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setNull(int, int)`.
`setNull(parameterIndex, sqlType, typeName)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setNull(int, int, String)`.
`setNull(parameterName, sqlType)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setNull(String, int)`.
`setNull(parameterName, sqlType, typeName)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setNull(String, int, String)`.
`setObject(index, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setObject(int, Object)`.
`setObject(parameterIndex, x, targetSqlType)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setObject(int, Object, int)`.
`setObject(parameterIndex, x, targetSqlType, scaleOrLength)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setObject(int, Object, int, int)`.
`setObject(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setObject(String, Object)`.
`setObject(parameterName, x, targetSqlType)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setObject(String, Object, int)`.
`setObject(parameterName, x, targetSqlType, scale)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setObject(String, Object, int, int)`.
`setPoolable(poolable)`	`void`	For documentation of this method, see`java.sql.Statement#setPoolable(boolean)`.
`setQueryTimeout(seconds)`	`void`	For documentation of this method, see`java.sql.Statement#setQueryTimeout(int)`.
`setRef(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setRef(int, Ref)`.
`setRowId(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setRowId(int, RowId)`.
`setRowId(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setRowId(String, RowId)`.
`setSQLXML(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setSQLXML(int, SQLXML)`.
`setSQLXML(parameterName, xmlObject)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setSQLXML(String, SQLXML)`.
`setShort(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setShort(int, short)`.
`setShort(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setShort(String, short)`.
`setString(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setString(int, String)`.
`setString(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setString(String, String)`.
`setTime(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setTime(int, Time)`.
`setTime(parameterIndex, x, timeZone)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setTime(int, Time, Calendar)`.
`setTime(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setTime(String, Time)`.
`setTime(parameterName, x, timeZone)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setTime(String, Time, Calendar)`.
`setTimestamp(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setTimestamp(int, Timestamp)`.
`setTimestamp(parameterIndex, x, timeZone)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar)`.
`setTimestamp(parameterName, x)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setTimestamp(String, Timestamp)`.
`setTimestamp(parameterName, x, timeZone)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setTimestamp(String, Timestamp, Calendar)`.
`setURL(parameterIndex, x)`	`void`	For documentation of this method, see`java.sql.PreparedStatement#setURL(int, URL)`.
`setURL(parameterName, val)`	`void`	For documentation of this method, see`java.sql.CallableStatement#setURL(String, URL)`.
`wasNull()`	`Boolean`	For documentation of this method, see`java.sql.CallableStatement#wasNull()`.

Detailed documentation

`addBatch()`

For documentation of this method, seejava.sql.PreparedStatement#addBatch().

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`addBatch(sql)`

For documentation of this method, seejava.sql.Statement#addBatch(String).

Parameters

Name	Type	Description
`sql`	`String`	The SQL command to add to this statement, typically an SQL`INSERT` or`UPDATE`.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`cancel()`

For documentation of this method, seejava.sql.Statement#cancel().

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`clearBatch()`

For documentation of this method, seejava.sql.Statement#clearBatch().

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`clearParameters()`

For documentation of this method, seejava.sql.PreparedStatement#clearParameters().

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`clearWarnings()`

For documentation of this method, seejava.sql.Statement#clearWarnings().

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`close()`

For documentation of this method, seejava.sql.Statement#close().

`execute()`

For documentation of this method, seejava.sql.PreparedStatement#execute().

Return

Boolean —true if the first result is a result set;false if the first result is an update count or there is no result.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`execute(sql)`

For documentation of this method, seejava.sql.Statement#execute(String).

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute.

Return

Boolean —true if the first result is a result set;false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`execute(sql, autoGeneratedKeys)`

For documentation of this method, seejava.sql.Statement#execute(String, int).

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute.
`autoGeneratedKeys`	`Integer`	A flag that indicates whether auto-generated keys are made available for future retrieval; either`Jdbc.Statement.RETURN_GENERATED_KEYS` or`Jdbc.Statement.NO_GENERATED_KEYS`.

Return

Boolean —true if the first result is a result set;false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`execute(sql, columnIndexes)`

For documentation of this method, seejava.sql.Statement#execute(String, int[]).

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute.
`columnIndexes`	`Integer[]`	The column indices in the whose auto-generated keys are made available for future retrieval.

Return

Boolean —true if the first result is a result set;false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`execute(sql, columnNames)`

For documentation of this method, seejava.sql.Statement#execute(String, String[]).

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute.
`columnNames`	`String[]`	The names of columns in the whose auto-generated keys are made available for future retrieval.

Return

Boolean —true if the first result is a result set;false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeBatch()`

For documentation of this method, seejava.sql.Statement#executeBatch().

Return

Integer[] — The update counts for each command in the batch, using the same order in which commands were added to the batch.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeBatch(parameters)`

Submits a batch of commands to the database for execution and if all commands executesuccessfully, returns an array of update counts. The parameters argument is a 2D array, whereeach inner array contains the parameters for a single execution of the statement. For example,if you have a statement like "INSERT INTO employees (name, age) VALUES (?, ?)", the parameterscould be[["John Doe", 30], ["John Smith", 25]].

The following example inserts multiple rows into a database using batching:

varconn=Jdbc.getCloudSqlConnection("jdbc:google:mysql://...");varstmt=conn.prepareStatement("INSERT INTO employees (name, age) VALUES (?, ?)");varparams=[["John Doe",30],["John Smith",25]];stmt.executeBatch(params);

Parameters

Name	Type	Description
`parameters`	`Object[][]`	A 2D array of Objects representing the parameters for each batch.

Return

Integer[] — An array of update counts containing one element for each command in the batch.

Throws

Error — if a database access error occurs.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeQuery()`

For documentation of this method, seejava.sql.PreparedStatement#executeQuery().

Return

JdbcResultSet — A result set that contains the data produced by the query.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeQuery(sql)`

For documentation of this method, seejava.sql.Statement#executeQuery(String).

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute, typically a static`SELECT`.

Return

JdbcResultSet — A result set containing the results of the execution. This is nevernull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate()`

For documentation of this method, seejava.sql.PreparedStatement#executeUpdate().

Return

Integer — The row count ofr SQL Data Manipulation Language statements, or 0 for SQL statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql)`

For documentation of this method, seejava.sql.Statement#executeUpdate(String).

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as`INSERT`,`UPDATE`, or`DELETE`), or else a statement that returns nothing (such as a DDL statement).

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql, autoGeneratedKeys)`

For documentation of this method, seejava.sql.Statement#executeUpdate(String, int).

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as`INSERT`,`UPDATE`, or`DELETE`), or else a statement that returns nothing (such as a DDL statement).
`autoGeneratedKeys`	`Integer`	A flag that indicates whether auto-generated keys are made available for future retrieval; either`Jdbc.Statement.RETURN_GENERATED_KEYS` or`Jdbc.Statement.NO_GENERATED_KEYS`.

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql, columnIndexes)`

For documentation of this method, seejava.sql.Statement#executeUpdate(String, int[]).

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as`INSERT`,`UPDATE`, or`DELETE`), or else a statement that returns nothing (such as a DDL statement).
`columnIndexes`	`Integer[]`	The column indices in the whose auto-generated keys are made available for future retrieval.

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql, columnNames)`

For documentation of this method, seejava.sql.Statement#executeUpdate(String, String[]).

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as`INSERT`,`UPDATE`, or`DELETE`), or else a statement that returns nothing (such as a DDL statement).
`columnNames`	`String[]`	The names of columns in the whose auto-generated keys are made available for future retrieval.

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getArray(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getArray(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

JdbcArray — The value of aARRAY parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getArray(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getArray(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcArray — The value of aARRAY parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBigDecimal(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getBigDecimal(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

BigNumber — The value of aNUMERIC parameter in full precision. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBigDecimal(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getBigDecimal(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

BigNumber — The value of aNUMERIC parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBlob(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getBlob(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

JdbcBlob — The value of aBLOB parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBlob(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getBlob(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcBlob — The value of aBLOB parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBoolean(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getBoolean(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Boolean — The value of aBIT orBOOLEAN parameter. Returnsfalse if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBoolean(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getBoolean(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Boolean — The value of aBIT orBOOLEAN parameter. Returnsfalse if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getByte(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getByte(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Byte — The value of aTINYINT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getByte(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getByte(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Byte — The value of aTINYINT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBytes(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getBytes(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Byte[] — The value of aBINARY orVARBINARY parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getBytes(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getBytes(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Byte[] — The value of aBINARY orVARBINARY parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getClob(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getClob(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

JdbcClob — The value of aCLOB parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getClob(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getClob(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcClob — The value of aCLOB parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getConnection()`

For documentation of this method, seejava.sql.Statement#getConnection().

Return

JdbcConnection — The connection that produced this statement.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getDate(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getDate(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

JdbcDate — The value of aDATE parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getDate(parameterIndex, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#getDate(int, Calendar).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Return

JdbcDate — The value of aDATE parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getDate(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getDate(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcDate — The value of aDATE parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getDate(parameterName, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#getDate(String, Calendar).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Return

JdbcDate — The value of aDATE parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getDouble(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getDouble(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Number — The value of aDOUBLE parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getDouble(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getDouble(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Number — The value of aDOUBLE parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getFetchDirection()`

For documentation of this method, seejava.sql.Statement#getFetchDirection().

Return

Integer — The default direction for result sets generated by this statement, which is eitherJdbc.ResultSet.FETCH_FORWARD orJdbc.ResultSet.FETCH_REVERSE.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getFetchSize()`

For documentation of this method, seejava.sql.Statement#getFetchSize().

Return

Integer — The default row fetch size for result sets generated from this statement.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getFloat(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getFloat(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Number — The value of aFLOAT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getFloat(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getFloat(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Number — The value of aFLOAT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getGeneratedKeys()`

For documentation of this method, seejava.sql.Statement#getGeneratedKeys().

Return

JdbcResultSet — A result set containing the auto-generated keys generated by the execution of this statement.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getInt(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getInt(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Integer — The value of aINTEGER parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getInt(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getInt(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Integer — The value of aINTEGER parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getLong(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getLong(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Integer — The value of aBIGINT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getLong(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getLong(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Integer — The value of aBIGINT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getMaxFieldSize()`

For documentation of this method, seejava.sql.Statement#getMaxFieldSize().

Return

Integer — The current column byte size limit for columns storing character and binary values; a value of zero indictates no limit.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getMaxRows()`

For documentation of this method, seejava.sql.Statement#getMaxRows().

Return

Integer — The current maximum number of rows for a result set produced by this statement; a value of 0 indicates no limit.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getMetaData()`

For documentation of this method, seejava.sql.PreparedStatement#getMetaData().

Return

JdbcResultSetMetaData — The description of a result set's columns, orNULL if this metadata is unavailable.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getMoreResults()`

For documentation of this method, seejava.sql.Statement#getMoreResults().

Return

Boolean —true if the next result is a result set;false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getMoreResults(current)`

For documentation of this method, seejava.sql.Statement#getMoreResults(int).

Parameters

Name	Type	Description
`current`	`Integer`	A flag that indicates what happens to current result sets when retrieved. This value is one of`Jdbc.Statement.CLOSE_CURRENT_RESULT`,`Jdbc.Statement.KEEP_CURRENT_RESULT`, or`Jdbc.Statement.CLOSE_ALL_RESULTS`.

Return

Boolean —true if the next result is a result set;false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getNClob(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getNClob(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	An index indicating which parameter to register (the first parameter is 1, the second is 2, and so on).

Return

JdbcClob — The value of aNCLOB parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getNClob(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getNClob(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcClob — The value of aNCLOB parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getNString(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getNString(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	An index indicating which parameter to register (the first parameter is 1, the second is 2, and so on).

Return

String — A string that maps aNCHAR,NVARCHAR, orLONGNVARCHAR value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getNString(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getNString(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

String — A string that maps aNCHAR,NVARCHAR, orLONGNVARCHAR value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getObject(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getObject(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Object — An object holding the parameter value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getObject(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getObject(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Object — An object holding the parameter value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getParameterMetaData()`

For documentation of this method, seejava.sql.PreparedStatement#getParameterMetaData().

Return

JdbcParameterMetaData — The parameter metadata, including the number, types, and properties for each parameter.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getQueryTimeout()`

For documentation of this method, seejava.sql.Statement#getQueryTimeout().

Return

Integer — The current query timeout in seconds; a value of zero indicates no timeout.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getRef(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getRef(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

JdbcRef — The value of aREF parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getRef(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getRef(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcRef — The value of aREF parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getResultSet()`

For documentation of this method, seejava.sql.Statement#getResultSet().

Return

JdbcResultSet — The current result set, ornull if the result is an update count or there are no more results.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getResultSetConcurrency()`

For documentation of this method, seejava.sql.Statement#getResultSetConcurrency().

Return

Integer — The result set concurrency for result sets generated from this statement, which is eitherJdbc.ResultSet.CONCUR_READ_ONLY orJdbc.ResultSet.CONCUR_UPDATABLE.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getResultSetHoldability()`

For documentation of this method, seejava.sql.Statement#getResultSetHoldability().

Return

Integer — The result set holdability, which is eitherJdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT orJdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getResultSetType()`

For documentation of this method, seejava.sql.Statement#getResultSetType().

Return

Integer — The result set type for result sets generated from this statement, which isJdbc.ResultSet.TYPE_FORWARD_ONLY,Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE, orJdbc.ResultSet.TYPE_SCROLL_INSENSITIVE.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getRowId(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getRowId(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	An index indicating which parameter to register (the first parameter is 1, the second is 2, and so on).

Return

JdbcRowId — TheROWID value. Returnsnull if the parameter contains an SQLNULL.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getRowId(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getRowId(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcRowId — TheROWID value. Returnsnull if the parameter contains an SQLNULL.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getSQLXML(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getSQLXML(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	An index indicating which parameter to register (the first parameter is 1, the second is 2, and so on).

Return

JdbcSQLXML — A SQLXML object that maps to an SQL XML value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getSQLXML(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getSQLXML(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcSQLXML — A SQLXML object that maps to an SQL XML value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getShort(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getShort(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

Integer — The value of aSMALLINT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getShort(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getShort(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

Integer — The value of aSMALLINT parameter. Returns 0 if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getString(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getString(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

String — The value of aCHAR,VARCHAR, orLONGVARCHAR parameter.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getString(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getString(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

String — The value of aCHAR,VARCHAR, orLONGVARCHAR parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTime(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getTime(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

JdbcTime — The value of aTIME parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTime(parameterIndex, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#getTime(int, Calendar).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Return

JdbcTime — The value of aTIME parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTime(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getTime(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcTime — The value of aTIME parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTime(parameterName, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#getTime(String, Calendar).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Return

JdbcTime — The value of aTIME parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTimestamp(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getTimestamp(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

JdbcTimestamp — The value of aTIMESTAMP parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTimestamp(parameterIndex, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#getTimestamp(int, Calendar).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Return

JdbcTimestamp — The value of aTIMESTAMP parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTimestamp(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getTimestamp(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

JdbcTimestamp — The value of aTIMESTAMP parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getTimestamp(parameterName, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#getTimestamp(String, Calendar).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Return

JdbcTimestamp — The value of aTIMESTAMP parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getURL(parameterIndex)`

For documentation of this method, seejava.sql.CallableStatement#getURL(int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

Return

String — The value of aDATALINK parameter as a string.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getURL(parameterName)`

For documentation of this method, seejava.sql.CallableStatement#getURL(String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter.

Return

String — The value of aDATALINK parameter. Returnsnull if the value isnull.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getUpdateCount()`

For documentation of this method, seejava.sql.Statement#getUpdateCount().

Return

Integer — The current result as an update count, or -1 if the current result is a result set or if there are no more results.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`getWarnings()`

For documentation of this method, seejava.sql.Statement#getWarnings().

Return

String[] — The current set of warnings, ornull if there are no warnings.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`isClosed()`

For documentation of this method, seejava.sql.Statement#isClosed().

Return

Boolean —true if this statement is closed;false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`isPoolable()`

For documentation of this method, seejava.sql.Statement#isPoolable().

Return

Boolean —true if this statement is poolable;false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`registerOutParameter(parameterIndex, sqlType)`

For documentation of this method, seejava.sql.CallableStatement#registerOutParameter(int, int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	An index indicating which parameter to register (the first parameter is 1, the second is 2, and so on).
`sqlType`	`Integer`	The JDBCtype code to register. If the parameter is of JDBC type`NUMERIC` or`DECIMAL`, use`registerOutParameter(parameterIndex, sqlType, scale)` instead.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`registerOutParameter(parameterIndex, sqlType, scale)`

For documentation of this method, seejava.sql.CallableStatement#registerOutParameter(int, int, int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	An index indicating which parameter to register (the first parameter is 1, the second is 2, and so on).
`sqlType`	`Integer`	The JDBCtype code to register.
`scale`	`Integer`	The desired number of digits to the right of the decimal point (must be zero or greater).

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`registerOutParameter(parameterIndex, sqlType, typeName)`

For documentation of this method, seejava.sql.CallableStatement#registerOutParameter(int, int, String).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
`sqlType`	`Integer`	Atype code value.
`typeName`	`String`	The fully-qualified name of an SQL structured type.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`registerOutParameter(parameterName, sqlType)`

For documentation of this method, seejava.sql.CallableStatement#registerOutParameter(String, int).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to be registered.
`sqlType`	`Integer`	Atype code value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`registerOutParameter(parameterName, sqlType, scale)`

For documentation of this method, seejava.sql.CallableStatement#registerOutParameter(String, int, int).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to be registered.
`sqlType`	`Integer`	Atype code value.
`scale`	`Integer`	The desired number of digits to the right of the decimal point, which must be zero or greater.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`registerOutParameter(parameterName, sqlType, typeName)`

For documentation of this method, seejava.sql.CallableStatement#registerOutParameter(String, int, String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to be registered.
`sqlType`	`Integer`	Atype code value.
`typeName`	`String`	The fully-qualified name of an SQL structured type.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setArray(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setArray(int, Array).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcArray`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBigDecimal(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setBigDecimal(int, BigDecimal).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`BigNumber`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBigDecimal(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setBigDecimal(String, BigDecimal).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`BigNumber`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBlob(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setBlob(int, Clob).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcBlob`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBlob(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setBlob(String, Blob).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcBlob`	A blob that maps to an SQL`BLOB` value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBoolean(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setBoolean(int, boolean).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Boolean`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBoolean(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setBoolean(String, boolean).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Boolean`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setByte(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setByte(int, byte).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Byte`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setByte(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setByte(String, byte).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Byte`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBytes(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setBytes(int, byte[]).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Byte[]`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setBytes(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setBytes(String, byte[]).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Byte[]`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setClob(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setClob(int, Clob).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcClob`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setClob(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setBlob(String, Clob).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcClob`	A clob that maps to an SQL`CLOB` value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setCursorName(name)`

For documentation of this method, seejava.sql.Statement#setCursorName(String).

Parameters

Name	Type	Description
`name`	`String`	The new cursor name, which must be unique within a connection.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setDate(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setDate(int, Date).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcDate`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setDate(parameterIndex, x, timeZone)`

For documentation of this method, seejava.sql.PreparedStatement#setDate(int, Date, Calendar).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcDate`	The parameter value to set.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setDate(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setDate(String, Date).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcDate`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setDate(parameterName, x, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#setDate(String, Date, Calendar).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcDate`	The parameter value to set.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setDouble(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setDouble(int, double).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Number`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setDouble(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setDouble(String, double).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Number`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setEscapeProcessing(enable)`

For documentation of this method, seejava.sql.Statement#setEscapeProcessing(boolean).

Parameters

Name	Type	Description
`enable`	`Boolean`	If`true`, escape processing is enabled; otherwise it is disabled.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setFetchDirection(direction)`

For documentation of this method, seejava.sql.Statement#setFetchDirection(int).

Parameters

Name	Type	Description
`direction`	`Integer`	The specified direction to set, which is either`Jdbc.ResultSet.FETCH_FORWARD` or`Jdbc.ResultSet.FETCH_REVERSE`.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setFetchSize(rows)`

For documentation of this method, seejava.sql.Statement#setFetchSize(int).

Parameters

Name	Type	Description
`rows`	`Integer`	The number of rows to fetch.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setFloat(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setFloat(int, float).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Number`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setFloat(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setFloat(String, float).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Number`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setInt(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setInt(int, int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Integer`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setInt(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setInt(String, int).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Integer`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setLong(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setLong(int, long).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Integer`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setLong(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setLong(String, long).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Integer`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setMaxFieldSize(max)`

For documentation of this method, seejava.sql.Statement#setMaxFieldSize(int).

Parameters

Name	Type	Description
`max`	`Integer`	The new column byte size limit; a value of zero indicates no limit.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setMaxRows(max)`

For documentation of this method, seejava.sql.Statement#setMaxRows(int).

Parameters

Name	Type	Description
`max`	`Integer`	The maximum number of rows a result set generated by this statement can have. A value of 0 indicates no limit.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNClob(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setNClob(int, NClob).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcClob`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNClob(parameterName, value)`

For documentation of this method, seejava.sql.CallableStatement#setNClob(String, NClob).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`value`	`JdbcClob`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNString(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setNString(int, String).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`String`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNString(parameterName, value)`

For documentation of this method, seejava.sql.CallableStatement#setNString(String, String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`value`	`String`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNull(parameterIndex, sqlType)`

For documentation of this method, seejava.sql.PreparedStatement#setNull(int, int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`sqlType`	`Integer`	TheSQL type of the specified parameter.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNull(parameterIndex, sqlType, typeName)`

For documentation of this method, seejava.sql.PreparedStatement#setNull(int, int, String).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`sqlType`	`Integer`	TheSQL type of the specified parameter.
`typeName`	`String`	The fully-qualifed name of an SQL user-defined type. Ignored if the parameter isn't a user-defined type or`REF`.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNull(parameterName, sqlType)`

For documentation of this method, seejava.sql.CallableStatement#setNull(String, int).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`sqlType`	`Integer`	The SQL type code.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setNull(parameterName, sqlType, typeName)`

For documentation of this method, seejava.sql.CallableStatement#setNull(String, int, String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`sqlType`	`Integer`	TheSQL type.
`typeName`	`String`	The fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL`REF` value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setObject(index, x)`

For documentation of this method, seejava.sql.PreparedStatement#setObject(int, Object).

Parameters

Name	Type	Description
`index`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Object`	The object containing the value to set the parameter to.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setObject(parameterIndex, x, targetSqlType)`

For documentation of this method, seejava.sql.PreparedStatement#setObject(int, Object, int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Object`	The object containing the value to set the parameter to.
`targetSqlType`	`Integer`	TheSQL type to send to the database.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setObject(parameterIndex, x, targetSqlType, scaleOrLength)`

For documentation of this method, seejava.sql.PreparedStatement#setObject(int, Object, int, int).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Object`	The object containing the value to set the parameter to.
`targetSqlType`	`Integer`	TheSQL type to send to the database. The scale argument may further qualify this type.
`scaleOrLength`	`Integer`	The number of digits after the decimal for`DECIMAL` or`NUMERIC` types, or the length of data for`InputStream` or`Reader` types. Ignored for all other types.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setObject(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setObject(String, Object).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Object`	The object containing the value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setObject(parameterName, x, targetSqlType)`

For documentation of this method, seejava.sql.CallableStatement#setObject(String, Object, int).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Object`	The object containing the value to set.
`targetSqlType`	`Integer`	TheSQL type sent to the database.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setObject(parameterName, x, targetSqlType, scale)`

For documentation of this method, seejava.sql.CallableStatement#setObject(String, Object, int, int).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Object`	The object containing the value to set.
`targetSqlType`	`Integer`	TheSQL type sent to the database. The scale parameter may further qualify this type.
`scale`	`Integer`	The number of digits after the decimal point for`DECIMAL` and`NUMERIC` types. Ignored for all other types.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setPoolable(poolable)`

For documentation of this method, seejava.sql.Statement#setPoolable(boolean).

Parameters

Name	Type	Description
`poolable`	`Boolean`	If`true`, requests that this statement be pooled; otherwise requests it not be pooled.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setQueryTimeout(seconds)`

For documentation of this method, seejava.sql.Statement#setQueryTimeout(int).

Parameters

Name	Type	Description
`seconds`	`Integer`	The new query timeout in seconds; a value of 0 indicates no timeout.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setRef(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setRef(int, Ref).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcRef`	The SQL`REF` value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setRowId(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setRowId(int, RowId).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcRowId`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setRowId(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setRowId(String, RowId).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcRowId`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setSQLXML(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setSQLXML(int, SQLXML).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcSQLXML`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setSQLXML(parameterName, xmlObject)`

For documentation of this method, seejava.sql.CallableStatement#setSQLXML(String, SQLXML).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`xmlObject`	`JdbcSQLXML`	A SQLXML object that maps to an SQL XML value.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setShort(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setShort(int, short).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`Integer`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setShort(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setShort(String, short).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`Integer`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setString(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setString(int, String).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`String`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setString(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setString(String, String).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`String`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTime(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setTime(int, Time).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcTime`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTime(parameterIndex, x, timeZone)`

For documentation of this method, seejava.sql.PreparedStatement#setTime(int, Time, Calendar).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcTime`	The parameter value to set.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTime(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setTime(String, Time).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcTime`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTime(parameterName, x, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#setTime(String, Time, Calendar).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcTime`	The parameter value to set.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTimestamp(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setTimestamp(int, Timestamp).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcTimestamp`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTimestamp(parameterIndex, x, timeZone)`

For documentation of this method, seejava.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`JdbcTimestamp`	The parameter value to set.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTimestamp(parameterName, x)`

For documentation of this method, seejava.sql.CallableStatement#setTimestamp(String, Timestamp).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcTimestamp`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setTimestamp(parameterName, x, timeZone)`

For documentation of this method, seejava.sql.CallableStatement#setTimestamp(String, Timestamp, Calendar).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`x`	`JdbcTimestamp`	The parameter value to set.
`timeZone`	`String`	A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as`PST`,`EST`, and`GMT`), long IDs (such as`US/Pacific` and`America/Los_Angeles`), and offsets (such as`GMT+6:30`).

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setURL(parameterIndex, x)`

For documentation of this method, seejava.sql.PreparedStatement#setURL(int, URL).

Parameters

Name	Type	Description
`parameterIndex`	`Integer`	The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
`x`	`String`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`setURL(parameterName, val)`

For documentation of this method, seejava.sql.CallableStatement#setURL(String, URL).

Parameters

Name	Type	Description
`parameterName`	`String`	The name of the parameter to set.
`val`	`String`	The parameter value to set.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

`wasNull()`

For documentation of this method, seejava.sql.CallableStatement#wasNull().

Return

Boolean —true if the last parameter read wasnull; returnsfalse otherwise.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

https://www.googleapis.com/auth/script.external_request

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-11 UTC.

Movatterモバイル変換

Class JdbcCallableStatement Stay organized with collections Save and categorize content based on your preferences.

Page Summary

Methods

Detailed documentation

addBatch()

Authorization

addBatch(sql)

Parameters

Authorization

cancel()

Authorization

clearBatch()

Authorization

clearParameters()

Authorization

clearWarnings()

Authorization

close()

execute()

Return

Authorization

execute(sql)

Parameters

Return

Authorization

execute(sql, autoGeneratedKeys)

Parameters

Return

Authorization

execute(sql, columnIndexes)

Parameters

Return

Authorization

execute(sql, columnNames)

Parameters

Return

Authorization

executeBatch()

Return

Authorization

executeBatch(parameters)

Parameters

Return

Throws

Authorization

executeQuery()

Return

Authorization

executeQuery(sql)

Parameters

Return

Authorization

executeUpdate()

Return

Authorization

executeUpdate(sql)

Parameters

Return

Authorization

executeUpdate(sql, autoGeneratedKeys)

Parameters

Return

Authorization

executeUpdate(sql, columnIndexes)

Parameters

Return

Authorization

executeUpdate(sql, columnNames)

Parameters

Return

Authorization

getArray(parameterIndex)

Parameters

Return

Authorization

getArray(parameterName)

Parameters

Return

Authorization

Class JdbcCallableStatement

`addBatch()`

`addBatch(sql)`

`cancel()`

`clearBatch()`

`clearParameters()`

`clearWarnings()`

`close()`

`execute()`

`execute(sql)`

`execute(sql, autoGeneratedKeys)`

`execute(sql, columnIndexes)`

`execute(sql, columnNames)`

`executeBatch()`

`executeBatch(parameters)`

`executeQuery()`

`executeQuery(sql)`

`executeUpdate()`

`executeUpdate(sql)`

`executeUpdate(sql, autoGeneratedKeys)`

`executeUpdate(sql, columnIndexes)`

`executeUpdate(sql, columnNames)`

`getArray(parameterIndex)`

`getArray(parameterName)`

`getBigDecimal(parameterIndex)`

`getBigDecimal(parameterName)`

`getBlob(parameterIndex)`

`getBlob(parameterName)`

`getBoolean(parameterIndex)`

`getBoolean(parameterName)`

`getByte(parameterIndex)`

`getByte(parameterName)`

`getBytes(parameterIndex)`

`getBytes(parameterName)`

`getClob(parameterIndex)`

`getClob(parameterName)`

`getConnection()`

`getDate(parameterIndex)`

`getDate(parameterIndex, timeZone)`

`getDate(parameterName)`

`getDate(parameterName, timeZone)`

`getDouble(parameterIndex)`