Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://developers.google.com/apps-script/reference/jdbc/jdbc-connection below:

Class JdbcConnection | Apps Script

Stay organized with collections Save and categorize content based on your preferences.

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

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

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

Release this connection's database and all associated resources.

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

• Connection.close()

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

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

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

• Connection.commit()

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

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

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.

JdbcBlob — An empty blob object.

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

JdbcStatement — A statement instance to execute queries with.

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

JdbcStatement — A statement instance to execute queries with.

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

JdbcStatement — A statement instance to execute queries with.

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

String[] — An array of warning strings.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

String — The native form of the provided statement.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

JdbcSavepoint — The new unnamed save point.

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

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

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

JdbcSavepoint — The new named save point.

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

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

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

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

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

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2024-12-05 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-05 UTC."],[[["`JdbcConnection` in Apps Script provides methods for interacting with external databases, similar to `java.sql.Connection` in Java."],["It offers functionalities like connection management, transaction control, statement creation, and database metadata retrieval."],["The methods allow for tasks such as opening/closing connections, committing/rolling back transactions, creating different statement types, and managing savepoints."],["Most methods necessitate the `https://www.googleapis.com/auth/script.external_request` authorization scope."]]],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4