Chapter 1 Understanding AI for Stored Procedures

Basic Steps for building a component

There are four basic steps in the AI for stored procedures development process:

The following sections describe each step.

Research the target stored procedure

You must research the stored procedure you plan to use to become familiar with how it is defined and how it works.

Create the component

Use the Component Builder to create a connection and a component. The connection provides access to a database that contains stored procedures. The component contains a collection of methods, and each method invokes a single stored procedure.

When you use the Component Builder to create a component, you can create component methods automatically by connecting to the target database and selecting a target stored procedure.

If the JDBC driver cannot access the stored procedure metadata on the database, you must create component methods manually by entering detailed information about the stored procedure properties.

For more information about creating components automatically or manually, see Chapter 2, "Working with the Component Builder"

Deploy the component

When you deploy the component, the Component Builder defines it in EAServer, and creates Java classes that implement the component. After the component is deployed, it is ready to run.

Use the component

Once a component is deployed, you can use it in applications. AI for Stored Procedures components can be used to build EAServer client applications or to build other EAServer components.

For information on how to build your client application, see the EAServer documentation.