- getAllTypeSettings() - Static method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns all JDBCTypeSettings
instances that are currently
enabled.
- getAlwaysUsePreparedStatement() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Indicates if prepared statement should be used even when no parameters are
set.
- getArray(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getArray(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getAsciiStream(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getAsciiStream(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getAttributeNames() - Method in class com.spotfire.ws.im.ds.MetadataItem
-
Returns an array of all attribute names.
- getAttributeValue(String) - Method in class com.spotfire.ws.im.ds.MetadataItem
-
Returns the value of a given attribute.
- getAttributeValues() - Method in class com.spotfire.ws.im.ds.MetadataItem
-
Returns an array of all attribute values.
- getAutocommit() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Get autocommit mode.
- getBatchSize(int) - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns the batch size that specifies the amount of data in each batch
update.
- getBatchSize() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the batch size that specifies the amount of data in each batch
update.
- getBigDecimal(int, int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBigDecimal(String, int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBigDecimal(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBigDecimal(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBinaryStream(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBinaryStream(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBlob(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBlob(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBoolean(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBoolean(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getByte(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getByte(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBytes(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getBytes(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getCatalogNamePattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the pattern used to format a catalog name in an SQL query.
- getCatalogs() - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
Returns a list of catalog items.
- getCharacterStream(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getCharacterStream(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getClob(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getClob(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getColumnAliasPattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the pattern used to format a column alias in an SQL query.
- getColumnNamePattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the pattern used to format a column name in an SQL query.
- getColumns(String, String, String) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
Returns a list of column items.
- getConcurrency() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getConditionListThreshold() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Return the condition list threshold.
- getConnection() - Method in class com.spotfire.ws.im.ds.sql.BasicSQLRuntime
-
- getConnection() - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns a database connection.
- getConnection() - Method in interface com.spotfire.ws.im.ds.sql.SQLRuntime
-
- getConnection() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getConnectionProperties() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the connection properties used when creating a new connection to
the database.
- getContext() - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
Returns the JDBCContext
.
- getContext() - Method in class com.spotfire.ws.im.ds.sql.BasicSQLFilter
-
- getContext() - Method in class com.spotfire.ws.im.ds.sql.BasicSQLRuntime
-
- getContext() - Method in interface com.spotfire.ws.im.ds.sql.SQLFilter
-
Returns the JDBCContext
.
- getContext() - Method in interface com.spotfire.ws.im.ds.sql.SQLRuntime
-
- getCreateTempTableCommands() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the SQL commands needed for creating a temporary table that is used
to store filter values (when more than 'condition-list-threshold') and to
store result from subqueries.
- getCredentials(String, String, String) - Method in interface com.spotfire.ws.im.ds.authspi.CredentialsProvider
-
- getCredentialsTimeout() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Gets the credentials timeout for a JDBC data source.
- getCursorName() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getDataSourceID() - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns the ID of the data source instance.
- getDataSourceName() - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns the name of the data source instance.
- getDate(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getDate(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getDate(int, Calendar) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getDate(String, Calendar) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getDateFormatExpression() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns an expression that converts a date field to a string value on the
format:"YYYY-MM-DD", e.g.
- getDateLiteralFormatExpression() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns an expression that converts a date literal to a database date
value.
- getDateTimeFormatExpression() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns an expression that converts a datetime field to string value on the
format: "YYYY-MM-DD HH:MM:SS", e.g.
- getDateTimeLiteralFormatExpression() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns an expression that converts a datetime literal to a database
datetime value.
- getDisplayName() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the name of the JDBC type to be displayed in a UI.
- getDouble(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getDouble(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getDriverClass() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the JDBC driver class.
- getDropTempTableCommands() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the SQL commands for deleting a temporary table.
- getExpandInClause() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Tells if an SQL IN-clause shall be expanded into OR conditions.
- getFetchDirection() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getFetchDirection() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getFetchSize(int) - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns the fetch size that specifies the amount of data fetched with each
database round trip for a query.
- getFetchSize() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the fetch size that specifies the amount of data fetched with each
database round trip for a query.
- getFetchSize() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getFetchSize() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getFloat(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getFloat(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getGeneratedKeys() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getHoldability() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getInt(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getInt(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getJavaType() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings.TypeMapping
-
Returns the Java type.
- getLobThreshold() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the threshold value when LOB values used as parameters in a WHERE
clause, must be written in temporary tables.
- getLong(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getLong(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getMaxColumnNameLength() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the maximum length allowed for column names.
- getMaxFieldSize() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getMaxInClauseSize() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the maximum size of an SQL IN-clause.
- getMaxLength() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings.TypeMapping
-
Returns the maximum length.
- getMaxRows() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getMetadata(MetadataItem[]) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
- getMetadata(MetadataItem[]) - Method in interface com.spotfire.ws.im.ds.sql.JDBCMetadataProvider
-
Returns a list of MetadataItem
objects that corresponds to the
given path.
- getMetaData() - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- getMetaData() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getMetadataProvider() - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns a new instance of a metadata provider.
- getMetadataProviderClass() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the JDBCMetadataProvider
class.
- getMinInClauseSize() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the minimum number of values for creating a SQL IN-clause.
- getMoreResults() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getMoreResults(int) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getName() - Method in class com.spotfire.ws.im.ds.MetadataItem
-
Returns the item name.
- getNCharacterStream(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getNCharacterStream(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getNClob(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getNClob(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getNString(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getNString(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getObject(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getObject(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getObject(int, Map) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getObject(String, Map) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getObject(int, Class) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getObject(String, Class) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getParameterMetaData() - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- getPassword() - Method in interface com.spotfire.ws.im.ds.authspi.DataSourceCredentials
-
- getPingCommand() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the ping command used to verify a JDBC connection.
- getProcedureExpressionPattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Return the pattern that determines how a procedure expression is written in
the SQL query.
- getProcedureMetadata(String, String, String) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
- getProcedureNamePattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the pattern used to format a procedure name in an SQL query.
- getProcedures(String, String) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
- getProcedureTableJDBCType() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the JDBC type for procedure tables.
- getProcedureTableTypeName() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the type name for procedure tables.
- getQueryBuilderClass() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the query builder class.
- getQueryTimeout() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getRef(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getRef(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getResultSet() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getResultSetConcurrency() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getResultSetHoldability() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getResultSetType() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getRow() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getRowId(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getRowId(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getSchemaNamePattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the pattern used to format a schema name in an SQL query.
- getSchemas(String) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
Returns a list of schema items.
- getShort(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getShort(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getSQLAggregateFuntion(String) - Method in class com.spotfire.ws.im.ds.sql.BasicSQLFilter
-
- getSQLAggregateFuntion(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Get the SQL aggregate function for the given DAT aggregate function, or
null if no such SQL function exists.
- getSQLAggregateFuntion(String) - Method in interface com.spotfire.ws.im.ds.sql.SQLFilter
-
- getSQLFilterClass() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the SQLFilter
class.
- getSQLRuntime() - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns a new instance of a SQL Runtime.
- getSQLRuntimeClass() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the SQLRuntime
class.
- getSQLType(Class, int) - Method in class com.spotfire.ws.im.ds.sql.BasicSQLFilter
-
- getSQLType(Class) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the SQL type for a given Java type.
- getSQLType(Class, int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the SQL type for a given Java type.
- getSQLType() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings.TypeMapping
-
Returns the SQL type.
- getSQLType(Class, int) - Method in interface com.spotfire.ws.im.ds.sql.SQLFilter
-
Returns the SQL type for a given Java type.
- getSQLXML(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getSQLXML(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getStatement() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getString(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getString(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getStringLiteralQuote() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns The character used as quote for string literals.
- getTableAliases(String, String) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
- getTableAliases(String, String) - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns all table aliases for tables in the specified catalog and schema.
- getTableExpressionPattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Return the pattern that determines how a table expression is written in the
SQL query.
- getTableNamePattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the pattern used to format a table name in an SQL query.
- getTables(String, String) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
Returns a list of table items.
- getTableTypes() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
- getTempTableNamePattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the pattern used to format a temporary table name in an SQL
command.
- getTime(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTime(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTime(int, Calendar) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTime(String, Calendar) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTimeFormatExpression() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns an expression that converts a time field to a string value on the
format:"HH:MM:SS", e.g.
- getTimeLiteralFormatExpression() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns an expression that converts a time literal to a database time
value.
- getTimestamp(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTimestamp(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTimestamp(int, Calendar) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTimestamp(String, Calendar) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getType() - Method in class com.spotfire.ws.im.ds.MetadataItem
-
Returns the item type.
- getType() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getTypeMappings() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns all Java to SQL type mappings.
- getTypeName() - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns the name of the JDBC type configuration.
- getTypeName() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the name of the JDBC type.
- getTypeSettings() - Method in interface com.spotfire.ws.im.ds.sql.JDBCContext
-
Returns the JDBC type configuration.
- getTypeSettings(String) - Static method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the JDBCTypeSettings
for a specified type name.
- getUnicodeStream(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getUnicodeStream(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getUpdateCount() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- getURL(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getURL(String) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getURLPattern() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Returns the URL pattern.
- getUserName() - Method in interface com.spotfire.ws.im.ds.authspi.DataSourceCredentials
-
- getWarnings() - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- getWarnings() - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- Guid - Class in com.spotfire.server.util
-
This class represents an universally unique identifier (UUID), also known as globally unique identifier (GUID), see
UUID
.
- Guid() - Constructor for class com.spotfire.server.util.Guid
-
Constructs a new Guid
.
- Guid(String) - Constructor for class com.spotfire.server.util.Guid
-
Constructs a new
Guid
using the specified guid string representation as described in the
Guid.toString()
method.
- SCHEMA - Static variable in class com.spotfire.ws.im.ds.MetadataItem
-
The schema type.
- setAlwaysUsePreparedStatement(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Indicates if prepared statement should be used even when no parameters are
set.
- setAnsiiStyleOuterJoin(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Set if an attempt should be done to go from oracle outer join syntax with
'(+)' to ANSI form
If useAnsiJoin() is true, then this setting has no effect.
- setAnsiJoin(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Set if an attempt should be made to create ansi join syntax.
- setArray(int, Array) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setAsciiStream(int, InputStream, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setAsciiStream(int, InputStream) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setAsciiStream(int, InputStream, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setAttribute(String, String) - Method in class com.spotfire.ws.im.ds.MetadataItem
-
Sets an attribute.
- setAutocommit(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the auto commit mode for connection on the data source.
- setBatchSize(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the batch size that specifies the amount of data in each batch update.
- setBigDecimal(int, BigDecimal) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBinaryStream(int, InputStream, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBinaryStream(int, InputStream) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBinaryStream(int, InputStream, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBlob(int, Blob) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBlob(int, InputStream) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBlob(int, InputStream, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBoolean(int, boolean) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setByte(int, byte) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setBytes(int, byte[]) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setCatalogNamePattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern used to format a catalog name in an SQL query.
- setCharacterStream(int, Reader, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setCharacterStream(int, Reader) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setCharacterStream(int, Reader, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setClob(int, Clob) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setClob(int, Reader) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setClob(int, Reader, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setColumnAliasPattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern used to format a column alias in an SQL query.
- setColumnNamePattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern used to format a column name in an SQL query.
- setConditionListThreshold(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the condition list threshold.
- setConnection(Connection) - Method in class com.spotfire.ws.im.ds.sql.BasicSQLRuntime
-
- setConnection(Connection) - Method in interface com.spotfire.ws.im.ds.sql.SQLRuntime
-
Sets the JDBC database connection.
- setConnectionProperties(Properties) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the connection properties used when creating a new connection to the
database.
- setContext(JDBCContext) - Method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
- setContext(JDBCContext) - Method in class com.spotfire.ws.im.ds.sql.BasicSQLFilter
-
- setContext(JDBCContext) - Method in class com.spotfire.ws.im.ds.sql.BasicSQLRuntime
-
- setContext(JDBCContext) - Method in interface com.spotfire.ws.im.ds.sql.JDBCMetadataProvider
-
Sets the JDBCContext
.
- setContext(JDBCContext) - Method in interface com.spotfire.ws.im.ds.sql.SQLFilter
-
Sets the JDBCContext
.
- setContext(JDBCContext) - Method in interface com.spotfire.ws.im.ds.sql.SQLRuntime
-
Sets the JDBC context.
- setCreateTempTableCommands(String[]) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the SQL commands needed for creating a temporary table that is used to
store filter values (when more than 'condition-list-threshold') and to
store result from subqueries.
- setCredentialsTimeout(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the credentials timeout for a JDBC data source.
- setCursorName(String) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setDate(int, Date) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setDate(int, Date, Calendar) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setDateFormatExpression(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets an expression that converts a date field to a string value on the
format:"YYYY-MM-DD", e.g.
- setDateLiteralFormatExpression(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets an expression that converts a date literal to a database date value.
- setDateTimeFormatExpression(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets an expression that converts a datetime field to string value on the
format: "YYYY-MM-DD HH:MM:SS", e.g.
- setDateTimeLiteralFormatExpression(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets an expression that converts a datetime literal to a database datetime
value.
- setDisplayName(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
- setDouble(int, double) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setDriverClass(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the JDBC driver class.
- setDropTempTableCommands(String[]) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the SQL commands for deleting a temporary table.
- setEscapeProcessing(boolean) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setExpandInClause(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets if an SQL IN-clause shall be expanded into OR conditions.
- setFetchDirection(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- setFetchDirection(int) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setFetchSize(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the fetch size that specifies the amount of data fetched with each
database round trip for a query.
- setFetchSize(int) - Method in class com.spotfire.ws.im.ds.sql.ResultSetWrapper
-
- setFetchSize(int) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setFloat(int, float) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setInt(int, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setLobThreshold(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the threshold value when LOB values used as parameters in a WHERE
clause, must be written in temporary tables.
- setLong(int, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setMaxColumnNameLength(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the maximum length allowed for database column names.
- setMaxFieldSize(int) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setMaxInClauseSize(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Size the maximum size of an SQL IN-clause.
- setMaxRows(int) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setMetadataProviderClass(Class) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the JDBCMetadataProvider
class.
- setMinInClauseSize(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the minimum number of values for creating a SQL IN-clause.
- setNCharacterStream(int, Reader) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setNCharacterStream(int, Reader, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setNClob(int, NClob) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setNClob(int, Reader) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setNClob(int, Reader, long) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setNString(int, String) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setNull(int, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setNull(int, int, String) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setObject(int, Object, int, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setObject(int, Object, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setObject(int, Object) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setPingCommand(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the ping command used to verify a JDBC connection.
- setPoolable(boolean) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setProcedureExpressionPattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern that determines how a procedure expression is written in
the SQL query.
- setProcedureNamePattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern used to format a procedure name in an SQL query.
- setProcedureTableJDBCType(int) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the JDBC type for procedure tables.
- setProcedureTableTypeName(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the type name for procedure tables.
- setQueryTimeout(int) - Method in class com.spotfire.ws.im.ds.sql.StatementWrapper
-
- setRef(int, Ref) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setRowId(int, RowId) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setSchemaNamePattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern used to format a schema name in an SQL query.
- setShort(int, short) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setSQLFilterClass(Class) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the SQLFilter
class.
- setSQLRuntimeClass(Class) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the SQLRuntime
class.
- setSQLXML(int, SQLXML) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setString(int, String) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setStringLiteralQuote(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets The character used as quote for string literals.
- setSupportsCatalogs(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets if the catalog level is supported in metadata.
- setSupportsDistinct(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets if the DISTINCT keyword is supported in SQL queries.
- setSupportsOrderBy(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets if the ORDER BY keyword is supported in SQL queries.
- setSupportsProcedures(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets if procedures are supported in metadata.
- setSupportsSchemas(boolean) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets if the schema level is supported in metadata.
- setTableExpressionPattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern that determines how a table expression is written in the
SQL query.
- setTableNamePattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern used to format a table name in an SQL query.
- setTableTypes(String[]) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
- setTempTableNamePattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the pattern used to format a temporary table name in an SQL command.
- setTime(int, Time) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setTime(int, Time, Calendar) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setTimeFormatExpression(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets an expression that converts a time field to a string value on the
format:"HH:MM:SS", e.g.
- setTimeLiteralFormatExpression(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets an expression that converts a time literal to a database time value.
- setTimestamp(int, Timestamp) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setTimestamp(int, Timestamp, Calendar) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setTypeMappings(JDBCTypeSettings.TypeMapping[]) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets all Java to SQL type mappings.
- setTypeName(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the name of the JDBC type.
- setUnicodeStream(int, InputStream, int) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setURL(int, URL) - Method in class com.spotfire.ws.im.ds.sql.PreparedStatementWrapper
-
- setURLPattern(String) - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Sets the URL pattern.
- sortMetadataItemsByName(MetadataItem[]) - Static method in class com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider
-
- SQLFilter - Interface in com.spotfire.ws.im.ds.sql
-
This interface should be used when full control over the SQL syntax is
required.
- SQLRuntime - Interface in com.spotfire.ws.im.ds.sql
-
This interface should be implemented when full control over the SQL execution
is required.
- StatementWrapper - Class in com.spotfire.ws.im.ds.sql
-
Use this class for creating wrapper classes around the Statement
interface.
- StatementWrapper(Statement) - Constructor for class com.spotfire.ws.im.ds.sql.StatementWrapper
-
Creates a new StatementWrapper
instance.
- supportsCatalogs() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Tells if the catalog level is supported in metadata.
- supportsDistinct() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Tells if the DISTINCT keyword is supported in SQL queries.
- supportsOrderBy() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Tells if the ORDER BY clause is supported in SQL queries.
- supportsProcedures() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Tells if procedures are supported in metadata.
- supportsSchemas() - Method in class com.spotfire.ws.im.ds.sql.JDBCTypeSettings
-
Tells if the schema level is supported in metadata.