JDBC Service

  • The Apps Script JDBC service allows connecting to various JDBC-compliant databases like Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle.

  • The Jdbc class is the primary entry point for establishing database connections and creating date/time objects.

  • The service provides numerous classes representing JDBC concepts, such as JdbcConnection, JdbcStatement, JdbcResultSet, and metadata classes, mirroring methods from the java.sql package.

  • These classes offer comprehensive methods for managing connections, executing queries and updates, handling different data types (including large objects and XML), retrieving result set information, and obtaining database metadata.

This service allows scripts to connect to JDBC-compliant databases, including Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle. See also the guide to JDBC.

Classes

JdbcArray

Methods

MethodReturn typeBrief description
free()voidFor documentation of this method, see java.sql.Array#free().
getArray()ObjectFor documentation of this method, see java.sql.Array#getArray()
getArray(index, count)ObjectFor documentation of this method, see java.sql.Array#getArray(long, int).
getBaseType()IntegerFor documentation of this method, see java.sql.Array#getBaseType().
getBaseTypeName()StringFor documentation of this method, see java.sql.Array#getBaseTypeName().
getResultSet()JdbcResultSetFor documentation of this method, see java.sql.Array#getResultSet().
getResultSet(index, count)JdbcResultSetFor documentation of this method, see java.sql.Array#getResultSet(long, int).

JdbcBlob

Methods

MethodReturn typeBrief description
free()voidFor documentation of this method, see java.sql.Blob#free().
getAppsScriptBlob()BlobGets the content of this JdbcBlob as an Apps Script blob.
getAs(contentType)BlobReturn the data inside this object as a blob converted to the specified content type.
getBytes(position, length)Byte[]For documentation of this method, see java.sql.Blob#getBytes(long, int).
length()IntegerFor documentation of this method, see java.sql.Blob#length().
position(pattern, start)IntegerFor documentation of this method, see java.sql.Blob#position(byte[], long).
position(pattern, start)IntegerFor documentation of this method, see java.sql.Blob#position(blob, long).
setBytes(position, blobSource)IntegerConvenience method for writing a JdbcBlob to this blob.
setBytes(position, blobSource, offset, length)IntegerConvenience method for writing a JdbcBlob to this blob.
setBytes(position, bytes)IntegerFor documentation of this method, see java.sql.Blob#setBytes(long, byte[]).
setBytes(position, bytes, offset, length)IntegerFor documentation of this method, see java.sql.Blob#setBytes(long, byte[], int, int).
truncate(length)voidFor documentation of this method, see java.sql.Blob#truncate(long).

JdbcCallableStatement

Methods

MethodReturn typeBrief description
addBatch()voidFor documentation of this method, see java.sql.PreparedStatement#addBatch().
addBatch(sql)voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel()voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch()voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearParameters()voidFor documentation of this method, see java.sql.PreparedStatement#clearParameters().
clearWarnings()voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close()voidFor documentation of this method, see java.sql.Statement#close().
execute()BooleanFor documentation of this method, see java.sql.PreparedStatement#execute().
execute(sql)BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames)BooleanFor documentation of this method, see java.sql.Statement#execute(String, String[]).
executeBatch()Integer[]For documentation of this method, see java.sql.Statement#executeBatch().
executeBatch(parameters)Integer[]Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeQuery()JdbcResultSetFor documentation of this method, see java.sql.PreparedStatement#executeQuery().
executeQuery(sql)JdbcResultSetFor documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate()IntegerFor documentation of this method, see java.sql.PreparedStatement#executeUpdate().
executeUpdate(sql)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int[]).
executeUpdate(sql, columnNames)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getArray(parameterIndex)JdbcArrayFor documentation of this method, see java.sql.CallableStatement#getArray(int).
getArray(parameterName)JdbcArrayFor documentation of this method, see java.sql.CallableStatement#getArray(String).
getBigDecimal(parameterIndex)BigNumberFor documentation of this method, see java.sql.CallableStatement#getBigDecimal(int).
getBigDecimal(parameterName)BigNumberFor documentation of this method, see java.sql.CallableStatement#getBigDecimal(String).
getBlob(parameterIndex)JdbcBlobFor documentation of this method, see java.sql.CallableStatement#getBlob(int).
getBlob(parameterName)JdbcBlobFor documentation of this method, see java.sql.CallableStatement#getBlob(String).
getBoolean(parameterIndex)BooleanFor documentation of this method, see java.sql.CallableStatement#getBoolean(int).
getBoolean(parameterName)BooleanFor documentation of this method, see java.sql.CallableStatement#getBoolean(String).
getByte(parameterIndex)ByteFor documentation of this method, see java.sql.CallableStatement#getByte(int).
getByte(parameterName)ByteFor documentation of this method, see java.sql.CallableStatement#getByte(String).
getBytes(parameterIndex)Byte[]For documentation of this method, see java.sql.CallableStatement#getBytes(int).
getBytes(parameterName)Byte[]For documentation of this method, see java.sql.CallableStatement#getBytes(String).
getClob(parameterIndex)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getClob(int).
getClob(parameterName)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getClob(String).
getConnection()JdbcConnectionFor documentation of this method, see java.sql.Statement#getConnection().
getDate(parameterIndex)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(int).
getDate(parameterIndex, timeZone)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(int, Calendar).
getDate(parameterName)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(String).
getDate(parameterName, timeZone)JdbcDateFor documentation of this method, see java.sql.CallableStatement#getDate(String, Calendar).
getDouble(parameterIndex)NumberFor documentation of this method, see java.sql.CallableStatement#getDouble(int).
getDouble(parameterName)NumberFor documentation of this method, see java.sql.CallableStatement#getDouble(String).
getFetchDirection()IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize()IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getFloat(parameterIndex)NumberFor documentation of this method, see java.sql.CallableStatement#getFloat(int).
getFloat(parameterName)NumberFor documentation of this method, see java.sql.CallableStatement#getFloat(String).
getGeneratedKeys()JdbcResultSetFor documentation of this method, see java.sql.Statement#getGeneratedKeys().
getInt(parameterIndex)IntegerFor documentation of this method, see java.sql.CallableStatement#getInt(int).
getInt(parameterName)IntegerFor documentation of this method, see java.sql.CallableStatement#getInt(String).
getLong(parameterIndex)IntegerFor documentation of this method, see java.sql.CallableStatement#getLong(int).
getLong(parameterName)IntegerFor documentation of this method, see java.sql.CallableStatement#getLong(String).
getMaxFieldSize()IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows()IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMetaData()JdbcResultSetMetaDataFor documentation of this method, see java.sql.PreparedStatement#getMetaData().
getMoreResults()BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current)BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getNClob(parameterIndex)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getNClob(int).
getNClob(parameterName)JdbcClobFor documentation of this method, see java.sql.CallableStatement#getNClob(String).
getNString(parameterIndex)StringFor documentation of this method, see java.sql.CallableStatement#getNString(int).
getNString(parameterName)StringFor documentation of this method, see java.sql.CallableStatement#getNString(String).
getObject(parameterIndex)ObjectFor documentation of this method, see java.sql.CallableStatement#getObject(int).
getObject(parameterName)ObjectFor documentation of this method, see java.sql.CallableStatement#getObject(String).
getParameterMetaData()JdbcParameterMetaDataFor documentation of this method, see java.sql.PreparedStatement#getParameterMetaData().
getQueryTimeout()IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getRef(parameterIndex)JdbcRefFor documentation of this method, see java.sql.CallableStatement#getRef(int).
getRef(parameterName)JdbcRefFor documentation of this method, see java.sql.CallableStatement#getRef(String).
getResultSet()JdbcResultSetFor documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency()IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability()IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType()IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getRowId(parameterIndex)JdbcRowIdFor documentation of this method, see java.sql.CallableStatement#getRowId(int).
getRowId(parameterName)JdbcRowIdFor documentation of this method, see java.sql.CallableStatement#getRowId(String).
getSQLXML(parameterIndex)JdbcSQLXMLFor documentation of this method, see java.sql.CallableStatement#getSQLXML(int).
getSQLXML(parameterName)JdbcSQLXMLFor documentation of this method, see java.sql.CallableStatement#getSQLXML(String).
getShort(parameterIndex)IntegerFor documentation of this method, see java.sql.CallableStatement#getShort(int).
getShort(parameterName)IntegerFor documentation of this method, see java.sql.CallableStatement#getShort(String).
getString(parameterIndex)StringFor documentation of this method, see java.sql.CallableStatement#getString(int).
getString(parameterName)StringFor documentation of this method, see java.sql.CallableStatement#getString(String).
getTime(parameterIndex)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(int).
getTime(parameterIndex, timeZone)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(int, Calendar).
getTime(parameterName)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(String).
getTime(parameterName, timeZone)JdbcTimeFor documentation of this method, see java.sql.CallableStatement#getTime(String, Calendar).
getTimestamp(parameterIndex)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(int).
getTimestamp(parameterIndex, timeZone)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(int, Calendar).
getTimestamp(parameterName)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(String).
getTimestamp(parameterName, timeZone)JdbcTimestampFor documentation of this method, see java.sql.CallableStatement#getTimestamp(String, Calendar).
getURL(parameterIndex)StringFor documentation of this method, see java.sql.CallableStatement#getURL(int).
getURL(parameterName)StringFor documentation of this method, see java.sql.CallableStatement#getURL(String).
getUpdateCount()IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings()String[]For documentation of this method, see java.sql.Statement#getWarnings().
isClosed()BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable()BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
registerOutParameter(parameterIndex, sqlType)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int).
registerOutParameter(parameterIndex, sqlType, scale)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, int).
registerOutParameter(parameterIndex, sqlType, typeName)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, String).
registerOutParameter(parameterName, sqlType)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int).
registerOutParameter(parameterName, sqlType, scale)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, int).
registerOutParameter(parameterName, sqlType, typeName)voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, String).
setArray(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setArray(int, Array).
setBigDecimal(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal).
setBigDecimal(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBigDecimal(String, BigDecimal).
setBlob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob).
setBlob(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBlob(String, Blob).
setBoolean(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).
setBoolean(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBoolean(String, boolean).
setByte(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).
setByte(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setByte(String, byte).
setBytes(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).
setBytes(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBytes(String, byte[]).
setClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob).
setClob(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setBlob(String, Clob).
setCursorName(name)voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setDate(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date).
setDate(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar).
setDate(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setDate(String, Date).
setDate(parameterName, x, timeZone)voidFor documentation of this method, see java.sql.CallableStatement#setDate(String, Date, Calendar).
setDouble(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).
setDouble(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setDouble(String, double).
setEscapeProcessing(enable)voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction)voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows)voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setFloat(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).
setFloat(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setFloat(String, float).
setInt(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setInt(int, int).
setInt(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setInt(String, int).
setLong(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setLong(int, long).
setLong(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setLong(String, long).
setMaxFieldSize(max)voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max)voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setNClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob).
setNClob(parameterName, value)voidFor documentation of this method, see java.sql.CallableStatement#setNClob(String, NClob).
setNString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNString(int, String).
setNString(parameterName, value)voidFor documentation of this method, see java.sql.CallableStatement#setNString(String, String).
setNull(parameterIndex, sqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int).
setNull(parameterIndex, sqlType, typeName)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).
setNull(parameterName, sqlType)voidFor documentation of this method, see java.sql.CallableStatement#setNull(String, int).
setNull(parameterName, sqlType, typeName)voidFor documentation of this method, see java.sql.CallableStatement#setNull(String, int, String).
setObject(index, x)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).
setObject(parameterIndex, x, targetSqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).
setObject(parameterIndex, x, targetSqlType, scaleOrLength)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int).
setObject(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object).
setObject(parameterName, x, targetSqlType)voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int).
setObject(parameterName, x, targetSqlType, scale)voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int, int).
setPoolable(poolable)voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds)voidFor documentation of this method, see java.sql.Statement#setQueryTimeout(int).
setRef(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref).
setRowId(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId).
setRowId(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setRowId(String, RowId).
setSQLXML(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML).
setSQLXML(parameterName, xmlObject)voidFor documentation of this method, see java.sql.CallableStatement#setSQLXML(String, SQLXML).
setShort(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setShort(int, short).
setShort(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setShort(String, short).
setString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setString(int, String).
setString(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setString(String, String).
setTime(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time).
setTime(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar).
setTime(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setTime(String, Time).
setTime(parameterName, x, timeZone)voidFor documentation of this method, see java.sql.CallableStatement#setTime(String, Time, Calendar).
setTimestamp(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp).
setTimestamp(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar).
setTimestamp(parameterName, x)voidFor documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp).
setTimestamp(parameterName, x, timeZone)voidFor documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp, Calendar).
setURL(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setURL(int, URL).
setURL(parameterName, val)voidFor documentation of this method, see java.sql.CallableStatement#setURL(String, URL).
wasNull()BooleanFor documentation of this method, see java.sql.CallableStatement#wasNull().

JdbcClob

Methods

MethodReturn typeBrief description
free()voidFor documentation of this method, see java.sql.Clob#truncate(long).
getAppsScriptBlob()BlobGets the content of this JdbcClob as an Apps Script blob.
getAs(contentType)BlobReturn the data inside this object as a blob converted to the specified content type.
getSubString(position, length)StringFor documentation of this method, see java.sql.Clob#getSubString(long, int).
length()IntegerFor documentation of this method, see java.sql.Clob#length().
position(search, start)IntegerFor documentation of this method, see java.sql.Clob#position(Clob, long).
position(search, start)IntegerFor documentation of this method, see java.sql.Clob#position(String, long).
setString(position, blobSource)IntegerConvenience method for writing a JdbcClob to a clob.
setString(position, blobSource, offset, len)IntegerConvenience method for writing a JdbcClob to a clob.
setString(position, value)IntegerFor documentation of this method, see java.sql.Clob#setString(long, String).
setString(position, value, offset, len)IntegerFor documentation of this method, see java.sql.Clob#setString(long, String, int, int).
truncate(length)voidFor documentation of this method, see java.sql.Clob#truncate(long).

JdbcConnection

Methods

MethodReturn typeBrief description
clearWarnings()voidFor documentation of this method, see java.sql.Connection#clearWarnings().
close()voidRelease this connection's database and all associated resources.
commit()voidMakes all pending changes permanent, releases database locks held by this JdbcConnection.
createArrayOf(typeName, elements)JdbcArrayFor documentation of this method, see java.sql.Connection#createArrayOf(String, Object[]).
createBlob()JdbcBlobConstructs a JdbcBlob instance.
createClob()JdbcClobFor documentation of this method, see java.sql.Connection#createClob().
createNClob()JdbcClobFor documentation of this method, see java.sql.Connection#createNClob().
createSQLXML()JdbcSQLXMLFor documentation of this method, see java.sql.Connection#createSQLXML().
createStatement()JdbcStatementCreates a JdbcStatement object for sending SQL statements to the database.
createStatement(resultSetType, resultSetConcurrency)JdbcStatementCreates a JdbcStatement object for sending SQL statements to the database.
createStatement(resultSetType, resultSetConcurrency, resultSetHoldability)JdbcStatementCreates a JdbcStatement object for sending SQL statements to the database.
createStruct(typeName, attributes)JdbcStructFor documentation of this method, see java.sql.Connection#createStruct(String, Object[]).
getAutoCommit()BooleanFor documentation of this method, see java.sql.Connection#getAutoCommit().
getCatalog()Stringor documentation of this method, see java.sql.Connection#getCatalog().
getHoldability()IntegerFor documentation of this method, see java.sql.Connection#getHoldability().
getMetaData()JdbcDatabaseMetaDataFor documentation of this method, see java.sql.Connection#getMetaData().
getTransactionIsolation()IntegerFor documentation of this method, see java.sql.Connection#getTransactionIsolation().
getWarnings()String[]For documentation of this method, see java.sql.Connection#getWarnings().
isClosed()BooleanFor documentation of this method, see java.sql.Connection#isClosed().
isReadOnly()BooleanFor documentation of this method, see java.sql.Connection#isReadOnly().
isValid(timeout)BooleanFor documentation of this method, see java.sql.Connection#isValid(int).
nativeSQL(sql)StringFor documentation of this method, see java.sql.Connection#nativeSQL(String).
prepareCall(sql)JdbcCallableStatementFor documentation of this method, see java.sql.Connection#prepareCall(String).
prepareCall(sql, resultSetType, resultSetConcurrency)JdbcCallableStatementFor documentation of this method, see java.sql.Connection#prepareCall(String, int, int).
prepareCall(sql, resultSetType, resultSetConcurrency, resultSetHoldability)JdbcCallableStatementFor documentation of this method, see java.sql.Connection#prepareCall(String, int, int, int).
prepareStatement(sql)JdbcPreparedStatementFor documentation of this method, see java.sql.Connection#prepareStatement(String).
prepareStatement(sql, autoGeneratedKeys)JdbcPreparedStatementFor documentation of this method, see java.sql.Connection#prepareStatement(String, int).
prepareStatement(sql, resultSetType, resultSetConcurrency)JdbcPreparedStatementFor documentation of this method, see java.sql.Connection#prepareStatement(String, int, int).
prepareStatement(sql, resultSetType, resultSetConcurrency, resultSetHoldability)JdbcPreparedStatementFor documentation of this method, see java.sql.Connection#prepareStatement(String, int, int, int).
prepareStatementByIndex(sql, indices)JdbcPreparedStatementFor documentation of this method, see java.sql.Connection#prepareStatement(String, int[]).
prepareStatementByName(sql, columnNames)JdbcPreparedStatementFor documentation of this method, see java.sql.Connection#prepareStatement(String, String[]).
releaseSavepoint(savepoint)voidFor documentation of this method, see java.sql.Connection#releaseSavepoint(Savepoint).
rollback()voidFor documentation of this method, see java.sql.Connection#rollback().
rollback(savepoint)voidFor documentation of this method, see java.sql.Connection#rollback(Savepoint).
setAutoCommit(autoCommit)voidFor documentation of this method, see java.sql.Connection#setAutoCommit(boolean).
setCatalog(catalog)voidFor documentation of this method, see java.sql.Connection#setCatalog(String).
setHoldability(holdability)voidFor documentation of this method, see java.sql.Connection#setHoldability(int).
setReadOnly(readOnly)voidFor documentation of this method, see java.sql.Connection#setReadOnly(boolean).
setSavepoint()JdbcSavepointFor documentation of this method, see java.sql.Connection#setSavepoint().
setSavepoint(name)JdbcSavepointFor documentation of this method, see java.sql.Connection#setSavepoint(String).
setTransactionIsolation(level)voidFor documentation of this method, see java.sql.Connection#setTransactionIsolation(int).

Methods

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

JdbcDate

Methods

MethodReturn typeBrief description
after(when)BooleanFor documentation of this method, see java.sql.Date#after(date).
before(when)BooleanFor documentation of this method, see java.sql.Date#before(date).
getDate()IntegerFor documentation of this method, see java.sql.Date#getDate().
getMonth()IntegerFor documentation of this method, see java.sql.Date#getMonth().
getTime()IntegerFor documentation of this method, see java.sql.Date#getTime().
getYear()IntegerFor documentation of this method, see java.sql.Date#getYear().
setDate(date)voidFor documentation of this method, see java.sql.Date#setDate(int).
setMonth(month)voidFor documentation of this method, see java.sql.Date#setMonth(int).
setTime(milliseconds)voidFor documentation of this method, see java.sql.Date#setTime(int).
setYear(year)voidFor documentation of this method, see java.sql.Date#setYear(int).

JdbcPreparedStatement

Methods

MethodReturn typeBrief description
addBatch()voidFor documentation of this method, see java.sql.PreparedStatement#addBatch().
addBatch(sql)voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel()voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch()voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearParameters()voidFor documentation of this method, see java.sql.PreparedStatement#clearParameters().
clearWarnings()voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close()voidFor documentation of this method, see java.sql.Statement#close().
execute()BooleanFor documentation of this method, see java.sql.PreparedStatement#execute().
execute(sql)BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames)BooleanFor documentation of this method, see java.sql.Statement#execute(String, String[]).
executeBatch()Integer[]For documentation of this method, see java.sql.Statement#executeBatch().
executeBatch(parameters)Integer[]Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeQuery()JdbcResultSetFor documentation of this method, see java.sql.PreparedStatement#executeQuery().
executeQuery(sql)JdbcResultSetFor documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate()IntegerFor documentation of this method, see java.sql.PreparedStatement#executeUpdate().
executeUpdate(sql)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int[]).
executeUpdate(sql, columnNames)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getConnection()JdbcConnectionFor documentation of this method, see java.sql.Statement#getConnection().
getFetchDirection()IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize()IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getGeneratedKeys()JdbcResultSetFor documentation of this method, see java.sql.Statement#getGeneratedKeys().
getMaxFieldSize()IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows()IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMetaData()JdbcResultSetMetaDataFor documentation of this method, see java.sql.PreparedStatement#getMetaData().
getMoreResults()BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current)BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getParameterMetaData()JdbcParameterMetaDataFor documentation of this method, see java.sql.PreparedStatement#getParameterMetaData().
getQueryTimeout()IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getResultSet()JdbcResultSetFor documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency()IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability()IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType()IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getUpdateCount()IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings()String[]For documentation of this method, see java.sql.Statement#getWarnings().
isClosed()BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable()BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
setArray(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setArray(int, Array).
setBigDecimal(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal).
setBlob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob).
setBoolean(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).
setByte(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).
setBytes(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).
setClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob).
setCursorName(name)voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setDate(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date).
setDate(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar).
setDouble(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).
setEscapeProcessing(enable)voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction)voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows)voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setFloat(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).
setInt(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setInt(int, int).
setLong(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setLong(int, long).
setMaxFieldSize(max)voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max)voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setNClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob).
setNString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNString(int, String).
setNull(parameterIndex, sqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int).
setNull(parameterIndex, sqlType, typeName)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).
setObject(index, x)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).
setObject(parameterIndex, x, targetSqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).
setObject(parameterIndex, x, targetSqlType, scaleOrLength)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int).
setPoolable(poolable)voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds)voidFor documentation of this method, see java.sql.Statement#setQueryTimeout(int).
setRef(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref).
setRowId(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId).
setSQLXML(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML).
setShort(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setShort(int, short).
setString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setString(int, String).
setTime(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time).
setTime(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar).
setTimestamp(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp).
setTimestamp(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar).
setURL(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setURL(int, URL).

JdbcRef

JdbcResultSet

Methods

MethodReturn typeBrief description
absolute(row)BooleanFor documentation of this method, see java.sql.ResultSet#absolute(int).
afterLast()voidFor documentation of this method, see java.sql.ResultSet#afterLast().
beforeFirst()voidFor documentation of this method, see java.sql.ResultSet#beforeFirst().
cancelRowUpdates()voidFor documentation of this method, see java.sql.ResultSet#cancelRowUpdates().
clearWarnings()voidFor documentation of this method, see java.sql.ResultSet#clearWarnings().
close()voidFor documentation of this method, see java.sql.ResultSet#close().
deleteRow()voidFor documentation of this method, see java.sql.ResultSet#deleteRow().
findColumn(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#findColumn(String).
first()BooleanFor documentation of this method, see java.sql.ResultSet#first().
getArray(columnIndex)JdbcArrayFor documentation of this method, see java.sql.ResultSet#getArray(int).
getArray(columnLabel)JdbcArrayFor documentation of this method, see java.sql.ResultSet#getArray(String).
getBigDecimal(columnIndex)BigNumberFor documentation of this method, see java.sql.ResultSet#getBigDecimal(int).
getBigDecimal(columnLabel)BigNumberFor documentation of this method, see java.sql.ResultSet#getBigDecimal(String).
getBlob(columnIndex)JdbcBlobFor documentation of this method, see java.sql.ResultSet#getBlob(int).
getBlob(columnLabel)JdbcBlobFor documentation of this method, see java.sql.ResultSet#getBlob(String).
getBoolean(columnIndex)BooleanFor documentation of this method, see java.sql.ResultSet#getBoolean(int).
getBoolean(columnLabel)BooleanFor documentation of this method, see java.sql.ResultSet#getBoolean(String).
getByte(columnIndex)ByteFor documentation of this method, see java.sql.ResultSet#getByte(int).
getByte(columnLabel)ByteFor documentation of this method, see java.sql.ResultSet#getByte(String).
getBytes(columnIndex)Byte[]For documentation of this method, see java.sql.ResultSet#getBytes(int).
getBytes(columnLabel)Byte[]For documentation of this method, see java.sql.ResultSet#getBytes(String).
getClob(columnIndex)JdbcClobFor documentation of this method, see java.sql.ResultSet#getClob(int).
getClob(columnLabel)JdbcClobFor documentation of this method, see java.sql.ResultSet#getClob(String).
getConcurrency()IntegerFor documentation of this method, see java.sql.ResultSet#getConcurrency().
getCursorName()StringFor documentation of this method, see java.sql.ResultSet#getCursorName().
getDate(columnIndex)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(int).
getDate(columnIndex, timeZone)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(int, Calendar).
getDate(columnLabel)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(String).
getDate(columnLabel, timeZone)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(String, Calendar).
getDouble(columnIndex)NumberFor documentation of this method, see java.sql.ResultSet#getDouble(int).
getDouble(columnLabel)NumberFor documentation of this method, see java.sql.ResultSet#getDouble(String).
getFetchDirection()IntegerFor documentation of this method, see java.sql.ResultSet#getFetchDirection().
getFetchSize()IntegerFor documentation of this method, see java.sql.ResultSet#getFetchSize().
getFloat(columnIndex)NumberFor documentation of this method, see java.sql.ResultSet#getFloat(int).
getFloat(columnLabel)NumberFor documentation of this method, see java.sql.ResultSet#getFloat(String).
getHoldability()IntegerFor documentation of this method, see java.sql.ResultSet#getHoldability().
getInt(columnIndex)IntegerFor documentation of this method, see java.sql.ResultSet#getInt(int).
getInt(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#getInt(String).
getLong(columnIndex)IntegerFor documentation of this method, see java.sql.ResultSet#getLong(int).
getLong(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#getLong(String).
getMetaData()JdbcResultSetMetaDataFor documentation of this method, see java.sql.ResultSet#getMetaData().
getNClob(columnIndex)JdbcClobFor documentation of this method, see java.sql.ResultSet#getNClob(int).
getNClob(columnLabel)JdbcClobFor documentation of this method, see java.sql.ResultSet#getNClob(String).
getNString(columnIndex)StringFor documentation of this method, see java.sql.ResultSet#getNString(int).
getNString(columnLabel)StringFor documentation of this method, see java.sql.ResultSet#getNString(String).
getObject(columnIndex)ObjectFor documentation of this method, see java.sql.ResultSet#getObject(int).
getObject(columnLabel)ObjectFor documentation of this method, see java.sql.ResultSet#getObject(String).
getRef(columnIndex)JdbcRefFor documentation of this method, see java.sql.ResultSet#getRef(int).
getRef(columnLabel)JdbcRefFor documentation of this method, see java.sql.ResultSet#getRef(String).
getRow()IntegerFor documentation of this method, see java.sql.ResultSet#getRow().
getRowId(columnIndex)JdbcRowIdFor documentation of this method, see java.sql.ResultSet#getRowId(int).
getRowId(columnLabel)JdbcRowIdFor documentation of this method, see java.sql.ResultSet#getRowId(String).
getRows(queryString)Object[][]Returns all the rows from this ResultSet object.
getRows(queryString, batchSize)Object[][]Returns up to batchSize rows from this ResultSet object.
getSQLXML(columnIndex)JdbcSQLXMLFor documentation of this method, see java.sql.ResultSet#getSQLXML(int).
getSQLXML(columnLabel)JdbcSQLXMLFor documentation of this method, see java.sql.ResultSet#getSQLXML(String).
getShort(columnIndex)IntegerFor documentation of this method, see java.sql.ResultSet#getShort(int).
getShort(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#getShort(String).
getStatement()JdbcStatementFor documentation of this method, see java.sql.ResultSet#getStatement().
getString(columnIndex)StringFor documentation of this method, see java.sql.ResultSet#getString(int).
getString(columnLabel)StringFor documentation of this method, see java.sql.ResultSet#getString(String).
getTime(columnIndex)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(int).
getTime(columnIndex, timeZone)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(int, Calendar).
getTime(columnLabel)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(String).
getTime(columnLabel, timeZone)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(String, Calendar).
getTimestamp(columnIndex)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(int).
getTimestamp(columnIndex, timeZone)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(int, Calendar).
getTimestamp(columnLabel)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(String).
getTimestamp(columnLabel, timeZone)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(String, Calendar).
getType()IntegerFor documentation of this method, see java.sql.ResultSet#getType().
getURL(columnIndex)StringFor documentation of this method, see java.sql.ResultSet#getURL(int).
getURL(columnLabel)StringFor documentation of this method, see java.sql.ResultSet#getURL(String).
getWarnings()String[]Returns the current set of warnings reported by the driver.
insertRow()voidFor documentation of this method, see java.sql.ResultSet#insertRow().
isAfterLast()BooleanFor documentation of this method, see java.sql.ResultSet#isAfterLast().
isBeforeFirst()BooleanFor documentation of this method, see java.sql.ResultSet#isBeforeFirst().
isClosed()BooleanFor documentation of this method, see java.sql.ResultSet#isClosed().
isFirst()BooleanFor documentation of this method, see java.sql.ResultSet#isFirst().
isLast()BooleanFor documentation of this method, see java.sql.ResultSet#isLast().
last()BooleanFor documentation of this method, see java.sql.ResultSet#first().
moveToCurrentRow()voidFor documentation of this method, see java.sql.ResultSet#moveToCurrentRow().
moveToInsertRow()voidFor documentation of this method, see java.sql.ResultSet#moveToInsertRow().
next()BooleanFor documentation of this method, see java.sql.ResultSet#next().
previous()BooleanFor documentation of this method, see java.sql.ResultSet#previous().
refreshRow()voidFor documentation of this method, see java.sql.ResultSet#refreshRow().
relative(rows)BooleanFor documentation of this method, see java.sql.ResultSet#relative(int).
rowDeleted()BooleanFor documentation of this method, see java.sql.ResultSet#rowDeleted().
rowInserted()BooleanFor documentation of this method, see java.sql.ResultSet#rowInserted().
rowUpdated()BooleanFor documentation of this method, see java.sql.ResultSet#rowUpdated().
setFetchDirection(direction)voidFor documentation of this method, see java.sql.ResultSet#setFetchDirection(int).
setFetchSize(rows)voidFor documentation of this method, see java.sql.ResultSet#setFetchSize(int).
updateArray(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateArray(int, Array).
updateArray(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateArray(String, Array).
updateBigDecimal(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBigDecimal(int, BigDecimal).
updateBigDecimal(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateBigDecimal(String, BigDecimal).
updateBlob(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBlob(int, Blob).
updateBlob(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateRef(String, Blob).
updateBoolean(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBoolean(int, boolean).
updateBoolean(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateBoolean(String, boolean).
updateByte(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateByte(int, byte).
updateByte(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateByte(String, byte).
updateBytes(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBytes(int, byte[]).
updateBytes(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateBytes(String, byte[]).
updateClob(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateClob(int, Clob).
updateClob(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateClob(String, Clob).
updateDate(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateDate(int, Date).
updateDate(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateDate(String, Date).
updateDouble(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateDouble(int, double).
updateDouble(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateDouble(String, double).
updateFloat(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateFloat(int, float).
updateFloat(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateFloat(String, float).
updateInt(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateInt(int, int).
updateInt(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateInt(String, int).
updateLong(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateLong(int, long).
updateLong(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateLong(String, long).
updateNClob(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateNClob(int, NClob).
updateNClob(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateNClob(String, NClob).
updateNString(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateNString(int, String).
updateNString(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateNString(String, String).
updateNull(columnIndex)voidFor documentation of this method, see java.sql.ResultSet#updateNull(int).
updateNull(columnLabel)voidFor documentation of this method, see java.sql.ResultSet#updateNull(String).
updateObject(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateObject(int, Object).
updateObject(columnIndex, x, scaleOrLength)voidFor documentation of this method, see java.sql.ResultSet#updateObject(int, Object, int).
updateObject(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateObject(String, Object).
updateObject(columnLabel, x, scaleOrLength)voidFor documentation of this method, see java.sql.ResultSet#updateObject(String, Object, int).
updateRef(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateRef(int, Ref).
updateRef(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateRef(String, Ref).
updateRow()voidFor documentation of this method, see java.sql.ResultSet#updateRow().
updateRowId(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateRowId(int, RowId).
updateRowId(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateRowId(String, RowId).
updateSQLXML(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateSQLXML(int, SQLXML).
updateSQLXML(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateSQLXML(String, SQLXML).
updateShort(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateShort(int, short).
updateShort(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateShort(String, short).
updateString(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateString(int, String).
updateString(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateString(String, String).
updateTime(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateTime(int, Time).
updateTime(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateTime(String, Time).
updateTimestamp(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateTimestamp(int, Timestamp).
updateTimestamp(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateTimestamp(String, Timestamp).
wasNull()BooleanFor documentation of this method, see java.sql.ResultSet#wasNull().

Methods

MethodReturn typeBrief description
getCatalogName(column)StringFor documentation of this method, see java.sql.ResultSetMetaData#getCatalogName(int).
getColumnClassName(column)StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnClassName(int).
getColumnCount()IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getColumnCount().
getColumnDisplaySize(column)IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getColumnDisplaySize(int).
getColumnLabel(column)StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnLabel(int).
getColumnName(column)StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnName(int).
getColumnType(column)IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getColumnType(int).
getColumnTypeName(column)StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnTypeName(int).
getPrecision(column)IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getPrecision(int).
getScale(column)IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getScale(int).
getSchemaName(column)StringFor documentation of this method, see java.sql.ResultSetMetaData#getSchemaName(int).
getTableName(column)StringFor documentation of this method, see java.sql.ResultSetMetaData#getTableName(int).
isAutoIncrement(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isAutoIncrement(int).
isCaseSensitive(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isCaseSensitive(int).
isCurrency(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isCurrency(int).
isDefinitelyWritable(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isDefinitelyWritable(int).
isNullable(column)IntegerFor documentation of this method, see java.sql.ResultSetMetaData#isNullable(int).
isReadOnly(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isReadOnly(int).
isSearchable(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isSearchable(int).
isSigned(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isSigned(int).
isWritable(column)BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isWritable(int).

JdbcRowId

JdbcSQLXML

JdbcSavepoint

JdbcStatement

Methods

MethodReturn typeBrief description
addBatch(sql)voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel()voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch()voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearWarnings()voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close()voidFor documentation of this method, see java.sql.Statement#close().
execute(sql)BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames)BooleanFor documentation of this method, see java.sql.Statement#execute(String, String[]).
executeBatch()Integer[]For documentation of this method, see java.sql.Statement#executeBatch().
executeQuery(sql)JdbcResultSetFor documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate(sql)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int[]).
executeUpdate(sql, columnNames)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getConnection()JdbcConnectionFor documentation of this method, see java.sql.Statement#getConnection().
getFetchDirection()IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize()IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getGeneratedKeys()JdbcResultSetFor documentation of this method, see java.sql.Statement#getGeneratedKeys().
getMaxFieldSize()IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows()IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMoreResults()BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current)BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getQueryTimeout()IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getResultSet()JdbcResultSetFor documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency()IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability()IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType()IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getUpdateCount()IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings()String[]For documentation of this method, see java.sql.Statement#getWarnings().
isClosed()BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable()BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
setCursorName(name)voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setEscapeProcessing(enable)voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction)voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows)voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setMaxFieldSize(max)voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max)voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setPoolable(poolable)voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds)voidFor documentation of this method, see java.sql.Statement#setQueryTimeout(int).

JdbcStruct

JdbcTime

Methods

MethodReturn typeBrief description
after(when)BooleanFor documentation of this method, see java.sql.Date#after(Date).
before(when)BooleanFor documentation of this method, see java.sql.Date#before(Date).
getHours()IntegerFor documentation of this method, see java.sql.Date#getHours().
getMinutes()IntegerFor documentation of this method, see java.sql.Date#getMinutes().
getSeconds()IntegerFor documentation of this method, see java.sql.Date#getSeconds().
getTime()IntegerFor documentation of this method, see java.sql.Date#getTime().
setHours(hours)voidFor documentation of this method, see java.sql.Date#setHours(int).
setMinutes(minutes)voidFor documentation of this method, see java.sql.Date#setMinutes(int).
setSeconds(seconds)voidFor documentation of this method, see java.sql.Date#setSeconds(int).
setTime(milliseconds)voidFor documentation of this method, see java.sql.Time#setTime(long).

JdbcTimestamp

Methods

MethodReturn typeBrief description
after(when)BooleanFor documentation of this method, see java.sql.Timestamp#after(Timestamp).
before(when)BooleanFor documentation of this method, see java.sql.Timestamp#before(Timestamp).
getDate()IntegerFor documentation of this method, see java.sql.Date#getDate().
getHours()IntegerFor documentation of this method, see java.sql.Date#getHours().
getMinutes()IntegerFor documentation of this method, see java.sql.Date#getMinutes().
getMonth()IntegerFor documentation of this method, see java.sql.Date#getMonth().
getNanos()IntegerFor documentation of this method, see java.sql.Timestamp#getNanos().
getSeconds()IntegerFor documentation of this method, see java.sql.Date#getSeconds().
getTime()IntegerFor documentation of this method, see java.sql.Timestamp#getTime().
getYear()IntegerFor documentation of this method, see java.sql.Date#getYear().
setDate(date)voidFor documentation of this method, see java.sql.Date#setDate(int).
setHours(hours)voidFor documentation of this method, see java.sql.Date#setHours(int).
setMinutes(minutes)voidFor documentation of this method, see java.sql.Date#setMinutes(int).
setMonth(month)voidFor documentation of this method, see java.sql.Date#setMonth(int).
setNanos(nanoseconds)voidFor documentation of this method, see java.sql.Timestamp#setNanos(int).
setSeconds(seconds)voidFor documentation of this method, see java.sql.Date#setSeconds(int).
setTime(milliseconds)voidFor documentation of this method, see java.sql.Timestamp#setTime(long).
setYear(year)voidFor documentation of this method, see java.sql.Date#setYear(int).

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 2025-12-11 UTC.