Class JdbcConnection

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

Methods

Method	Return type	Brief description
`clearWarnings()`	`void`	For documentation of this method, see `java.sql.Connection#clearWarnings()`.
`close()`	`void`	Release this connection's database and all associated resources.
`commit()`	`void`	Makes all pending changes permanent, releases database locks held by this `JdbcConnection`.
`createArrayOf(typeName, elements)`	`JdbcArray`	For documentation of this method, see `java.sql.Connection#createArrayOf(String, Object[])`.
`createBlob()`	`JdbcBlob`	Constructs a `JdbcBlob` instance.
`createClob()`	`JdbcClob`	For documentation of this method, see `java.sql.Connection#createClob()`.
`createNClob()`	`JdbcClob`	For documentation of this method, see `java.sql.Connection#createNClob()`.
`createSQLXML()`	`JdbcSQLXML`	For documentation of this method, see `java.sql.Connection#createSQLXML()`.
`createStatement()`	`JdbcStatement`	Creates a `JdbcStatement` object for sending SQL statements to the database.
`createStatement(resultSetType, resultSetConcurrency)`	`JdbcStatement`	Creates a `JdbcStatement` object for sending SQL statements to the database.
`createStatement(resultSetType, resultSetConcurrency, resultSetHoldability)`	`JdbcStatement`	Creates a `JdbcStatement` object for sending SQL statements to the database.
`createStruct(typeName, attributes)`	`JdbcStruct`	For documentation of this method, see `java.sql.Connection#createStruct(String, Object[])`.
`getAutoCommit()`	`Boolean`	For documentation of this method, see `java.sql.Connection#getAutoCommit()`.
`getCatalog()`	`String`	or documentation of this method, see `java.sql.Connection#getCatalog()`.
`getHoldability()`	`Integer`	For documentation of this method, see `java.sql.Connection#getHoldability()`.
`getMetaData()`	`JdbcDatabaseMetaData`	For documentation of this method, see `java.sql.Connection#getMetaData()`.
`getTransactionIsolation()`	`Integer`	For documentation of this method, see `java.sql.Connection#getTransactionIsolation()`.
`getWarnings()`	`String[]`	For documentation of this method, see `java.sql.Connection#getWarnings()`.
`isClosed()`	`Boolean`	For documentation of this method, see `java.sql.Connection#isClosed()`.
`isReadOnly()`	`Boolean`	For documentation of this method, see `java.sql.Connection#isReadOnly()`.
`isValid(timeout)`	`Boolean`	For documentation of this method, see `java.sql.Connection#isValid(int)`.
`nativeSQL(sql)`	`String`	For documentation of this method, see `java.sql.Connection#nativeSQL(String)`.
`prepareCall(sql)`	`JdbcCallableStatement`	For documentation of this method, see `java.sql.Connection#prepareCall(String)`.
`prepareCall(sql, resultSetType, resultSetConcurrency)`	`JdbcCallableStatement`	For documentation of this method, see `java.sql.Connection#prepareCall(String, int, int)`.
`prepareCall(sql, resultSetType, resultSetConcurrency, resultSetHoldability)`	`JdbcCallableStatement`	For documentation of this method, see `java.sql.Connection#prepareCall(String, int, int, int)`.
`prepareStatement(sql)`	`JdbcPreparedStatement`	For documentation of this method, see `java.sql.Connection#prepareStatement(String)`.
`prepareStatement(sql, autoGeneratedKeys)`	`JdbcPreparedStatement`	For documentation of this method, see `java.sql.Connection#prepareStatement(String, int)`.
`prepareStatement(sql, resultSetType, resultSetConcurrency)`	`JdbcPreparedStatement`	For documentation of this method, see `java.sql.Connection#prepareStatement(String, int, int)`.
`prepareStatement(sql, resultSetType, resultSetConcurrency, resultSetHoldability)`	`JdbcPreparedStatement`	For documentation of this method, see `java.sql.Connection#prepareStatement(String, int, int, int)`.
`prepareStatementByIndex(sql, indices)`	`JdbcPreparedStatement`	For documentation of this method, see `java.sql.Connection#prepareStatement(String, int[])`.
`prepareStatementByName(sql, columnNames)`	`JdbcPreparedStatement`	For documentation of this method, see `java.sql.Connection#prepareStatement(String, String[])`.
`releaseSavepoint(savepoint)`	`void`	For documentation of this method, see `java.sql.Connection#releaseSavepoint(Savepoint)`.
`rollback()`	`void`	For documentation of this method, see `java.sql.Connection#rollback()`.
`rollback(savepoint)`	`void`	For documentation of this method, see `java.sql.Connection#rollback(Savepoint)`.
`setAutoCommit(autoCommit)`	`void`	For documentation of this method, see `java.sql.Connection#setAutoCommit(boolean)`.
`setCatalog(catalog)`	`void`	For documentation of this method, see `java.sql.Connection#setCatalog(String)`.
`setHoldability(holdability)`	`void`	For documentation of this method, see `java.sql.Connection#setHoldability(int)`.
`setReadOnly(readOnly)`	`void`	For documentation of this method, see `java.sql.Connection#setReadOnly(boolean)`.
`setSavepoint()`	`JdbcSavepoint`	For documentation of this method, see `java.sql.Connection#setSavepoint()`.
`setSavepoint(name)`	`JdbcSavepoint`	For documentation of this method, see `java.sql.Connection#setSavepoint(String)`.
`setTransactionIsolation(level)`	`void`	For documentation of this method, see `java.sql.Connection#setTransactionIsolation(int)`.

Detailed documentation

`clearWarnings()`

For documentation of this method, see java.sql.Connection#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()`

Release this connection's database and all associated resources.

const conn = Jdbc.getConnection(
    'jdbc:mysql://<host>:<port>/<instance>',
    'user',
    'password',
);
conn.close();

`commit()`

Makes all pending changes permanent, releases database locks held by this JdbcConnection.

const conn = Jdbc.getConnection(
    'jdbc:mysql://<host>:<port>/<instance>',
    'user',
    'password',
);
conn.setAutoCommit(false);
const stmt = conn.prepareStatement(
    'insert into person (lname,fname) values (?,?)',
);
const start = new Date();
for (let i = 0; i < 5000; i++) {
  // Objects are accessed using 1-based indexing
  stmt.setObject(1, `firstName${i}`);
  stmt.setObject(2, `lastName${i}`);
  stmt.addBatch();
}
const res = stmt.executeBatch();
conn.commit();  // When this returns, this is when changes are actually
                // committed
conn.close();

Authorization

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

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

`createArrayOf(typeName, elements)`

For documentation of this method, see java.sql.Connection#createArrayOf(String, Object[]).

Parameters

Name	Type	Description
`typeName`	`String`	The database-specific SQL name of the array elemnents' type. Options include built-in types, user-defined types, or standard SQL types supported by the database.
`elements`	`Object[]`	The elements to populate in the returned object.

Return

JdbcArray — An array whose elements map to the specified SQL type.

`createBlob()`

Constructs a JdbcBlob instance. See also java.sql.Connection#createBlob().

The object returned initially contains no data. You can use the setBytes methods of JdbcBlob to set the data it should contain. The blob used here is not the same as the blob created with Utilities.newBlob(data). To convert between the two formats, use the defined getBytes() and setBytes() methods. Alternatively, both JdbcBlob and JdbcClob provide a getAppsScriptBlob() convenience method for converting to a format that can be used by Apps Script.

Return

JdbcBlob — An empty blob object.

`createClob()`

For documentation of this method, see java.sql.Connection#createClob().

Return

JdbcClob — An empty clob object.

`createNClob()`

For documentation of this method, see java.sql.Connection#createNClob().

Return

JdbcClob — An empty nclob object.

`createSQLXML()`

For documentation of this method, see java.sql.Connection#createSQLXML().

Return

JdbcSQLXML — An empty SQLXML object.

`createStatement()`

Creates a JdbcStatement object for sending SQL statements to the database. See also java.sql.Connection#createStatement().

// This sample code assumes authentication is off
const conn = Jdbc.getConnection('jdbc:mysql://<host>:3306/<instance>');
const stmt = conn.createStatement();

stmt.setMaxRows(100);
const rs = stmt.execute('select * from person');

while (rs.next()) {
  // Do something
}

rs.close();
stmt.close();
conn.close();

Return

JdbcStatement — A statement instance to execute queries with.

`createStatement(resultSetType, resultSetConcurrency)`

Creates a JdbcStatement object for sending SQL statements to the database. See also java.sql.Connection#createStatement(int, int).

This version allows the result set type and concurrency to be overridden.

// This sample code assumes authentication is off
// For more information about this method, see documentation here:
//  http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html#createStatement(int,
//  int)
const conn = Jdbc.getConnection('jdbc:mysql://<host>:3306/<instance>');
const stmt = conn.createStatement(
    Jdbc.ResultSet.TYPE_FORWARD_ONLY,
    Jdbc.ResultSet.CONCUR_READ_ONLY,
);

stmt.setMaxRows(100);
const rs = stmt.execute('select * from person');

while (rs.next()) {
  // Do something
}

rs.close();
stmt.close();
conn.close();

Parameters

Name	Type	Description
`resultSetType`	`Integer`	A result set type; one of `Jdbc.ResultSet.TYPE_FORWARD_ONLY`, `Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE`, or `Jdbc.ResultSet.TYPE_SCROLL_SENSITIVE`.
`resultSetConcurrency`	`Integer`	A concurrency type; either `Jdbc.ResultSet.CONCUR_READ_ONLY` or `Jdbc.ResultSet.CONCUR_UPDATABLE`.

Return

JdbcStatement — A statement instance to execute queries with.

`createStatement(resultSetType, resultSetConcurrency, resultSetHoldability)`

Creates a JdbcStatement object for sending SQL statements to the database. See also java.sql.Connection#createStatement(int, int, int).

This version allows the result set type, concurrency and holdability to be overridden.

// This sample code assumes authentication is off
// For more information about this method, see documentation here:
//  http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html#createStatement(int,
//  int)
const conn = Jdbc.getConnection('jdbc:mysql://<host>:3306/<instance>');
const stmt = conn.createStatement(
    Jdbc.ResultSet.TYPE_FORWARD_ONLY,
    Jdbc.ResultSet.CONCUR_READ_ONLY,
    Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT,
);

stmt.setMaxRows(100);
const rs = stmt.execute('select * from person');

while (rs.next()) {
  // Do something
}

rs.close();
stmt.close();
conn.close();

Parameters

Name	Type	Description
`resultSetType`	`Integer`	A result set type; one of `Jdbc.ResultSet.TYPE_FORWARD_ONLY`, `Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE`, or `Jdbc.ResultSet.TYPE_SCROLL_SENSITIVE`.
`resultSetConcurrency`	`Integer`	A concurrency type; either `Jdbc.ResultSet.CONCUR_READ_ONLY` or `Jdbc.ResultSet.CONCUR_UPDATABLE`.
`resultSetHoldability`	`Integer`	A holdability setting; either `Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT` or `Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT`.

Return

JdbcStatement — A statement instance to execute queries with.

`createStruct(typeName, attributes)`

For documentation of this method, see java.sql.Connection#createStruct(String, Object[]).

Parameters

Name	Type	Description
`typeName`	`String`	The database-specific SQL name of the array elemnents' type. Options include built-in types, user-defined types, or standard SQL types supported by the database.
`attributes`	`Object[]`	The attributes that populate the returned object.

Return

JdbcStruct — A structure object that maps to the given SQL type and is populated with the given attributes.

`getAutoCommit()`

For documentation of this method, see java.sql.Connection#getAutoCommit().

Return

Boolean — true if the connection's auto-commit mode is enabled; false otherwise.

Authorization

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

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

`getCatalog()`

or documentation of this method, see java.sql.Connection#getCatalog().

Return

String — The current catalog name or null if no name has been set.

Authorization

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

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

`getHoldability()`

For documentation of this method, see java.sql.Connection#getHoldability().

Return

Integer — The holdability setting of the connection; either Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT or Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT.

`getMetaData()`

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

Return

JdbcDatabaseMetaData — The metadata of the database this connection connects to.

Authorization

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

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

`getTransactionIsolation()`

For documentation of this method, see java.sql.Connection#getTransactionIsolation().

Return

Integer — The current transaction level, which is one of: Jdbc.Connection.TRANSACTION_READ_UNCOMMITTED, Jdbc.Connection.TRANSACTION_READ_COMMITTED, Jdbc.Connection.TRANSACTION_REPEATABLE_READ, Jdbc.Connection.TRANSACTION_SERIALIZABLE, or Jdbc.Connection.TRANSACTION_NONE.

Authorization

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

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

`getWarnings()`

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

Return

String[] — An array of warning strings.

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.Connection#isClosed().

Return

Boolean — true if the connection is closed; false otherwise.

Authorization

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

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

`isReadOnly()`

For documentation of this method, see java.sql.Connection#isReadOnly().

Return

Boolean — true if the connection is read-only; false otherwise.

Authorization

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

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

`isValid(timeout)`

For documentation of this method, see java.sql.Connection#isValid(int).

Parameters

Name	Type	Description
`timeout`	`Integer`	The time in seconds to wait for the validation operation to complete. A value of 0 indicates no timeout is applied.

Return

Boolean — true if the connection is valid; false otherwise. Also returns false if the timeout period expires before the operation completes.

Authorization

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

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

`nativeSQL(sql)`

For documentation of this method, see java.sql.Connection#nativeSQL(String).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' placeholders.

Return

String — The native form of the provided statement.

Authorization

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

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

`prepareCall(sql)`

For documentation of this method, see java.sql.Connection#prepareCall(String).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' placeholders, typically provided using JDBC call escape syntax.

Return

JdbcCallableStatement — A callable statement containing the pre-compiled SQL statement.

`prepareCall(sql, resultSetType, resultSetConcurrency)`

For documentation of this method, see java.sql.Connection#prepareCall(String, int, int).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' placeholders, typically provided using JDBC call escape syntax.
`resultSetType`	`Integer`	A result set type; one of `Jdbc.ResultSet.TYPE_FORWARD_ONLY`, `Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE`, or `Jdbc.ResultSet.TYPE_SCROLL_SENSITIVE`.
`resultSetConcurrency`	`Integer`	A concurrency type; either `Jdbc.ResultSet.CONCUR_READ_ONLY` or `Jdbc.ResultSet.CONCUR_UPDATABLE`.

Return

JdbcCallableStatement — A callable statement containing the pre-compiled SQL statement that produces result sets with the provided type and concurrency.

`prepareCall(sql, resultSetType, resultSetConcurrency, resultSetHoldability)`

For documentation of this method, see java.sql.Connection#prepareCall(String, int, int, int).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' placeholders, typically provided using JDBC call escape syntax.
`resultSetType`	`Integer`	A result set type; one of `Jdbc.ResultSet.TYPE_FORWARD_ONLY`, `Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE`, or `Jdbc.ResultSet.TYPE_SCROLL_SENSITIVE`.
`resultSetConcurrency`	`Integer`	A concurrency type; either `Jdbc.ResultSet.CONCUR_READ_ONLY` or `Jdbc.ResultSet.CONCUR_UPDATABLE`.
`resultSetHoldability`	`Integer`	A holdability setting; either `Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT` or `Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT`.

Return

JdbcCallableStatement — A callable statement containing the pre-compiled SQL statement that produces result sets with the provided type, concurrency.

`prepareStatement(sql)`

For documentation of this method, see java.sql.Connection#prepareStatement(String).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' IN parameter placeholders.

Return

JdbcPreparedStatement — A prepared statement containing the pre-compiled SQL statement.

`prepareStatement(sql, autoGeneratedKeys)`

For documentation of this method, see java.sql.Connection#prepareStatement(String, int).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' IN parameter placeholders.
`autoGeneratedKeys`	`Integer`	A flag that indicates whether auto-generated keys are returned; either `Jdbc.Statement.RETURN_GENERATED_KEYS` or `Jdbc.Statement.NO_GENERATED_KEYS`.

Return

JdbcPreparedStatement — A prepared statement containing the pre-compiled SQL statement, possibly capable of returning auto-generated keys.

`prepareStatement(sql, resultSetType, resultSetConcurrency)`

For documentation of this method, see java.sql.Connection#prepareStatement(String, int, int).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' IN parameter placeholders.
`resultSetType`	`Integer`	A result set type; one of `Jdbc.ResultSet.TYPE_FORWARD_ONLY`, `Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE`, or `Jdbc.ResultSet.TYPE_SCROLL_SENSITIVE`.
`resultSetConcurrency`	`Integer`	A concurrency type; either `Jdbc.ResultSet.CONCUR_READ_ONLY` or `Jdbc.ResultSet.CONCUR_UPDATABLE`.

Return

JdbcPreparedStatement — A prepared statement containing the pre-compiled SQL statement that produces result sets with the provided type and concurrency.

`prepareStatement(sql, resultSetType, resultSetConcurrency, resultSetHoldability)`

For documentation of this method, see java.sql.Connection#prepareStatement(String, int, int, int).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' IN parameter placeholders.
`resultSetType`	`Integer`	A result set type; one of `Jdbc.ResultSet.TYPE_FORWARD_ONLY`, `Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE`, or `Jdbc.ResultSet.TYPE_SCROLL_SENSITIVE`.
`resultSetConcurrency`	`Integer`	A concurrency type; either `Jdbc.ResultSet.CONCUR_READ_ONLY` or `Jdbc.ResultSet.CONCUR_UPDATABLE`.
`resultSetHoldability`	`Integer`	A holdability setting; either `Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT` or `Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT`.

Return

JdbcPreparedStatement — A prepared statement containing the pre-compiled SQL statement that produces result sets with the provided type, concurrency, and holdability.

`prepareStatementByIndex(sql, indices)`

For documentation of this method, see java.sql.Connection#prepareStatement(String, int[]).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' IN parameter placeholders.
`indices`	`Integer[]`	The column indices of columns that are returned from the inserted row or rows.

Return

JdbcPreparedStatement — A prepared statement containing the pre-compiled SQL statement, capable of returning auto-generated keys specified by the provided column indices.

`prepareStatementByName(sql, columnNames)`

For documentation of this method, see java.sql.Connection#prepareStatement(String, String[]).

Parameters

Name	Type	Description
`sql`	`String`	An SQL statement that may contain one more more '?' IN parameter placeholders.
`columnNames`	`String[]`	The column names that specify which columns the method should return from the inserted row or rows.

Return

JdbcPreparedStatement — A prepared statement containing the pre-compiled SQL statement, capable of returning auto-generated keys specified by the provided column names.

`releaseSavepoint(savepoint)`

For documentation of this method, see java.sql.Connection#releaseSavepoint(Savepoint).

Parameters

Name	Type	Description
`savepoint`	`JdbcSavepoint`	The save point to remove.

Authorization

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

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

`rollback()`

For documentation of this method, see java.sql.Connection#rollback().

Authorization

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

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

`rollback(savepoint)`

For documentation of this method, see java.sql.Connection#rollback(Savepoint).

Parameters

Name	Type	Description
`savepoint`	`JdbcSavepoint`	The save point to rollback to.

Authorization

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

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

`setAutoCommit(autoCommit)`

For documentation of this method, see java.sql.Connection#setAutoCommit(boolean).

Parameters

Name	Type	Description
`autoCommit`	`Boolean`	If `true`, auto-commit mode is enabled; `false` disables.

Authorization

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

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

`setCatalog(catalog)`

For documentation of this method, see java.sql.Connection#setCatalog(String).

Parameters

Name	Type	Description
`catalog`	`String`	The name of a catalog (the subspace in the connection's database) in which to work.

Authorization

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

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

`setHoldability(holdability)`

For documentation of this method, see java.sql.Connection#setHoldability(int).

Parameters

Name	Type	Description
`holdability`	`Integer`	The default holdability of `JdbcResultSet` objects created with this connection; either `Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT` or `Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT`.

`setReadOnly(readOnly)`

For documentation of this method, see java.sql.Connection#setReadOnly(boolean).

Parameters

Name	Type	Description
`readOnly`	`Boolean`	If `true`, read-only mode is enabled; `false` disables.

Authorization

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

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

`setSavepoint()`

For documentation of this method, see java.sql.Connection#setSavepoint().

Return

JdbcSavepoint — The new unnamed save point.

Authorization

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

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

`setSavepoint(name)`

For documentation of this method, see java.sql.Connection#setSavepoint(String).

Parameters

Name	Type	Description
`name`	`String`	The name of the created save point.

Return

JdbcSavepoint — The new named save point.

Authorization

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

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

`setTransactionIsolation(level)`

For documentation of this method, see java.sql.Connection#setTransactionIsolation(int).

Parameters

Name	Type	Description
`level`	`Integer`	The transaction level to set, which is one of: `Jdbc.Connection.TRANSACTION_READ_UNCOMMITTED`, `Jdbc.Connection.TRANSACTION_READ_COMMITTED`, `Jdbc.Connection.TRANSACTION_REPEATABLE_READ`, `Jdbc.Connection.TRANSACTION_SERIALIZABLE`, or `Jdbc.Connection.TRANSACTION_NONE`.

Authorization

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

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