| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
ASA User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Part 3 Adding Logic to the Database |
This part describes how to build logic into your database using SQL stored procedures, triggers, and Java.
Storing logic in the database makes it available automatically to all applications, providing consistency, performance, and security benefits.
The combined Java/Stored Procedure debugger is a powerful tool for debugging all kinds of logic.
|
| Chapter 15: Using Procedures, Triggers, and Batches |
| Procedure and trigger overview |
| Benefits of procedures and triggers |
![[+]](/dwicons/i_expand.gif)
| Introduction to procedures |
|
| Introduction to user-defined functions |
|
| Introduction to triggers |
| Introduction to batches |
|
| Control statements |
|
| The structure of procedures and triggers |
|
| Returning results from procedures |
|
| Using cursors in procedures and triggers |
|
| Errors and warnings in procedures and triggers |
| Using the EXECUTE IMMEDIATE statement in procedures |
| Transactions and savepoints in procedures and triggers |
|
| Some tips for writing procedures |
|
| Statements allowed in batches |
|
| Calling external libraries from procedures |
|
| Chapter 16: Welcome to Java in the Database |
|
| Introduction to Java in the database |
|
| Java in the database Q & A |
|
| A Java seminar |
|
| The runtime environment for Java in the database |
|
| A Java in the database exercise |
|
| Chapter 17: Using Java in the Database |
|
| Overview of using Java |
|
| Java-enabling a database |
|
| Installing Java classes into a database |
|
| Creating columns to hold Java objects |
|
| Inserting, updating, and deleting Java objects |
| Querying Java objects |
|
| Comparing Java fields and objects |
|
| Special features of Java classes in the database |
|
| How Java objects are stored |
|
| Java database design |
|
| Using computed columns with Java classes |
|
| Configuring memory for Java |
|
| Chapter 18: Data Access Using JDBC |
|
| JDBC overview |
|
| Establishing JDBC connections |
|
| Using JDBC to access data |
|
| Using the Sybase jConnect JDBC driver |
|
| Creating distributed applications |
|
| Chapter 19: Debugging Logic in the Database |
|
| Introduction to debugging in the database |
|
| Tutorial 1: Connecting to a database |
|
| Tutorial 2: Debugging a stored procedure |
|
| Tutorial 3: Debugging a Java class |
|
|