Chapter 1 Understanding AI for Stored Procedures

What Is AI for stored procedures?

AI for stored procedures is an EAServer component development and deployment tool that allows application developers to quickly integrate database stored procedures with EAServer.

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™, a transaction server, AI for CICS, AI for stored procedures, and Adaptive Server® Anywhere (ASA).

A Description of AI for stored procedures

AI for Stored Procedures allows you to create EAServer 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 EAServer, where they can be used by EAServer client applications or by other EAServer 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™ for 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 EAServer components that invoke stored procedures
A library of Java classes that AI for stored procedures components use to invoke the target stored procedures from EAServer

Figure 1-1 shows the design architecture of AI for stored procedures.

Figure 1-1: AI for stored procedures design architecture

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

Figure 1-2 shows the runtime architecture of AI for stored procedures.

Figure 1-2: AI for stored procedures runtime architecture

During runtime, a client application attempts to invoke a component in EAServer, 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."