oracle.jbo.server
Class JboSQLListValidator

java.lang.Object
  oracle.jbo.common.NamedObjectImpl
      oracle.jbo.rules.AbstractValidator
          oracle.jbo.rules.JboAbstractValidator
              oracle.jbo.rules.JboListValidator
                  oracle.jbo.server.JboSQLListValidator

All Implemented Interfaces:

DefPersistable, PersistentDefinition, JboValidatorHints, JboValidatorInterface, ValidatorConstants, VariableManagerOwner, VariableManagerOwnerBase

public class JboSQLListValidator
extends JboListValidator

A validator that tests for the presence of a literal value in a list of database values. The list of values is obtained by invoking the validator's SQL query, and then taking the values from the first column of the result.

Since:

Jdeveloper 3.0

Field Summary

protected int

mBindingStyle

Fields inherited from class oracle.jbo.rules.JboListValidator

mSource

Fields inherited from class oracle.jbo.rules.JboAbstractValidator

mValidatingAttr

Fields inherited from class oracle.jbo.rules.AbstractValidator

mbInverse, mDescription, mErrorMessageClass, mMsgExpr, mMsgId, mMsgIds, mResourceBundleId, mTriggeringAttributeNames, mTriggeringAttributes, mValidatingAttrName

Fields inherited from class oracle.jbo.common.NamedObjectImpl

mFullName, mObjName, mParent, mProperties, RES_ID_SUFFIX

Fields inherited from interface oracle.jbo.rules.ValidatorConstants

ATTR, ATTR_STR, BETWEEN, EO, EO_STR, EQUALTO, EXPR, EXPR_STR, GREATERTHAN, GREATERTHANEQUALTO, JBO, JBO_STR, LESSTHAN, LESSTHANEQUALTO, LITERAL, LITERAL_STR, MANDATORY_STR, mCompOperTypeVals, mRhsTypeVals, mSeverityVals, NOTEQUALTO, PNAME_CompareLength, PNAME_CompareType, PNAME_CompareValue, PNAME_DataType, PNAME_Description, PNAME_ErrorMessageExpressions, PNAME_ErrorMessageId, PNAME_ErrorMessageIds, PNAME_Exposed, PNAME_ExprValueSupplier, PNAME_ForPersonalization, PNAME_Inverse, PNAME_Name, PNAME_OnAttribute, PNAME_OnAttributes, PNAME_OnCondition, PNAME_OperandType, PNAME_Severity, PNAME_Subtype, PNAME_TransactionLevel, PNAME_TransientExpression, PNAME_Trigger, PNAME_ValidationBeanClass, PNAME_ValName, PNAME_xmlns, PRECISION_SCALE_STR, SEVERITY_ERROR, SEVERITY_RECOVERABLE_ERROR, SEVERITY_VETOABLE_WARNING, SEVERITY_WARNING, SQL, SQL_STR, VALIDATION_XMLNS, VALIDATOR_MSG_ID_PREFIX, VO, VO_STR, VO_USAGE, VO_USAGE_STR

Fields inherited from interface oracle.jbo.mom.xml.DefPersistable

XML_STATEMENT

Constructor Summary

JboSQLListValidator()
Creates an uninitialized list validator.

Method Summary

int	getBindingStyle()
java.util.Vector	getList(java.lang.Object source) Gets this validator's list of values.
java.lang.String	getSQL() Gets this validator's SQL statement.
void	loadXMLContents(DefElement elem)
void	setBindingStyle(int bindingStyle)
void	setSQL(java.lang.String str) Sets this validator's SQL statement.
java.lang.String	toString() Internal: For debugging purposes only.

Methods inherited from class oracle.jbo.rules.JboListValidator

convertToVector, doValidateValue, getDefXMLElementTag, getList, getValidatorSubType, initialize, initValidatorProperties, setList, validateValue, validateValueWithContext, writeChildren

Methods inherited from class oracle.jbo.rules.JboAbstractValidator

applyValidatorPersonalization, clone, closeObject, getDefXMLNameSpace, getErrorMsgId, getErrorReportAttrDef, getFullName, getImageLoc, getName, getOrigObject, getTriggeringAttributeDefs, getValidatingAttributeName, getValidatorType, getValueToValidate, getXMLElementTag, isForPersonalization, isReadOnly, raiseException, resolve, setForPersonalization, setInitialized, setName, setNewValue, setOrigObject, setValidatingAttribute, setValidatingAttribute, validate, validateMany, writeContents, writeObject

Methods inherited from class oracle.jbo.rules.AbstractValidator

applyValidatorPersonalization, convertToJava, copyErrorMsgInfo, createException, createExprValueSupplier, ensureVariableManager, getDescription, getErrorMessageClass, getErrorMsgExpressions, getErrorMsgIds, getExprValueSupplierType, getInverse, getMessageBundleClass, getOnCondition, getOwner, getResourceBundleDef, getResourceBundleId, getSeverity, getTriggeringAttributeNames, getVariableManager, hasErrorMsg, hasValidationCondition, hasVariables, initErrMsgParms, initTriggeringAttributeDefs, isDirty, isMovedToAttrLevel, isNew, isTransactionLevel, isTransactionLevel, isValidatable, loadVariables, parseSeverityStr, prepareException, raiseException, readStringArrayList, readTransientExpression, readUserObject, readUserObject, readUserObjectTrim, readUserObjectTrim, readUserStringElementsMap, setDefaultDescription, setDescription, setDirty, setErrorMessageClass, setErrorMsgExpressions, setErrorMsgId, setErrorMsgIds, setExprValueSupplierType, setInverse, setNew, setOnCondition, setResourceBundleDef, setResourceBundleId, setSeverity, setTransactionLevel, setTriggeringAttributeNames, setValidatingAttributeName

Methods inherited from class oracle.jbo.common.NamedObjectImpl

allocatePropertyMap, getAllProperties, getParent, getProperties, getPropertiesAsStrings, getPropertiesMap, getProperty, getProperty, getPropertyExpressionsMap, getPropertyMap, getResourcesFromBundle, getStringFromMessageBundle, isPropertyExpression, mergePropertyMap, refreshProperty, removeProperty, removeProperty, requiresNamePrefixedResId, resolveObjectProperty, resolvePropertyRaw, setFullName, setParent, setPropertiesMap, setPropertiesMap2, setProperty, setProperty, setPropertyExpression, setPropertyMap

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.jbo.rules.JboValidatorHints

getTriggeringAttributeNames, isTransactionLevel

Methods inherited from interface oracle.jbo.rules.JboValidatorInterface

getDescription, setDescription

Methods inherited from interface oracle.jbo.mom.xml.DefPersistable

isDirty, isNew, setDirty, setNew

Field Detail

mBindingStyle

protected int mBindingStyle

Constructor Detail

JboSQLListValidator

public JboSQLListValidator()

Creates an uninitialized list validator.

Invoke setSQL() to provide a list of comparison values.

Method Detail

getBindingStyle

public int getBindingStyle()

setBindingStyle

public void setBindingStyle(int bindingStyle)

setSQL

public void setSQL(java.lang.String str)

Sets this validator's SQL statement.

Parameters:

str - an SQL statement.

getSQL

public java.lang.String getSQL()

Gets this validator's SQL statement.

Returns:

an SQL statement.

getList

public java.util.Vector getList(java.lang.Object source)

Gets this validator's list of values.

This method executes the validator's SQL statement and extracts and the first column of the result.

Overrides:

getList in class JboListValidator

Parameters:

source - the source row.

Returns:

a vector containing the values from the first column of the result.

toString

public java.lang.String toString()

Internal: For debugging purposes only.

Overrides:

toString in class JboListValidator

loadXMLContents

public void loadXMLContents(DefElement elem)

Overrides:

loadXMLContents in class JboListValidator