Stay organized with collections Save and categorize content based on your preferences.
Methods Method Return type Brief descriptionaddBatch() 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(). 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().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestaddBatch(sql)
For documentation of this method, see java.sql.Statement#addBatch(String).
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_requestcancel()
For documentation of this method, see java.sql.Statement#cancel().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestclearBatch()
For documentation of this method, see java.sql.Statement#clearBatch().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestclearWarnings()
For documentation of this method, see java.sql.Statement#clearWarnings().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecute()
For documentation of this method, see java.sql.PreparedStatement#execute().
Boolean — true if the first result is a result set; false if the first result is an update count or there is no result.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecute(sql)
For documentation of this method, see java.sql.Statement#execute(String).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecute(sql, autoGeneratedKeys)
For documentation of this method, see java.sql.Statement#execute(String, int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecute(sql, columnIndexes)
For documentation of this method, see java.sql.Statement#execute(String, int[]).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecute(sql, columnNames)
For documentation of this method, see java.sql.Statement#execute(String, String[]).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteBatch()
For documentation of this method, see java.sql.Statement#executeBatch().
Integer[] — The update counts for each command in the batch, using the same order in which commands were added to the batch.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteQuery()
For documentation of this method, see java.sql.PreparedStatement#executeQuery().
JdbcResultSet — A result set that contains the data produced by the query.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteQuery(sql)
For documentation of this method, see java.sql.Statement#executeQuery(String).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteUpdate()
For documentation of this method, see java.sql.PreparedStatement#executeUpdate().
Integer — The row count ofr SQL Data Manipulation Language statements, or 0 for SQL statements that return nothing.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteUpdate(sql)
For documentation of this method, see java.sql.Statement#executeUpdate(String).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteUpdate(sql, autoGeneratedKeys)
For documentation of this method, see java.sql.Statement#executeUpdate(String, int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteUpdate(sql, columnIndexes)
For documentation of this method, see java.sql.Statement#executeUpdate(String, int[]).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestexecuteUpdate(sql, columnNames)
For documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetArray(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getArray(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetArray(parameterName)
For documentation of this method, see java.sql.CallableStatement#getArray(String).
parameterName String The name of the parameter. Return
JdbcArray — The value of a ARRAY parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBigDecimal(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getBigDecimal(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBigDecimal(parameterName)
For documentation of this method, see java.sql.CallableStatement#getBigDecimal(String).
parameterName String The name of the parameter. Return
BigNumber — The value of a NUMERIC parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBlob(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getBlob(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBlob(parameterName)
For documentation of this method, see java.sql.CallableStatement#getBlob(String).
parameterName String The name of the parameter. Return
JdbcBlob — The value of a BLOB parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBoolean(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getBoolean(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBoolean(parameterName)
For documentation of this method, see java.sql.CallableStatement#getBoolean(String).
parameterName String The name of the parameter. Return
Boolean — The value of a BIT or BOOLEAN parameter. Returns false if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetByte(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getByte(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetByte(parameterName)
For documentation of this method, see java.sql.CallableStatement#getByte(String).
parameterName String The name of the parameter. Return
Byte — The value of a TINYINT parameter. Returns 0 if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBytes(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getBytes(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBytes(parameterName)
For documentation of this method, see java.sql.CallableStatement#getBytes(String).
parameterName String The name of the parameter. Return
Byte[] — The value of a BINARY or VARBINARY parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetClob(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getClob(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetClob(parameterName)
For documentation of this method, see java.sql.CallableStatement#getClob(String).
parameterName String The name of the parameter. Return
JdbcClob — The value of a CLOB parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetConnection()
For documentation of this method, see java.sql.Statement#getConnection().
JdbcConnection — The connection that produced this statement.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getDate(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(parameterIndex, timeZone)
For documentation of this method, see java.sql.CallableStatement#getDate(int, Calendar).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(parameterName)
For documentation of this method, see java.sql.CallableStatement#getDate(String).
parameterName String The name of the parameter. Return
JdbcDate — The value of a DATE parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(parameterName, timeZone)
For documentation of this method, see java.sql.CallableStatement#getDate(String, Calendar).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDouble(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getDouble(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDouble(parameterName)
For documentation of this method, see java.sql.CallableStatement#getDouble(String).
parameterName String The name of the parameter. Return
Number — The value of a DOUBLE parameter. Returns 0 if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFetchDirection()
For documentation of this method, see java.sql.Statement#getFetchDirection().
Integer — The default direction for result sets generated by this statement, which is either Jdbc.ResultSet.FETCH_FORWARD or Jdbc.ResultSet.FETCH_REVERSE.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFetchSize()
For documentation of this method, see java.sql.Statement#getFetchSize().
Integer — The default row fetch size for result sets generated from this statement.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFloat(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getFloat(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFloat(parameterName)
For documentation of this method, see java.sql.CallableStatement#getFloat(String).
parameterName String The name of the parameter. Return
Number — The value of a FLOAT parameter. Returns 0 if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetGeneratedKeys()
For documentation of this method, see java.sql.Statement#getGeneratedKeys().
JdbcResultSet — A result set containing the auto-generated keys generated by the execution of this statement.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetInt(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getInt(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetInt(parameterName)
For documentation of this method, see java.sql.CallableStatement#getInt(String).
parameterName String The name of the parameter. Return
Integer — The value of a INTEGER parameter. Returns 0 if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetLong(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getLong(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetLong(parameterName)
For documentation of this method, see java.sql.CallableStatement#getLong(String).
parameterName String The name of the parameter. Return
Integer — The value of a BIGINT parameter. Returns 0 if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetMaxFieldSize()
For documentation of this method, see java.sql.Statement#getMaxFieldSize().
Integer — The current column byte size limit for columns storing character and binary values; a value of zero indictates no limit.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetMaxRows()
For documentation of this method, see java.sql.Statement#getMaxRows().
Integer — The current maximum number of rows for a result set produced by this statement; a value of 0 indicates no limit.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetMoreResults()
For documentation of this method, see java.sql.Statement#getMoreResults().
Boolean — true if the next result is a result set; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetMoreResults(current)
For documentation of this method, see java.sql.Statement#getMoreResults(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNClob(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getNClob(int).
parameterIndex Integer An index indicating which paramater 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNClob(parameterName)
For documentation of this method, see java.sql.CallableStatement#getNClob(String).
parameterName String The name of the parameter. Return
JdbcClob — The value of a NCLOB parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNString(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getNString(int).
parameterIndex Integer An index indicating which paramater 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNString(parameterName)
For documentation of this method, see java.sql.CallableStatement#getNString(String).
parameterName String The name of the parameter. Return
String — A string that maps a NCHAR, NVARCHAR, or LONGNVARCHAR value.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetObject(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getObject(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetObject(parameterName)
For documentation of this method, see java.sql.CallableStatement#getObject(String).
parameterName String The name of the parameter. Return
Object — An object holding the parameter value.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetQueryTimeout()
For documentation of this method, see java.sql.Statement#getQueryTimeout().
Integer — The current query timeout in seconds; a value of zero indicates no timeout.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRef(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getRef(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRef(parameterName)
For documentation of this method, see java.sql.CallableStatement#getRef(String).
parameterName String The name of the parameter. Return
JdbcRef — The value of a REF parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetResultSet()
For documentation of this method, see java.sql.Statement#getResultSet().
JdbcResultSet — The current result set, or null if the result is an update count or there are no more results.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetResultSetConcurrency()
For documentation of this method, see java.sql.Statement#getResultSetConcurrency().
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetResultSetHoldability()
For documentation of this method, see java.sql.Statement#getResultSetHoldability().
Integer — The result set holdability, which is either Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT or Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetResultSetType()
For documentation of this method, see java.sql.Statement#getResultSetType().
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRowId(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getRowId(int).
parameterIndex Integer An index indicating which paramater 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRowId(parameterName)
For documentation of this method, see java.sql.CallableStatement#getRowId(String).
parameterName String The name of the parameter. Return
JdbcRowId — The ROWID value. Returns null if the parameter contains an SQL NULL.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetSQLXML(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getSQLXML(int).
parameterIndex Integer An index indicating which paramater 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetSQLXML(parameterName)
For documentation of this method, see java.sql.CallableStatement#getSQLXML(String).
parameterName String The name of the parameter. Return
JdbcSQLXML — A SQLXML object that maps to an SQL XML value.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetShort(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getShort(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetShort(parameterName)
For documentation of this method, see java.sql.CallableStatement#getShort(String).
parameterName String The name of the parameter. Return
Integer — The value of a SMALLINT parameter. Returns 0 if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetString(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getString(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetString(parameterName)
For documentation of this method, see java.sql.CallableStatement#getString(String).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getTime(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(parameterIndex, timeZone)
For documentation of this method, see java.sql.CallableStatement#getTime(int, Calendar).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(parameterName)
For documentation of this method, see java.sql.CallableStatement#getTime(String).
parameterName String The name of the parameter. Return
JdbcTime — The value of a TIME parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(parameterName, timeZone)
For documentation of this method, see java.sql.CallableStatement#getTime(String, Calendar).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getTimestamp(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(parameterIndex, timeZone)
For documentation of this method, see java.sql.CallableStatement#getTimestamp(int, Calendar).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(parameterName)
For documentation of this method, see java.sql.CallableStatement#getTimestamp(String).
parameterName String The name of the parameter. Return
JdbcTimestamp — The value of a TIMESTAMP parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(parameterName, timeZone)
For documentation of this method, see java.sql.CallableStatement#getTimestamp(String, Calendar).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetURL(parameterIndex)
For documentation of this method, see java.sql.CallableStatement#getURL(int).
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetURL(parameterName)
For documentation of this method, see java.sql.CallableStatement#getURL(String).
parameterName String The name of the parameter. Return
String — The value of a DATALINK parameter. Returns null if the value is null.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetUpdateCount()
For documentation of this method, see java.sql.Statement#getUpdateCount().
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetWarnings()
For documentation of this method, see java.sql.Statement#getWarnings().
String[] — The current set of warnings, or null if there are no warnings.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestisClosed()
For documentation of this method, see java.sql.Statement#isClosed().
Boolean — true if this statement is closed; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestisPoolable()
For documentation of this method, see java.sql.Statement#isPoolable().
Boolean — true if this statement is poolable; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestregisterOutParameter(parameterIndex, sqlType) registerOutParameter(parameterIndex, sqlType, scale)
For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, int).
parameterIndex Integer An index indicating which paramater 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_requestregisterOutParameter(parameterIndex, sqlType, typeName)
For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, String).
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_requestregisterOutParameter(parameterName, sqlType)
For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int).
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_requestregisterOutParameter(parameterName, sqlType, scale)
For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, int).
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_requestregisterOutParameter(parameterName, sqlType, typeName)
For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, String).
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_requestsetArray(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setArray(int, Array).
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_requestsetBigDecimal(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal).
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_requestsetBigDecimal(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setBigDecimal(String, BigDecimal).
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_requestsetBlob(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob).
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_requestsetBlob(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setBlob(String, Blob).
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_requestsetBoolean(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).
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_requestsetBoolean(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setBoolean(String, boolean).
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_requestsetByte(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).
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_requestsetByte(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setByte(String, byte).
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_requestsetBytes(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).
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_requestsetBytes(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setBytes(String, byte[]).
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_requestsetClob(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob).
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_requestsetClob(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setBlob(String, Clob).
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_requestsetCursorName(name)
For documentation of this method, see java.sql.Statement#setCursorName(String).
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_requestsetDate(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date).
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_requestsetDate(parameterIndex, x, timeZone)
For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar).
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_requestsetDate(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setDate(String, Date).
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_requestsetDate(parameterName, x, timeZone)
For documentation of this method, see java.sql.CallableStatement#setDate(String, Date, Calendar).
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_requestsetDouble(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).
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_requestsetDouble(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setDouble(String, double).
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_requestsetEscapeProcessing(enable)
For documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
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_requestsetFetchDirection(direction)
For documentation of this method, see java.sql.Statement#setFetchDirection(int).
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_requestsetFetchSize(rows)
For documentation of this method, see java.sql.Statement#setFetchSize(int).
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_requestsetFloat(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).
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_requestsetFloat(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setFloat(String, float).
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_requestsetInt(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setInt(int, int).
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_requestsetInt(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setInt(String, int).
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_requestsetLong(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setLong(int, long).
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_requestsetLong(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setLong(String, long).
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_requestsetMaxFieldSize(max)
For documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
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_requestsetMaxRows(max)
For documentation of this method, see java.sql.Statement#setMaxRows(int).
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_requestsetNClob(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob).
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_requestsetNClob(parameterName, value)
For documentation of this method, see java.sql.CallableStatement#setNClob(String, NClob).
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_requestsetNString(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setNString(int, String).
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_requestsetNString(parameterName, value)
For documentation of this method, see java.sql.CallableStatement#setNString(String, String).
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_requestsetNull(parameterIndex, sqlType)
For documentation of this method, see java.sql.PreparedStatement#setNull(int, int).
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_requestsetNull(parameterIndex, sqlType, typeName)
For documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).
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_requestsetNull(parameterName, sqlType)
For documentation of this method, see java.sql.CallableStatement#setNull(String, int).
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_requestsetNull(parameterName, sqlType, typeName)
For documentation of this method, see java.sql.CallableStatement#setNull(String, int, String).
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_requestsetObject(index, x)
For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).
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_requestsetObject(parameterIndex, x, targetSqlType)
For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).
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_requestsetObject(parameterIndex, x, targetSqlType, scaleOrLength)
For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int).
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_requestsetObject(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setObject(String, Object).
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_requestsetObject(parameterName, x, targetSqlType)
For documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int).
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_requestsetObject(parameterName, x, targetSqlType, scale)
For documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int, int).
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_requestsetPoolable(poolable)
For documentation of this method, see java.sql.Statement#setPoolable(boolean).
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_requestsetQueryTimeout(seconds)
For documentation of this method, see java.sql.Statement#setQueryTimeout(int).
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_requestsetRef(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref).
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_requestsetRowId(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId).
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_requestsetRowId(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setRowId(String, RowId).
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_requestsetSQLXML(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML).
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_requestsetSQLXML(parameterName, xmlObject)
For documentation of this method, see java.sql.CallableStatement#setSQLXML(String, SQLXML).
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_requestsetShort(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setShort(int, short).
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_requestsetShort(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setShort(String, short).
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_requestsetString(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setString(int, String).
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_requestsetString(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setString(String, String).
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_requestsetTime(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time).
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_requestsetTime(parameterIndex, x, timeZone)
For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar).
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_requestsetTime(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setTime(String, Time).
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_requestsetTime(parameterName, x, timeZone)
For documentation of this method, see java.sql.CallableStatement#setTime(String, Time, Calendar).
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_requestsetTimestamp(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp).
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_requestsetTimestamp(parameterIndex, x, timeZone)
For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar).
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_requestsetTimestamp(parameterName, x)
For documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp).
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_requestsetTimestamp(parameterName, x, timeZone)
For documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp, Calendar).
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_requestsetURL(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setURL(int, URL).
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_requestsetURL(parameterName, val)
For documentation of this method, see java.sql.CallableStatement#setURL(String, URL).
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_requestwasNull()
For documentation of this method, see java.sql.CallableStatement#wasNull().
Boolean — true if the last parameter read was null; returns false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestExcept as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-05 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-05 UTC."],[[["`JdbcCallableStatement` methods in Apps Script enable interaction with database stored procedures using JDBC."],["Methods cover functionalities like executing procedures, setting input parameters, and retrieving output/result sets."],["Each method's documentation details its purpose, parameters, return type, and authorization requirements."],["Authorization with the `https://www.googleapis.com/auth/script.external_request` scope is necessary for all methods."],["Comprehensive documentation and links to corresponding Java documentation provide detailed guidance."]]],["`JdbcCallableStatement` manages SQL stored procedures and parameters, enabling batch operations (`addBatch`, `executeBatch`), execution (`execute`, `executeQuery`, `executeUpdate`), and parameter management (`clearParameters`, `registerOutParameter`). Data retrieval uses `get...()` methods (e.g., `getInt`, `getString`), while `set...()` methods (e.g., `setInt`, `setString`) set parameter values. Metadata and properties are accessed via methods like `getConnection`, and statement control is achieved using `close` and `cancel`. Methods often have variants for indexed or named parameters. The `wasNull` method tells if the last read parameter is null. `setTime`, `setTimestamp`, and `setURL` set values. All of them require external request authorization.\n"]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4