 | Level: Intermediate Daniel Wintschel (daniel@humandoing.net), Author and developer
25 Oct 2005 This two-part tutorial series demonstrates how to create a simple wiki system by embedding Apache Derby in a Web application server. Part 1 gave you an overview of the basic system and regular expressions. This tutorial shows you how to use Java™ functions, stored procedures, and triggers within the Derby database and outlines the advantages of using these features, including reducing the coupling between database and middle-tier code, minimizing the number of transactions opened, and increasing performance by reducing network traffic.
In this tutorial
- Java functions
- Java procedures
- Database triggers
Prerequisites
This tutorial assumes you have a basic knowledge of the Java Database Connectivity (JDBC) API. It's also beneficial to have some familiarity with the concepts of database triggers, functions, and procedures. But if you don't, this tutorial defines and describes each of these in enough detail to ensure that you feel comfortable with these topics. To run the example code in this tutorial, you must perform the following steps (detailed further in the tutorial):
- Download and install Tomcat 5.0.28, Derby 10.1.1.0, Apache Ant 1.6.5, and J2SE 1.4.2_09.
- Define some environmental variables in your shell.
- Extract the supplied .zip file.
- Modify the /web/WEB-INF/web.xml file.
System requirements
Duration
Under two hours
Formats html, pdf
| | | |
