Class JdbcCallableStatement

    • The JdbcCallableStatement 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 the https://www.googleapis.com/auth/script.external_request scope for external database interaction.
    JdbcCallableStatement

    A JDBC CallableStatement . For documentation of this class, see java.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 execute successfully, 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, see java.sql.PreparedStatement#addBatch() .

    Authorization

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

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

    addBatch(sql)

    For documentation of this method, see java.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 following scopes :

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

    cancel()

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

    Authorization

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

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

    clearBatch()

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

    Authorization

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

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

    clearParameters()

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

    Authorization

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

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

    clearWarnings()

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

    Authorization

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

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

    close()

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

    execute()

    For documentation of this method, see java.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 following scopes :

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

    execute(sql)

    For documentation of this method, see java.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 following scopes :

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

    execute(sql, autoGeneratedKeys)

    For documentation of this method, see java.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 following scopes :

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

    execute(sql, columnIndexes)

    For documentation of this method, see java.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 following scopes :

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

    execute(sql, columnNames)

    For documentation of this method, see java.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 following scopes :

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

    executeBatch()

    For documentation of this method, see java.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 following scopes :

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

    executeBatch(parameters)

    Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The parameters argument is a 2D array, where each 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 parameters could be [["John Doe", 30], ["John Smith", 25]] .

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

     var 
  
 conn 
  
 = 
  
 Jdbc 
 . 
 getCloudSqlConnection 
 ( 
 "jdbc:google:mysql://..." 
 ); 
 var 
  
 stmt 
  
 = 
  
 conn 
 . 
 prepareStatement 
 ( 
 "INSERT INTO employees (name, age) VALUES (?, ?)" 
 ); 
 var 
  
 params 
  
 = 
  
 [[ 
 "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 following scopes :

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

    executeQuery()

    For documentation of this method, see java.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 following scopes :

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

    executeQuery(sql)

    For documentation of this method, see java.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 never null .

    Authorization

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

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

    executeUpdate()

    For documentation of this method, see java.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 following scopes :

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

    executeUpdate(sql)

    For documentation of this method, see java.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 following scopes :

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

    executeUpdate(sql, autoGeneratedKeys)

    For documentation of this method, see java.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 following scopes :

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

    executeUpdate(sql, columnIndexes)

    For documentation of this method, see java.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 following scopes :

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

    executeUpdate(sql, columnNames)

    For documentation of this method, see java.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 following scopes :

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

    getArray(parameterIndex)

    For documentation of this method, see java.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 a ARRAY parameter. Returns null if the value is null .

    Authorization

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

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

    getArray(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcArray — The value of a ARRAY parameter. Returns null if the value is null .

    Authorization

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

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

    getBigDecimal(parameterIndex)

    For documentation of this method, see java.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 a NUMERIC parameter in full precision. Returns null if the value is null .

    Authorization

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

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

    getBigDecimal(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    BigNumber — The value of a NUMERIC parameter. Returns null if the value is null .

    Authorization

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

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

    getBlob(parameterIndex)

    For documentation of this method, see java.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 a BLOB parameter. Returns null if the value is null .

    Authorization

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

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

    getBlob(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcBlob — The value of a BLOB parameter. Returns null if the value is null .

    Authorization

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

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

    getBoolean(parameterIndex)

    For documentation of this method, see java.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 a BIT or BOOLEAN parameter. Returns false if the value is null .

    Authorization

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

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

    getBoolean(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Boolean — The value of a BIT or BOOLEAN parameter. Returns false if the value is null .

    Authorization

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

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

    getByte(parameterIndex)

    For documentation of this method, see java.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 a TINYINT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getByte(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Byte — The value of a TINYINT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getBytes(parameterIndex)

    For documentation of this method, see java.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 a BINARY or VARBINARY parameter. Returns null if the value is null .

    Authorization

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

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

    getBytes(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Byte[] — The value of a BINARY or VARBINARY parameter. Returns null if the value is null .

    Authorization

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

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

    getClob(parameterIndex)

    For documentation of this method, see java.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 a CLOB parameter. Returns null if the value is null .

    Authorization

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

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

    getClob(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcClob — The value of a CLOB parameter. Returns null if the value is null .

    Authorization

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

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

    getConnection()

    For documentation of this method, see java.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 following scopes :

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

    getDate(parameterIndex)

    For documentation of this method, see java.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 a DATE parameter. Returns null if the value is null .

    Authorization

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

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

    getDate(parameterIndex, timeZone)

    For documentation of this method, see java.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 a DATE parameter. Returns null if the value is null .

    Authorization

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

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

    getDate(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcDate — The value of a DATE parameter. Returns null if the value is null .

    Authorization

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

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

    getDate(parameterName, timeZone)

    For documentation of this method, see java.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 a DATE parameter. Returns null if the value is null .

    Authorization

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

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

    getDouble(parameterIndex)

    For documentation of this method, see java.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 a DOUBLE parameter. Returns 0 if the value is null .

    Authorization

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

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

    getDouble(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Number — The value of a DOUBLE parameter. Returns 0 if the value is null .

    Authorization

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

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

    getFetchDirection()

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

    Return

    Integer — The default direction for result sets generated by this statement, 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 following scopes :

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

    getFetchSize()

    For documentation of this method, see java.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 following scopes :

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

    getFloat(parameterIndex)

    For documentation of this method, see java.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 a FLOAT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getFloat(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Number — The value of a FLOAT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getGeneratedKeys()

    For documentation of this method, see java.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 following scopes :

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

    getInt(parameterIndex)

    For documentation of this method, see java.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 a INTEGER parameter. Returns 0 if the value is null .

    Authorization

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

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

    getInt(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Integer — The value of a INTEGER parameter. Returns 0 if the value is null .

    Authorization

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

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

    getLong(parameterIndex)

    For documentation of this method, see java.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 a BIGINT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getLong(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Integer — The value of a BIGINT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getMaxFieldSize()

    For documentation of this method, see java.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 following scopes :

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

    getMaxRows()

    For documentation of this method, see java.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 following scopes :

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

    getMetaData()

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

    Return

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

    Authorization

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

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

    getMoreResults()

    For documentation of this method, see java.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 following scopes :

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

    getMoreResults(current)

    For documentation of this method, see java.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 following scopes :

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

    getNClob(parameterIndex)

    For documentation of this method, see java.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 a NCLOB parameter. Returns null if the value is null .

    Authorization

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

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

    getNClob(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcClob — The value of a NCLOB parameter. Returns null if the value is null .

    Authorization

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

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

    getNString(parameterIndex)

    For documentation of this method, see java.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 a NCHAR , NVARCHAR , or LONGNVARCHAR value.

    Authorization

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

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

    getNString(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    String — A string that maps a NCHAR , NVARCHAR , or LONGNVARCHAR value.

    Authorization

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

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

    getObject(parameterIndex)

    For documentation of this method, see java.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 following scopes :

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

    getObject(parameterName)

    For documentation of this method, see java.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 following scopes :

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

    getParameterMetaData()

    For documentation of this method, see java.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 following scopes :

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

    getQueryTimeout()

    For documentation of this method, see java.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 following scopes :

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

    getRef(parameterIndex)

    For documentation of this method, see java.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 a REF parameter. Returns null if the value is null .

    Authorization

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

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

    getRef(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcRef — The value of a REF parameter. Returns null if the value is null .

    Authorization

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

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

    getResultSet()

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

    Return

    JdbcResultSet — The current result set, or null 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 following scopes :

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

    getResultSetConcurrency()

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

    Return

    Integer — The result set concurrency for result sets generated from this statement, which is either Jdbc.ResultSet.CONCUR_READ_ONLY or Jdbc.ResultSet.CONCUR_UPDATABLE .

    Authorization

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

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

    getResultSetHoldability()

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

    Return

    Integer — The result set holdability, which is either Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT or Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT .

    Authorization

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

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

    getResultSetType()

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

    Return

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

    Authorization

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

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

    getRowId(parameterIndex)

    For documentation of this method, see java.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 — The ROWID value. Returns null if the parameter contains an SQL NULL .

    Authorization

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

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

    getRowId(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcRowId — The ROWID value. Returns null if the parameter contains an SQL NULL .

    Authorization

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

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

    getSQLXML(parameterIndex)

    For documentation of this method, see java.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 following scopes :

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

    getSQLXML(parameterName)

    For documentation of this method, see java.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 following scopes :

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

    getShort(parameterIndex)

    For documentation of this method, see java.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 a SMALLINT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getShort(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    Integer — The value of a SMALLINT parameter. Returns 0 if the value is null .

    Authorization

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

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

    getString(parameterIndex)

    For documentation of this method, see java.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 a CHAR , VARCHAR , or LONGVARCHAR parameter.

    Authorization

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

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

    getString(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    String — The value of a CHAR , VARCHAR , or LONGVARCHAR parameter. Returns null if the value is null .

    Authorization

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

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

    getTime(parameterIndex)

    For documentation of this method, see java.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 a TIME parameter. Returns null if the value is null .

    Authorization

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

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

    getTime(parameterIndex, timeZone)

    For documentation of this method, see java.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 a TIME parameter. Returns null if the value is null .

    Authorization

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

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

    getTime(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcTime — The value of a TIME parameter. Returns null if the value is null .

    Authorization

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

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

    getTime(parameterName, timeZone)

    For documentation of this method, see java.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 a TIME parameter. Returns null if the value is null .

    Authorization

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

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

    getTimestamp(parameterIndex)

    For documentation of this method, see java.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 a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

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

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

    getTimestamp(parameterIndex, timeZone)

    For documentation of this method, see java.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 a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

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

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

    getTimestamp(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    JdbcTimestamp — The value of a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

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

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

    getTimestamp(parameterName, timeZone)

    For documentation of this method, see java.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 a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

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

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

    getURL(parameterIndex)

    For documentation of this method, see java.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 a DATALINK parameter as a string.

    Authorization

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

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

    getURL(parameterName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter.

    Return

    String — The value of a DATALINK parameter. Returns null if the value is null .

    Authorization

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

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

    getUpdateCount()

    For documentation of this method, see java.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 following scopes :

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

    getWarnings()

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

    Return

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

    Authorization

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

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

    isClosed()

    For documentation of this method, see java.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 following scopes :

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

    isPoolable()

    For documentation of this method, see java.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 following scopes :

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

    registerOutParameter(parameterIndex, sqlType)

    For documentation of this method, see java.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 JDBC type 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 following scopes :

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

    registerOutParameter(parameterIndex, sqlType, scale)

    For documentation of this method, see java.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 JDBC type 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 following scopes :

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

    registerOutParameter(parameterIndex, sqlType, typeName)

    For documentation of this method, see java.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 A type 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 following scopes :

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

    registerOutParameter(parameterName, sqlType)

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

    Parameters

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

    Authorization

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

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

    registerOutParameter(parameterName, sqlType, scale)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter to be registered.
    sqlType
    		Integer A type 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 following scopes :

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

    registerOutParameter(parameterName, sqlType, typeName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter to be registered.
    sqlType
    		Integer A type 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 following scopes :

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

    setArray(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setBigDecimal(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setBigDecimal(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setBlob(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setBlob(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setBoolean(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setBoolean(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setByte(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setByte(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setBytes(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setBytes(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setClob(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setClob(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setCursorName(name)

    For documentation of this method, see java.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 following scopes :

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

    setDate(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setDate(parameterIndex, x, timeZone)

    For documentation of this method, see java.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 following scopes :

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

    setDate(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setDate(parameterName, x, timeZone)

    For documentation of this method, see java.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 following scopes :

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

    setDouble(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setDouble(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setEscapeProcessing(enable)

    For documentation of this method, see java.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 following scopes :

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

    setFetchDirection(direction)

    For documentation of this method, see java.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 following scopes :

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

    setFetchSize(rows)

    For documentation of this method, see java.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 following scopes :

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

    setFloat(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setFloat(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setInt(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setInt(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setLong(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setLong(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setMaxFieldSize(max)

    For documentation of this method, see java.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 following scopes :

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

    setMaxRows(max)

    For documentation of this method, see java.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 following scopes :

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

    setNClob(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setNClob(parameterName, value)

    For documentation of this method, see java.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 following scopes :

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

    setNString(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setNString(parameterName, value)

    For documentation of this method, see java.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 following scopes :

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

    setNull(parameterIndex, sqlType)

    For documentation of this method, see java.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 The SQL type of the specified parameter.

    Authorization

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

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

    setNull(parameterIndex, sqlType, typeName)

    For documentation of this method, see java.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 The SQL 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 following scopes :

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

    setNull(parameterName, sqlType)

    For documentation of this method, see java.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 following scopes :

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

    setNull(parameterName, sqlType, typeName)

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

    Parameters

    Name Type Description
    parameterName
    		String The name of the parameter to set.
    sqlType
    		Integer The SQL 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 following scopes :

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

    setObject(index, x)

    For documentation of this method, see java.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 following scopes :

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

    setObject(parameterIndex, x, targetSqlType)

    For documentation of this method, see java.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 The SQL type to send to the database.

    Authorization

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

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

    setObject(parameterIndex, x, targetSqlType, scaleOrLength)

    For documentation of this method, see java.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 The SQL 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 following scopes :

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

    setObject(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setObject(parameterName, x, targetSqlType)

    For documentation of this method, see java.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 The SQL type sent to the database.

    Authorization

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

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

    setObject(parameterName, x, targetSqlType, scale)

    For documentation of this method, see java.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 The SQL 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 following scopes :

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

    setPoolable(poolable)

    For documentation of this method, see java.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 following scopes :

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

    setQueryTimeout(seconds)

    For documentation of this method, see java.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 following scopes :

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

    setRef(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setRowId(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setRowId(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setSQLXML(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setSQLXML(parameterName, xmlObject)

    For documentation of this method, see java.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 following scopes :

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

    setShort(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setShort(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setString(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setString(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setTime(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setTime(parameterIndex, x, timeZone)

    For documentation of this method, see java.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 following scopes :

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

    setTime(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setTime(parameterName, x, timeZone)

    For documentation of this method, see java.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 following scopes :

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

    setTimestamp(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setTimestamp(parameterIndex, x, timeZone)

    For documentation of this method, see java.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 following scopes :

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

    setTimestamp(parameterName, x)

    For documentation of this method, see java.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 following scopes :

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

    setTimestamp(parameterName, x, timeZone)

    For documentation of this method, see java.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 following scopes :

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

    setURL(parameterIndex, x)

    For documentation of this method, see java.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 following scopes :

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

    setURL(parameterName, val)

    For documentation of this method, see java.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 following scopes :

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

    wasNull()

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

    Return

    Boolean — true if the last parameter read was null ; returns false otherwise.

    Authorization

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

    • https://www.googleapis.com/auth/script.external_request
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: