clearWarnings()

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

close()

Release the JdbcConnection's database and all associated resources.

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

See also

• java.sql.Connection#close()

commit()

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

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

See also

• java.sql.Connection#commit()

createArrayOf(typeName, elements)

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

Parameters

Return

JdbcArray

createBlob()

Constructs a JdbcBlob instance The object returned initially contains no data. The setBytes methods of JdbcBlob may be used to set the data it should contain. Note that 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

See also

• java.sql.Connection#createBlob()

createClob()

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

Return

JdbcClob

createNClob()

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

Return

JdbcClob

createSQLXML()

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

Return

JdbcSQLXML

createStatement()

Creates a JdbcStatement object for sending SQL statements to the database.

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

 stmt.setMaxRows(100);
 var rs = stmt.execute("select * from person");

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

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

Return

JdbcStatement — a JdbcStatement instance to execute queries with

See also

• java.sql.Connection#createStatement()

createStatement(resultSetType, resultSetConcurrency)

Creates a JdbcStatement object for sending SQL statements to the database. 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)
 var conn = Jdbc.getConnection("jdbc:mysql://<host>:3306/<instance>")
 var stmt = conn.createStatement(Jdbc.ResultSet.TYPE_FORWARD_ONLY,
                                 Jdbc.ResultSet.CONCUR_READ_ONLY);

 stmt.setMaxRows(100);
 var rs = stmt.execute("select * from person");

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

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

Parameters

Return

JdbcStatement — a JdbcStatement instance to execute queries with

See also

• java.sql.Connection#createStatement(int, int)

createStatement(resultSetType, resultSetConcurrency, resultSetHoldability)

Creates a JdbcStatement object for sending SQL statements to the database. 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)
 var conn = Jdbc.getConnection("jdbc:mysql://<host>:3306/<instance>")
 var stmt = conn.createStatement(Jdbc.ResultSet.TYPE_FORWARD_ONLY,
                                 Jdbc.ResultSet.CONCUR_READ_ONLY,
                                 Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT);

 stmt.setMaxRows(100);
 var rs = stmt.execute("select * from person");

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

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

Parameters

Return

JdbcStatement — a JdbcStatement instance to execute queries with

See also

• java.sql.Connection#createStatement(int, int, int)

createStruct(typeName, attributes)

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

Parameters

Return

JdbcStruct

getAutoCommit()

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

Return

Boolean

getCatalog()

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

Return

String

getHoldability()

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

Return

Integer

getMetaData()

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

Return

JdbcDatabaseMetaData

getTransactionIsolation()

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

Return

Integer

getWarnings()

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

Return

String[]

isClosed()

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

Return

Boolean

isReadOnly()

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

Return

Boolean

isValid(timeout)

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

Parameters

Return

Boolean

nativeSQL(sql)

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

Parameters

Return

String

prepareCall(sql)

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

Parameters

Return

JdbcCallableStatement

prepareCall(sql, resultSetType, resultSetConcurrency)

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

Parameters

Return

JdbcCallableStatement

prepareCall(sql, resultSetType, resultSetConcurrency, resultSetHoldability)

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

Parameters

Return

JdbcCallableStatement

prepareStatement(sql)

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

Parameters

Return

JdbcPreparedStatement

prepareStatement(sql, autoGeneratedKeys)

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

Parameters

Return

JdbcPreparedStatement

prepareStatement(sql, resultSetType, resultSetConcurrency)

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

Parameters

Return

JdbcPreparedStatement

prepareStatement(sql, resultSetType, resultSetConcurrency, resultSetHoldability)

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

Parameters

Return

JdbcPreparedStatement

prepareStatementByIndex(sql, indices)

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

Parameters

Return

JdbcPreparedStatement

prepareStatementByName(sql, columnNames)

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

Parameters

Return

JdbcPreparedStatement

releaseSavepoint(savepoint)

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

Parameters

rollback()

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

rollback(savepoint)

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

Parameters

setAutoCommit(autoCommit)

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

Parameters

setCatalog(catalog)

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

Parameters

setHoldability(holdability)

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

Parameters

setReadOnly(readOnly)

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

Parameters

setSavepoint()

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

Return

JdbcSavepoint

setSavepoint(name)

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

Parameters

Return

JdbcSavepoint

setTransactionIsolation(level)

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

Parameters