A B C D E F G I K L N P Q R S U V

A

absolute(int) - Method in interface sqlj.runtime.Scrollable
Moves the iterator object to the row with the given row number.
ADD_BATCH_COUNT - Static variable in class sqlj.runtime.ExecutionContext
Constant returned by getUpdateCount() if the last statement encountered was added to the existing statement batch rather than being executed.
adjustDOUBLEValue(double) - Static method in class com.sap.sql.ApproximateNumericHelper
Open SQL does not guarantee that a double value that has been stored in a column with JDBC type DOUBLE and read again compares with equal to the original value.
adjustREALValue(float) - Static method in class com.sap.sql.ApproximateNumericHelper
 
afterLast() - Method in interface sqlj.runtime.Scrollable
Moves the iterator object to immediately after its last row.
ApproximateNumericHelper - Class in com.sap.sql
 
ApproximateNumericHelper() - Constructor for class com.sap.sql.ApproximateNumericHelper
 
AsciiStream - Class in sqlj.runtime
Deprecated. Please use CharacterStream instead.
AsciiStream(InputStream) - Constructor for class sqlj.runtime.AsciiStream
Deprecated. Creates an Ascii-valued input stream with an uninitialized length.
AsciiStream(InputStream, int) - Constructor for class sqlj.runtime.AsciiStream
Deprecated. Creates an Ascii-valued input stream of given length.
ASENSITIVE - Static variable in interface sqlj.runtime.ResultSetIterator
Constant used by the "sensitivity" field, indicating that the iterator is defined to have an asensitive cursor.
AUTO_BATCH - Static variable in class sqlj.runtime.ExecutionContext
Constant passed to setBatchLimit() or returned by getBatchLimit(), indicating that implicit batch execution should be performed, and that the actual batch size is at the discretion of the Open SQL / SQLJ runtime.

B

BatchExecutionContext - Class in com.sap.sql
The class BatchExecutionContext allows for batching in Open SQL / SQLJ.
BatchExecutionContext() - Constructor for class com.sap.sql.BatchExecutionContext
Creates a new BatchExecutionContext object.
beforeFirst() - Method in interface sqlj.runtime.Scrollable
Moves the iterator object to immediately before its first row.
BinaryStream - Class in sqlj.runtime
BinaryStream is a class derived from java.io.InputStream.
BinaryStream(InputStream) - Constructor for class sqlj.runtime.BinaryStream
Creates a new BinaryStream object using the given InputStream object in.
BinaryStream(InputStream, int) - Constructor for class sqlj.runtime.BinaryStream
Creates a new BinaryStream object using the given InputStream object.

C

cancel() - Method in class sqlj.runtime.ExecutionContext
The cancel method can be used by one thread to cancel a sql operation that is currently being executed by another thread using this context.
CardinalityViolationException - Exception in com.sap.sql
Exception thrown by the Open SQL / SQLJ runtime if a single row query returns a result set with more than one row.
CardinalityViolationException() - Constructor for exception com.sap.sql.CardinalityViolationException
Constructs a new NoDataException object.
CharacterStream - Class in sqlj.runtime
A class derived from java.io.Reader whose instances contain Unicode data.
CharacterStream(Reader) - Constructor for class sqlj.runtime.CharacterStream
Creates a new CharacterStream object using the given Reader object in.
CharacterStream(Reader, int) - Constructor for class sqlj.runtime.CharacterStream
Creates a new CharacterStream object using the given Reader object in.
clearWarnings() - Method in interface sqlj.runtime.ResultSetIterator
After this call getWarnings returns null until a new warning is reported for this iterator.
close() - Method in interface sqlj.runtime.ConnectionContext
Releases all resources used in maintaining database state on this ConnectionContext object and closes the underlying JDBC Connection object.
close(boolean) - Method in interface sqlj.runtime.ConnectionContext
Releases all resources used in maintaining database state on this ConnectionContext object.
close() - Method in interface sqlj.runtime.ResultSetIterator
Closes the iterator object, releasing any underlying resources.
CLOSE_CONNECTION - Static variable in interface sqlj.runtime.ConnectionContext
Constant indicating that the underlying JDBC Connection should be closed.
com.sap.sql - package com.sap.sql
 
ConnectionContext - Interface in sqlj.runtime
The ConnectionContext interface provides a set of methods that manage a set of SQL operations performed during a session with a specific database.
createCheckerFactory() - Static method in class com.sap.sql.DatabaseServices
 
createNativeStatement(Connection) - Static method in class com.sap.sql.NativeSQLAccess
This method allows to create a Statement object on the Native SQL connection underlying a given Open SQL connection.
createNativeStatement(Connection, int, int) - Static method in class com.sap.sql.NativeSQLAccess
This method allows to create a Statement object on the Native SQL connection underlying a given Open SQL connection.

D

DatabaseServices - Class in com.sap.sql
A collection of services and utilities regarding the database server.
DateTimeNormalizer - Class in com.sap.sql
This class can be used to normalize time values that need to be stored via JDBC.
DEFAULT_DATA_SOURCE - Static variable in class sqlj.runtime.RuntimeContext
The JNDI name of the data source used to create the default Connection object jdbc/defaultDataSource.
DEFAULT_RUNTIME - Static variable in class sqlj.runtime.RuntimeContext
The fully qualified class name of the default runtime implementation used when no other implementation has been defined for a VM environment.
DuplicateKeyException - Exception in com.sap.sql
 
DuplicateKeyException(SQLException) - Constructor for exception com.sap.sql.DuplicateKeyException
Deprecated. 
DuplicateKeyException(String, String, int) - Constructor for exception com.sap.sql.DuplicateKeyException
Do not use this constructor!

E

endFetch() - Method in interface sqlj.runtime.PositionedIterator
Returns true iff the iterator is not positioned on a row.
EXCEPTION_COUNT - Static variable in class sqlj.runtime.ExecutionContext
Constant returned by getUpdateCount indicating that an exeception was thrown before the last execution was successfully completed, or no operation has yet been attempted on this context.
EXEC_BATCH_COUNT - Static variable in class sqlj.runtime.ExecutionContext
Constant returned by getUpdateCount() if the last execution was a statement batch execution.
execute() - Method in class sqlj.runtime.ExecutionContext
Performs a generic execute on the currently registered statement.
executeBatch() - Method in class sqlj.runtime.ExecutionContext
Executes the pending statement batch contained in this ExecutionContext object and returns the result as an array of update counts.
executeQuery() - Method in class sqlj.runtime.ExecutionContext
Performs an execute query on the currently registered statement.
executeUpdate() - Method in class sqlj.runtime.ExecutionContext
Performs an execute update on the currently registered statement.
ExecutionContext - Class in sqlj.runtime
An execution context provides the context in which executable sql operations are preformed.
ExecutionContext() - Constructor for class sqlj.runtime.ExecutionContext
 

F

FETCH_FORWARD - Static variable in interface sqlj.runtime.ResultSetIterator
Constant to indicate that the rows in an iterator object will be processed in a forward direction first-to-last.
FETCH_REVERSE - Static variable in interface sqlj.runtime.ResultSetIterator
Constant to indicate that the rows in an iterator object will be processed in a forward direction first-to-last.
FETCH_UNKNOWN - Static variable in interface sqlj.runtime.ResultSetIterator
Constant to indicate that the rows in an iterator object will be processed in an unknown direction.
first() - Method in interface sqlj.runtime.Scrollable
Moves the iterator object to its first row.
ForUpdate - Interface in sqlj.runtime
This interface is not usable with Open SQL / SQLJ.

G

getBatchLimit() - Method in class com.sap.sql.BatchExecutionContext
Returns the current batch limit that was set for this BatchExecutionContext object.
getBatchLimit() - Method in class sqlj.runtime.ExecutionContext
Returns the current batch limit that was set for this BatchExecutionContext object.
getBatchUpdateCounts() - Method in class sqlj.runtime.ExecutionContext
Returns an array of update counts containing one element for each command in the last statement batch to successfully complete execution.
getConnectedProfile(Object) - Method in interface sqlj.runtime.ConnectionContext
This method is for internal use.
getConnection() - Method in interface sqlj.runtime.ConnectionContext
Returns the underlying jdbc connection object associated with this context instance.
getCursorName() - Method in interface sqlj.runtime.ForUpdate
Get the name of the SQL cursor used by this iterator.
getDefaultConnection() - Method in class sqlj.runtime.RuntimeContext
Returns the default connection object, if one exists, or null otherwise.
getDictionaryReader(Connection) - Static method in class com.sap.sql.DatabaseServices
Gets a DictionaryReader object which provides metadata access to the database objects defined in the Dictionary.
getExecutionContext() - Method in interface sqlj.runtime.ConnectionContext
Returns the default ExecutionContext object of this ConnectionContext object.
getFetchDirection() - Method in class sqlj.runtime.ExecutionContext
Retrieves the direction for fetching rows from database tables that is the default for scrollable iterator objects generated from this ExecutionContext object.
getFetchDirection() - Method in interface sqlj.runtime.Scrollable
Retrieves the direction for fetching rows for this iterator object.
getFetchSize() - Method in class sqlj.runtime.ExecutionContext
Retrieves the number of rows that is the current fetch size for iterator objects generated from this ExecutionContext object.
getFetchSize() - Method in interface sqlj.runtime.ResultSetIterator
This method is not supported in Open SQL / SQLJ.
getInputStream() - Method in class sqlj.runtime.StreamWrapper
Returns the underlying input stream which is being wrapped.
getLength() - Method in class sqlj.runtime.CharacterStream
Returns the length in characters of the wrapped Reader object, as specified during construction or in the last call to setLength.
getLength() - Method in class sqlj.runtime.StreamWrapper
Returns the length in bytes of the wrapped InputStream, as specified during construction or in the last call to setLength().
getLoaderForClass(Class) - Method in class sqlj.runtime.RuntimeContext
Returns a loader associated with a class.
getMaxFieldSize() - Method in class sqlj.runtime.ExecutionContext
The max field size limit (in bytes) is the maximum amount of data returned for any column value for sql operations subsequently executed using this context; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns.
getMaximumPositiveDOUBLEValue() - Static method in class com.sap.sql.ApproximateNumericHelper
Determines greatest positive double value, which can be stored in a DOUBLE (or FLOAT) column.
getMaximumPositiveREALValue() - Static method in class com.sap.sql.ApproximateNumericHelper
Determines greatest positive float value, which can be stored in a REAL column.
getMaxRows() - Method in class sqlj.runtime.ExecutionContext
The max rows limit is the maximum number of rows that any ResultSetIterator or jdbc ResultSet returned by sql operations subsequently executed using this context can contain.
getMinimumPositiveDOUBLEValue() - Static method in class com.sap.sql.ApproximateNumericHelper
Determines smallest positive double value, which can be stored in a DOUBLE (or FLOAT) column.
getMinimumPositiveREALValue() - Static method in class com.sap.sql.ApproximateNumericHelper
Determines smallest positive float value, which can be stored in a REAL column.
getNativeMetaData(Connection) - Static method in class com.sap.sql.NativeSQLAccess
This method gives access to the DatabaseMetaData of the Native SQL connection underlying an Open SQL connection.
getNextResultSet() - Method in class sqlj.runtime.ExecutionContext
Moves to the currently registered statement's next result.
getQueryTimeout() - Method in class sqlj.runtime.ExecutionContext
The query timeout limit is the maxiumum number of seconds sql opeations subsequently executed using this context may take to complete.
getReader() - Method in class sqlj.runtime.CharacterStream
Returns the underlying Reader object wrapped by the CharacterStream object.
getResultSet() - Method in interface sqlj.runtime.ResultSetIterator
Returns the JDBC result set associated with this iterator.
getRow() - Method in interface sqlj.runtime.ResultSetIterator
Retrieves the current row number.
getRuntime() - Static method in class sqlj.runtime.RuntimeContext
Returns the runtime context associated with the current java virtual machine instance.
getSensitivity() - Method in interface sqlj.runtime.ResultSetIterator
Retrieves the sensitivity of this iterator object.
getSQLType(Connection) - Static method in class com.sap.sql.DatabaseServices
Returns the SQL processor type (open, native, vendor) of the given database connection.
getTypeMap() - Method in interface sqlj.runtime.ConnectionContext
Type maps are not supported by Open SQL / SQLJ.
getUpdateCount() - Method in class sqlj.runtime.ExecutionContext
Returns the number of rows updated by the last sql operation to complete execution using this context. 0 is returned if the last sql operation was not a DML statement.
getUTCTimestamp(Connection) - Static method in class com.sap.sql.DatabaseServices
Returns the current UTC time on the DB server as a Timestamp.
getVendorID(String) - Static method in class com.sap.sql.NativeSQLAccess
Gets the product identifier VENDOR_<vendor name> that corresponds to the given database product name.
getVendorID(Connection) - Static method in class com.sap.sql.NativeSQLAccess
Gets the product identifier VENDOR_<vendor name> for the given connection.
getVendorName(int) - Static method in class com.sap.sql.NativeSQLAccess
Gets the database product name that corresponds to the given product identifier.
getVendorName(Connection) - Static method in class com.sap.sql.NativeSQLAccess
Gets the corresponding database product name for the given database connection.
getVendorNames() - Static method in class com.sap.sql.NativeSQLAccess
Gets an array of all supported database product names.
getVendorTitle(int) - Static method in class com.sap.sql.NativeSQLAccess
Gets the database product title for the given product identifier.
getWarnings() - Method in class sqlj.runtime.ExecutionContext
Returns the first warning reported by the last sql operation to complete execution using this context.
getWarnings() - Method in interface sqlj.runtime.ResultSetIterator
The first warning reported by calls on this iterator is returned.

I

INSENSITIVE - Static variable in interface sqlj.runtime.ResultSetIterator
Constant used by the "sensitivity" field, indicating that the iterator is defined to have an insensitive cursor.
isAfterLast() - Method in interface sqlj.runtime.Scrollable
Indicates whether the iterator object is after its last row.
isBatching() - Method in class sqlj.runtime.ExecutionContext
Returns true if batching is currently enabled for this execution contextobject, false if batching is disabled.
isBeforeFirst() - Method in interface sqlj.runtime.Scrollable
Indicates whether the iterator object is before its first row.
isClosed() - Method in interface sqlj.runtime.ConnectionContext
Determines wether this ConnectionContext object has already been closed.
isClosed() - Method in interface sqlj.runtime.ResultSetIterator
 
isFirst() - Method in interface sqlj.runtime.Scrollable
Indicates whether the iterator object is on its first row.
isLast() - Method in interface sqlj.runtime.Scrollable
Indicates whether the iterator object is on its last row.
isTransientSQLError(Connection, SQLException) - Static method in class com.sap.sql.NativeSQLAccess
Returns true, if the SQLException originates from a database error that is of transient nature, false otherwise.
isValidDOUBLEValue(double) - Static method in class com.sap.sql.ApproximateNumericHelper
Determines if a given double value can be stored in a DOUBLE (or FLOAT) column.
isValidREALValue(float) - Static method in class com.sap.sql.ApproximateNumericHelper
Determines if a given float value can be stored in a REAL column.

K

KEEP_CONNECTION - Static variable in interface sqlj.runtime.ConnectionContext
Constant indicating that the underlying JDBC Connection should not be closed.

L

last() - Method in interface sqlj.runtime.Scrollable
Moves the iterator object to its last row.

N

NamedIterator - Interface in sqlj.runtime
An interface implemented by all iterators that employ a by-name binding strategy.
NativeSQLAccess - Class in com.sap.sql
This class allows to circumvent Open SQL restrictions on specific databaseses.
NEW_BATCH_COUNT - Static variable in class sqlj.runtime.ExecutionContext
Constant returned by getUpdateCount() if the last statement encountered was added to a new statement batch rather than being executed.
next() - Method in interface sqlj.runtime.ResultSetIterator
Advances the iterator to the next row.
NoDataException - Exception in com.sap.sql
Exception thrown by the Open SQL / SQLJ runtime if a single row query returns an empty result set.
NoDataException() - Constructor for exception com.sap.sql.NoDataException
Constructs a new NoDataException object.
normalizeSqlDateMillies(long) - Static method in class com.sap.sql.DateTimeNormalizer
Normalizes a milli second value according to the specification of java.sql.Date.
normalizeSqlTimeMillies(long) - Static method in class com.sap.sql.DateTimeNormalizer
Normalizes a milli second value according to the specification of java.sql.Time.

P

PositionedIterator - Interface in sqlj.runtime
An interface implemented by all iterators that employ a by-position binding strategy.
prepareNativeCall(Connection, String) - Static method in class com.sap.sql.NativeSQLAccess
This method allows to prepare a CallableStatement object on the Native SQL connection underlying a given Open SQL connection.
prepareNativeCall(Connection, String, int, int) - Static method in class com.sap.sql.NativeSQLAccess
This method allows to prepare a CallableStatement object on the Native SQL connection underlying a given Open SQL connection.
prepareNativeStatement(Connection, String) - Static method in class com.sap.sql.NativeSQLAccess
This method allows to prepare a PreparedStatement object on the Native SQL connection underlying a given Open SQL connection.
prepareNativeStatement(Connection, String, int, int) - Static method in class com.sap.sql.NativeSQLAccess
This method allows to prepare a PreparedStatement object on the Native SQL connection underlying a given Open SQL connection.
previous() - Method in interface sqlj.runtime.Scrollable
Moves the iterator object to its previous row.
PROPERTY_KEY - Static variable in class sqlj.runtime.RuntimeContext
The key under which the RuntimeContext implementation class name is stored in the system properties.

Q

QUERY_COUNT - Static variable in class sqlj.runtime.ExecutionContext
Constant returned by getUpdateCount indicating that the last execution produced a result set or iterator.

R

registerStatement(ConnectionContext, Object, int) - Method in class com.sap.sql.BatchExecutionContext
This methods is for internal use of the SQLJ runtime an must not be called by an application.
registerStatement(ConnectionContext, Object, int) - Method in class sqlj.runtime.ExecutionContext
Creates, registers and returns a statement.
relative(int) - Method in interface sqlj.runtime.Scrollable
Moves the iterator object the given number of rows, either positive or negative, from its current position.
releaseStatement() - Method in class sqlj.runtime.ExecutionContext
Releases the currently registered statement, signaling that all execution-related operations have completed.
ResultSetIterator - Interface in sqlj.runtime
An interface that defines the shared functionality of those objects used to iterate over the contents of a result set.
RuntimeContext - Class in sqlj.runtime
This class is for internal use only.
RuntimeContext() - Constructor for class sqlj.runtime.RuntimeContext
 

S

Scrollable - Interface in sqlj.runtime
This interface is not usable with Open SQL / SQLJ.
SENSITIVE - Static variable in interface sqlj.runtime.ResultSetIterator
Constant used by the "sensitivity" field, indicating that the iterator is defined to have a sensitive cursor.
setBatching(boolean) - Method in class com.sap.sql.BatchExecutionContext
On an BatchExecutionContext object, batching cannot be switched of.
setBatching(boolean) - Method in class sqlj.runtime.ExecutionContext
Enables or disables batching for statements executed on this ExecutionContext object.
setBatchLimit(int) - Method in class com.sap.sql.BatchExecutionContext
Sets the maximum batch size on this batch context object.
setBatchLimit(int) - Method in class sqlj.runtime.ExecutionContext
Sets the maximum batch size on this batch context object.
setFetchDirection(int) - Method in class sqlj.runtime.ExecutionContext
Gives the SQLJ runtime a hint as to the direction in which rows of scrollable iterator objects are processed.
setFetchDirection(int) - Method in interface sqlj.runtime.Scrollable
Gives the SQLJ runtime a hint as to the direction in which rows of this iterator object are processed.
setFetchSize(int) - Method in class sqlj.runtime.ExecutionContext
Gives the SQLJ runtime a hint as to the number of rows that should be fetched when more rows are needed.
setFetchSize(int) - Method in interface sqlj.runtime.ResultSetIterator
This method is not supported in Open SQL / SQLJ.
setLength(int) - Method in class sqlj.runtime.CharacterStream
Sets the length Java field of the wrapped Reader object to be the passed value.
setLength(int) - Method in class sqlj.runtime.StreamWrapper
Sets the length attribute of the wrapped stream to be the passed value.
setMaxFieldSize(int) - Method in class sqlj.runtime.ExecutionContext
The max field size limit (in bytes) is the maximum amount of data returned for any column value for sql operations subsequently executed using this context; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns.
setMaxRows(int) - Method in class sqlj.runtime.ExecutionContext
The max rows limit is the maximum number of rows that any ResultSetIterator or jdbc ResultSet returned by sql operations subsequently executed using this context can contain.
setQueryTimeout(int) - Method in class sqlj.runtime.ExecutionContext
The query timeout limit is the maxiumum number of seconds sql opeations subsequently executed using this context may take to complete.
SQL_STATE - Static variable in exception com.sap.sql.CardinalityViolationException
SQL state indicating that more than one row was returned by a single row query.
SQL_STATE - Static variable in exception com.sap.sql.NoDataException
SQL state indicating that no data was returned by a single row query.
SQL_TYPE_NATIVE_SQL - Static variable in class com.sap.sql.DatabaseServices
SQL processor of type Native SQL
SQL_TYPE_OPEN_SQL - Static variable in class com.sap.sql.DatabaseServices
SQL processor of type Open SQL
SQL_TYPE_VENDOR_SQL - Static variable in class com.sap.sql.DatabaseServices
SQL processor of type Vendor SQL
sqlj.runtime - package sqlj.runtime
 
SQLNullException - Exception in sqlj.runtime
The SQLNullException class is a particular instance of SQLException used in the case that SQL NULL was attemped to be fetched into a java primitive type.
SQLNullException() - Constructor for exception sqlj.runtime.SQLNullException
Create a SQLNullException object.
StreamWrapper - Class in sqlj.runtime
This class wraps a particular InputStream instance.
StreamWrapper(InputStream) - Constructor for class sqlj.runtime.StreamWrapper
Creates a new StreamWrapper using the bytes in the passed InputStream.
StreamWrapper(InputStream, int) - Constructor for class sqlj.runtime.StreamWrapper
Creates a new StreamWrapper using the bytes in the passed InputStream.

U

UnicodeStream - Class in sqlj.runtime
Deprecated. Please use CharacterStream instead.
UnicodeStream(InputStream) - Constructor for class sqlj.runtime.UnicodeStream
Deprecated. Creates a Unicode-valued input stream with an uninitialized length.
UnicodeStream(InputStream, int) - Constructor for class sqlj.runtime.UnicodeStream
Deprecated. Creates a Unicode-valued input stream of given length.
UNLIMITED_BATCH - Static variable in class sqlj.runtime.ExecutionContext
Constant passed to setBatchLimit() or returned by getBatchLimit(), indicating that no implicit batch execution should be performed once a certain batch size is reached.

V

VENDOR_DB2_UDB - Static variable in class com.sap.sql.NativeSQLAccess
DB2 UDB for UNIX and NT database
VENDOR_DB2_UDB_AS400 - Static variable in class com.sap.sql.NativeSQLAccess
DB2 UDB for AS/400 database
VENDOR_DB2_UDB_OS390 - Static variable in class com.sap.sql.NativeSQLAccess
DB2 UDB for OS/390 database
VENDOR_INFORMIX - Static variable in class com.sap.sql.NativeSQLAccess
Informix database
VENDOR_JAVADB - Static variable in class com.sap.sql.NativeSQLAccess
Java DB database
VENDOR_MS_SQL_SERVER - Static variable in class com.sap.sql.NativeSQLAccess
MS SQL Server database
VENDOR_MYSQL - Static variable in class com.sap.sql.NativeSQLAccess
MySQL Server database
VENDOR_ORACLE - Static variable in class com.sap.sql.NativeSQLAccess
Oracle database
VENDOR_SAP_HDB - Static variable in class com.sap.sql.NativeSQLAccess
SAP HDB database
VENDOR_SAPDB - Static variable in class com.sap.sql.NativeSQLAccess
SAP DB database
VENDOR_SYBASE - Static variable in class com.sap.sql.NativeSQLAccess
Sybase
VENDOR_UNKNOWN - Static variable in class com.sap.sql.NativeSQLAccess
Unknown database product

A B C D E F G I K L N P Q R S U V

Copyright 2012 SAP AG Complete Copyright Notice