JDBC Service

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

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

  • The service provides numerous classes representing JDBC concepts, such asJdbcConnection,JdbcStatement,JdbcResultSet, and metadata classes, mirroring methods from thejava.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.

JDBC

This service allows scripts to connect to JDBC-compliant databases, includingGoogle Cloud SQL, MySQL, Microsoft SQL Server, and Oracle. See also theguide to JDBC.

Classes

NameBrief description
JdbcThe JDBC service allows scripts to connect toGoogle Cloud SQL, MySQL,Microsoft SQL Server, and Oracle databases.
JdbcArrayA JDBCArray.
JdbcBlobA JDBCBlob.
JdbcCallableStatementA JDBCCallableStatement.
JdbcClobA JDBCClob.
JdbcConnectionA JDBCConnection.
JdbcDatabaseMetaDataA JDBC database metadata object.
JdbcDateA JDBCDate.
JdbcParameterMetaDataA JDBCParameterMetaData.
JdbcPreparedStatementA JDBCPreparedStatement.
JdbcRefA JDBCRef.
JdbcResultSetA JDBCResultSet.
JdbcResultSetMetaDataA JDBCResultSetMetaData.
JdbcRowIdA JDBCRowId.
JdbcSQLXMLA JDBCSQLXML.
JdbcSavepointA JDBCSavepoint.
JdbcStatementA JDBCStatement.
JdbcStructA JDBCStruct.
JdbcTimeA JDBCTime.
JdbcTimestampA JDBCTimestamp.

Jdbc

Methods

MethodReturn typeBrief description
getCloudSqlConnection(url)JdbcConnectionAttempts to establish a connection to the given Google Cloud SQL URL.
getCloudSqlConnection(url, info)JdbcConnectionAttempts to establish a connection to the given Google Cloud SQL URL.
getCloudSqlConnection(url, userName, password)JdbcConnectionAttempts to establish a connection to the given Google Cloud SQL URL.
getConnection(url)JdbcConnectionAttempts to establish a connection to the given database URL.
getConnection(url, info)JdbcConnectionAttempts to establish a connection to the given database URL.
getConnection(url, userName, password)JdbcConnectionAttempts to establish a connection to the given database using a username and password.
newDate(milliseconds)JdbcDateCreate a date from milliseconds since epoch.
newTime(milliseconds)JdbcTimeCreate a time from milliseconds since epoch.
newTimestamp(milliseconds)JdbcTimestampCreate a timestamp from milliseconds since epoch.
parseDate(date)JdbcDateCreate a date by parsing the SQL date string.
parseTime(time)JdbcTimeCreate a time by parsing the SQL time string.
parseTimestamp(timestamp)JdbcTimestampCreate a timestamp by parsing the SQL timestamp string.

JdbcArray

Methods

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

JdbcBlob

Methods

MethodReturn typeBrief description
free()voidFor documentation of this method, seejava.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, seejava.sql.Blob#getBytes(long, int).
length()IntegerFor documentation of this method, seejava.sql.Blob#length().
position(pattern, start)IntegerFor documentation of this method, seejava.sql.Blob#position(byte[], long).
position(pattern, start)IntegerFor documentation of this method, seejava.sql.Blob#position(blob, long).
setBytes(position, blobSource)IntegerConvenience method for writing aJdbcBlob to this blob.
setBytes(position, blobSource, offset, length)IntegerConvenience method for writing aJdbcBlob to this blob.
setBytes(position, bytes)IntegerFor documentation of this method, seejava.sql.Blob#setBytes(long, byte[]).
setBytes(position, bytes, offset, length)IntegerFor documentation of this method, seejava.sql.Blob#setBytes(long, byte[], int, int).
truncate(length)voidFor documentation of this method, seejava.sql.Blob#truncate(long).

JdbcCallableStatement

Methods

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

JdbcClob

Methods

MethodReturn typeBrief description
free()voidFor documentation of this method, seejava.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, seejava.sql.Clob#getSubString(long, int).
length()IntegerFor documentation of this method, seejava.sql.Clob#length().
position(search, start)IntegerFor documentation of this method, seejava.sql.Clob#position(Clob, long).
position(search, start)IntegerFor documentation of this method, seejava.sql.Clob#position(String, long).
setString(position, blobSource)IntegerConvenience method for writing aJdbcClob to a clob.
setString(position, blobSource, offset, len)IntegerConvenience method for writing aJdbcClob to a clob.
setString(position, value)IntegerFor documentation of this method, seejava.sql.Clob#setString(long, String).
setString(position, value, offset, len)IntegerFor documentation of this method, seejava.sql.Clob#setString(long, String, int, int).
truncate(length)voidFor documentation of this method, seejava.sql.Clob#truncate(long).

JdbcConnection

Methods

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

JdbcDatabaseMetaData

Methods

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

JdbcDate

Methods

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

JdbcParameterMetaData

Methods

MethodReturn typeBrief description
getParameterClassName(param)StringFor documentation of this method, seejava.sql.ParameterMetaData#getParameterClassName(int).
getParameterCount()IntegerFor documentation of this method, seejava.sql.ParameterMetaData#getParameterCount().
getParameterMode(param)IntegerFor documentation of this method, seejava.sql.ParameterMetaData#getParameterMode(int).
getParameterType(param)IntegerFor documentation of this method, seejava.sql.ParameterMetaData#getParameterType(int).
getParameterTypeName(param)StringFor documentation of this method, seejava.sql.ParameterMetaData#getParameterTypeName(int).
getPrecision(param)IntegerFor documentation of this method, seejava.sql.ParameterMetaData#getPrecision(int).
getScale(param)IntegerFor documentation of this method, seejava.sql.ParameterMetaData#getScale(int).
isNullable(param)IntegerFor documentation of this method, seejava.sql.ParameterMetaData#isNullable(int).
isSigned(param)BooleanFor documentation of this method, seejava.sql.ParameterMetaData#isSigned(int).

JdbcPreparedStatement

Methods

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

JdbcRef

Methods

MethodReturn typeBrief description
getBaseTypeName()StringFor documentation of this method, seejava.sql.Ref#getBaseTypeName().
getObject()ObjectFor documentation of this method, seejava.sql.Ref#getObject().
setObject(object)voidFor documentation of this method, seejava.sql.Ref#setObject(Object).

JdbcResultSet

Methods

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

JdbcResultSetMetaData

Methods

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

JdbcRowId

Methods

MethodReturn typeBrief description
getBytes()Byte[]For documentation of this method, seejava.sql.RowId#getBytes().

JdbcSQLXML

Methods

MethodReturn typeBrief description
free()voidFor documentation of this method, seejava.sql.SQLXML#free().
getString()StringFor documentation of this method, seejava.sql.SQLXML#getString().
setString(value)voidFor documentation of this method, seejava.sql.SQLXML#setString(String).

JdbcSavepoint

Methods

MethodReturn typeBrief description
getSavepointId()IntegerFor documentation of this method, seejava.sql.Savepoint#getSavepointId().
getSavepointName()StringFor documentation of this method, seejava.sql.Savepoint#getSavepointName().

JdbcStatement

Methods

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

JdbcStruct

Methods

MethodReturn typeBrief description
getAttributes()Object[]For documentation of this method, seejava.sql.Struct#getAttributes().
getSQLTypeName()StringFor documentation of this method, seejava.sql.Struct#getSQLTypeName().

JdbcTime

Methods

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

JdbcTimestamp

Methods

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

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

Last updated 2025-12-11 UTC.