db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j..@apache.org
Subject svn commit: r355248 [1/3] - in /db/derby/site/trunk: build/site/ build/site/papers/ build/site/papers/DerbyTut/ build/site/skin/ src/documentation/ src/documentation/content/xdocs/ src/documentation/content/xdocs/papers/ src/documentation/content/xdocs...
Date Thu, 08 Dec 2005 22:30:16 GMT
Author: jta
Date: Thu Dec  8 14:30:05 2005
New Revision: 355248

URL: http://svn.apache.org/viewcvs?rev=355248&view=rev
Log:
Added a new Derby Tutorial to the Papers section. Also added it to the
Papers site navigation, resulting in changes to all papers on that tab.
Added a p.code-block style to src/documentation/skinconf.xml for more
visible code block formatting.

Added:
    db/derby/site/trunk/build/site/papers/DerbyTut/
    db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png   (with props)
    db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html   (with props)
    db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png   (with props)
    db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html   (with props)
    db/derby/site/trunk/build/site/papers/DerbyTut/index.html   (with props)
    db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html   (with props)
    db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png   (with props)
    db/derby/site/trunk/build/site/papers/DerbyTut/ns_intro.html   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/embedded.aart   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/embedded_intro.xml   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/embedded_server.aart   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/ij_intro.xml   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/index.xml   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/install_software.xml   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/network_server.aart   (with props)
    db/derby/site/trunk/src/documentation/content/xdocs/papers/DerbyTut/ns_intro.xml   (with props)
Modified:
    db/derby/site/trunk/build/site/linkmap.html
    db/derby/site/trunk/build/site/papers/ApacheConUs04.html
    db/derby/site/trunk/build/site/papers/DerbyClientSpec.html
    db/derby/site/trunk/build/site/papers/Intersect-design.html
    db/derby/site/trunk/build/site/papers/JDBCImplementation.html
    db/derby/site/trunk/build/site/papers/MiscPresentations.html
    db/derby/site/trunk/build/site/papers/btree_package.html
    db/derby/site/trunk/build/site/papers/derby_arch.html
    db/derby/site/trunk/build/site/papers/derby_htw.html
    db/derby/site/trunk/build/site/papers/derby_web.html
    db/derby/site/trunk/build/site/papers/fortune_tut.html
    db/derby/site/trunk/build/site/papers/index.html
    db/derby/site/trunk/build/site/papers/logformats.html
    db/derby/site/trunk/build/site/papers/optimizer.html
    db/derby/site/trunk/build/site/papers/pageformats.html
    db/derby/site/trunk/build/site/papers/recovery.html
    db/derby/site/trunk/build/site/papers/versionupgrade.html
    db/derby/site/trunk/build/site/skin/profile.css
    db/derby/site/trunk/src/documentation/content/xdocs/papers/index.xml
    db/derby/site/trunk/src/documentation/content/xdocs/site.xml
    db/derby/site/trunk/src/documentation/skinconf.xml

Modified: db/derby/site/trunk/build/site/linkmap.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/linkmap.html?rev=355248&r1=355247&r2=355248&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/linkmap.html (original)
+++ db/derby/site/trunk/build/site/linkmap.html Thu Dec  8 14:30:05 2005
@@ -119,6 +119,24 @@
 <div class="menuitem">
 <a href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>
 </div>
+<div onclick="SwitchMenu('menu_1.3.5', 'skin/')" id="menu_1.3.5Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.3.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="papers/DerbyTut/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="papers/DerbyTut/install_software.html">Step 1: Install Software</a>
+</div>
+<div class="menuitem">
+<a href="papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>
+</div>
+<div class="menuitem">
+<a href="papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>
+</div>
+<div class="menuitem">
+<a href="papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
 </div>
 <div onclick="SwitchMenu('menu_1.4', 'skin/')" id="menu_1.4Title" class="menutitle">Derby Engine</div>
 <div id="menu_1.4" class="menuitemgroup">
@@ -651,6 +669,45 @@
 <li>
 <a class="external" href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>&nbsp;&nbsp;&nbsp;_________________________&nbsp;&nbsp;<em>articles</em>
 </li>
+</ul>
+       
+<ul>
+<li>
+<a href="papers/DerbyTut/">Derby Tutorial</a>&nbsp;&nbsp;&nbsp;_________________________&nbsp;&nbsp;<em>derbyTut</em>
+</li>
+<ul>
+           
+<ul>
+<li>
+<a href="papers/DerbyTut/index.html">Overview</a>&nbsp;&nbsp;&nbsp;_________________________&nbsp;&nbsp;<em>index</em>
+</li>
+</ul>
+           
+<ul>
+<li>
+<a href="papers/DerbyTut/install_software.html">Step 1: Install Software</a>&nbsp;&nbsp;&nbsp;_________________________&nbsp;&nbsp;<em>install</em>
+</li>
+</ul>
+           
+<ul>
+<li>
+<a href="papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>&nbsp;&nbsp;&nbsp;_________________________&nbsp;&nbsp;<em>ij_intro</em>
+</li>
+</ul>
+           
+<ul>
+<li>
+<a href="papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>&nbsp;&nbsp;&nbsp;_________________________&nbsp;&nbsp;<em>embed</em>
+</li>
+</ul>
+           
+<ul>
+<li>
+<a href="papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>&nbsp;&nbsp;&nbsp;_________________________&nbsp;&nbsp;<em>ns</em>
+</li>
+</ul>
+       
+</ul>
 </ul>
   
 </ul>

Modified: db/derby/site/trunk/build/site/papers/ApacheConUs04.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/ApacheConUs04.html?rev=355248&r1=355247&r2=355248&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/papers/ApacheConUs04.html (original)
+++ db/derby/site/trunk/build/site/papers/ApacheConUs04.html Thu Dec  8 14:30:05 2005
@@ -77,6 +77,24 @@
 <div class="menuitem">
 <a href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>
 </div>
+<div onclick="SwitchMenu('menu_1.1.5', '../skin/')" id="menu_1.1.5Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.1.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyTut/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/install_software.html">Step 1: Install Software</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
 </div>
 <div onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Derby Engine</div>
 <div id="menu_1.2" class="menuitemgroup">

Modified: db/derby/site/trunk/build/site/papers/DerbyClientSpec.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyClientSpec.html?rev=355248&r1=355247&r2=355248&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/papers/DerbyClientSpec.html (original)
+++ db/derby/site/trunk/build/site/papers/DerbyClientSpec.html Thu Dec  8 14:30:05 2005
@@ -80,6 +80,24 @@
 <div class="menuitem">
 <a href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>
 </div>
+<div onclick="SwitchMenu('menu_1.1.5', '../skin/')" id="menu_1.1.5Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.1.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyTut/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/install_software.html">Step 1: Install Software</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
 </div>
 <div onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Derby Engine</div>
 <div id="menu_1.2" class="menuitemgroup">

Added: db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png?rev=355248&view=auto
==============================================================================
Binary file - no diff available.

Propchange: db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png
------------------------------------------------------------------------------
    svn:mime-type = image/png

Added: db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html?rev=355248&view=auto
==============================================================================
--- db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html (added)
+++ db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html Thu Dec  8 14:30:05 2005
@@ -0,0 +1,508 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.7">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Step 3: Embedded Derby</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<div class="header">
+<div class="grouplogo">
+<a href="http://db.apache.org"><img class="logoImage" alt="" src="../../images/db-logo-white.png" title=""></a>
+</div>
+<div class="projectlogo">
+<a href="http://db.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin Java RDBMS."></a>
+</div>
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                    <input attr="value" name="Search" value="Search" type="submit">
+</form>
+</div>
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<div id="level2tabs"></div>
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Papers</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../../papers/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_web.html">Derby Web Site</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyInstruction">Instruction</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.1.5', '../../skin/')" id="menu_selected_1.1.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Derby Tutorial</div>
+<div id="menu_selected_1.1.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../../papers/DerbyTut/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/install_software.html">Step 1: Install Software</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Step 3: Embedded Derby</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../../skin/')" id="menu_1.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.2.1', '../../skin/')" id="menu_1.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.2.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/engine">Engine</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/language">Language</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/publishedapi">API</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_arch.html">Architecture</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/btree_package.html">BTree</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/pageformats.html">Disk Page Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_htw.html">How Things Work</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/Intersect-design.html">Intersect &amp; Except</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/JDBCImplementation.html">JDBC</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/logformats.html">Log Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/recovery.html">Logging &amp; Recovery</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/optimizer.html">Optimizer</a>
+</div>
+<div class="menuitem">
+<a href="http://svn.apache.org/repos/asf/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/package.html">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3', '../../skin/')" id="menu_1.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../../skin/')" id="menu_1.4Title" class="menutitle">Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/ApacheConUs04.html">ApacheCon US '04</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<div id="credit2"></div>
+</div>
+<div id="content">
+<div class="trail">
+<text>Font size:</text> 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Step 3: Embedded Derby</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#ij_intro">Introduction</a>
+</li>
+<li>
+<a href="#embedded_setup">Set the environment</a>
+</li>
+<li>
+<a href="#sample_app">Sample Application</a>
+<ul class="minitoc">
+<li>
+<a href="#copy_sample_app">Copy sample application</a>
+</li>
+<li>
+<a href="#em_lookat_code">A quick look at the code</a>
+<ul class="minitoc">
+<li>
+<a href="#embedded_driver">Load the Embedded JDBC Driver</a>
+</li>
+<li>
+<a href="#embedded_url">Get an Embedded Connection</a>
+</li>
+<li>
+<a href="#shutdown">Shut Derby down</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#compile_sample_app">Compile sample application</a>
+</li>
+<li>
+<a href="#run_sample_app">Run sample application</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#just_one_app">Embedded Derby supports multiple users in one JVM</a>
+</li>
+</ul>
+</div> 
+
+
+<a name="N1000C"></a><a name="ij_intro"></a>
+<h2 class="boxed">Introduction</h2>
+<div class="section">
+<p>
+When an application accesses a Derby database using the Embedded Derby JDBC
+driver,
+the Derby engine does not run in a separate process, and there are no
+separate database processes to start up and shut down.
+Instead, the Derby database engine runs inside the same
+Java Virtual Machine (JVM) as the application.
+So, Derby becomes part of the application 
+just like any other jar file that the application uses.
+Figure 1 depicts this embedded architecture.
+</p>
+<p>
+
+<strong>Figure 1: Derby Embedded Architecture</strong>
+
+</p>
+<p>
+
+<img alt="Figure 1: Embedded Architecture" src="embedded.png">
+</p>
+<p>
+This section shows how to compile and run a simple Java application using
+the Derby Embedded JDBC driver.
+The information presented is deliberately simple.
+For complete information, see the
+<a href="http://db.apache.org/derby/manuals/">Derby Developer's Guide</a>.
+</p>
+</div>
+
+
+<a name="N1002A"></a><a name="embedded_setup"></a>
+<h2 class="boxed">Set the environment</h2>
+<div class="section">
+<p>
+To set up the environment,
+follow the 
+"<a href="install_software.html#derby_configure">Configure Embedded Derby</a>"
+instructions.
+</p>
+</div>
+
+
+<a name="N10038"></a><a name="sample_app"></a>
+<h2 class="boxed">Sample Application</h2>
+<div class="section">
+<a name="N1003E"></a><a name="copy_sample_app"></a>
+<h3 class="boxed">Copy sample application</h3>
+<p>
+   The Derby software includes a sample application. Copy that application
+   into your current directory as shown below:
+   </p>
+<p class="code-block">Windows:
+c:\&gt; copy %DERBY_INSTALL%\demo\simple\SimpleApp.java .
+</p>
+<p class="code-block">UNIX:
+cp $DERBY_INSTALL/demo/simple/SimpleApp.java .
+</p>
+<p>
+   By default this application runs in embedded mode and does the following:
+   </p>
+<ul>
+       
+<li> Starts up the Derby engine</li>
+       
+<li> Creates and connects to a database</li>
+       
+<li> Creates a table</li>
+       
+<li> Inserts data</li>
+       
+<li> Updates data</li>
+       
+<li> Selects data</li>
+       
+<li> Drops a table</li>
+       
+<li> Disconnects</li>
+       
+<li> Shuts down Derby</li>
+   
+</ul>
+<a name="N10071"></a><a name="em_lookat_code"></a>
+<h3 class="boxed">A quick look at the code</h3>
+<p>
+   The <span class="codefrag">SimpleApp.java</span> application spends most of its time
+   creating a table, inserting data into that table, and selecting the
+   data back, demonstrating many JDBC calls as it does so.
+   This section highlights the JDBC calls that make this specifically an
+   embedded Derby application.
+   The "<a href="ns_intro.html#ns_lookat_code">Derby Network Server</a>"
+   section shows how the same JDBC calls turn the same code into a 
+   client/server application.
+   </p>
+<a name="N10081"></a><a name="embedded_driver"></a>
+<h4>Load the Embedded JDBC Driver</h4>
+<p>
+   The <span class="codefrag">SimpleApp</span> application
+   loads the Derby Embedded JDBC driver and starts Derby up with this code:
+   </p>
+<p class="code-block">public String driver = "org.apache.derby.jdbc.EmbeddedDriver";
+...
+Class.forName(driver).newInstance();
+</p>
+<a name="N10092"></a><a name="embedded_url"></a>
+<h4>Get an Embedded Connection</h4>
+<p>
+   The <span class="codefrag">SimpleApp</span> application
+   creates and connects to the <span class="codefrag">derbyDB</span> database with this code:
+   </p>
+<p class="code-block">public String protocol = "jdbc:derby:";
+...
+conn = DriverManager.getConnection(protocol + "derbyDB;create=true", props);
+</p>
+<p>
+   That embedded connection URL, fully constructed, looks like this:
+   </p>
+<p class="code-block">jdbc:derby:derbyDB;create=true</p>
+<a name="N100AD"></a><a name="shutdown"></a>
+<h4>Shut Derby down</h4>
+<p>A clean shutdown performs a checkpoint and releases resources. 
+      If an embedded application doesn't shut down Derby, 
+      a checkpoint won't be performed.
+      Nothing bad will happen; it just means that the next connection 
+       will be slower because Derby will run its recovery code.
+   </p>
+<p>Code to shut down a specific database looks like this: </p>
+<p class="code-block">DriverManager.getConnection("jdbc:derby:MyDbTest;shutdown=true");</p>
+<p>Code to shut down all databases and the Derby engine looks like this: </p>
+<p class="code-block">DriverManager.getConnection("jdbc:derby:;shutdown=true");</p>
+<p>The <span class="codefrag">SimpleApp.java</span> code uses the second call to shut down
+    all databases and the engine.
+    You might also notice that it tests for a SQL exception.
+    A clean shutdown always throws SQL exception <span class="codefrag">XJ015</span>, 
+    which can be ignored.
+   </p>
+<a name="N100CF"></a><a name="compile_sample_app"></a>
+<h3 class="boxed">Compile sample application</h3>
+<p>
+   Compile the sample application as shown below:
+   </p>
+<p class="code-block">javac SimpleApp.java</p>
+<a name="N100DD"></a><a name="run_sample_app"></a>
+<h3 class="boxed">Run sample application</h3>
+<p>
+   Run the sample application like this:
+   </p>
+<p class="code-block">java SimpleApp</p>
+<p>You should see the output shown below:</p>
+<p class="code-block">SimpleApp starting in embedded mode.
+Loaded the appropriate driver.
+Connected to and created database derbyDB
+Created table derbyDB
+Inserted 1956 Webster
+Inserted 1910 Union
+Updated 1956 Webster to 180 Grand
+Updated 180 Grand to 300 Lakeshore
+Verified the rows
+Dropped table derbyDB
+Closed result set and statement
+Committed transaction and closed connection
+Database shut down normally
+SimpleApp finished
+</p>
+<p>If instead you see an error like the one below, it means the class path
+   is not correctly set:
+   </p>
+<p class="code-block">java SimpleApp
+SimpleApp starting in embedded mode.
+exception thrown:
+java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
+        at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
+        at java.security.AccessController.doPrivileged(Native Method)
+        at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
+        at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
+        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
+        at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
+        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
+        at java.lang.Class.forName0(Native Method)
+        at java.lang.Class.forName(Class.java:141)
+        at SimpleApp.go(SimpleApp.java:77)
+        at SimpleApp.main(SimpleApp.java:61)
+SimpleApp finished
+</p>
+<p>
+   For help resolving class path problems, see the 
+   "<a href="install_software.html#derby_configure">Configure Embedded Derby</a>"
+   and
+   "<a href="install_software.html#derby_verify">Verify Derby</a>"
+   instructions.
+   </p>
+</div>
+
+
+<a name="N10105"></a><a name="just_one_app"></a>
+<h2 class="boxed">Embedded Derby supports multiple users in one JVM</h2>
+<div class="section">
+<p>
+Derby supports multiple connections to a given database.
+An example of an embedded application that manages concurrent users 
+is a Tomcat or Geronimo application server that embeds Derby.
+Any number of users can execute Web applications that access a database
+through that Web server.
+</p>
+<p>
+However, only one JVM may boot ("open") that database, so
+multiple applications running in <em>different</em> JVMs
+cannot access the same database.
+To understand this better, do the following.
+</p>
+<p>
+The <span class="codefrag">SimpleApp</span> application created a database called
+<span class="codefrag">derbyDB</span>. 
+In one window connect to this database with
+<span class="codefrag">ij</span> as shown below:
+</p>
+<p class="code-block">java org.apache.derby.tools.ij
+ij version 10.1
+ij&gt; connect 'jdbc:derby:derbyDB';
+ij&gt;
+</p>
+</div>
+
+
+<p>
+Now, in another window try to run your <span class="codefrag">SimpleApp</span>
+application:
+</p>
+
+
+<p class="code-block">java SimpleApp
+SimpleApp starting in embedded mode.
+Loaded the appropriate driver.
+exception thrown:
+SQL Exception: Failed to start database 'derbyDB', see the next exception for details.
+SQL Exception: Another instance of Derby may have already booted the database /home/jta/databases/sample_app/derbyDB.
+SimpleApp finished
+</p>
+
+
+<p>
+The connection that <span class="codefrag">SimpleApp</span> tries to establish fails because
+another application,
+<span class="codefrag">ij</span>,
+is already connected to the <span class="codefrag">derbyDB</span> database.
+</p>
+
+
+<p>
+The problem is <span class="codefrag">ij</span> and <span class="codefrag">SimpleApp</span> are running in
+different JVMs
+and a given database can only be accessed from one JVM. 
+The first application to connect "wins", in this case <span class="codefrag">ij</span>, and
+prevents other applications from connecting.
+</p>
+
+<p>
+In fact, you <em>can</em> establish multiple connections to a given database from
+different JVMs.
+That's the topic of the next section, 
+"<a href="ns_intro.html">Step 4: Derby Network Server</a>".
+</p>
+
+
+</div>
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0papers/DerbyTut/embedded_intro.html">derby-dev@db.apache.org</a>
+</div>
+</div>
+</body>
+</html>

Propchange: db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png?rev=355248&view=auto
==============================================================================
Binary file - no diff available.

Propchange: db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png
------------------------------------------------------------------------------
    svn:mime-type = image/png

Added: db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html?rev=355248&view=auto
==============================================================================
--- db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html (added)
+++ db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html Thu Dec  8 14:30:05 2005
@@ -0,0 +1,472 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.7">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Step 2: ij Basics</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<div class="header">
+<div class="grouplogo">
+<a href="http://db.apache.org"><img class="logoImage" alt="" src="../../images/db-logo-white.png" title=""></a>
+</div>
+<div class="projectlogo">
+<a href="http://db.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin Java RDBMS."></a>
+</div>
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                    <input attr="value" name="Search" value="Search" type="submit">
+</form>
+</div>
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<div id="level2tabs"></div>
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Papers</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../../papers/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_web.html">Derby Web Site</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyInstruction">Instruction</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.1.5', '../../skin/')" id="menu_selected_1.1.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Derby Tutorial</div>
+<div id="menu_selected_1.1.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../../papers/DerbyTut/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/install_software.html">Step 1: Install Software</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Step 2: ij Basics</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../../skin/')" id="menu_1.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.2.1', '../../skin/')" id="menu_1.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.2.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/engine">Engine</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/language">Language</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/publishedapi">API</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_arch.html">Architecture</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/btree_package.html">BTree</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/pageformats.html">Disk Page Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_htw.html">How Things Work</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/Intersect-design.html">Intersect &amp; Except</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/JDBCImplementation.html">JDBC</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/logformats.html">Log Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/recovery.html">Logging &amp; Recovery</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/optimizer.html">Optimizer</a>
+</div>
+<div class="menuitem">
+<a href="http://svn.apache.org/repos/asf/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/package.html">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3', '../../skin/')" id="menu_1.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../../skin/')" id="menu_1.4Title" class="menutitle">Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/ApacheConUs04.html">ApacheCon US '04</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<div id="credit2"></div>
+</div>
+<div id="content">
+<div class="trail">
+<text>Font size:</text> 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Step 2: ij Basics</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#ij_intro">Introduction</a>
+</li>
+<li>
+<a href="#ij_setup">Set the environment</a>
+</li>
+<li>
+<a href="#ij_start">Start up ij</a>
+</li>
+<li>
+<a href="#ij_create">Create a database</a>
+</li>
+<li>
+<a href="#ij_connect">Connect to a database</a>
+<ul class="minitoc">
+<li>
+<a href="#Protocol">Protocol</a>
+</li>
+<li>
+<a href="#Database">Database</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#ij_sql">Execute SQL statements</a>
+</li>
+<li>
+<a href="#ij_disconnect">Disconnect from a database</a>
+</li>
+<li>
+<a href="#ij_exit">Exit</a>
+</li>
+<li>
+<a href="#Run+SQL+Scripts">Run SQL Scripts</a>
+</li>
+</ul>
+</div> 
+
+
+<a name="N1000C"></a><a name="ij_intro"></a>
+<h2 class="boxed">Introduction</h2>
+<div class="section">
+<p>
+
+<span class="codefrag">ij</span> is an interactive SQL scripting tool that comes with Derby. 
+It can be used with the Derby Embedded JDBC driver 
+or with a client JDBC driver, such as the Derby Network Client.
+</p>
+<p>
+This section uses the Derby Embedded JDBC driver to introduce a few 
+<span class="codefrag">ij</span> features.
+The information presented here is minimal, just enough to get started.
+For a more complete introduction, see the
+<a href="http://db.apache.org/derby/docs/dev/tools/ctoolsij32837.html">Getting
+started with ij</a> section
+in the <a href="http://db.apache.org/derby/manuals/">Tools 
+and Utilities Guide</a>.
+</p>
+</div>
+
+
+<a name="N10027"></a><a name="ij_setup"></a>
+<h2 class="boxed">Set the environment</h2>
+<div class="section">
+<p>
+To set up the environment,
+follow the 
+"<a href="install_software.html#derby_configure">Configure Embedded Derby</a>"
+instructions.
+</p>
+</div>
+
+
+<a name="N10035"></a><a name="ij_start"></a>
+<h2 class="boxed">Start up ij</h2>
+<div class="section">
+<p>Start up <span class="codefrag">ij</span> with this command:</p>
+<p class="code-block">java org.apache.derby.tools.ij</p>
+<p>You should see the output shown below:</p>
+<p class="code-block">ij version 10.1
+ij&gt;
+</p>
+<p>
+The error below means the class path isn't set correctly:
+</p>
+<p class="code-block">java org.apache.derby.tools.ij
+Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/tools/ij
+</p>
+<p>
+For help resolving class path problems, see the 
+"<a href="install_software.html#derby_configure">Configure Embedded Derby</a>"
+and
+"<a href="install_software.html#derby_verify">Verify Derby</a>"
+instructions.
+</p>
+</div>
+
+
+<a name="N1005F"></a><a name="ij_create"></a>
+<h2 class="boxed">Create a database</h2>
+<div class="section">
+<p>
+To create a database,
+specify the <span class="codefrag">create=true</span> attribute
+in the connection URL. 
+For example, the command below creates a new database called
+<span class="codefrag">MyDbTest</span>:
+</p>
+<p class="code-block">ij&gt; connect 'jdbc:derby:MyDbTest;create=true';</p>
+<p>
+Now quit out of <span class="codefrag">ij</span>:
+</p>
+<p class="code-block">ij&gt; exit; </p>
+<p>
+List the contents of your directory with
+<span class="codefrag">ls</span> (UNIX) or
+<span class="codefrag">dir</span> (Windows).
+On UNIX you'll see output like this:
+</p>
+<p class="code-block">$ ls
+MyDbTest  derby.log
+</p>
+<p>
+The <span class="codefrag">MyDbTest</span> directory contains the files that make up 
+the database you just created.
+The <span class="codefrag">derby.log</span> file is an error log, which is helpful
+whenever things don't work as expected.
+</p>
+</div>
+
+
+<a name="N10093"></a><a name="ij_connect"></a>
+<h2 class="boxed">Connect to a database</h2>
+<div class="section">
+<p>
+Start up <span class="codefrag">ij</span> again and 
+<a href="http://db.apache.org/derby/docs/dev/tools/rtoolsijcomref22318.html">connect</a> to the database you just created:
+</p>
+<p class="code-block">java org.apache.derby.tools.ij
+ij&gt; connect 'jdbc:derby:MyDbTest';
+</p>
+<p>
+We'll take a quick look at the
+protocol ("<span class="codefrag">jdbc:derby:</span>") and
+database ("<span class="codefrag">MyDbTest</span>") in this connection URL.
+</p>
+<a name="N100B0"></a><a name="Protocol"></a>
+<h3 class="boxed">Protocol</h3>
+<p>
+Internally, <span class="codefrag">ij</span> determines by default which driver to load
+from the protocol ("<span class="codefrag">jdbc:derby:</span>").
+In this case, it knows to load the embedded JDBC driver.
+We could also have specified the protocol with a property as shown below:
+</p>
+<p class="code-block">java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij
+ij&gt; connect 'MyDbTest';
+</p>
+<p>
+For more information about <span class="codefrag">ij</span> startup properties see
+<a href="http://db.apache.org/derby/docs/dev/tools/ttoolsij30600.html">Starting
+ij using properties</a> in the
+<a href="http://db.apache.org/derby/docs/dev/tools/ttoolsij98878.html">Tools 
+and Utilities Guide</a>.
+</p>
+<a name="N100D2"></a><a name="Database"></a>
+<h3 class="boxed">Database</h3>
+<p>
+Connecting to the <span class="codefrag">MyDbTest</span> database in the connection URL
+above works
+because the <span class="codefrag">MyDbTest</span> database directory is
+in the current working directory;
+<em>i.e.</em>,
+the directory where you started up <span class="codefrag">ij</span>.
+</p>
+<p>
+Let's say that your current directory location is 
+<span class="codefrag">/home/bill/databases</span>
+and that you decide to change your directory to a different place entirely.
+You can connect to the <span class="codefrag">MyDbTest</span> database 
+by specifying the complete directory path,
+like this:
+</p>
+<p class="code-block">java org.apache.derby.tools.ij
+ij&gt; connect 'jdbc:derby:/home/bill/databases/MyDbTest';
+</p>
+<p>
+You could also specify the Derby system home for the database like this:
+</p>
+<p class="code-block">java org.apache.derby.tools.ij -Dderby.system.home=/home/bill/databases
+ij&gt; connect 'jdbc:derby:MyDbTest';
+</p>
+<p>
+The <em>Developer's Guide</em> provides information
+about where Derby looks for databases:
+</p>
+<ul>
+   
+<li>
+<a href="http://db.apache.org/derby/docs/dev/devguide/cdevdvlp34964.html">Connecting to databases</a>
+</li>
+   
+<li> 
+<a href="http://db.apache.org/derby/docs/dev/devguide/cdevdvlp13018.html">Defining the system directory</a>
+</li>
+
+</ul>
+</div>
+
+
+<a name="N10111"></a><a name="ij_sql"></a>
+<h2 class="boxed">Execute SQL statements</h2>
+<div class="section">
+<p>
+Once you connect to a database, you can execute SQL statements.
+<span class="codefrag">ij</span> expects each statement to be terminated
+with a semicolon (;); for example:
+</p>
+<p class="code-block">ij&gt; create table derbyDB(num int, addr varchar(40));
+ij&gt; insert into derbyDB values (1956,'Webster St.');
+ij&gt; insert into derbyDB values (1910,'Union St.');
+ij&gt; update derbyDB set num=180, addr='Grand Ave.' where num=1956;
+ij&gt; select * from derbyDb;
+</p>
+</div>
+
+
+<a name="N10122"></a><a name="ij_disconnect"></a>
+<h2 class="boxed">Disconnect from a database</h2>
+<div class="section">
+<p>
+The <a href="http://db.apache.org/derby/docs/dev/tools/rtoolsijcomref20382.html">disconnect</a> 
+command disconnects from the current database:
+</p>
+<p class="code-block">ij&gt; disconnect;</p>
+</div>
+
+
+<a name="N10134"></a><a name="ij_exit"></a>
+<h2 class="boxed">Exit</h2>
+<div class="section">
+<p>
+The <a href="http://db.apache.org/derby/docs/dev/tools/rtoolsijcomref33358.html">exit</a>
+command quits out of <span class="codefrag">ij</span> and, in embedded mode,
+shuts down the Derby database:
+</p>
+<p class="code-block">ij&gt; exit;</p>
+</div>
+
+
+<a name="N10149"></a><a name="Run+SQL+Scripts"></a>
+<h2 class="boxed">Run SQL Scripts</h2>
+<div class="section">
+<p>
+You can execute SQL scripts in <span class="codefrag">ij</span> as shown below:
+</p>
+<p class="code-block">ij&gt; run 'my_file.sql';</p>
+<p>
+You can also run SQL scripts from the command line:
+</p>
+<p class="code-block">java org.apache.derby.tools.ij my_file.sql</p>
+<p>
+The <a href="http://db.apache.org/derby/docs/dev/tools/ttoolsij98878.html">Tools and Utilities Guide</a>
+provides more information about running SQL scripts from <span class="codefrag">ij</span>.
+</p>
+<p>
+After completing these <span class="codefrag">ij</span> steps, you're
+ready to move to "<a href="embedded_intro.html">Step 3: Embedded Derby</a>".
+</p>
+</div>
+
+
+</div>
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0papers/DerbyTut/ij_intro.html">derby-dev@db.apache.org</a>
+</div>
+</div>
+</body>
+</html>

Propchange: db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/site/trunk/build/site/papers/DerbyTut/index.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyTut/index.html?rev=355248&view=auto
==============================================================================
--- db/derby/site/trunk/build/site/papers/DerbyTut/index.html (added)
+++ db/derby/site/trunk/build/site/papers/DerbyTut/index.html Thu Dec  8 14:30:05 2005
@@ -0,0 +1,392 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.7">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Apache Derby Tutorial</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<div class="header">
+<div class="grouplogo">
+<a href="http://db.apache.org"><img class="logoImage" alt="" src="../../images/db-logo-white.png" title=""></a>
+</div>
+<div class="projectlogo">
+<a href="http://db.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin Java RDBMS."></a>
+</div>
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                    <input attr="value" name="Search" value="Search" type="submit">
+</form>
+</div>
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<div id="level2tabs"></div>
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Papers</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../../papers/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_web.html">Derby Web Site</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyInstruction">Instruction</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.1.5', '../../skin/')" id="menu_selected_1.1.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Derby Tutorial</div>
+<div id="menu_selected_1.1.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menupage">
+<div class="menupagetitle">Overview</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/install_software.html">Step 1: Install Software</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../../skin/')" id="menu_1.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.2.1', '../../skin/')" id="menu_1.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.2.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/engine">Engine</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/language">Language</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/publishedapi">API</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_arch.html">Architecture</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/btree_package.html">BTree</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/pageformats.html">Disk Page Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_htw.html">How Things Work</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/Intersect-design.html">Intersect &amp; Except</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/JDBCImplementation.html">JDBC</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/logformats.html">Log Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/recovery.html">Logging &amp; Recovery</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/optimizer.html">Optimizer</a>
+</div>
+<div class="menuitem">
+<a href="http://svn.apache.org/repos/asf/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/package.html">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3', '../../skin/')" id="menu_1.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../../skin/')" id="menu_1.4Title" class="menutitle">Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/ApacheConUs04.html">ApacheCon US '04</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+<div id="credit">
+<hr>
+<a href="http://forrest.apache.org/"><img border="0" title="Built with Apache Forrest" alt="Built with Apache Forrest - logo" src="../../images/built-with-forrest-button.png" style="width: 88px;height: 31px;"></a>
+</div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<div id="credit2"></div>
+</div>
+<div id="content">
+<div class="trail">
+<text>Font size:</text> 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Apache Derby Tutorial</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Overview">Overview</a>
+</li>
+<li>
+<a href="#Intended+Audience">Intended Audience</a>
+</li>
+<li>
+<a href="#Tutorial+Topics">Tutorial Topics</a>
+</li>
+<li>
+<a href="#next">Next Steps</a>
+<ul class="minitoc">
+<li>
+<a href="#More+Information">More Information</a>
+</li>
+<li>
+<a href="#Using+Derby+with+other+Products">Using Derby with other Products</a>
+</li>
+</ul>
+</li>
+</ul>
+</div> 
+
+
+<a name="N1000C"></a><a name="Overview"></a>
+<h2 class="boxed">Overview</h2>
+<div class="section">
+<p>
+
+<a href="http://db.apache.org/derby">Apache Derby</a>,
+an <a href="http://db.apache.org">Apache DB subproject</a>,
+is a relational database implemented in Java.
+Its footprint is so small you can easily embed it in any Java-based solution.
+In addition to its embedded framework,
+Derby supports a more familiar client/server framework with the
+Derby Network Server.
+This tutorial introduces Derby's basic features and
+walks you through using both frameworks;
+first the embedded framework using the Derby Embedded JDBC driver, 
+then the Network Server framework using the
+Derby Network Client JDBC driver.
+</p>
+</div>
+
+
+<a name="N1001E"></a><a name="Intended+Audience"></a>
+<h2 class="boxed">Intended Audience</h2>
+<div class="section">
+<p>
+This tutorial is intended for new Derby users who have 
+had at least light exposure to SQL, Java, and JDBC.
+</p>
+</div>
+
+
+<a name="N10028"></a><a name="Tutorial+Topics"></a>
+<h2 class="boxed">Tutorial Topics</h2>
+<div class="section">
+<p>
+This tutorial is organized into the sections below:
+</p>
+<ol>
+   
+<li> 
+<a href="install_software.html">Install Software</a> shows how to:
+         <ul>
+           
+<li> Install the Apache Derby software. </li>
+           
+<li> Configure your environment to use the 
+                Derby Embedded JDBC driver. </li>
+           
+<li> Verify your installation with the <span class="codefrag">sysinfo</span> tool.</li>
+         
+</ul>
+   
+</li>
+   
+<li> 
+<a href="ij_intro.html">ij Basics</a> shows how to
+         use the <span class="codefrag">ij</span> tool with the embedded Derby JDBC
+         driver to create a database and execute SQL queries.
+   </li>
+
+   
+<li> 
+<a href="embedded_intro.html">Embedded Derby</a> shows how to
+        compile and run a simple Java application that uses the
+        Derby Embedded JDBC driver.
+   </li>
+   
+<li> 
+<a href="ns_intro.html">Derby Network Server</a> show how to:
+        <ul>
+             
+<li> Start the Derby Network Server.</li>
+             
+<li> Configure your environment to use the
+                  Derby Network Client JDBC driver.</li>
+             
+<li> Compile and run a simple Java application that uses the
+                   network server.
+             </li>
+        
+</ul>
+   
+</li>
+
+</ol>
+</div>
+
+
+<a name="N1006F"></a><a name="next"></a>
+<h2 class="boxed">Next Steps</h2>
+<div class="section">
+<p>
+After completing the four steps in this tutorial, 
+you'll understand the basics of how to
+use Derby in the embedded and Network Server frameworks.
+</p>
+<a name="N10078"></a><a name="More+Information"></a>
+<h3 class="boxed">More Information</h3>
+<p>
+More information about Derby is on the
+<a href="http://db.apache.org/derby">Derby web site</a>
+and on the
+<a class="external" href="http://wiki.apache.org/db-derby/">Derby Wiki</a>.
+Please post any problems or questions to the
+<a href="http://db.apache.org/derby/derby_mail.html">derby-user@db.apache.org</a>
+mail list.
+</p>
+<a name="N1008E"></a><a name="Using+Derby+with+other+Products"></a>
+<h3 class="boxed">Using Derby with other Products</h3>
+<p>
+Below is a partial list of resources on the Derby web site that show how 
+to use Derby with another product:
+</p>
+<ul>
+   
+<li> 
+<a href="http://db.apache.org/derby/integrate/plugin_howto.html">Eclipse</a> 
+   
+</li>
+   
+<li>
+<a href="http://db.apache.org/derby/integrate/db_torque.html">Torque</a>
+   
+</li>
+   
+<li>
+<a href="http://db.apache.org/derby/papers/fortune_tut.html">Tomcat 5.0</a>
+   
+</li>
+   
+<li>
+<a href="http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html">Tomcat 5.5</a>
+   
+</li>
+   
+<li>
+<a href="http://db.apache.org/derby/integrate/JPetStoreGeronimo.html">Geronimo</a>
+   
+</li>
+   
+<li>
+<a href="http://db.apache.org/derby/integrate/JPetStoreWebSphere.html">WebSphere</a>
+   
+</li>
+
+</ul>
+<p>
+More products that work with Derby are summarized
+on the Derby web site 
+<a href="http://db.apache.org/derby/integrate/misc.html">Integration
+Topics: Summary</a> page and on the 
+<a class="external" href="http://wiki.apache.org/db-derby/UsesOfDerby">UsesOfDerby</a> Wiki
+page.
+</p>
+</div>
+
+
+<p>
+<em>Last updated: December 8, 2005</em>
+</p>
+
+</div>
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2005 Apache Software Foundation</div>
+<div id="logos">
+<a href="http://validator.w3.org/check/referer"><img style="height: 31px; width: 88px;" title="Valid HTML 4.01!" alt="Valid HTML 4.01!" src="../../skin/images/valid-html401.png" class="logoImage"></a><a href="http://jigsaw.w3.org/css-validator/check/referer"><img style="height: 31px; width: 88px;" title="Valid CSS!" alt="Valid CSS!" src="../../skin/images/vcss.png" class="logoImage"></a>
+</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0papers/DerbyTut/index.html">derby-dev@db.apache.org</a>
+</div>
+</div>
+</body>
+</html>

Propchange: db/derby/site/trunk/build/site/papers/DerbyTut/index.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html?rev=355248&view=auto
==============================================================================
--- db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html (added)
+++ db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html Thu Dec  8 14:30:05 2005
@@ -0,0 +1,528 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.7">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Step 1: Install Software</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<div class="header">
+<div class="grouplogo">
+<a href="http://db.apache.org"><img class="logoImage" alt="" src="../../images/db-logo-white.png" title=""></a>
+</div>
+<div class="projectlogo">
+<a href="http://db.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin Java RDBMS."></a>
+</div>
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                    <input attr="value" name="Search" value="Search" type="submit">
+</form>
+</div>
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<div id="level2tabs"></div>
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Papers</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../../papers/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_web.html">Derby Web Site</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyInstruction">Instruction</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/DerbyBooksAndArticles">Articles/Books</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.1.5', '../../skin/')" id="menu_selected_1.1.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Derby Tutorial</div>
+<div id="menu_selected_1.1.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../../papers/DerbyTut/index.html">Overview</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Step 1: Install Software</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../../skin/')" id="menu_1.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.2.1', '../../skin/')" id="menu_1.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.2.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/engine">Engine</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/language">Language</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/publishedapi">API</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_arch.html">Architecture</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/btree_package.html">BTree</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/pageformats.html">Disk Page Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/derby_htw.html">How Things Work</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/Intersect-design.html">Intersect &amp; Except</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/JDBCImplementation.html">JDBC</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/logformats.html">Log Format</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/recovery.html">Logging &amp; Recovery</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/optimizer.html">Optimizer</a>
+</div>
+<div class="menuitem">
+<a href="http://svn.apache.org/repos/asf/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/package.html">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3', '../../skin/')" id="menu_1.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../../skin/')" id="menu_1.4Title" class="menutitle">Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/ApacheConUs04.html">ApacheCon US '04</a>
+</div>
+<div class="menuitem">
+<a href="../../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<div id="credit2"></div>
+</div>
+<div id="content">
+<div class="trail">
+<text>Font size:</text> 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Step 1: Install Software</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Introduction">Introduction</a>
+</li>
+<li>
+<a href="#jdk">Java Development Kit (JDK)</a>
+<ul class="minitoc">
+<li>
+<a href="#jdk_install">Install JDK</a>
+</li>
+<li>
+<a href="#jdk_configure">Configure JDK</a>
+</li>
+<li>
+<a href="#jdk_verify">Verify JDK</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#derby">Apache Derby</a>
+<ul class="minitoc">
+<li>
+<a href="#derby_download">Download Derby</a>
+</li>
+<li>
+<a href="#derby_install">Install Derby</a>
+</li>
+<li>
+<a href="#set_derby_install">Set DERBY_INSTALL</a>
+</li>
+<li>
+<a href="#derby_configure">Configure Embedded Derby</a>
+</li>
+<li>
+<a href="#derby_verify">Verify Derby</a>
+</li>
+</ul>
+</li>
+</ul>
+</div> 
+
+
+<a name="N1000C"></a><a name="Introduction"></a>
+<h2 class="boxed">Introduction</h2>
+<div class="section">
+<p>
+This tutorial
+requires the Java Development Kit (JDK)
+and the Apache Derby software.
+</p>
+<p>
+First, this section describes which JDK release is required, 
+asks you to install it if you haven't already,
+then shows you how to configure and verify your installation.
+</p>
+<p>
+Next, it shows you how to install the Apache Derby software,
+configure your environment to use the Derby Embedded JDBC driver,
+and verify your installation with the Derby <span class="codefrag">sysinfo</span> tool.
+</p>
+</div>
+
+
+<a name="N1001F"></a><a name="jdk"></a>
+<h2 class="boxed">Java Development Kit (JDK)</h2>
+<div class="section">
+<p>Derby requires Java 2 Standard Edition (J2SE) 1.3 or higher
+(this tutorial was developed using JDK 1.4.2).
+Only the Java Runtime Environment (JRE) is required to run Derby,
+but this tutorial compiles a Java application, so it requires
+the Java Development Kit (JDK).
+</p>
+<p>
+If you already have a JDK installed, 
+<a href="#jdk_verify">verify</a> you are configured to use it,
+then proceed
+to the <a href="#derby">Apache Derby</a> installation section.
+</p>
+<a name="N10033"></a><a name="jdk_install"></a>
+<h3 class="boxed">Install JDK</h3>
+<p>
+If you have not already installed a JDK,
+download and install it now. 
+No specific vendor implementation is required;
+the only requirement is that it be certified for J2SE 1.3 or higher.
+Java's reference implementation is at
+<a class="external" href="http://java.sun.com/j2se/">http://java.sun.com/j2se/</a>.
+After installing the JDK of your choice, proceed to the next section.
+</p>
+<a name="N10041"></a><a name="jdk_configure"></a>
+<h3 class="boxed">Configure JDK</h3>
+<p>
+Set the <span class="codefrag">JAVA_HOME</span> environment variable to the root location of
+the JDK installation directory.
+The examples below use
+<span class="codefrag">C:\jdk1.4</span> for Windows and 
+<span class="codefrag">/opt/jdk1.4</span> for UNIX, but be sure to use the actual
+location on your system.
+</p>
+<p class="code-block">Windows:
+C:\&gt; set JAVA_HOME=C:\jdk1.4
+</p>
+<p class="code-block">UNIX Korn Shell:
+$ export JAVA_HOME=/opt/jdk1.4
+</p>
+<p>
+Next set the <span class="codefrag">PATH</span> environment variable to include the JDK
+<span class="codefrag">bin</span> directory.
+The <span class="codefrag">PATH</span> variable tells the operating system where to find the
+<span class="codefrag">java</span> interpreter and the <span class="codefrag">javac</span> compiler.
+</p>
+<p class="code-block">Windows:
+C:\&gt; set PATH=%PATH%;%JAVA_HOME%\bin
+</p>
+<p class="code-block">UNIX Korn Shell:
+$ export PATH=$JAVA_HOME/bin:$PATH
+</p>
+<a name="N10076"></a><a name="jdk_verify"></a>
+<h3 class="boxed">Verify JDK</h3>
+<p>
+Use the <span class="codefrag">java -version</span> command, as shown below,
+to verify the installed release:
+</p>
+<p class="code-block">java -version
+java version "1.4.2_04"
+Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05)
+Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode)
+</p>
+<p>
+The output you see may be different from what is shown above because
+the <span class="codefrag">java -version</span> command outputs vendor-specific information;
+however, if you don't see what looks like valid version information, then 
+<strong>STOP!</strong>
+And don't proceed until you resolve that problem.
+</p>
+</div>
+
+
+<a name="N10091"></a><a name="derby"></a>
+<h2 class="boxed">Apache Derby</h2>
+<div class="section">
+<a name="N10097"></a><a name="derby_download"></a>
+<h3 class="boxed">Download Derby</h3>
+<p>
+Download the binary Apache Derby distribution from the Derby web site at 
+<a href="http://db.apache.org/derby/derby_downloads.html">http://db.apache.org/derby/derby_downloads.html</a>.
+These tutorial instructions use version 10.1.2.1 and 
+assume you downloaded one of the binary distribution files 
+listed in the table below:
+</p>
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+     
+<tr>
+<th colspan="1" rowspan="1">Operating System</th><th colspan="1" rowspan="1">Download File</th>
+</tr>
+     
+<tr>
+<td colspan="1" rowspan="1">Windows</td><td colspan="1" rowspan="1">db-derby-10.1.2.1-bin.zip</td>
+</tr>
+     
+<tr>
+<td colspan="1" rowspan="1">UNIX, Linux, and Mac</td><td colspan="1" rowspan="1">db-derby-10.1.2.1-bin.tar.gz</td>
+</tr>
+
+</table>
+<p>If a more recent release is available, download that,
+   then substitute that version number 
+for <span class="codefrag">10.1.2.1</span> in the following instructions.
+   </p>
+<a name="N100CC"></a><a name="derby_install"></a>
+<h3 class="boxed">Install Derby</h3>
+<p>
+    Choose the directory into which you want to install the Derby software.
+    You must have write permissions to this directory.
+    The sample instructions below use <span class="codefrag">C:\Apache</span> for Windows and
+    <span class="codefrag">/opt/Apache</span> for UNIX; be sure to use your actual location.
+    Copy the software distribution to the location you choose, then
+    extract it as shown below.
+    </p>
+<p class="code-block">Windows (use your extraction tool -- these instructions show mks unzip):
+mkdir C:\Apache
+copy db-derby-10.1.2.1-bin.zip C:\Apache
+cd C:\Apache
+unzip db-derby-10.1.2.1-bin.zip
+</p>
+<p class="code-block">UNIX:
+mkdir /opt/Apache
+cp db-derby-10.1.2.1-bin.tar.gz /opt/Apache
+cd /opt/Apache
+tar xzvf db-derby-10.1.2.1-bin.tar.gz
+</p>
+<p>In both cases, the software will now be extracted into a subdirectory
+    named <span class="codefrag">db-derby-10.1.2.1-bin</span>. 
+   </p>
+<a name="N100EA"></a><a name="set_derby_install"></a>
+<h3 class="boxed">Set DERBY_INSTALL</h3>
+<p>
+Set the <span class="codefrag">DERBY_INSTALL</span> variable to the location where you
+installed Derby.
+Examples are shown below, but be sure to use the actual location on 
+your system:
+</p>
+<p class="code-block">Windows:
+C:\&gt; set DERBY_INSTALL=C:\Apache\db-derby-10.1.2.1-bin
+</p>
+<p class="code-block">UNIX Korn Shell:
+$ export DERBY_INSTALL=/opt/Apache/db-derby-10.1.2.1-bin
+</p>
+<a name="N100FF"></a><a name="derby_configure"></a>
+<h3 class="boxed">Configure Embedded Derby</h3>
+<p>To use Derby in its embedded mode
+      set your <span class="codefrag">CLASSPATH</span> to include the jar files listed below:</p>
+<ul>
+     
+<li> 
+<span class="codefrag">derby.jar</span>: contains the Derby engine and the
+              Derby Embedded JDBC driver</li>
+     
+<li> 
+<span class="codefrag">derbytools.jar</span>:
+           optional, provides the <span class="codefrag">ij</span> tool that is used
+          by a couple sections in this tutorial</li>
+
+</ul>
+<p>
+   You can set your <span class="codefrag">CLASSPATH</span> explicitly with the command
+   shown below:
+</p>
+<p class="code-block">Windows:
+C:\&gt; set CLASSPATH=%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbytools.jar;.
+</p>
+<p class="code-block">UNIX:
+$ export CLASSPATH=$DERBY_INSTALL/lib/derby.jar:$DERBY_INSTALL/lib/derbytools.jar:.
+</p>
+<p>
+Notice that multiple entries in the class path are separated by a
+semicolon (;) on Windows and a colon (:) on UNIX.
+</p>
+<p>
+   The Derby software provides another way to set <span class="codefrag">CLASSPATH</span>,
+   using shell scripts (UNIX) and batch files (Windows).
+   This tutorial shows how to set
+   <span class="codefrag">CLASSPATH</span> explicitly 
+   and also how to use the Derby scripts to set it.
+</p>
+<p>
+   Change directory now into the
+   <span class="codefrag">DERBY_INSTALL/frameworks/embedded/bin</span> directory.
+    The <span class="codefrag">setEmbeddedCP.bat</span> (Windows) 
+    and <span class="codefrag">setEmbeddedCP.ksh</span>
+     (UNIX) scripts use the <span class="codefrag">DERBY_INSTALL</span> variable to set the 
+     <span class="codefrag">CLASSPATH</span>  for Derby embedded usage. 
+     You can edit the script itself to set 
+     <span class="codefrag">DERBY_INSTALL</span>, or you can let the script get 
+     <span class="codefrag">DERBY_INSTALL</span> from your environment. 
+     Since you already set <span class="codefrag">DERBY_INSTALL</span> in the 
+     "<a href="#set_derby_install">Set DERBY_INSTALL</a>" section above, 
+     you don't need to edit the script, 
+     so go ahead and execute it as shown below:
+   </p>
+<p class="code-block">Windows:
+C:\&gt; cd %DERBY_INSTALL%\frameworks\embedded\bin
+C:\Apache\db-derby-10.1.2.1-bin\frameworks\embedded\bin&gt; setEmbeddedCP.bat
+</p>
+<p class="code-block">UNIX:
+$ cd $DERBY_INSTALL/frameworks/embedded/bin
+$ . setEmbeddedCP.ksh
+</p>
+<a name="N1015F"></a><a name="derby_verify"></a>
+<h3 class="boxed">Verify Derby</h3>
+<p>Run the <span class="codefrag">sysinfo</span> command, as shown below, to output Derby
+system information:
+</p>
+<p class="code-block">java org.apache.derby.tools.sysinfo</p>
+<p>Successful output will look something like this:</p>
+<p class="code-block">------------------ Java Information ------------------
+Java Version:    1.4.2_06
+Java Vendor:     Sun Microsystems Inc.
+Java home:       /opt/jdk1.4
+Java classpath:  /opt/Apache/db-derby-10.1.2.1-bin/lib/derby.jar:/opt/Apache/db-derby-10.1.2.1-bin/lib/derbytools.jar:
+OS name:         Linux
+OS architecture: i386
+OS version:      2.6.10-1.760_FC3
+Java user name:  jta
+Java user home:  /home/jta
+Java user dir:   /opt/Apache/db-derby-10.1.2.1-bin/frameworks/embedded/bin
+java.specification.name: Java Platform API Specification
+java.specification.version: 1.4
+--------- Derby Information --------
+JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
+[/opt/Apache/db-derby-10.1.2.1-bin/lib/derby.jar] 10.1.2.1 - (330608)
+[/opt/Apache/db-derby-10.1.2.1-bin/lib/derbytools.jar] 10.1.2.1 - (330608)
+------------------------------------------------------
+----------------- Locale Information -----------------
+------------------------------------------------------
+</p>
+<p>
+The output on your system will probably be somewhat different 
+than the output shown above, 
+but it should reflect the correct location 
+of jar files on your machine and there shouldn't be any errors. 
+If you see an error like the one below, 
+it means your class path is not correctly set:
+</p>
+<p class="code-block">$ java org.apache.derby.tools.sysinfo
+Exception in thread "main" java.lang.NoClassDefFoundError: 
+     org/apache/derby/tools/sysinfo
+</p>
+<p>
+Echo your <span class="codefrag">CLASSPATH</span>, as shown below,
+then double check each entry in your class path to verify that the jar file 
+is where you expect it:
+</p>
+<p class="code-block">Windows:
+C:\&gt; echo %CLASSPATH% 
+C:\Apache\DB-DER~1.1-B\lib\derby.jar;C:\Apache\DB-DER~1.1-B\lib\derbytools.jar;
+</p>
+<p class="code-block">UNIX:
+$ echo $CLASSPATH
+/opt/Apache/db-derby-10.1.2.1-bin/lib/derby.jar:/opt/Apache/db-derby-10.1.2.1-bin/lib/derbytools.jar:
+</p>
+<p>
+If <span class="codefrag">sysinfo</span> outputs valid information, you're
+ready to move to "<a href="ij_intro.html">Step 2: ij Basics</a>".
+</p>
+</div>
+
+
+</div>
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0papers/DerbyTut/install_software.html">derby-dev@db.apache.org</a>
+</div>
+</div>
+</body>
+</html>

Propchange: db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png?rev=355248&view=auto
==============================================================================
Binary file - no diff available.

Propchange: db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png
------------------------------------------------------------------------------
    svn:mime-type = image/png



Mime
View raw message