Class JdbcCallableStatement

JdbcCallableStatement

A JDBC CallableStatement. For documentation of this class, see java.sql.CallableStatement.

See also

Methods

MethodReturn typeBrief description
addBatch()voidFor documentation of this method, see java.sql.PreparedStatement#addBatch().
addBatch(sql)voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel()voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch()voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearParameters()voidFor documentation of this method, see java.sql.PreparedStatement#clearParameters().
clearWarnings()voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close()voidFor documentation of this method, see java.sql.Statement#close().
execute()BooleanFor documentation of this method, see java.sql.PreparedStatement#execute().
execute(sql)BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames)BooleanFor documentation of this method, see java.sql.Statement#execute(String, String[]).
executeBatch()Integer[]For documentation of this method, see java.sql.Statement#executeBatch().
executeQuery()JdbcResultSetFor documentation of this method, see java.sql.PreparedStatement#executeQuery().
executeQuery(sql)JdbcResultSetFor documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate()IntegerFor documentation of this method, see java.sql.PreparedStatement#executeUpdate().
executeUpdate(sql)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnNames)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getArray(parameterIndex)JdbcArrayFor documentation of this method, see java.sql.CallableStatement#getArray(int).
getArray(parameterName)JdbcArrayFor documentation of this method, see java.sql.CallableStatement#getArray(String).
getBigDecimal(parameterIndex)BigNumberFor documentation of this method, see java.sql.CallableStatement#getBigDecimal(int).
getBigDecimal(parameterName)BigNumberFor documentation of this method, see java.sql.CallableStatement#getBigDecimal(String).
getBlob(parameterIndex)JdbcBlobFor documentation of this method, see java.sql.CallableStatement#getBlob(int).
getBlob(parameterName)JdbcBlobFor documentation of this method, see java.sql.CallableStatement#getBlob(String).
getBoolean(parameterIndex)BooleanFor documentation of this method, see java.sql.CallableStatement#getBoolean(int).
getBoolean(parameterName)BooleanFor documentation of this method, see java.sql.CallableStatement#getBoolean(String).
getByte(parameterIndex)ByteFor documentation of this method, see java.sql.CallableStatement#getByte(int).
getByte(parameterName)ByteFor 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)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getClob(int).
getClob(parameterName)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getClob(String).
getConnection()JdbcConnectionFor documentation of this method, see java.sql.Statement#getConnection().
getDate(parameterIndex)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(int).
getDate(parameterIndex, timeZone)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(int, java.util.Calendar).
getDate(parameterName)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(String).
getDate(parameterName, timeZone)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(String, java.util.Calendar).
getDouble(parameterIndex)NumberFor documentation of this method, see java.sql.CallableStatement#getDouble(int).
getDouble(parameterName)NumberFor documentation of this method, see java.sql.CallableStatement#getDouble(String).
getFetchDirection()IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize()IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getFloat(parameterIndex)NumberFor documentation of this method, see java.sql.CallableStatement#getFloat(int).
getFloat(parameterName)NumberFor documentation of this method, see java.sql.CallableStatement#getFloat(String).
getGeneratedKeys()JdbcResultSetFor documentation of this method, see java.sql.Statement#getGeneratedKeys().
getInt(parameterIndex)IntegerFor documentation of this method, see java.sql.CallableStatement#getInt(int).
getInt(parameterName)IntegerFor documentation of this method, see java.sql.CallableStatement#getInt(String).
getLong(parameterIndex)IntegerFor documentation of this method, see java.sql.CallableStatement#getLong(int).
getLong(parameterName)IntegerFor documentation of this method, see java.sql.CallableStatement#getLong(String).
getMaxFieldSize()IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows()IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMetaData()JdbcResultSetMetaDataFor documentation of this method, see java.sql.PreparedStatement#getMetaData().
getMoreResults()BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current)BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getNClob(parameterIndex)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getNClob(int).
getNClob(parameterName)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getNClob(String).
getNString(parameterIndex)StringFor documentation of this method, see java.sql.CallableStatement#getNString(int).
getNString(parameterName)StringFor documentation of this method, see java.sql.CallableStatement#getNString(String).
getObject(parameterIndex)ObjectFor documentation of this method, see java.sql.CallableStatement#getObject(int).
getObject(parameterName)ObjectFor documentation of this method, see java.sql.CallableStatement#getObject(String).
getParameterMetaData()JdbcParameterMetaDataFor documentation of this method, see java.sql.PreparedStatement#getParameterMetaData().
getQueryTimeout()IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getRef(parameterIndex)JdbcRefFor documentation of this method, see java.sql.CallableStatement#getRef(int).
getRef(parameterName)JdbcRefFor documentation of this method, see java.sql.CallableStatement#getRef(String).
getResultSet()JdbcResultSetFor documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency()IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability()IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType()IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getRowId(parameterIndex)JdbcRowIdFor documentation of this method, see java.sql.CallableStatement#getRowId(int).
getRowId(parameterName)JdbcRowIdFor documentation of this method, see java.sql.CallableStatement#getRowId(String).
getSQLXML(parameterIndex)JdbcSQLXMLFor documentation of this method, see java.sql.CallableStatement#getSQLXML(int).
getSQLXML(parameterName)JdbcSQLXMLFor documentation of this method, see java.sql.CallableStatement#getSQLXML(String).
getShort(parameterIndex)IntegerFor documentation of this method, see java.sql.CallableStatement#getShort(int).
getShort(parameterName)IntegerFor documentation of this method, see java.sql.CallableStatement#getShort(String).
getString(parameterIndex)StringFor documentation of this method, see java.sql.CallableStatement#getString(int).
getString(parameterName)StringFor documentation of this method, see java.sql.CallableStatement#getString(String).
getTime(parameterIndex)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(int).
getTime(parameterIndex, timeZone)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(int, java.util.Calendar).
getTime(parameterName)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(String).
getTime(parameterName, timeZone)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(String, java.util.Calendar).
getTimestamp(parameterIndex)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(int).
getTimestamp(parameterIndex, timeZone)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(int, java.util.Calendar).
getTimestamp(parameterName)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(String).
getTimestamp(parameterName, timeZone)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(String, java.util.Calendar).
getURL(parameterIndex)StringFor documentation of this method, see java.sql.CallableStatement#getURL(int).
getURL(parameterName)StringFor documentation of this method, see java.sql.CallableStatement#getURL(String).
getUpdateCount()IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings()String[]Returns the current set of warnings reported by the driver.
isClosed()BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable()BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
registerOutParameter(parameterIndex, sqlType)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int).
registerOutParameter(parameterIndex, sqlType, scale)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, int).
registerOutParameter(parameterIndex, sqlType, typeName)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, String).
registerOutParameter(parameterName, sqlType)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int).
registerOutParameter(parameterName, sqlType, scale)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, int).
registerOutParameter(parameterName, sqlType, typeName)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, String).
setArray(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setArray(int, java.sql.Array).
setBigDecimal(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, java.math.BigDecimal).
setBigDecimal(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBigDecimal(String, java.math.BigDecimal).
setBlob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBlob(int, java.sql.Blob).
setBlob(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBlob(String, java.sql.Blob).
setBoolean(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).
setBoolean(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBoolean(String, boolean).
setByte(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).
setByte(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setByte(String, byte).
setBytes(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).
setBytes(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBytes(String, byte[]).
setClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setClob(int, java.sql.Clob).
setClob(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setClob(String, java.sql.Clob).
setCursorName(name)voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setDate(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, java.sql.Date).
setDate(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, java.sql.Date, java.util.Calendar).
setDate(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setDate(String, java.sql.Date).
setDate(parameterName, x, timeZone)voidFor documentation of this method, see java.sql.CallableStatement#setDate(String, java.sql.Date, java.util.Calendar).
setDouble(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).
setDouble(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setDouble(String, double).
setEscapeProcessing(enable)voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction)voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows)voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setFloat(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).
setFloat(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setFloat(String, float).
setInt(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setInt(int, int).
setInt(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setInt(String, int).
setLong(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setLong(int, long).
setLong(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setLong(String, long).
setMaxFieldSize(max)voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max)voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setNClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNClob(int, java.sql.NClob).
setNClob(parameterName, value)voidFor documentation of this method, see java.sql.CallableStatement#setNClob(String, java.sql.NClob).
setNString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNString(int, String).
setNString(parameterName, value)voidFor documentation of this method, see java.sql.CallableStatement#setNString(String, String).
setNull(parameterIndex, sqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int).
setNull(parameterIndex, sqlType, typeName)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).
setNull(parameterName, sqlType)voidFor documentation of this method, see java.sql.CallableStatement#setNull(String, int).
setNull(parameterName, sqlType, typeName)voidFor documentation of this method, see java.sql.CallableStatement#setNull(String, int, String).
setObject(index, x)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).
setObject(parameterIndex, x, targetSqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).
setObject(parameterIndex, x, targetSqlType, scaleOrLength)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int).
setObject(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object).
setObject(parameterName, x, targetSqlType)voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int).
setObject(parameterName, x, targetSqlType, scale)voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int, int).
setPoolable(poolable)voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds)voidFor documentation of this method, see java.sql.Statement#setQueryTimeout(int).
setRef(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRef(int, java.sql.Ref).
setRowId(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRowId(int, java.sql.RowId).
setRowId(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setRowId(String, java.sql.RowId).
setSQLXML(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, java.sql.SQLXML).
setSQLXML(parameterName, xmlObject)voidFor documentation of this method, see java.sql.CallableStatement#setSQLXML(String, java.sql.SQLXML).
setShort(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setShort(int, short).
setShort(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setShort(String, short).
setString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setString(int, String).
setString(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setString(String, String).
setTime(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, java.sql.Time).
setTime(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, java.sql.Time, java.util.Calendar).
setTime(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setTime(String, java.sql.Time).
setTime(parameterName, x, timeZone)voidFor documentation of this method, see java.sql.CallableStatement#setTime(String, java.sql.Time, java.util.Calendar).
setTimestamp(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp).
setTimestamp(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp, java.util.Calendar).
setTimestamp(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setTimestamp(String, java.sql.Timestamp).
setTimestamp(parameterName, x, timeZone)voidFor documentation of this method, see java.sql.CallableStatement#setTimestamp(String, java.sql.Timestamp, java.util.Calendar).
setURL(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setURL(int, java.net.URL).
setURL(parameterName, val)voidFor documentation of this method, see java.sql.CallableStatement#setURL(String, java.net.URL).
wasNull()BooleanFor 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

NameTypeDescription
sqlString

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

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

NameTypeDescription
sqlString

Return

Boolean

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

NameTypeDescription
sqlString
autoGeneratedKeysInteger

Return

Boolean

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

NameTypeDescription
sqlString
columnIndexesInteger[]

Return

Boolean

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

NameTypeDescription
sqlString
columnNamesString[]

Return

Boolean

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[]

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

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

NameTypeDescription
sqlString

Return

JdbcResultSet

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

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

NameTypeDescription
sqlString

Return

Integer

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

NameTypeDescription
sqlString
autoGeneratedKeysInteger

Return

Integer

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

NameTypeDescription
sqlString
columnIndexesInteger[]

Return

Integer

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

NameTypeDescription
sqlString
columnNamesString[]

Return

Integer

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

NameTypeDescription
parameterIndexInteger

Return

JdbcArray

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

NameTypeDescription
parameterNameString

Return

JdbcArray

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

NameTypeDescription
parameterIndexInteger

Return

BigNumber

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

NameTypeDescription
parameterNameString

Return

BigNumber

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

NameTypeDescription
parameterIndexInteger

Return

JdbcBlob

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

NameTypeDescription
parameterNameString

Return

JdbcBlob

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

NameTypeDescription
parameterIndexInteger

Return

Boolean

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

NameTypeDescription
parameterNameString

Return

Boolean

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

NameTypeDescription
parameterIndexInteger

Return

Byte

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

NameTypeDescription
parameterNameString

Return

Byte

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

NameTypeDescription
parameterIndexInteger

Return

Byte[]

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

NameTypeDescription
parameterNameString

Return

Byte[]

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

NameTypeDescription
parameterIndexInteger

Return

JdbcClob

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

NameTypeDescription
parameterNameString

Return

JdbcClob

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

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

NameTypeDescription
parameterIndexInteger

Return

JdbcDate

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, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
timeZoneString

Return

JdbcDate

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

NameTypeDescription
parameterNameString

Return

JdbcDate

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, java.util.Calendar).

Parameters

NameTypeDescription
parameterNameString
timeZoneString

Return

JdbcDate

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

NameTypeDescription
parameterIndexInteger

Return

Number

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

NameTypeDescription
parameterNameString

Return

Number

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

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

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

NameTypeDescription
parameterIndexInteger

Return

Number

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

NameTypeDescription
parameterNameString

Return

Number

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

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

NameTypeDescription
parameterIndexInteger

Return

Integer

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

NameTypeDescription
parameterNameString

Return

Integer

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

NameTypeDescription
parameterIndexInteger

Return

Integer

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

NameTypeDescription
parameterNameString

Return

Integer

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

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

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

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

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

NameTypeDescription
currentInteger

Return

Boolean

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

NameTypeDescription
parameterIndexInteger

Return

JdbcClob

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

NameTypeDescription
parameterNameString

Return

JdbcClob

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

NameTypeDescription
parameterIndexInteger

Return

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

getNString(parameterName)

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

Parameters

NameTypeDescription
parameterNameString

Return

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

getObject(parameterIndex)

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

Parameters

NameTypeDescription
parameterIndexInteger

Return

Object

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

NameTypeDescription
parameterNameString

Return

Object

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

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

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

NameTypeDescription
parameterIndexInteger

Return

JdbcRef

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

NameTypeDescription
parameterNameString

Return

JdbcRef

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

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

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

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

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

NameTypeDescription
parameterIndexInteger

Return

JdbcRowId

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

NameTypeDescription
parameterNameString

Return

JdbcRowId

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

NameTypeDescription
parameterIndexInteger

Return

JdbcSQLXML

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

NameTypeDescription
parameterNameString

Return

JdbcSQLXML

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

NameTypeDescription
parameterIndexInteger

Return

Integer

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

NameTypeDescription
parameterNameString

Return

Integer

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

NameTypeDescription
parameterIndexInteger

Return

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

getString(parameterName)

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

Parameters

NameTypeDescription
parameterNameString

Return

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

getTime(parameterIndex)

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

Parameters

NameTypeDescription
parameterIndexInteger

Return

JdbcTime

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, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
timeZoneString

Return

JdbcTime

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

NameTypeDescription
parameterNameString

Return

JdbcTime

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, java.util.Calendar).

Parameters

NameTypeDescription
parameterNameString
timeZoneString

Return

JdbcTime

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

NameTypeDescription
parameterIndexInteger

Return

JdbcTimestamp

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, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
timeZoneString

Return

JdbcTimestamp

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

NameTypeDescription
parameterNameString

Return

JdbcTimestamp

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, java.util.Calendar).

Parameters

NameTypeDescription
parameterNameString
timeZoneString

Return

JdbcTimestamp

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

NameTypeDescription
parameterIndexInteger

Return

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

NameTypeDescription
parameterNameString

Return

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

getUpdateCount()

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

Return

Integer

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()

Returns the current set of warnings reported by the driver. For documentation of this method, see java.sql.Statement#getWarnings()

Return

String[] — array of 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

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

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

NameTypeDescription
parameterIndexInteger
sqlTypeInteger

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

NameTypeDescription
parameterIndexInteger
sqlTypeInteger
scaleInteger

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

NameTypeDescription
parameterIndexInteger
sqlTypeInteger
typeNameString

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

NameTypeDescription
parameterNameString
sqlTypeInteger

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

NameTypeDescription
parameterNameString
sqlTypeInteger
scaleInteger

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

NameTypeDescription
parameterNameString
sqlTypeInteger
typeNameString

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, java.sql.Array).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcArray

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, java.math.BigDecimal).

Parameters

NameTypeDescription
parameterIndexInteger
xBigNumber

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, java.math.BigDecimal).

Parameters

NameTypeDescription
parameterNameString
xBigNumber

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, java.sql.Blob).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcBlob

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, java.sql.Blob).

Parameters

NameTypeDescription
parameterNameString
xJdbcBlob

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

NameTypeDescription
parameterIndexInteger
xBoolean

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

NameTypeDescription
parameterNameString
xBoolean

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

NameTypeDescription
parameterIndexInteger
xByte

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

NameTypeDescription
parameterNameString
xByte

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

NameTypeDescription
parameterIndexInteger
xByte[]

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

NameTypeDescription
parameterNameString
xByte[]

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, java.sql.Clob).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcClob

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#setClob(String, java.sql.Clob).

Parameters

NameTypeDescription
parameterNameString
xJdbcClob

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

NameTypeDescription
nameString

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, java.sql.Date).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcDate

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, java.sql.Date, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcDate
timeZoneString

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, java.sql.Date).

Parameters

NameTypeDescription
parameterNameString
xJdbcDate

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, java.sql.Date, java.util.Calendar).

Parameters

NameTypeDescription
parameterNameString
xJdbcDate
timeZoneString

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

NameTypeDescription
parameterIndexInteger
xNumber

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

NameTypeDescription
parameterNameString
xNumber

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

NameTypeDescription
enableBoolean

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

NameTypeDescription
directionInteger

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

NameTypeDescription
rowsInteger

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

NameTypeDescription
parameterIndexInteger
xNumber

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

NameTypeDescription
parameterNameString
xNumber

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

NameTypeDescription
parameterIndexInteger
xInteger

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

NameTypeDescription
parameterNameString
xInteger

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

NameTypeDescription
parameterIndexInteger
xInteger

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

NameTypeDescription
parameterNameString
xInteger

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

NameTypeDescription
maxInteger

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

NameTypeDescription
maxInteger

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, java.sql.NClob).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcClob

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, java.sql.NClob).

Parameters

NameTypeDescription
parameterNameString
valueJdbcClob

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

NameTypeDescription
parameterIndexInteger
xString

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

NameTypeDescription
parameterNameString
valueString

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

NameTypeDescription
parameterIndexInteger
sqlTypeInteger

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

NameTypeDescription
parameterIndexInteger
sqlTypeInteger
typeNameString

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

NameTypeDescription
parameterNameString
sqlTypeInteger

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

NameTypeDescription
parameterNameString
sqlTypeInteger
typeNameString

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

NameTypeDescription
indexInteger
xObject

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

NameTypeDescription
parameterIndexInteger
xObject
targetSqlTypeInteger

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

NameTypeDescription
parameterIndexInteger
xObject
targetSqlTypeInteger
scaleOrLengthInteger

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

NameTypeDescription
parameterNameString
xObject

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

NameTypeDescription
parameterNameString
xObject
targetSqlTypeInteger

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

NameTypeDescription
parameterNameString
xObject
targetSqlTypeInteger
scaleInteger

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

NameTypeDescription
poolableBoolean

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

NameTypeDescription
secondsInteger

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, java.sql.Ref).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcRef

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, java.sql.RowId).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcRowId

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, java.sql.RowId).

Parameters

NameTypeDescription
parameterNameString
xJdbcRowId

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, java.sql.SQLXML).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcSQLXML

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, java.sql.SQLXML).

Parameters

NameTypeDescription
parameterNameString
xmlObjectJdbcSQLXML

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

NameTypeDescription
parameterIndexInteger
xInteger

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

NameTypeDescription
parameterNameString
xInteger

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

NameTypeDescription
parameterIndexInteger
xString

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

NameTypeDescription
parameterNameString
xString

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, java.sql.Time).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTime

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, java.sql.Time, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTime
timeZoneString

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, java.sql.Time).

Parameters

NameTypeDescription
parameterNameString
xJdbcTime

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, java.sql.Time, java.util.Calendar).

Parameters

NameTypeDescription
parameterNameString
xJdbcTime
timeZoneString

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, java.sql.Timestamp).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTimestamp

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, java.sql.Timestamp, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTimestamp
timeZoneString

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, java.sql.Timestamp).

Parameters

NameTypeDescription
parameterNameString
xJdbcTimestamp

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, java.sql.Timestamp, java.util.Calendar).

Parameters

NameTypeDescription
parameterNameString
xJdbcTimestamp
timeZoneString

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, java.net.URL).

Parameters

NameTypeDescription
parameterIndexInteger
xString

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, java.net.URL).

Parameters

NameTypeDescription
parameterNameString
valString

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

Authorization

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

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

发送以下问题的反馈:

此网页
Apps Script
Apps Script
需要帮助?请访问我们的支持页面