Uses of Class
org.identityconnectors.dbcommon.SQLParam

Packages that use SQLParam

Package	Description
org.identityconnectors.databasetable	This is the core package for the connector.
org.identityconnectors.databasetable.mapping	Database Table Connector Mapping Package Overview Database table connector use the configuration's switches to change the attribute to resource mapping.
org.identityconnectors.dbcommon	This is a generic bundle that contains many of the utilities needed for any sort of database connector, such as query builders, connection wrappers, and other SQL utilities.

Uses of SQLParam in org.identityconnectors.databasetable

Methods in org.identityconnectors.databasetable that return SQLParam

Modifier and Type	Method and Description
protected SQLParam	DatabaseTableFilterTranslator.getSQLParam(Attribute attribute, ObjectClass oclass, OperationOptions options)

Methods in org.identityconnectors.databasetable that return types with arguments of type SQLParam

Modifier and Type	Method and Description
static Map<String,SQLParam>	DatabaseTableSQLUtil.getColumnValues(MappingStrategy sms, ResultSet resultSet) Read one row from database result set and convert it to columnValues map.
Map<String,SQLParam>	DatabaseTableConnection.getColumnValues(ResultSet result) Get the Column Values map

Method parameters in org.identityconnectors.databasetable with type arguments of type SQLParam

Modifier and Type	Method and Description
CallableStatement	DatabaseTableConnection.prepareCall(String sql, List<SQLParam> params) Indirect call of prepareCall statement with mapped callable statement parameters
PreparedStatement	DatabaseTableConnection.prepareStatement(String sql, List<SQLParam> params) Indirect call of prepare statement with mapped prepare statement parameters
static void	DatabaseTableSQLUtil.setParams(MappingStrategy sms, CallableStatement statement, List<SQLParam> params) This method binds the "?"
static void	DatabaseTableSQLUtil.setParams(MappingStrategy sms, PreparedStatement statement, List<SQLParam> params) This method binds the "?"

Uses of SQLParam in org.identityconnectors.databasetable.mapping

Methods in org.identityconnectors.databasetable.mapping that return SQLParam

Modifier and Type	Method and Description
SQLParam	StringStrategy.getSQLParam(ResultSet resultSet, int i, String name, int sqlType)
SQLParam	NativeTimestampsStrategy.getSQLParam(ResultSet resultSet, int i, String name, int sqlType)
SQLParam	MappingStrategy.getSQLParam(ResultSet resultSet, int i, String name, int sqlType) Retrieve the SQL value from result set
SQLParam	JdbcConvertor.getSQLParam(ResultSet resultSet, int i, String name, int sqlType)
SQLParam	DefaultStrategy.getSQLParam(ResultSet resultSet, int i, String name, int sqlType)
SQLParam	AttributeConvertor.getSQLParam(ResultSet resultSet, int i, String name, int sqlType)

Methods in org.identityconnectors.databasetable.mapping with parameters of type SQLParam

Modifier and Type	Method and Description
void	StringStrategy.setSQLParam(PreparedStatement stmt, int idx, SQLParam parm)
void	NativeTimestampsStrategy.setSQLParam(PreparedStatement stmt, int idx, SQLParam parm)
void	MappingStrategy.setSQLParam(PreparedStatement stmt, int idx, SQLParam parm) Convert database type to connector supported set of attribute types
void	JdbcConvertor.setSQLParam(PreparedStatement stmt, int idx, SQLParam parm)
void	DefaultStrategy.setSQLParam(PreparedStatement stmt, int idx, SQLParam parm)
void	AttributeConvertor.setSQLParam(PreparedStatement stmt, int idx, SQLParam parm)

Uses of SQLParam in org.identityconnectors.dbcommon

Methods in org.identityconnectors.dbcommon that return SQLParam

Modifier and Type	Method and Description
protected abstract SQLParam	DatabaseFilterTranslator.getSQLParam(Attribute attribute, ObjectClass objectClass, OperationOptions options) Get the SQLParam for given attribute.
static SQLParam	SQLUtil.getSQLParam(ResultSet resultSet, int i, String name, int sqlType) Retrieve the SQL value from result set.

Methods in org.identityconnectors.dbcommon that return types with arguments of type SQLParam

Modifier and Type	Method and Description
static Map<String,SQLParam>	SQLUtil.getColumnValues(ResultSet resultSet) Read one row from database result set and convert a columns to attribute set.
List<SQLParam>	UpdateSetBuilder.getParams()
List<SQLParam>	InsertIntoBuilder.getParams()
List<SQLParam>	FilterWhereBuilder.getParams()
List<SQLParam>	DatabaseQueryBuilder.getParams() Values in wrapped object.

Methods in org.identityconnectors.dbcommon with parameters of type SQLParam

Modifier and Type	Method and Description
UpdateSetBuilder	UpdateSetBuilder.addBind(SQLParam param) Add column name and value pair.
InsertIntoBuilder	InsertIntoBuilder.addBind(SQLParam param) Add column name and value pair.
UpdateSetBuilder	UpdateSetBuilder.addBind(SQLParam param, String expression) Add column name and expression value pair.
void	FilterWhereBuilder.addBind(SQLParam param, String operator) Add name value pair bindings with operator, this is lazy bindings resolved at FilterWhereBuilder.getWhereClause().
void	UpdateSetBuilder.addValue(SQLParam param) Add the update value.
static int	SQLUtil.executeUpdateStatement(Connection conn, String sql, SQLParam... params) Executes DML sql statement.
static List<Object[]>	SQLUtil.selectRows(Connection conn, String sql, SQLParam... params) Selects all rows from select.
static Object	SQLUtil.selectSingleValue(Connection conn, String sql, SQLParam... params) Selects single value (first column) from select.
static void	SQLUtil.setSQLParam(PreparedStatement stmt, int idx, SQLParam parm) Set a parameter to statement.

Method parameters in org.identityconnectors.dbcommon with type arguments of type SQLParam

Modifier and Type	Method and Description
static String	SQLUtil.normalizeNullValues(String sql, List<SQLParam> params, List<SQLParam> out) The null param value normalizer.
static String	SQLUtil.normalizeNullValues(String sql, List<SQLParam> params, List<SQLParam> out) The null param value normalizer.
CallableStatement	DatabaseConnection.prepareCall(String sql, List<SQLParam> params) Indirect call of prepareCall statement with mapped callable statement parameters.
PreparedStatement	DatabaseConnection.prepareStatement(String sql, List<SQLParam> params) Indirect call of prepare statement with mapped prepare statement parameters.
static void	SQLUtil.setParams(CallableStatement statement, List<SQLParam> params) This method binds the "?"
static void	SQLUtil.setParams(PreparedStatement statement, List<SQLParam> params) This method binds the "?"