You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by jt...@apache.org on 2005/12/08 23:30:16 UTC
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...
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> _________________________ <em>articles</em>
</li>
+</ul>
+
+<ul>
+<li>
+<a href="papers/DerbyTut/">Derby Tutorial</a> _________________________ <em>derbyTut</em>
+</li>
+<ul>
+
+<ul>
+<li>
+<a href="papers/DerbyTut/index.html">Overview</a> _________________________ <em>index</em>
+</li>
+</ul>
+
+<ul>
+<li>
+<a href="papers/DerbyTut/install_software.html">Step 1: Install Software</a> _________________________ <em>install</em>
+</li>
+</ul>
+
+<ul>
+<li>
+<a href="papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a> _________________________ <em>ij_intro</em>
+</li>
+</ul>
+
+<ul>
+<li>
+<a href="papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a> _________________________ <em>embed</em>
+</li>
+</ul>
+
+<ul>
+<li>
+<a href="papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a> _________________________ <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> > <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">
+ <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">
+
+
+ </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 & 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 & 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>
+ <input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">
+ <input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+ <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:\> 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> connect 'jdbc:derby:derbyDB';
+ij>
+</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"> </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 ©
+ 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> > <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">
+ <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">
+
+
+ </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 & 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 & 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>
+ <input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">
+ <input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+ <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>
+</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> connect 'jdbc:derby:MyDbTest;create=true';</p>
+<p>
+Now quit out of <span class="codefrag">ij</span>:
+</p>
+<p class="code-block">ij> 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> 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> 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> 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> 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> create table derbyDB(num int, addr varchar(40));
+ij> insert into derbyDB values (1956,'Webster St.');
+ij> insert into derbyDB values (1910,'Union St.');
+ij> update derbyDB set num=180, addr='Grand Ave.' where num=1956;
+ij> 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> 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> 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> 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"> </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 ©
+ 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> > <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">
+ <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">
+
+
+ </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 & 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 & 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>
+ <input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">
+ <input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+ <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"> </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 ©
+ 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> > <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">
+ <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">
+
+
+ </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 & 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 & 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>
+ <input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">
+ <input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+ <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:\> 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:\> 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:\> 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:\> 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:\> cd %DERBY_INSTALL%\frameworks\embedded\bin
+C:\Apache\db-derby-10.1.2.1-bin\frameworks\embedded\bin> 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:\> 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"> </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 ©
+ 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