Class JdbcConnection

    • A JdbcConnection is a JDBC Connection object used to interact with a database.

    • It provides methods to manage the connection, such as closing it, committing or rolling back transactions, and setting properties like auto-commit and read-only modes.

    • The class includes methods for creating various types of SQL statements (Statement, PreparedStatement, CallableStatement) and objects like Arrays, Blobs, Clobs, and SQLXML.

    • Methods are available to retrieve information about the connection and the database metadata, as well as handle warnings.
    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 
 ();

    See also

    • Connection.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

    See also

    • Connection.commit()

    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
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: