| <!-- |
| Licensed to the Apache Software Foundation (ASF) under one or more |
| contributor license agreements. See the NOTICE file distributed with |
| this work for additional information regarding copyright ownership. |
| The ASF licenses this file to You under the Apache License, Version 2.0 |
| (the "License"); you may not use this file except in compliance with |
| the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| --> |
| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> |
| <HTML lang="en"> |
| <HEAD><META http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> |
| <TITLE>Example Programs</TITLE> |
| <link rel="stylesheet" type="text/css" href="csfull.css" title="sample"> |
| </HEAD> |
| <BODY> |
| |
| <H1>Example Apache Derby Programs</H1> |
| <p>In this distribution of Apache Derby, the directory |
| <em class="fileName">demo/programs/</em> contains example databases and programs |
| written in Java. Some of the sample programs are used as references in some of |
| the Derby user manuals, |
| see <A href="../../docs/html/getstart/index.html"><i>Getting Started with Derby</i></A> and |
| the <A href="../../docs/html/adminguide/index.html"><i>Derby Server and Administration Guide</i></A>. |
| Other programs are simply demonstrations of how to get started using Derby, |
| or how to utilize certain features.</p> |
| <UL> |
| <LI><A href="simple/example.html">Simple</A> |
| <p class="BodyRelative">A very simple JDBC application that boots the driver, |
| creates a database, and loads some data. This application can run in both |
| embedded and client/server settings.</p> |
| </LI> |
| <LI><A href="nserverdemo/readme.html">Network Server Sample Programs</A> |
| <p class="BodyRelative">Two examples are provided to demonstrate how to obtain an <em class="Emphasis">embedded connection</em> |
| and <em class="Emphasis">client connections</em> using the Network Server to connect to the same database. |
| An embedded connection is a connection to a database that is booted in the same JVM as the application. |
| Client applications that require a database connection across the network use the network server protocol (DRDA) |
| to connect to the Network Server. This type of connection is referred to as a client connection.</p></LI> |
| <LI><A href="toursdb/toursdb_readme.html">ToursDB sample database schema</a> |
| <p class="BodyRelative">The <code>toursdb</code> database is provided as an example and demo database to illustrate some |
| functionality of the Derby RDBMS. Many of the examples in the Derby |
| documentation use tables that exist in the <code>toursdb</code> database. |
| The document describes the tables, the names and types of columns in those tables, and the constraints, indexes, and triggers in the database. |
| </p> |
| </li> |
| <LI><A href="workingwithderby/readme.html">Getting Started With Derby</A> |
| <p class="BodyRelative">Programs described and modified as part of the activities documented in |
| the <A href="../../docs/html/getstart/index.html"><i>Getting Started With Derby</i></A> manual.</p> |
| </LI> |
| <LI><A href="scores/README" type="text/plain">Scores</A> |
| <p class="BodyRelative"> |
| This demo shows how to use user-coded Java |
| functions and procedures inside the Derby engine. |
| </p> |
| </LI> |
| <LI><A href="vtis/README.html">VTIs</A> |
| <p class="BodyRelative">This set of demos contains sample table functions for |
| <ul> |
| <li>Making a table out of a property file</li> |
| <li>Making tables out of Subversion logs, Apache web server logs, and |
| JIRA reports</li> |
| </ul> |
| </p> |
| </LI> |
| </UL> |
| |
| </BODY> |
| </HTML> |