C-LANG Statements › FINDERPARAMETER Statement—Specify Finder Parameters

FINDERPARAMETER Statement—Specify Finder Parameters

The FINDERPARAMETER statement specifies the finder parameters in an Entity Bean job. You specify finder parameters to update the property values of an existing entity bean or to remove an entity bean from the database.

Supported Job Type

When the operation type is UPDATE or REMOVE, this statement is required for the Entity Bean job type.

Syntax

This statement has the following format:

FINDERPARAMETER {TYPE(type) VALUE(value)}
                {TYPE(type) ARRAY(value,value,...)}
                {URI(uri)}

TYPE(type)

Specifies the Java class of the parameter.

Limits: Up to 1024 characters; case-sensitive

Examples: String, java.lang.String, Integer

Note: If the package is not specified, java.lang is assumed.

VALUE(value)

Specifies the String value for the method parameter.

Limits: Up to 1024 characters; case-sensitive

ARRAY(value,value,...)

Specifies a set of string values for the method parameter.

Limits: Up to 1024 characters per array value; case-sensitive

Note: If you specify the ARRAY operand, the statement value cannot exceed 3588 characters.

URI(uri)

Specifies the location (URI) of the binary output produced by a payload producing job. A payload producing job is a job that produces binary output that is persisted as a serialized Java object. The serialized Java object is stored as a file on the agent computer. The URI can be passed as input to a payload consuming job.

Limits: Up to 255 characters; case-sensitive

Example: 'FS:c:\Program Files\Common Files\System\ADO\input.txt'

Note: For more information about retrieving the URI of a payload producing job, see the documentation for your scheduling manager.

Notes:

• Enclose values that contain delimiters (such as spaces) in double quotation marks.
• To specify multiple parameters, use multiple FINDERPARAMETER statements. Order is important. If the method contains three parameters, specify the first parameter in the first statement, the second parameter in the second statement, and the third parameter in the third statement. The job fails if the parameters are listed in the wrong order.

Example: Update the Phone Number for the Acme Company in a Database

Suppose that you want to update the phone number for the Acme company to 800-555-0199. The customer entity bean stores the customer ID and phone number. The primary key for the customer is the customer ID. To find the entity bean, the job uses the Acme's customer ID. When the job runs, the Acme company's phone number is changed.

AGENT APPAGENT
INITIAL_CONTEXT weblogic.jndi.WLInitialContextFactory
LOCATION t3://localhost:7001
BEAN customer
OPERATIONTYPE UPDATE
METHOD changephone
FINDERMETHOD acme
FINDERPARAMETER TYPE(String) VALUE(customerid)
MODIFYPARAMETER TYPE(String) VALUE(800-555-0199)