google-apps-script.jdbc.d.ts

// Type definitions for Google Apps Script 2015-11-12
// Project: https://developers.google.com/apps-script/
// Definitions by: motemen <https://github.com/motemen/>
// Definitions: https://github.com/DefinitelyTyped/DefinitelyTyped

/// <reference path="google-apps-script.types.d.ts" />
/// <reference path="google-apps-script.base.d.ts" />

declare namespace GoogleAppsScript {
  export module JDBC {
    /**
     * The JDBC service allows scripts to connect to Google Cloud SQL, MySQL,
     *  Microsoft SQL Server, and Oracle databases. For more information, see the
     *  guide to JDBC.
     */
    export interface Jdbc {
      getCloudSqlConnection(url: string): JdbcConnection;
      getCloudSqlConnection(url: string, info: Object): JdbcConnection;
      getCloudSqlConnection(url: string, userName: string, password: string): JdbcConnection;
      getConnection(url: string): JdbcConnection;
      getConnection(url: string, info: Object): JdbcConnection;
      getConnection(url: string, userName: string, password: string): JdbcConnection;
      newDate(milliseconds: Integer): JdbcDate;
      newTime(milliseconds: Integer): JdbcTime;
      newTimestamp(milliseconds: Integer): JdbcTimestamp;
      parseDate(date: string): JdbcDate;
      parseTime(time: string): JdbcTime;
      parseTimestamp(timestamp: string): JdbcTimestamp;
    }

    /**
     * A JDBC Array. For documentation of this class, see java.sql.Array.
     */
    export interface JdbcArray {
      free(): void;
      getArray(): Object;
      getArray(index: Integer, count: Integer): Object;
      getBaseType(): Integer;
      getBaseTypeName(): string;
      getResultSet(): JdbcResultSet;
      getResultSet(index: Integer, count: Integer): JdbcResultSet;
    }

    /**
     * A JDBC Blob. For documentation of this class, see java.sql.Blob.
     */
    export interface JdbcBlob {
      free(): void;
      getAppsScriptBlob(): Base.Blob;
      getAs(contentType: string): Base.Blob;
      getBytes(position: Integer, length: Integer): Byte[];
      length(): Integer;
      position(pattern: Byte[], start: Integer): Integer;
      position(pattern: JdbcBlob, start: Integer): Integer;
      setBytes(position: Integer, blobSource: Base.BlobSource): Integer;
      setBytes(position: Integer, blobSource: Base.BlobSource, offset: Integer, length: Integer): Integer;
      setBytes(position: Integer, bytes: Byte[]): Integer;
      setBytes(position: Integer, bytes: Byte[], offset: Integer, length: Integer): Integer;
      truncate(length: Integer): void;
    }

    /**
     * A JDBC CallableStatement. For documentation of this class, see
     *  java.sql.CallableStatement.
     * See also
     *
     *  CallableStatement
     */
    export interface JdbcCallableStatement {
      addBatch(): void;
      addBatch(sql: string): void;
      cancel(): void;
      clearBatch(): void;
      clearParameters(): void;
      clearWarnings(): void;
      close(): void;
      execute(): boolean;
      execute(sql: string): boolean;
      execute(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): boolean;
      execute(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): boolean;
      execute(sql: string, columnNames: String[]): boolean;
      executeBatch(): Integer[];
      executeQuery(): JdbcResultSet;
      executeQuery(sql: string): JdbcResultSet;
      executeUpdate(): Integer;
      executeUpdate(sql: string): Integer;
      executeUpdate(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): Integer;
      executeUpdate(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): Integer;
      executeUpdate(sql: string, columnNames: String[]): Integer;
      getArray(parameterIndex: Integer): JdbcArray;
      getArray(parameterName: string): JdbcArray;
      getBigDecimal(parameterIndex: Integer): BigNumber;
      getBigDecimal(parameterName: string): BigNumber;
      getBlob(parameterIndex: Integer): JdbcBlob;
      getBlob(parameterName: string): JdbcBlob;
      getBoolean(parameterIndex: Integer): boolean;
      getBoolean(parameterName: string): boolean;
      getByte(parameterIndex: Integer): Byte;
      getByte(parameterName: string): Byte;
      getBytes(parameterIndex: Integer): Byte[];
      getBytes(parameterName: string): Byte[];
      getClob(parameterIndex: Integer): JdbcClob;
      getClob(parameterName: string): JdbcClob;
      getConnection(): JdbcConnection;
      getDate(parameterIndex: Integer): JdbcDate;
      getDate(parameterIndex: Integer, timeZone: string): JdbcDate;
      getDate(parameterName: string): JdbcDate;
      getDate(parameterName: string, timeZone: string): JdbcDate;
      getDouble(parameterIndex: Integer): Number;
      getDouble(parameterName: string): Number;
      getFetchDirection(): Integer;
      getFetchSize(): Integer;
      getFloat(parameterIndex: Integer): Number;
      getFloat(parameterName: string): Number;
      getGeneratedKeys(): JdbcResultSet;
      getInt(parameterIndex: Integer): Integer;
      getInt(parameterName: string): Integer;
      getLong(parameterIndex: Integer): Integer;
      getLong(parameterName: string): Integer;
      getMaxFieldSize(): Integer;
      getMaxRows(): Integer;
      getMetaData(): JdbcResultSetMetaData;
      getMoreResults(): boolean;
      getMoreResults(current: Integer): boolean;
      getNClob(parameterIndex: Integer): JdbcClob;
      getNClob(parameterName: string): JdbcClob;
      getNString(parameterIndex: Integer): string;
      getNString(parameterName: string): string;
      getObject(parameterIndex: Integer): Object;
      getObject(parameterName: string): Object;
      getParameterMetaData(): JdbcParameterMetaData;
      getQueryTimeout(): Integer;
      getRef(parameterIndex: Integer): JdbcRef;
      getRef(parameterName: string): JdbcRef;
      getResultSet(): JdbcResultSet;
      getResultSetConcurrency(): Integer;
      getResultSetHoldability(): Integer;
      getResultSetType(): Integer;
      getRowId(parameterIndex: Integer): JdbcRowId;
      getRowId(parameterName: string): JdbcRowId;
      getSQLXML(parameterIndex: Integer): JdbcSQLXML;
      getSQLXML(parameterName: string): JdbcSQLXML;
      getShort(parameterIndex: Integer): Integer;
      getShort(parameterName: string): Integer;
      getString(parameterIndex: Integer): string;
      getString(parameterName: string): string;
      getTime(parameterIndex: Integer): JdbcTime;
      getTime(parameterIndex: Integer, timeZone: string): JdbcTime;
      getTime(parameterName: string): JdbcTime;
      getTime(parameterName: string, timeZone: string): JdbcTime;
      getTimestamp(parameterIndex: Integer): JdbcTimestamp;
      getTimestamp(parameterIndex: Integer, timeZone: string): JdbcTimestamp;
      getTimestamp(parameterName: string): JdbcTimestamp;
      getTimestamp(parameterName: string, timeZone: string): JdbcTimestamp;
      getURL(parameterIndex: Integer): string;
      getURL(parameterName: string): string;
      getUpdateCount(): Integer;
      getWarnings(): String[];
      isClosed(): boolean;
      isPoolable(): boolean;
      registerOutParameter(parameterIndex: Integer, sqlType: Integer): void;
      registerOutParameter(parameterIndex: Integer, sqlType: Integer, scale: Integer): void;
      registerOutParameter(parameterIndex: Integer, sqlType: Integer, typeName: string): void;
      registerOutParameter(parameterName: string, sqlType: Integer): void;
      registerOutParameter(parameterName: string, sqlType: Integer, scale: Integer): void;
      registerOutParameter(parameterName: string, sqlType: Integer, typeName: string): void;
      setArray(parameterIndex: Integer, x: JdbcArray): void;
      setBigDecimal(parameterIndex: Integer, x: BigNumber): void;
      setBigDecimal(parameterName: string, x: BigNumber): void;
      setBlob(parameterIndex: Integer, x: JdbcBlob): void;
      setBlob(parameterName: string, x: JdbcBlob): void;
      setBoolean(parameterIndex: Integer, x: boolean): void;
      setBoolean(parameterName: string, x: boolean): void;
      setByte(parameterIndex: Integer, x: Byte): void;
      setByte(parameterName: string, x: Byte): void;
      setBytes(parameterIndex: Integer, x: Byte[]): void;
      setBytes(parameterName: string, x: Byte[]): void;
      setClob(parameterIndex: Integer, x: JdbcClob): void;
      setClob(parameterName: string, x: JdbcClob): void;
      setCursorName(name: string): void;
      setDate(parameterIndex: Integer, x: JdbcDate): void;
      setDate(parameterIndex: Integer, x: JdbcDate, timeZone: string): void;
      setDate(parameterName: string, x: JdbcDate): void;
      setDate(parameterName: string, x: JdbcDate, timeZone: string): void;
      setDouble(parameterIndex: Integer, x: Number): void;
      setDouble(parameterName: string, x: Number): void;
      setEscapeProcessing(enable: boolean): void;
      setFetchDirection(direction: Integer): void;
      setFetchSize(rows: Integer): void;
      setFloat(parameterIndex: Integer, x: Number): void;
      setFloat(parameterName: string, x: Number): void;
      setInt(parameterIndex: Integer, x: Integer): void;
      setInt(parameterName: string, x: Integer): void;
      setLong(parameterIndex: Integer, x: Integer): void;
      setLong(parameterName: string, x: Integer): void;
      setMaxFieldSize(max: Integer): void;
      setMaxRows(max: Integer): void;
      setNClob(parameterIndex: Integer, x: JdbcClob): void;
      setNClob(parameterName: string, value: JdbcClob): void;
      setNString(parameterIndex: Integer, x: string): void;
      setNString(parameterName: string, value: string): void;
      setNull(parameterIndex: Integer, sqlType: Integer): void;
      setNull(parameterIndex: Integer, sqlType: Integer, typeName: string): void;
      setNull(parameterName: string, sqlType: Integer): void;
      setNull(parameterName: string, sqlType: Integer, typeName: string): void;
      setObject(index: Integer, x: Object): void;
      setObject(parameterIndex: Integer, x: Object, targetSqlType: Integer): void;
      setObject(parameterIndex: Integer, x: Object, targetSqlType: Integer, scaleOrLength: Integer): void;
      setObject(parameterName: string, x: Object): void;
      setObject(parameterName: string, x: Object, targetSqlType: Integer): void;
      setObject(parameterName: string, x: Object, targetSqlType: Integer, scale: Integer): void;
      setPoolable(poolable: boolean): void;
      setQueryTimeout(seconds: Integer): void;
      setRef(parameterIndex: Integer, x: JdbcRef): void;
      setRowId(parameterIndex: Integer, x: JdbcRowId): void;
      setRowId(parameterName: string, x: JdbcRowId): void;
      setSQLXML(parameterIndex: Integer, x: JdbcSQLXML): void;
      setSQLXML(parameterName: string, xmlObject: JdbcSQLXML): void;
      setShort(parameterIndex: Integer, x: Integer): void;
      setShort(parameterName: string, x: Integer): void;
      setString(parameterIndex: Integer, x: string): void;
      setString(parameterName: string, x: string): void;
      setTime(parameterIndex: Integer, x: JdbcTime): void;
      setTime(parameterIndex: Integer, x: JdbcTime, timeZone: string): void;
      setTime(parameterName: string, x: JdbcTime): void;
      setTime(parameterName: string, x: JdbcTime, timeZone: string): void;
      setTimestamp(parameterIndex: Integer, x: JdbcTimestamp): void;
      setTimestamp(parameterIndex: Integer, x: JdbcTimestamp, timeZone: string): void;
      setTimestamp(parameterName: string, x: JdbcTimestamp): void;
      setTimestamp(parameterName: string, x: JdbcTimestamp, timeZone: string): void;
      setURL(parameterIndex: Integer, x: string): void;
      setURL(parameterName: string, val: string): void;
      wasNull(): boolean;
    }

    /**
     * A JDBC Clob. For documentation of this class, see java.sql.Clob.
     */
    export interface JdbcClob {
      free(): void;
      getAppsScriptBlob(): Base.Blob;
      getAs(contentType: string): Base.Blob;
      getSubString(position: Integer, length: Integer): string;
      length(): Integer;
      position(search: JdbcClob, start: Integer): Integer;
      position(search: string, start: Integer): Integer;
      setString(position: Integer, blobSource: Base.BlobSource): Integer;
      setString(position: Integer, blobSource: Base.BlobSource, offset: Integer, len: Integer): Integer;
      setString(position: Integer, value: string): Integer;
      setString(position: Integer, value: string, offset: Integer, len: Integer): Integer;
      truncate(length: Integer): void;
    }

    /**
     * A JDBC Connection. For documentation of this class, see java.sql.Connection.
     */
    export interface JdbcConnection {
      clearWarnings(): void;
      close(): void;
      commit(): void;
      createArrayOf(typeName: string, elements: Object[]): JdbcArray;
      createBlob(): JdbcBlob;
      createClob(): JdbcClob;
      createNClob(): JdbcClob;
      createSQLXML(): JdbcSQLXML;
      createStatement(): JdbcStatement;
      createStatement(resultSetType: Integer, resultSetConcurrency: Integer): JdbcStatement;
      createStatement(resultSetType: Integer, resultSetConcurrency: Integer, resultSetHoldability: Integer): JdbcStatement;
      createStruct(typeName: string, attributes: Object[]): JdbcStruct;
      getAutoCommit(): boolean;
      getCatalog(): string;
      getHoldability(): Integer;
      getMetaData(): JdbcDatabaseMetaData;
      getTransactionIsolation(): Integer;
      getWarnings(): String[];
      isClosed(): boolean;
      isReadOnly(): boolean;
      isValid(timeout: Integer): boolean;
      nativeSQL(sql: string): string;
      prepareCall(sql: string): JdbcCallableStatement;
      prepareCall(sql: string, resultSetType: Integer, resultSetConcurrency: Integer): JdbcCallableStatement;
      prepareCall(sql: string, resultSetType: Integer, resultSetConcurrency: Integer, resultSetHoldability: Integer): JdbcCallableStatement;
      prepareStatement(sql: string): JdbcPreparedStatement;
      prepareStatement(sql: string, autoGeneratedKeys: Integer): JdbcPreparedStatement;
      prepareStatement(sql: string, resultSetType: Integer, resultSetConcurrency: Integer): JdbcPreparedStatement;
      prepareStatement(sql: string, resultSetType: Integer, resultSetConcurrency: Integer, resultSetHoldability: Integer): JdbcPreparedStatement;
      prepareStatementByIndex(sql: string, indices: Integer[]): JdbcPreparedStatement;
      prepareStatementByName(sql: string, columnNames: String[]): JdbcPreparedStatement;
      releaseSavepoint(savepoint: JdbcSavepoint): void;
      rollback(): void;
      rollback(savepoint: JdbcSavepoint): void;
      setAutoCommit(autoCommit: boolean): void;
      setCatalog(catalog: string): void;
      setHoldability(holdability: Integer): void;
      setReadOnly(readOnly: boolean): void;
      setSavepoint(): JdbcSavepoint;
      setSavepoint(name: string): JdbcSavepoint;
      setTransactionIsolation(level: Integer): void;
    }

    /**
     * A JDBC DatabaseMetaData. For documentation of this class, see
     *  java.sql.DatabaseMetaData.
     */
    export interface JdbcDatabaseMetaData {
      allProceduresAreCallable(): boolean;
      allTablesAreSelectable(): boolean;
      autoCommitFailureClosesAllResultSets(): boolean;
      dataDefinitionCausesTransactionCommit(): boolean;
      dataDefinitionIgnoredInTransactions(): boolean;
      deletesAreDetected(type: Integer): boolean;
      doesMaxRowSizeIncludeBlobs(): boolean;
      getAttributes(catalog: string, schemaPattern: string, typeNamePattern: string, attributeNamePattern: string): JdbcResultSet;
      getBestRowIdentifier(catalog: string, schema: string, table: string, scope: Integer, nullable: boolean): JdbcResultSet;
      getCatalogSeparator(): string;
      getCatalogTerm(): string;
      getCatalogs(): JdbcResultSet;
      getClientInfoProperties(): JdbcResultSet;
      getColumnPrivileges(catalog: string, schema: string, table: string, columnNamePattern: string): JdbcResultSet;
      getColumns(catalog: string, schemaPattern: string, tableNamePattern: string, columnNamePattern: string): JdbcResultSet;
      getConnection(): JdbcConnection;
      getCrossReference(parentCatalog: string, parentSchema: string, parentTable: string, foreignCatalog: string, foreignSchema: string, foreignTable: string): JdbcResultSet;
      getDatabaseMajorVersion(): Integer;
      getDatabaseMinorVersion(): Integer;
      getDatabaseProductName(): string;
      getDatabaseProductVersion(): string;
      getDefaultTransactionIsolation(): Integer;
      getDriverMajorVersion(): Integer;
      getDriverMinorVersion(): Integer;
      getDriverName(): string;
      getDriverVersion(): string;
      getExportedKeys(catalog: string, schema: string, table: string): JdbcResultSet;
      getExtraNameCharacters(): string;
      getFunctionColumns(catalog: string, schemaPattern: string, functionNamePattern: string, columnNamePattern: string): JdbcResultSet;
      getFunctions(catalog: string, schemaPattern: string, functionNamePattern: string): JdbcResultSet;
      getIdentifierQuoteString(): string;
      getImportedKeys(catalog: string, schema: string, table: string): JdbcResultSet;
      getIndexInfo(catalog: string, schema: string, table: string, unique: boolean, approximate: boolean): JdbcResultSet;
      getJDBCMajorVersion(): Integer;
      getJDBCMinorVersion(): Integer;
      getMaxBinaryLiteralLength(): Integer;
      getMaxCatalogNameLength(): Integer;
      getMaxCharLiteralLength(): Integer;
      getMaxColumnNameLength(): Integer;
      getMaxColumnsInGroupBy(): Integer;
      getMaxColumnsInIndex(): Integer;
      getMaxColumnsInOrderBy(): Integer;
      getMaxColumnsInSelect(): Integer;
      getMaxColumnsInTable(): Integer;
      getMaxConnections(): Integer;
      getMaxCursorNameLength(): Integer;
      getMaxIndexLength(): Integer;
      getMaxProcedureNameLength(): Integer;
      getMaxRowSize(): Integer;
      getMaxSchemaNameLength(): Integer;
      getMaxStatementLength(): Integer;
      getMaxStatements(): Integer;
      getMaxTableNameLength(): Integer;
      getMaxTablesInSelect(): Integer;
      getMaxUserNameLength(): Integer;
      getNumericFunctions(): string;
      getPrimaryKeys(catalog: string, schema: string, table: string): JdbcResultSet;
      getProcedureColumns(catalog: string, schemaPattern: string, procedureNamePattern: string, columnNamePattern: string): JdbcResultSet;
      getProcedureTerm(): string;
      getProcedures(catalog: string, schemaPattern: string, procedureNamePattern: string): JdbcResultSet;
      getResultSetHoldability(): Integer;
      getRowIdLifetime(): Integer;
      getSQLKeywords(): string;
      getSQLStateType(): Integer;
      getSchemaTerm(): string;
      getSchemas(): JdbcResultSet;
      getSchemas(catalog: string, schemaPattern: string): JdbcResultSet;
      getSearchStringEscape(): string;
      getStringFunctions(): string;
      getSuperTables(catalog: string, schemaPattern: string, tableNamePattern: string): JdbcResultSet;
      getSuperTypes(catalog: string, schemaPattern: string, typeNamePattern: string): JdbcResultSet;
      getSystemFunctions(): string;
      getTablePrivileges(catalog: string, schemaPattern: string, tableNamePattern: string): JdbcResultSet;
      getTableTypes(): JdbcResultSet;
      getTables(catalog: string, schemaPattern: string, tableNamePattern: string, types: String[]): JdbcResultSet;
      getTimeDateFunctions(): string;
      getTypeInfo(): JdbcResultSet;
      getUDTs(catalog: string, schemaPattern: string, typeNamePattern: string, types: Integer[]): JdbcResultSet;
      getURL(): string;
      getUserName(): string;
      getVersionColumns(catalog: string, schema: string, table: string): JdbcResultSet;
      insertsAreDetected(type: Integer): boolean;
      isCatalogAtStart(): boolean;
      isReadOnly(): boolean;
      locatorsUpdateCopy(): boolean;
      nullPlusNonNullIsNull(): boolean;
      nullsAreSortedAtEnd(): boolean;
      nullsAreSortedAtStart(): boolean;
      nullsAreSortedHigh(): boolean;
      nullsAreSortedLow(): boolean;
      othersDeletesAreVisible(type: Integer): boolean;
      othersInsertsAreVisible(type: Integer): boolean;
      othersUpdatesAreVisible(type: Integer): boolean;
      ownDeletesAreVisible(type: Integer): boolean;
      ownInsertsAreVisible(type: Integer): boolean;
      ownUpdatesAreVisible(type: Integer): boolean;
      storesLowerCaseIdentifiers(): boolean;
      storesLowerCaseQuotedIdentifiers(): boolean;
      storesMixedCaseIdentifiers(): boolean;
      storesMixedCaseQuotedIdentifiers(): boolean;
      storesUpperCaseIdentifiers(): boolean;
      storesUpperCaseQuotedIdentifiers(): boolean;
      supportsANSI92EntryLevelSQL(): boolean;
      supportsANSI92FullSQL(): boolean;
      supportsANSI92IntermediateSQL(): boolean;
      supportsAlterTableWithAddColumn(): boolean;
      supportsAlterTableWithDropColumn(): boolean;
      supportsBatchUpdates(): boolean;
      supportsCatalogsInDataManipulation(): boolean;
      supportsCatalogsInIndexDefinitions(): boolean;
      supportsCatalogsInPrivilegeDefinitions(): boolean;
      supportsCatalogsInProcedureCalls(): boolean;
      supportsCatalogsInTableDefinitions(): boolean;
      supportsColumnAliasing(): boolean;
      supportsConvert(): boolean;
      supportsConvert(fromType: Integer, toType: Integer): boolean;
      supportsCoreSQLGrammar(): boolean;
      supportsCorrelatedSubqueries(): boolean;
      supportsDataDefinitionAndDataManipulationTransactions(): boolean;
      supportsDataManipulationTransactionsOnly(): boolean;
      supportsDifferentTableCorrelationNames(): boolean;
      supportsExpressionsInOrderBy(): boolean;
      supportsExtendedSQLGrammar(): boolean;
      supportsFullOuterJoins(): boolean;
      supportsGetGeneratedKeys(): boolean;
      supportsGroupBy(): boolean;
      supportsGroupByBeyondSelect(): boolean;
      supportsGroupByUnrelated(): boolean;
      supportsIntegrityEnhancementFacility(): boolean;
      supportsLikeEscapeClause(): boolean;
      supportsLimitedOuterJoins(): boolean;
      supportsMinimumSQLGrammar(): boolean;
      supportsMixedCaseIdentifiers(): boolean;
      supportsMixedCaseQuotedIdentifiers(): boolean;
      supportsMultipleOpenResults(): boolean;
      supportsMultipleResultSets(): boolean;
      supportsMultipleTransactions(): boolean;
      supportsNamedParameters(): boolean;
      supportsNonNullableColumns(): boolean;
      supportsOpenCursorsAcrossCommit(): boolean;
      supportsOpenCursorsAcrossRollback(): boolean;
      supportsOpenStatementsAcrossCommit(): boolean;
      supportsOpenStatementsAcrossRollback(): boolean;
      supportsOrderByUnrelated(): boolean;
      supportsOuterJoins(): boolean;
      supportsPositionedDelete(): boolean;
      supportsPositionedUpdate(): boolean;
      supportsResultSetConcurrency(type: Integer, concurrency: Integer): boolean;
      supportsResultSetHoldability(holdability: Integer): boolean;
      supportsResultSetType(type: Integer): boolean;
      supportsSavepoints(): boolean;
      supportsSchemasInDataManipulation(): boolean;
      supportsSchemasInIndexDefinitions(): boolean;
      supportsSchemasInPrivilegeDefinitions(): boolean;
      supportsSchemasInProcedureCalls(): boolean;
      supportsSchemasInTableDefinitions(): boolean;
      supportsSelectForUpdate(): boolean;
      supportsStatementPooling(): boolean;
      supportsStoredFunctionsUsingCallSyntax(): boolean;
      supportsStoredProcedures(): boolean;
      supportsSubqueriesInComparisons(): boolean;
      supportsSubqueriesInExists(): boolean;
      supportsSubqueriesInIns(): boolean;
      supportsSubqueriesInQuantifieds(): boolean;
      supportsTableCorrelationNames(): boolean;
      supportsTransactionIsolationLevel(level: Integer): boolean;
      supportsTransactions(): boolean;
      supportsUnion(): boolean;
      supportsUnionAll(): boolean;
      updatesAreDetected(type: Integer): boolean;
      usesLocalFilePerTable(): boolean;
      usesLocalFiles(): boolean;
    }

    /**
     * A JDBC Date. For documentation of this class, see java.sql.Date.
     */
    export interface JdbcDate {
      after(when: JdbcDate): boolean;
      before(when: JdbcDate): boolean;
      getDate(): Integer;
      getMonth(): Integer;
      getTime(): Integer;
      getYear(): Integer;
      setDate(date: Integer): void;
      setMonth(month: Integer): void;
      setTime(milliseconds: Integer): void;
      setYear(year: Integer): void;
    }

    /**
     * A JDBC ParameterMetaData. For documentation of this class, see
     *  java.sql.ParameterMetaData.
     */
    export interface JdbcParameterMetaData {
      getParameterClassName(param: Integer): string;
      getParameterCount(): Integer;
      getParameterMode(param: Integer): Integer;
      getParameterType(param: Integer): Integer;
      getParameterTypeName(param: Integer): string;
      getPrecision(param: Integer): Integer;
      getScale(param: Integer): Integer;
      isNullable(param: Integer): Integer;
      isSigned(param: Integer): boolean;
    }

    /**
     * A JDBC PreparedStatement. For documentation of this class, see
     *  java.sql.PreparedStatement.
     */
    export interface JdbcPreparedStatement {
      addBatch(): void;
      addBatch(sql: string): void;
      cancel(): void;
      clearBatch(): void;
      clearParameters(): void;
      clearWarnings(): void;
      close(): void;
      execute(): boolean;
      execute(sql: string): boolean;
      execute(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): boolean;
      execute(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): boolean;
      execute(sql: string, columnNames: String[]): boolean;
      executeBatch(): Integer[];
      executeQuery(): JdbcResultSet;
      executeQuery(sql: string): JdbcResultSet;
      executeUpdate(): Integer;
      executeUpdate(sql: string): Integer;
      executeUpdate(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): Integer;
      executeUpdate(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): Integer;
      executeUpdate(sql: string, columnNames: String[]): Integer;
      getConnection(): JdbcConnection;
      getFetchDirection(): Integer;
      getFetchSize(): Integer;
      getGeneratedKeys(): JdbcResultSet;
      getMaxFieldSize(): Integer;
      getMaxRows(): Integer;
      getMetaData(): JdbcResultSetMetaData;
      getMoreResults(): boolean;
      getMoreResults(current: Integer): boolean;
      getParameterMetaData(): JdbcParameterMetaData;
      getQueryTimeout(): Integer;
      getResultSet(): JdbcResultSet;
      getResultSetConcurrency(): Integer;
      getResultSetHoldability(): Integer;
      getResultSetType(): Integer;
      getUpdateCount(): Integer;
      getWarnings(): String[];
      isClosed(): boolean;
      isPoolable(): boolean;
      setArray(parameterIndex: Integer, x: JdbcArray): void;
      setBigDecimal(parameterIndex: Integer, x: BigNumber): void;
      setBlob(parameterIndex: Integer, x: JdbcBlob): void;
      setBoolean(parameterIndex: Integer, x: boolean): void;
      setByte(parameterIndex: Integer, x: Byte): void;
      setBytes(parameterIndex: Integer, x: Byte[]): void;
      setClob(parameterIndex: Integer, x: JdbcClob): void;
      setCursorName(name: string): void;
      setDate(parameterIndex: Integer, x: JdbcDate): void;
      setDate(parameterIndex: Integer, x: JdbcDate, timeZone: string): void;
      setDouble(parameterIndex: Integer, x: Number): void;
      setEscapeProcessing(enable: boolean): void;
      setFetchDirection(direction: Integer): void;
      setFetchSize(rows: Integer): void;
      setFloat(parameterIndex: Integer, x: Number): void;
      setInt(parameterIndex: Integer, x: Integer): void;
      setLong(parameterIndex: Integer, x: Integer): void;
      setMaxFieldSize(max: Integer): void;
      setMaxRows(max: Integer): void;
      setNClob(parameterIndex: Integer, x: JdbcClob): void;
      setNString(parameterIndex: Integer, x: string): void;
      setNull(parameterIndex: Integer, sqlType: Integer): void;
      setNull(parameterIndex: Integer, sqlType: Integer, typeName: string): void;
      setObject(index: Integer, x: Object): void;
      setObject(parameterIndex: Integer, x: Object, targetSqlType: Integer): void;
      setObject(parameterIndex: Integer, x: Object, targetSqlType: Integer, scaleOrLength: Integer): void;
      setPoolable(poolable: boolean): void;
      setQueryTimeout(seconds: Integer): void;
      setRef(parameterIndex: Integer, x: JdbcRef): void;
      setRowId(parameterIndex: Integer, x: JdbcRowId): void;
      setSQLXML(parameterIndex: Integer, x: JdbcSQLXML): void;
      setShort(parameterIndex: Integer, x: Integer): void;
      setString(parameterIndex: Integer, x: string): void;
      setTime(parameterIndex: Integer, x: JdbcTime): void;
      setTime(parameterIndex: Integer, x: JdbcTime, timeZone: string): void;
      setTimestamp(parameterIndex: Integer, x: JdbcTimestamp): void;
      setTimestamp(parameterIndex: Integer, x: JdbcTimestamp, timeZone: string): void;
      setURL(parameterIndex: Integer, x: string): void;
    }

    /**
     * A JDBC Ref. For documentation of this class, see java.sql.Ref.
     */
    export interface JdbcRef {
      getBaseTypeName(): string;
      getObject(): Object;
      setObject(object: Object): void;
    }

    /**
     * A JDBC ResultSet. For documentation of this class, see java.sql.ResultSet.
     */
    export interface JdbcResultSet {
      absolute(row: Integer): boolean;
      afterLast(): void;
      beforeFirst(): void;
      cancelRowUpdates(): void;
      clearWarnings(): void;
      close(): void;
      deleteRow(): void;
      findColumn(columnLabel: string): Integer;
      first(): boolean;
      getArray(columnIndex: Integer): JdbcArray;
      getArray(columnLabel: string): JdbcArray;
      getBigDecimal(columnIndex: Integer): BigNumber;
      getBigDecimal(columnLabel: string): BigNumber;
      getBlob(columnIndex: Integer): JdbcBlob;
      getBlob(columnLabel: string): JdbcBlob;
      getBoolean(columnIndex: Integer): boolean;
      getBoolean(columnLabel: string): boolean;
      getByte(columnIndex: Integer): Byte;
      getByte(columnLabel: string): Byte;
      getBytes(columnIndex: Integer): Byte[];
      getBytes(columnLabel: string): Byte[];
      getClob(columnIndex: Integer): JdbcClob;
      getClob(columnLabel: string): JdbcClob;
      getConcurrency(): Integer;
      getCursorName(): string;
      getDate(columnIndex: Integer): JdbcDate;
      getDate(columnIndex: Integer, timeZone: string): JdbcDate;
      getDate(columnLabel: string): JdbcDate;
      getDate(columnLabel: string, timeZone: string): JdbcDate;
      getDouble(columnIndex: Integer): Number;
      getDouble(columnLabel: string): Number;
      getFetchDirection(): Integer;
      getFetchSize(): Integer;
      getFloat(columnIndex: Integer): Number;
      getFloat(columnLabel: string): Number;
      getHoldability(): Integer;
      getInt(columnIndex: Integer): Integer;
      getInt(columnLabel: string): Integer;
      getLong(columnIndex: Integer): Integer;
      getLong(columnLabel: string): Integer;
      getMetaData(): JdbcResultSetMetaData;
      getNClob(columnIndex: Integer): JdbcClob;
      getNClob(columnLabel: string): JdbcClob;
      getNString(columnIndex: Integer): string;
      getNString(columnLabel: string): string;
      getObject(columnIndex: Integer): Object;
      getObject(columnLabel: string): Object;
      getRef(columnIndex: Integer): JdbcRef;
      getRef(columnLabel: string): JdbcRef;
      getRow(): Integer;
      getRowId(columnIndex: Integer): JdbcRowId;
      getRowId(columnLabel: string): JdbcRowId;
      getSQLXML(columnIndex: Integer): JdbcSQLXML;
      getSQLXML(columnLabel: string): JdbcSQLXML;
      getShort(columnIndex: Integer): Integer;
      getShort(columnLabel: string): Integer;
      getStatement(): JdbcStatement;
      getString(columnIndex: Integer): string;
      getString(columnLabel: string): string;
      getTime(columnIndex: Integer): JdbcTime;
      getTime(columnIndex: Integer, timeZone: string): JdbcTime;
      getTime(columnLabel: string): JdbcTime;
      getTime(columnLabel: string, timeZone: string): JdbcTime;
      getTimestamp(columnIndex: Integer): JdbcTimestamp;
      getTimestamp(columnIndex: Integer, timeZone: string): JdbcTimestamp;
      getTimestamp(columnLabel: string): JdbcTimestamp;
      getTimestamp(columnLabel: string, timeZone: string): JdbcTimestamp;
      getType(): Integer;
      getURL(columnIndex: Integer): string;
      getURL(columnLabel: string): string;
      getWarnings(): String[];
      insertRow(): void;
      isAfterLast(): boolean;
      isBeforeFirst(): boolean;
      isClosed(): boolean;
      isFirst(): boolean;
      isLast(): boolean;
      last(): boolean;
      moveToCurrentRow(): void;
      moveToInsertRow(): void;
      next(): boolean;
      previous(): boolean;
      refreshRow(): void;
      relative(rows: Integer): boolean;
      rowDeleted(): boolean;
      rowInserted(): boolean;
      rowUpdated(): boolean;
      setFetchDirection(direction: Integer): void;
      setFetchSize(rows: Integer): void;
      updateArray(columnIndex: Integer, x: JdbcArray): void;
      updateArray(columnLabel: string, x: JdbcArray): void;
      updateBigDecimal(columnIndex: Integer, x: BigNumber): void;
      updateBigDecimal(columnLabel: string, x: BigNumber): void;
      updateBlob(columnIndex: Integer, x: JdbcBlob): void;
      updateBlob(columnLabel: string, x: JdbcBlob): void;
      updateBoolean(columnIndex: Integer, x: boolean): void;
      updateBoolean(columnLabel: string, x: boolean): void;
      updateByte(columnIndex: Integer, x: Byte): void;
      updateByte(columnLabel: string, x: Byte): void;
      updateBytes(columnIndex: Integer, x: Byte[]): void;
      updateBytes(columnLabel: string, x: Byte[]): void;
      updateClob(columnIndex: Integer, x: JdbcClob): void;
      updateClob(columnLabel: string, x: JdbcClob): void;
      updateDate(columnIndex: Integer, x: JdbcDate): void;
      updateDate(columnLabel: string, x: JdbcDate): void;
      updateDouble(columnIndex: Integer, x: Number): void;
      updateDouble(columnLabel: string, x: Number): void;
      updateFloat(columnIndex: Integer, x: Number): void;
      updateFloat(columnLabel: string, x: Number): void;
      updateInt(columnIndex: Integer, x: Integer): void;
      updateInt(columnLabel: string, x: Integer): void;
      updateLong(columnIndex: Integer, x: Integer): void;
      updateLong(columnLabel: string, x: Integer): void;
      updateNClob(columnIndex: Integer, x: JdbcClob): void;
      updateNClob(columnLabel: string, x: JdbcClob): void;
      updateNString(columnIndex: Integer, x: string): void;
      updateNString(columnLabel: string, x: string): void;
      updateNull(columnIndex: Integer): void;
      updateNull(columnLabel: string): void;
      updateObject(columnIndex: Integer, x: Object): void;
      updateObject(columnIndex: Integer, x: Object, scaleOrLength: Integer): void;
      updateObject(columnLabel: string, x: Object): void;
      updateObject(columnLabel: string, x: Object, scaleOrLength: Integer): void;
      updateRef(columnIndex: Integer, x: JdbcRef): void;
      updateRef(columnLabel: string, x: JdbcRef): void;
      updateRow(): void;
      updateRowId(columnIndex: Integer, x: JdbcRowId): void;
      updateRowId(columnLabel: string, x: JdbcRowId): void;
      updateSQLXML(columnIndex: Integer, x: JdbcSQLXML): void;
      updateSQLXML(columnLabel: string, x: JdbcSQLXML): void;
      updateShort(columnIndex: Integer, x: Integer): void;
      updateShort(columnLabel: string, x: Integer): void;
      updateString(columnIndex: Integer, x: string): void;
      updateString(columnLabel: string, x: string): void;
      updateTime(columnIndex: Integer, x: JdbcTime): void;
      updateTime(columnLabel: string, x: JdbcTime): void;
      updateTimestamp(columnIndex: Integer, x: JdbcTimestamp): void;
      updateTimestamp(columnLabel: string, x: JdbcTimestamp): void;
      wasNull(): boolean;
    }

    /**
     * A JDBC ResultSetMetaData. For documentation of this class, see
     *  java.sql.ResultSetMetaData.
     */
    export interface JdbcResultSetMetaData {
      getCatalogName(column: Integer): string;
      getColumnClassName(column: Integer): string;
      getColumnCount(): Integer;
      getColumnDisplaySize(column: Integer): Integer;
      getColumnLabel(column: Integer): string;
      getColumnName(column: Integer): string;
      getColumnType(column: Integer): Integer;
      getColumnTypeName(column: Integer): string;
      getPrecision(column: Integer): Integer;
      getScale(column: Integer): Integer;
      getSchemaName(column: Integer): string;
      getTableName(column: Integer): string;
      isAutoIncrement(column: Integer): boolean;
      isCaseSensitive(column: Integer): boolean;
      isCurrency(column: Integer): boolean;
      isDefinitelyWritable(column: Integer): boolean;
      isNullable(column: Integer): Integer;
      isReadOnly(column: Integer): boolean;
      isSearchable(column: Integer): boolean;
      isSigned(column: Integer): boolean;
      isWritable(column: Integer): boolean;
    }

    /**
     * A JDBC RowId. For documentation of this class, see java.sql.RowId.
     */
    export interface JdbcRowId {
      getBytes(): Byte[];
    }

    /**
     * A JDBC SQLXML. For documentation of this class, see java.sql.SQLXML.
     */
    export interface JdbcSQLXML {
      free(): void;
      getString(): string;
      setString(value: string): void;
    }

    /**
     * A JDBC Savepoint. For documentation of this class, see java.sql.Savepoint.
     * See also
     *
     * Savepoint
     */
    export interface JdbcSavepoint {
      getSavepointId(): Integer;
      getSavepointName(): string;
    }

    /**
     * A JDBC Statement. For documentation of this class, see java.sql.Statement.
     */
    export interface JdbcStatement {
      addBatch(sql: string): void;
      cancel(): void;
      clearBatch(): void;
      clearWarnings(): void;
      close(): void;
      execute(sql: string): boolean;
      execute(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): boolean;
      execute(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): boolean;
      execute(sql: string, columnNames: String[]): boolean;
      executeBatch(): Integer[];
      executeQuery(sql: string): JdbcResultSet;
      executeUpdate(sql: string): Integer;
      executeUpdate(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): Integer;
      executeUpdate(sql: string, autoGeneratedKeys: Integer, sql_: string, columnIndexes: Integer[]): Integer;
      executeUpdate(sql: string, columnNames: String[]): Integer;
      getConnection(): JdbcConnection;
      getFetchDirection(): Integer;
      getFetchSize(): Integer;
      getGeneratedKeys(): JdbcResultSet;
      getMaxFieldSize(): Integer;
      getMaxRows(): Integer;
      getMoreResults(): boolean;
      getMoreResults(current: Integer): boolean;
      getQueryTimeout(): Integer;
      getResultSet(): JdbcResultSet;
      getResultSetConcurrency(): Integer;
      getResultSetHoldability(): Integer;
      getResultSetType(): Integer;
      getUpdateCount(): Integer;
      getWarnings(): String[];
      isClosed(): boolean;
      isPoolable(): boolean;
      setCursorName(name: string): void;
      setEscapeProcessing(enable: boolean): void;
      setFetchDirection(direction: Integer): void;
      setFetchSize(rows: Integer): void;
      setMaxFieldSize(max: Integer): void;
      setMaxRows(max: Integer): void;
      setPoolable(poolable: boolean): void;
      setQueryTimeout(seconds: Integer): void;
    }

    /**
     * A JDBC Struct. For documentation of this class, see java.sql.Struct.
     */
    export interface JdbcStruct {
      getAttributes(): Object[];
      getSQLTypeName(): string;
    }

    /**
     * A JDBC Time. For documentation of this class, see java.sql.Time.
     */
    export interface JdbcTime {
      after(when: JdbcTime): boolean;
      before(when: JdbcTime): boolean;
      getHours(): Integer;
      getMinutes(): Integer;
      getSeconds(): Integer;
      getTime(): Integer;
      setHours(hours: Integer): void;
      setMinutes(minutes: Integer): void;
      setSeconds(seconds: Integer): void;
      setTime(milliseconds: Integer): void;
    }

    /**
     * A JDBC Timestamp. For documentation of this class, see java.sql.Timestamp.
     */
    export interface JdbcTimestamp {
      after(when: JdbcTimestamp): boolean;
      before(when: JdbcTimestamp): boolean;
      getDate(): Integer;
      getHours(): Integer;
      getMinutes(): Integer;
      getMonth(): Integer;
      getNanos(): Integer;
      getSeconds(): Integer;
      getTime(): Integer;
      getYear(): Integer;
      setDate(date: Integer): void;
      setHours(hours: Integer): void;
      setMinutes(minutes: Integer): void;
      setMonth(month: Integer): void;
      setNanos(nanoseconds: Integer): void;
      setSeconds(seconds: Integer): void;
      setTime(milliseconds: Integer): void;
      setYear(year: Integer): void;
    }

  }
}

declare var Jdbc: GoogleAppsScript.JDBC.Jdbc;