From basic to advanced, these technical articles give you the information you need to use Java DB successfully and efficiently.
This document demonstrates how to quickly set up a connection to Sun's Java DB (which is based on the Apache Derby database) in NetBeans. Once a connection is made, you can easily begin working with the database in the NetBeans IDE, allowing you to create tables, populate them with data, run SQL queries, and more.
"There is a big difference in the behavior of a database when it is populated with a small amount of test inputs and when it holds a large amount of data... [and] you should take some action to ensure that the application is working correctly with large amounts of data... First of all, there are various tips on how you should tune Derby properties such as page size and the size of the cache... but usually the bigger problem lies in your application and database design, so you should focus on these issues first and leave Derby properties for the end. In the following sections, I will cover some techniques that can help you optimize problematic parts of your application."
"Rich Internet Applications (RIAs) are becoming more and more popular as the capabilities available to Internet clients increase. There is a growing demand for RIAs to be able to store rich, structured, searchable data on the same machine as the web browser, and to be able to synchronize this data with a centralized data store running behind the web server." This article explains how to do this.
"This tutorial will concentrate mainly on using Derby as an embedded database for a Java application. In other words Derby will be used as a persistent data store, and it is the application which will manage the database. This is in contrast to client/server mode, where the database is loaded onto a server and waits for client applications to connect to it. If you add to its simplicity of setup, ease of use, and small footprint, the fact that Derby supports referential integrity and ACID-compliant transactions, you have a pretty powerful database tool for your Java applications."
This article describes how Java DB can be used as an embedded database to act as a cache for services deployed in the Sun Java System Application Server. This is particularly useful if:
Using Java DB as a cache for the results of the Service calls in the Service itself to limit the amount of communication with the legacy systems, eliminating costs associated with communicating with a legacy system.