 | Level: Intermediate Dave Warner (david.warner@ngc.com), Senior Database Administrator, Northrop Grumman IT Solutions
20 Feb 2007 So far, this series has covered the basics of storing and retrieving data in Apache Derby using SQL. This tutorial shows you how to use this knowledge in a straightforward way. In the previous tutorial, you developed a framework that allows you to store and manage Sarbanes-Oxley Act (SOX) compliance documents. Now you'll learn how to enter and report the information.
Objectives - Learn the basics of OpenOffice.org Forms and Reports, part of OpenOffice.org Base.
- Get familiar with best practices surrounding data entry, transaction management, and auditing while you walk through the process of building a portion of a SOX tracking application.
Prerequisites
You should be reasonably comfortable with standard Java tools, have a smattering of SQL experience, and know the basics of XML. The ability to install and configure a Java Virtual Machine (JVM), Apache Ant or Eclipse, and Derby is required.
System requirements
To run the examples in this tutorial, you need the following:
- JVM 1.5 or later
- Approximately 100-200MB of free space, depending on your choice of tool set
- At least 64MB of RAM for your virtual machine (VM)
- Eclipse 3.2.1
- Derby plug-ins for Eclipse
- OpenOffice.org 2.0
Duration
Under 2 hours
Formats html, pdf
| | | |
