Chapter 1 Understanding AI for Stored Procedures

What Is AI for Stored Procedures?

AI for Stored Procedures is a Jaguar component development and deployment tool that allows application developers to quickly integrate database stored procedures with Jaguar.

AI for Stored Procedures is included in Sybase EAServer. EAServer is an integrated set of application servers that you use to deploy Web applications that support high-volume traffic, dynamic content, and intensive online transaction processing. EAServer consists of PowerDynamo, Jaguar, AI for CICS, AI for Stored Procedures, and Adaptive Server Anywhere (ASA).

This section covers the following topics:

A Description of AI for Stored Procedures

AI for Stored Procedures allows you to create Jaguar components that provide access to existing stored procedures, making the stored procedures accessible to Web-based client applications.

The AI for Stored Procedures Component Builder is a design tool that you use to create these components. The Component Builder makes it easy to create components by simply browsing a database and selecting a collection of stored procedures. No manual coding is required.

After you create the components, you can use the Component Builder to deploy them to Jaguar, where they can be used by Jaguar client applications or by other Jaguar components.

AI for Stored Procedures components use Java Database Connectivity (JDBC) to access stored procedures. Using the Component Builder, you can create components that invoke stored procedures in any database that is accessible through a JDBC driver. AI for Stored Procedures includes the Sybase jConnect JDBC driver for access to Sybase databases such as Adaptive Server Anywhere (ASA) and Adaptive Server Enterprise (ASE). For non-Sybase databases, such as Oracle, you must provide additional JDBC drivers.

AI for Stored Procedures Architecture

AI for Stored Procedures consists of the following:

A design tool called the Component Builder that allows you to create Jaguar components that invoke stored procedures
A library of Java classes that AI for Stored Procedures components use to invoke the target stored procedures from Jaguar

Figure 1-1 shows the design-time architecture of AI for Stored Procedures.

Figure 1-1: AI for Stored Procedures design-time architecture

During design time, the Component Builder imports the stored procedure metadata, then creates and deploys the component into Jaguar.

Figure 1-2 shows the run-time architecture of AI for Stored Procedures.

Figure 1-2: AI for Stored Procedures run-time architecture

During run time, a client application attempts to invoke a component in Jaguar, which in turn accesses the target stored procedure.

Supported Procedures

AI for Stored Procedures supports the following stored procedures and queries:

Database stored procedures (for any database that is accessible through JDBC)
Database SQL commands (for example, select, insert, execute, update, delete)
DirectConnect Remote Stored Procedures (RSPs)
Open ServerConnect language events and Remote Procedure Calls (RPCs)

This documentation refers to all supported procedures as "target stored procedures."