db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r843115 [11/44] - in /websites/production/db/content/derby: ./ binaries/ blogs/ blogs/images/ dev/ docs/ images/ integrate/ integrate/plugin_help/ integrate/plugin_help/images/ logo/ manuals/ papers/ papers/DerbyTut/ releases/ skin/ skin/cs...
Date Wed, 19 Dec 2012 18:20:28 GMT
Added: websites/production/db/content/derby/integrate/db_torque.html
==============================================================================
--- websites/production/db/content/derby/integrate/db_torque.html (added)
+++ websites/production/db/content/derby/integrate/db_torque.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,628 @@
+<!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.8">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Running the Torque Tutorial on 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">
+<!--+
+    |breadtrail
+    +-->
+<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>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="unselected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="unselected" href="../manuals/index.html">Documentation</a>
+</li>
+<li class="current">
+<a class="selected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Blogs and Articles About Derby</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#blogs">Blogs</a>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3', '../skin/')" id="menu_1.1.3Title" class="menutitle">Articles</div>
+<div id="menu_1.1.3" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.1.3.1', '../skin/')" id="menu_1.1.3.1Title" class="menutitle">Tutorials, Tips and Tuning</div>
+<div id="menu_1.1.3.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#getstarted">Getting Started</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#features">Features, Hints and Tips</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#security">Security</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#performance">Performance and Tuning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.2', '../skin/')" id="menu_1.1.3.2Title" class="menutitle">Tools and Migration</div>
+<div id="menu_1.1.3.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#migration">Migration</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.3', '../skin/')" id="menu_1.1.3.3Title" class="menutitle">Applications</div>
+<div id="menu_1.1.3.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#client">Client</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#middletier">Middle Tier</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#persistence">Persistence</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#scalability">Scalability and Failover</a>
+</div>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Integration With Other Products</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#uses">What works with Derby?</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#products">Product Writeups</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3', '../skin/')" id="menu_1.3Title" class="menutitle">Eclipse Plug-ins</div>
+<div id="menu_1.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/derby_plugin_info.html">Info</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../skin/')" id="menu_1.4Title" class="menutitle">Papers and Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/index.html">Overview</a>
+</div>
+<div onclick="SwitchMenu('menu_1.4.2', '../skin/')" id="menu_1.4.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.4.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.4.2.1', '../skin/')" id="menu_1.4.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.4.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://db.apache.org/derby/javadoc/engine/org/apache/derby/iapi/types/package-summary.html#package_description">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.3', '../skin/')" id="menu_1.4.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.4.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.4', '../skin/')" id="menu_1.4.4Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.4.4" 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 onclick="SwitchMenu('menu_1.4.5', '../skin/')" id="menu_1.4.5Title" class="menutitle">Presentations</div>
+<div id="menu_1.4.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/ApacheCon.html">ApacheCon</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Victorian+Java+User+Group">Victorian JUG 2008</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+</div>
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<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>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2"></div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div class="trail">Font size: 
+	          &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>Running the Torque Tutorial on Derby</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Overview">Overview</a>
+</li>
+<li>
+<a href="#Step+1">Step 1</a>
+</li>
+<li>
+<a href="#Step+2">Step 2</a>
+<ul class="minitoc">
+<li>
+<a href="#Torque+Generator+Properties">Torque Generator Properties</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#Step+3">Step 3</a>
+<ul class="minitoc">
+<li>
+<a href="#Adding+the+driver+to+the+maven+repository">Adding the driver to the maven repository</a>
+</li>
+<li>
+<a href="#Specifying+the+driver+dependency">Specifying the driver dependency</a>
+</li>
+<li>
+<a href="#Creating+the+database">Creating the database</a>
+</li>
+<li>
+<a href="#Creating+the+tables">Creating the tables</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#Step+4">Step 4</a>
+<ul class="minitoc">
+<li>
+<a href="#Torque+Run-Time+Properties">Torque Run-Time Properties</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#Step+5">Step 5</a>
+</li>
+<li>
+<a href="#Step+6">Step 6</a>
+</li>
+<li>
+<a href="#Got+Questions%3F">Got Questions?</a>
+</li>
+</ul>
+</div> 
+
+
+<a name="N1000D"></a><a name="Overview"></a>
+<h2 class="boxed">Overview</h2>
+<div class="section">
+<p>
+
+<a href="http://db.apache.org/torque">Torque</a>, an Apache DB subproject,
+is a persistence layer that performs object mapping between java 
+objects and a relational database. 
+</p>
+<p>
+Torque 3.2 has an
+<a href="http://db.apache.org/torque/releases/torque-3.2/releases/torque-3.2/tutorial/index.html">excellent 
+tutorial</a> that uses MySQL.
+This page summarizes the changes 
+required for each step to run the tutorial on Derby 10.1
+using the Derby embedded JDBC driver. 
+The instructions below assume Derby 10.1.3.1 -- modify those instructions
+to match the specific release you installed.
+(These instructions have also been verified to work with the Derby 10.2 beta.)
+</p>
+<p>
+Currently Torque just works with the embedded jdbc driver;
+it doesn't work with the
+Derby Network Client JDBC driver or the
+IBM DB2 Universal JDBC driver because of an issue with the Village software
+it uses.
+Details are in
+<a class="external" href="http://issues.apache.org/jira/browse/DERBY-142">DERBY-142</a>.
+</p>
+</div>
+
+
+<a name="N10029"></a><a name="Step+1"></a>
+<h2 class="boxed">Step 1</h2>
+<div class="section"></div>
+
+
+<p>
+No changes to this step are required.
+</p>
+
+
+<a name="N10033"></a><a name="Step+2"></a>
+<h2 class="boxed">Step 2</h2>
+<div class="section">
+<a name="N10039"></a><a name="Torque+Generator+Properties"></a>
+<h3 class="boxed">Torque Generator Properties</h3>
+<p>Below is a <span class="codefrag">project.properties</span> file that works
+      with the Derby embedded driver:</p>
+<pre class="code">
+   # The name of the project Torque will generate code for.
+   torque.project = bookstore
+
+   # The target database platform.
+   torque.database = derby
+
+   # The target package to put the generated classes in.
+   torque.targetPackage = com.kazmier.om
+
+   # The JDBC URL that Torque can use to create and
+   # drop databases if instructed to do so.
+   # Derby note: Manually create/drop databases
+   torque.database.createUrl =
+
+   # The JDBC URL that will be used to create tables in your database.
+   torque.database.buildUrl = jdbc:derby:bookstore
+
+   # The JDBC URL that will be used to access your database.
+   torque.database.url = jdbc:derby:bookstore
+
+   # The JDBC database driver to use when connecting to your database.
+   torque.database.driver = org.apache.derby.jdbc.EmbeddedDriver
+
+   # The administrative username that has sufficient privileges to create
+   # and drop databases and tables that Torque executes at generation time.
+   torque.database.user = app
+
+   # The administrative password for the supplied username.
+   torque.database.password = app
+
+   # The hostname or IP address of your database server.
+   torque.database.host = 127.0.0.1 
+  </pre>
+</div>
+
+
+
+<a name="N1004B"></a><a name="Step+3"></a>
+<h2 class="boxed">Step 3</h2>
+<div class="section">
+<a name="N10051"></a><a name="Adding+the+driver+to+the+maven+repository"></a>
+<h3 class="boxed">Adding the driver to the maven repository</h3>
+<p>
+I added the Derby jar to my local maven repository like this:
+</p>
+<pre class="code">
+  mkdir ~/.maven/repository/derby
+  mkdir ~/.maven/repository/derby/jars
+  cp /opt/Apache/db-derby-10.1.3.1-bin/lib/derby.jar ~/.maven/repository/derby/jars/derby-10.1.3.1-bin.jar
+</pre>
+<p>
+There are probably other ways for incorporating the Derby jar
+that don't require renaming the jar to include the version.
+</p>
+<a name="N10062"></a><a name="Specifying+the+driver+dependency"></a>
+<h3 class="boxed">Specifying the driver dependency</h3>
+<p>
+Here is the complete <span class="codefrag">project.xml</span> file:
+</p>
+<pre class="code">
+   &lt;project&gt;
+     &lt;pomVersion&gt;3&lt;/pomVersion&gt;
+     &lt;groupId&gt;torque&lt;/groupId&gt;
+     &lt;id&gt;torque-tutorial&lt;/id&gt;
+     &lt;name&gt;Torque&lt;/name&gt;
+     &lt;currentVersion&gt;3.2&lt;/currentVersion&gt;
+
+     &lt;dependencies&gt;
+
+       &lt;dependency&gt;
+         &lt;artifactId&gt;derby&lt;/artifactId&gt;
+         &lt;groupId&gt;derby&lt;/groupId&gt;
+         &lt;version&gt;10.1.3.1-bin&lt;/version&gt;
+       &lt;/dependency&gt;
+
+     &lt;/dependencies&gt;
+   &lt;/project&gt;
+</pre>
+<a name="N10073"></a><a name="Creating+the+database"></a>
+<h3 class="boxed">Creating the database</h3>
+<p>
+The Torque Tutorial instructions mention that 
+<span class="codefrag">maven torque:create-db</span>
+doesn't work for
+all databases, and I didn't find a way to make it work for Derby.
+(I also didn't try very hard, so it might be possible.)
+</p>
+<p>
+Manually create the database in the root directory of
+your Torque project like this:
+</p>
+<pre class="code">
+   java org.apache.derby.tools.ij
+   ij version 10.1
+   ij&gt; connect 'jdbc:derby:bookstore;create=true';
+   ij&gt; quit; 
+</pre>
+<p>
+Now set the
+<span class="codefrag">DERBY_SYSTEM_HOME</span> environment variable to this directory location.
+You'll use it in Step 6
+to set the <span class="codefrag">derby.system.home</span> property 
+so Derby will know where to find the database you created.
+For example, here is how I set it on my Linux machine:
+</p>
+<pre class="code">
+   export DERBY_SYSTEM_HOME=/home/jta/Apache/TorqueTutorial
+</pre>
+<p>
+If I were on Windows, I would have set the variable like this instead:
+</p>
+<pre class="code">
+   set DERBY_SYSTEM_HOME=C:\home\jta\Apache\TorqueTutorial
+</pre>
+<a name="N1009B"></a><a name="Creating+the+tables"></a>
+<h3 class="boxed">Creating the tables</h3>
+<p>
+No changes to this step are required.
+</p>
+</div>
+
+
+<a name="N100A6"></a><a name="Step+4"></a>
+<h2 class="boxed">Step 4</h2>
+<div class="section">
+<a name="N100AC"></a><a name="Torque+Run-Time+Properties"></a>
+<h3 class="boxed">Torque Run-Time Properties</h3>
+<p>
+Here is the complete <span class="codefrag">src/conf/torque.properties</span> file:
+</p>
+<pre class="code">
+   torque.database.default = bookstore
+   torque.database.bookstore.adapter = derby
+
+   #Using commons-dbcp
+   torque.dsfactory.bookstore.factory = org.apache.torque.dsfactory.SharedPoolDataSourceFactory
+   torque.dsfactory.bookstore.connection.driver = org.apache.derby.jdbc.EmbeddedDriver
+   torque.dsfactory.bookstore.connection.url = jdbc:derby:bookstore
+   torque.dsfactory.bookstore.connection.user = app
+   torque.dsfactory.bookstore.connection.password = app
+</pre>
+</div>
+
+
+<a name="N100BE"></a><a name="Step+5"></a>
+<h2 class="boxed">Step 5</h2>
+<div class="section">
+<p>
+No changes to this step are required.
+</p>
+</div>
+
+
+<a name="N100C8"></a><a name="Step+6"></a>
+<h2 class="boxed">Step 6</h2>
+<div class="section">
+<p>
+I made two modifications for running the sample application:
+</p>
+<ul>
+  
+<li> Set the <span class="codefrag">derby.system.home</span> property to the environment
+       variable created in Step 3.
+  </li>
+  
+<li> Replace the mysql jar with the derby jar:
+       <span class="codefrag">lib/derby-10.1.3.1-bin.jar</span>
+  
+</li>
+
+</ul>
+<p>
+Here is the command I ran on my Linux machine:
+</p>
+<pre class="code">
+   [jta@gertie target]$ java -Dderby.system.home=$DERBY_SYSTEM_HOME -cp classes:lib/avalon-framework-4.1.4.jar:lib/commons-beanutils-1.7.0.jar:lib/commons-collections-3.1.jar:lib/commons-configuration-1.1.jar:lib/commons-dbcp-1.2.1.jar:lib/commons-lang-2.1.jar:lib/commons-logging-1.0.4.jar:lib/commons-pool-1.2.jar:lib/jcs-20030822.182132.jar:lib/derby-10.1.3.1-bin.jar:lib/torque-3.2.jar:lib/village-2.0.jar com.kazmier.Bookstore
+</pre>
+</div>
+
+
+<a name="N100E8"></a><a name="Got+Questions%3F"></a>
+<h2 class="boxed">Got Questions?</h2>
+<div class="section">
+<p>
+  Jean Anderson wrote these instructions.
+  Please post any questions about them 
+  to <a href="../derby_mail.html">derby-user@db.apache.org</a>.
+  </p>
+</div>
+
+
+<p>
+<em>Last Updated: August 17, 2006</em>
+</p>
+
+
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0integrate/db_torque.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/integrate/derby_plugin.html
==============================================================================
--- websites/production/db/content/derby/integrate/derby_plugin.html (added)
+++ websites/production/db/content/derby/integrate/derby_plugin.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,564 @@
+<!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.8">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Derby 10 Core Plug-in for Eclipse</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">
+<!--+
+    |breadtrail
+    +-->
+<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>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="unselected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="unselected" href="../manuals/index.html">Documentation</a>
+</li>
+<li class="current">
+<a class="selected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Blogs and Articles About Derby</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#blogs">Blogs</a>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3', '../skin/')" id="menu_1.1.3Title" class="menutitle">Articles</div>
+<div id="menu_1.1.3" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.1.3.1', '../skin/')" id="menu_1.1.3.1Title" class="menutitle">Tutorials, Tips and Tuning</div>
+<div id="menu_1.1.3.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#getstarted">Getting Started</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#features">Features, Hints and Tips</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#security">Security</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#performance">Performance and Tuning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.2', '../skin/')" id="menu_1.1.3.2Title" class="menutitle">Tools and Migration</div>
+<div id="menu_1.1.3.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#migration">Migration</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.3', '../skin/')" id="menu_1.1.3.3Title" class="menutitle">Applications</div>
+<div id="menu_1.1.3.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#client">Client</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#middletier">Middle Tier</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#persistence">Persistence</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#scalability">Scalability and Failover</a>
+</div>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Integration With Other Products</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#uses">What works with Derby?</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#products">Product Writeups</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.3', '../skin/')" id="menu_selected_1.3Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.3" class="selectedmenuitemgroup" style="display: block;">
+<div class="menupage">
+<div class="menupagetitle">10 Core</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/func_spec_plugins.html">1.0 UI Functional Spec</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_howto.html">10 Core and 1.1 UI</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/Readme.html">Building 1.1 UI</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_slides.html">Derby Plug-ins Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6', '../skin/')" id="menu_1.3.6Title" class="menutitle">10 Core and 1.1 UI Documentation</div>
+<div id="menu_1.3.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/java_project.html">Creating an Eclipse Project</a>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6.3', '../skin/')" id="menu_1.3.6.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.3.6.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6.4', '../skin/')" id="menu_1.3.6.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.3.6.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6.6', '../skin/')" id="menu_1.3.6.6Title" class="menutitle">ij</div>
+<div id="menu_1.3.6.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij_toc.html">Using ij</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij.html">SQL commands</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij2.html">SQL scripts</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/derby_app.html">Building a Java App</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../skin/')" id="menu_1.4Title" class="menutitle">Papers and Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/index.html">Overview</a>
+</div>
+<div onclick="SwitchMenu('menu_1.4.2', '../skin/')" id="menu_1.4.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.4.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.4.2.1', '../skin/')" id="menu_1.4.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.4.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://db.apache.org/derby/javadoc/engine/org/apache/derby/iapi/types/package-summary.html#package_description">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.3', '../skin/')" id="menu_1.4.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.4.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.4', '../skin/')" id="menu_1.4.4Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.4.4" 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 onclick="SwitchMenu('menu_1.4.5', '../skin/')" id="menu_1.4.5Title" class="menutitle">Presentations</div>
+<div id="menu_1.4.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/ApacheCon.html">ApacheCon</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Victorian+Java+User+Group">Victorian JUG 2008</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+</div>
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<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>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2"></div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div class="trail">Font size: 
+	          &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>Derby 10 Core Plug-in for Eclipse</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Overview">Overview</a>
+</li>
+<li>
+<a href="#Functionality">Functionality</a>
+</li>
+<li>
+<a href="#Components">Components</a>
+</li>
+<li>
+<a href="#The+UI+plug-in">The UI plug-in</a>
+</li>
+<li>
+<a href="#Software+Requirements">Software Requirements</a>
+</li>
+<li>
+<a href="#Install">Install</a>
+</li>
+<li>
+<a href="#Resources">Resources</a>
+</li>
+</ul>
+</div>
+
+
+<a name="N1000D"></a><a name="Overview"></a>
+<h2 class="boxed">Overview</h2>
+<div class="section">
+<p>
+The Apache Derby Core Plug-in for Eclipse allows the Derby jars to be 
+available to the Eclipse platform through a standard plug-in.
+</p>
+</div>
+
+
+<a name="N10017"></a><a name="Functionality"></a>
+<h2 class="boxed">Functionality</h2>
+<div class="section">
+<p>
+This 'core' plug-in consists of all the Derby related jars and can be used 
+in Eclipse projects for:
+</p>
+<ul>
+
+<li>database application development</li>
+
+<li>plug-in development with the Derby 'core' plug-in as its dependency</li>
+
+</ul>
+</div>
+
+
+<a name="N1002A"></a><a name="Components"></a>
+<h2 class="boxed">Components</h2>
+<div class="section">
+<p>
+The Apache Derby Core Plug-in for Eclipse consists of a zip file containing the plugin.
+Information for the most recent version as of this writing is listed below.
+</p>
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+
+<tr>
+
+<td colspan="1" rowspan="1">Name</td>
+<td colspan="1" rowspan="1">Purpose</td>
+<td colspan="1" rowspan="1">Packaging</td>
+
+</tr>
+
+<tr>
+
+<td colspan="1" rowspan="1">org.apache.derby.core_10.2.2</td>
+<td colspan="1" rowspan="1">Contains derby.jar, derbynet.jar, derbytools.jar and derbyclient.jar</td>
+<td colspan="1" rowspan="1">derby_core_plugin_10.2.2.485682.zip</td>
+
+</tr>
+
+</table>
+</div>
+
+
+<a name="N1005B"></a><a name="The+UI+plug-in"></a>
+<h2 class="boxed">The UI plug-in</h2>
+<div class="section">
+<p>
+See the document, <a href="plugin_howto.html">Using the 10 Core and 1.1
+UI Derby plug-ins</a> for complete information about compatibility between
+the 'Core' and 'UI' plug-ins. 
+</p>
+</div>
+
+
+<a name="N10069"></a><a name="Software+Requirements"></a>
+<h2 class="boxed">Software Requirements</h2>
+<div class="section">
+<ul>
+
+<li>Java Development Kit
+<ul>
+
+<li>Sun JDK version 1.3.x or higher</li>
+
+<li>IBM SDK version 1.3.x or higher</li>
+
+</ul>
+
+</li>
+
+
+<li>Eclipse from <a class="external" href="http://www.eclipse.org">eclipse.org</a>
+
+<ul>
+
+<li>Eclipse 3.1 M6 or higher</li>
+
+</ul>
+
+</li>
+
+</ul>
+<div class="warning">
+<div class="label">Warning</div>
+<div class="content">Note: Eclipse 3.0 is not supported</div>
+</div>
+</div>
+
+
+<a name="N1008F"></a><a name="Install"></a>
+<h2 class="boxed">Install</h2>
+<div class="section">
+<p>
+Download the Derby core plug-in zip from the Apache Derby site:
+<a href="../derby_downloads.html">http://db.apache.org/derby/derby_downloads.html</a>.  
+The plug-in is available for download from each Derby release download page.
+</p>
+<p>
+After downloading, unzip the file to the Eclipse installation directory. The 
+zip file will unpack to create a new subdirectory under the plugins directory 
+of the Eclipse installation. 
+</p>
+<p>
+Launch Eclipse, if Eclipse was already running while unzipping the file, 
+please re-start it.
+</p>
+</div>
+
+
+<a name="N100A3"></a><a name="Resources"></a>
+<h2 class="boxed">Resources</h2>
+<div class="section">
+<p>
+More information on Apache Derby can be found at:
+<a href="http://db.apache.org/derby/">http://db.apache.org/derby/</a>
+
+</p>
+</div>
+
+
+
+<p>
+
+<em>Last updated: January 4, 2007</em>
+
+</p>
+
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0integrate/derby_plugin.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/integrate/derby_plugin_info.html
==============================================================================
--- websites/production/db/content/derby/integrate/derby_plugin_info.html (added)
+++ websites/production/db/content/derby/integrate/derby_plugin_info.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,431 @@
+<!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.8">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Derby Plug-in for Eclipse</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">
+<!--+
+    |breadtrail
+    +-->
+<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>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="unselected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="unselected" href="../manuals/index.html">Documentation</a>
+</li>
+<li class="current">
+<a class="selected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Blogs and Articles About Derby</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#blogs">Blogs</a>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3', '../skin/')" id="menu_1.1.3Title" class="menutitle">Articles</div>
+<div id="menu_1.1.3" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.1.3.1', '../skin/')" id="menu_1.1.3.1Title" class="menutitle">Tutorials, Tips and Tuning</div>
+<div id="menu_1.1.3.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#getstarted">Getting Started</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#features">Features, Hints and Tips</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#security">Security</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#performance">Performance and Tuning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.2', '../skin/')" id="menu_1.1.3.2Title" class="menutitle">Tools and Migration</div>
+<div id="menu_1.1.3.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#migration">Migration</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.3', '../skin/')" id="menu_1.1.3.3Title" class="menutitle">Applications</div>
+<div id="menu_1.1.3.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#client">Client</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#middletier">Middle Tier</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#persistence">Persistence</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#scalability">Scalability and Failover</a>
+</div>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Integration With Other Products</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#uses">What works with Derby?</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#products">Product Writeups</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.3', '../skin/')" id="menu_selected_1.3Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.3" class="selectedmenuitemgroup" style="display: block;">
+<div class="menupage">
+<div class="menupagetitle">Info</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../skin/')" id="menu_1.4Title" class="menutitle">Papers and Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/index.html">Overview</a>
+</div>
+<div onclick="SwitchMenu('menu_1.4.2', '../skin/')" id="menu_1.4.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.4.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.4.2.1', '../skin/')" id="menu_1.4.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.4.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://db.apache.org/derby/javadoc/engine/org/apache/derby/iapi/types/package-summary.html#package_description">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.3', '../skin/')" id="menu_1.4.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.4.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.4', '../skin/')" id="menu_1.4.4Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.4.4" 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 onclick="SwitchMenu('menu_1.4.5', '../skin/')" id="menu_1.4.5Title" class="menutitle">Presentations</div>
+<div id="menu_1.4.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/ApacheCon.html">ApacheCon</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Victorian+Java+User+Group">Victorian JUG 2008</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+</div>
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<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>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2"></div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div class="trail">Font size: 
+	          &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>Derby Plug-in for Eclipse</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Overview">Overview</a>
+</li>
+<li>
+<a href="#Build">Build</a>
+</li>
+<li>
+<a href="#Alternative">Alternative</a>
+</li>
+<li>
+<a href="#Resources">Resources</a>
+</li>
+</ul>
+</div>
+
+
+<a name="N1000D"></a><a name="Overview"></a>
+<h2 class="boxed">Overview</h2>
+<div class="section">
+<p>
+Between version 10.3 and 10.8.2, Apache Derby distributions included 
+plug-ins for Eclipse.
+These consisted of 3 plug-ins:
+</p>
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+
+<tr>
+
+<td colspan="1" rowspan="1">Plug-in</td>
+<td colspan="1" rowspan="1">Purpose</td>
+
+</tr>
+
+<tr>
+
+<td colspan="1" rowspan="1">core</td>
+<td colspan="1" rowspan="1">Contained the base derby* jars (derby.jar, derbynet.jar, derbytools.jar, derbyclient.jar) providing the actual Derby functionality. Packaged as derby_core_plugin_10.[minor].[bugfixrelease].[build].zip.  
+</td>
+
+</tr>
+
+<tr>
+
+<td colspan="1" rowspan="1">ui</td>
+<td colspan="1" rowspan="1">
+Contained the ui functionality, which enabled one to add a Derby 'Nature' to an Eclipse project, which then added the jars available for building, and added menu options for starting certain Derby tools: to start Network Server and choose port number, start ij, and run sysinfo. Packaged with the doc plugin into derby_ui_plugin_1.[minor].[build].zip.
+</td>
+
+</tr>
+
+<tr>
+
+<td colspan="1" rowspan="1">doc</td>
+<td colspan="1" rowspan="1">
+Contained the Eclipse-Help documentation for the plugin functionality. Packaged with the doc plugin into derby_ui_plugin_1.[minor].[build].zip.
+</td>
+
+</tr>
+
+</table>
+</div>
+
+
+<a name="N1004E"></a><a name="Build"></a>
+<h2 class="boxed">Build</h2>
+<div class="section">
+<p>
+To build the 'core' plug-in one needs to check out a Derby source tree using svn, then build the derby* jars as described in <a class="external" href="http://svn.apache.org/viewvc/db/derby/code/trunk/BUILDING.html?view=markup">BUILDING.html</a>, and then issue 'ant plugin'.
+</p>
+<p>
+To build the ui and doc plug-ins, follow the instructions in the readme.txt in the plugins directory (<a class="external" href="http://svn.apache.org/viewvc/db/derby/code/trunk/plugins/eclipse/Readme.txt?view=markup">Readme.txt</a>).
+</p>
+</div>
+
+
+<a name="N10063"></a><a name="Alternative"></a>
+<h2 class="boxed">Alternative</h2>
+<div class="section">
+<p>
+To achieve similar functionality as the plugins, one can add the derby* jars to a project's classpath, and create 'run' items. 
+</p>
+</div>
+
+
+<a name="N1006D"></a><a name="Resources"></a>
+<h2 class="boxed">Resources</h2>
+<div class="section">
+<p>
+More information on Apache Derby can be found at:
+<a href="http://db.apache.org/derby/">http://db.apache.org/derby/</a>
+
+</p>
+</div>
+
+
+<p>
+
+<em>Last updated: October 1, 2012</em>
+
+</p>
+
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0integrate/derby_plugin_info.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/integrate/func_spec_plugins.html
==============================================================================
--- websites/production/db/content/derby/integrate/func_spec_plugins.html (added)
+++ websites/production/db/content/derby/integrate/func_spec_plugins.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,634 @@
+<!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.8">
+<meta name="Forrest-skin-name" content="pelt">
+<meta name="generator" content="">
+<title>Derby 1.0 UI Plug-in for Eclipse</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">
+<!--+
+    |breadtrail
+    +-->
+<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>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="unselected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="unselected" href="../manuals/index.html">Documentation</a>
+</li>
+<li class="current">
+<a class="selected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Blogs and Articles About Derby</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#blogs">Blogs</a>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3', '../skin/')" id="menu_1.1.3Title" class="menutitle">Articles</div>
+<div id="menu_1.1.3" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.1.3.1', '../skin/')" id="menu_1.1.3.1Title" class="menutitle">Tutorials, Tips and Tuning</div>
+<div id="menu_1.1.3.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#getstarted">Getting Started</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#features">Features, Hints and Tips</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#security">Security</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#performance">Performance and Tuning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.2', '../skin/')" id="menu_1.1.3.2Title" class="menutitle">Tools and Migration</div>
+<div id="menu_1.1.3.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#migration">Migration</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.3.3', '../skin/')" id="menu_1.1.3.3Title" class="menutitle">Applications</div>
+<div id="menu_1.1.3.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../blogs/index.html#client">Client</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#middletier">Middle Tier</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#persistence">Persistence</a>
+</div>
+<div class="menuitem">
+<a href="../blogs/index.html#scalability">Scalability and Failover</a>
+</div>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Integration With Other Products</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#uses">What works with Derby?</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#products">Product Writeups</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.3', '../skin/')" id="menu_selected_1.3Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.3" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a href="../integrate/derby_plugin.html">10 Core</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">1.0 UI Functional Spec</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_howto.html">10 Core and 1.1 UI</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/Readme.html">Building 1.1 UI</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_slides.html">Derby Plug-ins Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6', '../skin/')" id="menu_1.3.6Title" class="menutitle">10 Core and 1.1 UI Documentation</div>
+<div id="menu_1.3.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/java_project.html">Creating an Eclipse Project</a>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6.3', '../skin/')" id="menu_1.3.6.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.3.6.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6.4', '../skin/')" id="menu_1.3.6.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.3.6.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_1.3.6.6', '../skin/')" id="menu_1.3.6.6Title" class="menutitle">ij</div>
+<div id="menu_1.3.6.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij_toc.html">Using ij</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij.html">SQL commands</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij2.html">SQL scripts</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/derby_app.html">Building a Java App</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../skin/')" id="menu_1.4Title" class="menutitle">Papers and Presentations</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/index.html">Overview</a>
+</div>
+<div onclick="SwitchMenu('menu_1.4.2', '../skin/')" id="menu_1.4.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.4.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.4.2.1', '../skin/')" id="menu_1.4.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.4.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://db.apache.org/derby/javadoc/engine/org/apache/derby/iapi/types/package-summary.html#package_description">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.3', '../skin/')" id="menu_1.4.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.4.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4.4', '../skin/')" id="menu_1.4.4Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.4.4" 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 onclick="SwitchMenu('menu_1.4.5', '../skin/')" id="menu_1.4.5Title" class="menutitle">Presentations</div>
+<div id="menu_1.4.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/ApacheCon.html">ApacheCon</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Victorian+Java+User+Group">Victorian JUG 2008</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+</div>
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">&nbsp; 
+                  <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<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>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2"></div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div class="trail">Font size: 
+	          &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>Derby 1.0 UI Plug-in for Eclipse</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Derby+1.0+UI+Plug-in+for+Eclipse">Derby 1.0 UI Plug-in for Eclipse</a>
+<ul class="minitoc">
+<li>
+<a href="#">Background and Overview</a>
+</li>
+<li>
+<a href="#Proposal+for+new+plug-ins+with+addition+of+Derby+Network+Client">Proposal for new plug-ins with addition of Derby Network Client</a>
+</li>
+<li>
+<a href="#-N10038">Rationale for separate plug-ins</a>
+</li>
+<li>
+<a href="#Current+plug-ins">Current plug-ins</a>
+</li>
+<li>
+<a href="#New+plug-ins">New plug-ins</a>
+</li>
+<li>
+<a href="#-N1005F">Source and Binaries at Apache</a>
+</li>
+<li>
+<a href="#Downloading+the+binary+version+of+the+plug-ins+via+the+Eclipse+Update+Manager">Downloading the binary version of the plug-ins via the Eclipse Update Manager</a>
+</li>
+<li>
+<a href="#Obtaining+the+source+for+the+UI+plug-in">Obtaining the source for the UI plug-in</a>
+</li>
+<li>
+<a href="#-N1009A">Eclipse Java Build Path</a>
+</li>
+<li>
+<a href="#-N100A3">Tools</a>
+</li>
+<li>
+<a href="#-N100AC">Product layout and versioning</a>
+</li>
+<li>
+<a href="#-N100B9">Comparision with previous plug-ins</a>
+</li>
+<li>
+<a href="#-N100C2">Testing</a>
+</li>
+<li>
+<a href="#-N10135">Documentation</a>
+</li>
+<li>
+<a href="#-N10147">TO DO or Questions to Resolve</a>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<hr>
+<a name="N10011"></a><a name="Derby+1.0+UI+Plug-in+for+Eclipse"></a>
+<h2 class="boxed">Derby 1.0 UI Plug-in for Eclipse</h2>
+<div class="section">
+<hr>
+<a name="N10016"></a>
+<h3 class="boxed">Background and Overview</h3>
+<p>In its present form the Derby Core plug-in contains only three jar files - derby.jar, derbytools.jar, derbynet.jar. The functionality of the core plug-in makes available these jar files, and thus the Derby database to Eclipse users. Using only this plug-in means manually adding the Derby jar files to the Java Build path in Eclipse. The plug-in is available for download (or to build) at the Apache Derby web site. Note: the core plug-in does not add these jars to an Eclipse user's classpath. They are installed in the Eclipse plug-ins directory, but are not associated with any particular project.</p>
+<p>Another set of plug-ins which is currently available as sister plug-ins to the Derby Core plug-in is the IBM Integration plug-in for Derby. These plug-ins contain db2jcc.jar, db2jcc_license_c.jar, ui.jar and the html help files. The db2jcc.jar file contains the IBM DB2 JDBC Universal driver which acts as a client to the Derby Network server.</p>
+<p>By installing the IBM Integration plug-ins in addition to the Derby Core plug-in the following functionality is provided:</p>
+<ul>
+<li>Ability to configure the Derby network server for each project, including the port number and derby.system.home</li>
+<li>All Derby jar files are added to the Java Build Path of an Eclipse project</li>
+<li>Run ij and entire SQL scripts from within Eclipse</li>
+<li>Start and stop the network server from within Eclipse and track them for each project</li>
+<li>Run sysinfo from within Eclipse</li>
+<li>Integrated help and tutorial on using the plug-ins.</li>
+</ul>
+<p>These plug-ins are available for download as one zip file at the IBM developerWorks web site.</p>
+<a name="N10031"></a><a name="Proposal+for+new+plug-ins+with+addition+of+Derby+Network+Client"></a>
+<h3 class="boxed">Proposal for new plug-ins with addition of Derby Network Client</h3>
+<p>With the creation of the Derby Network Client, we are proposing that the Derby Core plug-in and the IBM Integration plug-in be changed into three new plug-ins. The new Derby core plug-in will contain derby.jar, derbytools.jar, derbynet.jar and derbyclient.jar. The new UI plug-in, Derby tools plug-in (this name has not been finalized and is open for discussion), will contain ui.jar and the help plug-in will contain the html help files.</p>
+<hr>
+<a name="N10038"></a><a name="-N10038"></a>
+<h3 class="boxed">Rationale for separate plug-ins</h3>
+<a name="N1003E"></a><a name="Current+plug-ins"></a>
+<h3 class="boxed">Current plug-ins</h3>
+<p>Currently there are two plug-ins required to make use of the Derby tools like ij and sysinfo and to start the Derby network server from within Eclipse. The core plug-in adds the Derby jar files and the IBM Integration plug-in adds the DB2 network client jar files and the UI components to the Eclipse platform.</p>
+<p>There are several reasons for having two plug-ins:</p>
+<ul>
+<li>Legal requirements</li>
+<li style="list-style: none">
+<ul>
+<li>By using the db2jcc and db2jcc_license_c.jar files we needed to have customers agree to the license agreement prior to downloading the UI plugin. This meant the plug-in had to be hosted at IBM.</li>
+</ul>
+</li>
+<li>The core plug-in can be built at the same time the Derby jar files are built using the ant script available at Apache Derby. By separating the plug-ins the core plug-in can be built from the latest available source at the Derby site. The UI plug-in just contains the DB2 JDBC driver jar files, the UI components which change infrequently.</li>
+<li>Plug-ins frequently depend on other plug-ins and require they already be present or that they be installed at the same time. Also, it's part of the design of Eclipse to separate the UI components - the View layer from the Model layer. An example of this can be found at the CVS repository for the <a class="external" href="http://cvs.sourceforge.net/viewcvs.py/dbedit/">DBEdit</a> plug-in.</li>
+</ul>
+<a name="N10056"></a><a name="New+plug-ins"></a>
+<h3 class="boxed">New plug-ins</h3>
+<p>We believe it is best to have two plug-ins, a UI and a Core, as this follows the pattern generally adhered to for Eclipse plug-ins. The core functionality is separated from the UI functionality. A third plug-in, the help, would document the functionality associated with the UI plug-in.</p>
+<p>Listed below are the scenarios to first build the plug-ins and second, download the plug-ins from the Apache Derby web site.</p>
+<hr>
+<a name="N1005F"></a><a name="-N1005F"></a>
+<h3 class="boxed">Source and Binaries at Apache</h3>
+<p>Presently there is only one plug-in hosted at Apache, the Derby core plug-in. The core plug-in can be downloaded via a web page as a zip file, from the Apache web site <a href="http://db.apache.org/derby/derby_downloads.html">downloads</a> page. The source for the existing Derby plug-in can be checked out via SVN and built using the same ant script used to build the derby jar files. The source for the new plug-in should also be able to be checked out, as well as downloaded in its binary form.</p>
+<p>Starting with the release of the plug-in that contains the new Derby network client, we would like to propose some changes to the way the source tree holds the new ui plug-in, as well as ways to obtain the binary version of both the core and ui plug-ins. To obtain or update the 'binary' version of the plug-ins an Eclipse Update Manager site would need to exist at the Apache web site. To check out the source to build the ui plug-in will require a new branch off of the trunk directory at the Apache Derby source tree. Additional information about these options are discussed below.</p>
+<a name="N1006D"></a><a name="Downloading+the+binary+version+of+the+plug-ins+via+the+Eclipse+Update+Manager"></a>
+<h3 class="boxed">Downloading the binary version of the plug-ins via the Eclipse Update Manager</h3>
+<p>The most commonly used and efficient way for Eclipse users to download plug-ins is to use the Eclipse Update Manager feature. This tool allows users to point Eclipse to a web site (common http URL) to download a plug-in and any plug-in it depends upon. For instance, if we have two plug-ins we can allow users to download only the core plug-in, or both plug-ins. If they choose to download the UI plug-in they will either have to download the core plug-in, or else Eclipse will check to see if they already have the core plug-in and allow the download to continue.</p>
+<p>We know how to do this, all we need is to determine if we want to have an Update Site now, when it is possible the URL for Apache Derby may change in the future. If we change the URL we will have to redirect users to a new URL when it changes.</p>
+<a name="N10075"></a><a name="Obtaining+the+source+for+the+UI+plug-in"></a>
+<h3 class="boxed">Obtaining the source for the UI plug-in</h3>
+<p>We propose creating a new directory/location off the current source tree to get all source files from subversion as an Eclipse plug-in project. Once the source files are imported into the Eclipse workspace as a plug-in project the user would be able to build the plug-in from the source. The html documentation for the help plug-in would be included in this source.</p>
+<p>The specific details will be worked out on derby-dev@db.apache.org if the vote accepting this contribution passes.</p>
+<p>Some examples of this style of checking out source code suitable to import as an Eclipse project are at the Apache Forrest site, Web Tools Project (Eclipse) and the DBEdit (SourceForge) plugins sites.</p>
+<ul>
+<li>Forrest: <a class="external" href="http://svn.apache.org/repos/asf/forrest/trunk/tools/eclipse/">http://svn.apache.org/repos/asf/forrest/trunk/tools/eclipse/</a>
+</li>
+<li>WTP: <a class="external" href="http://www.eclipse.org/webtools/testtutorials/developingwtp/DevelopingWTP.html">http://www.eclipse.org/webtools/testtutorials/developingwtp/DevelopingWTP.html</a>
+</li>
+<li>DBEdit: <a class="external" href="http://cvs.sourceforge.net/viewcvs.py/dbedit/">http://cvs.sourceforge.net/viewcvs.py/dbedit/</a>.</li>
+</ul>
+<p>Some proposed structures, subject to community approval, for the source tree at Derby could be,</p>
+<ul>
+<li>/trunk/tools/eclipse</li>
+<li>/trunk/plugins/eclipse</li>
+</ul>
+<p>The first option is the way forrest has the source tree for Eclipse plug-ins and the second option is something we thought would be nice if Derby ever had a plug-in for something like the NetBeans IDE. For instance the second structure would lend itself to adding a /trunk/plugins/netbeans directory for the NetBeans IDE and would make the use of the term plugins generic. The idea is to put these options as a vote to the Derby list as well as to ask for other suggestions.</p>
+<hr>
+<a name="N1009A"></a><a name="-N1009A"></a>
+<h3 class="boxed">Eclipse Java Build Path</h3>
+<p>derby.jar, derbynet.jar, derbytools.jar and derbyclient.jar are added to the Eclipse project Java Build Path when the Apache Derby nature is added to the Eclipse project.</p>
+<hr>
+<a name="N100A3"></a><a name="-N100A3"></a>
+<h3 class="boxed">Tools</h3>
+<p>The 'ui' plugin adds the derbytools.jar to the project build/run path, this enables the Derby tools like 'ij' and 'sysinfo' to be run within the Eclipse environment. The ability to run the 'dblook' utility has not been yet been provided.</p>
+<hr>
+<a name="N100AC"></a><a name="-N100AC"></a>
+<h3 class="boxed">Product layout and versioning</h3>
+<p>The Derby core plug-in will contain derby.jar, derbytools.jar, derbynet.jar and derbyclient.jar. The UI plug-in will contain ui.jar and the help plug-in with contain the html help files. The version of the core plug-in will be the version of the Derby release which is offered at the time of release of the plug-in, currently thought to be 10.1.0.0. The version of the UI and help plug-ins will be 1.0.0.</p>
+<p>The information contained in the Eclipse help files associated with the plug-in and the sample program have been changed to reflect the new Derby client database connection URL.</p>
+<p>Since the core plug-in will now have an addtional jar file contained in it, namely derbyclient.jar, the java class, DerbyEclipsePlugin.java, that creates the plugin.xml file for the existing core plug-in will need to be modified to include derbyclient.jar.</p>
+<hr>
+<a name="N100B9"></a><a name="-N100B9"></a>
+<h3 class="boxed">Comparision with previous plug-ins</h3>
+<p>At this time the functionality between the previous versions of the plug-in and the newer versions will be identical except for any differences due to changes in behaviour of the Derby Client replacing the DB2 Universal Driver client.</p>
+<hr>
+<a name="N100C2"></a><a name="-N100C2"></a>
+<h3 class="boxed">Testing</h3>
+<p>Below is a list of manual testing steps which have been completed at the time of this contribution. The timing of this testing should occur whenever a new binary version of the plug-ins is made available at http://db.apache.org/derby/derby_downloads.html, or more frequently if desired, such as when a new milestone of Eclipse is released.</p>
+<ol>
+<li>Unzip the plug-ins into the $ECLIPSE_HOME directory. For instance, if Eclipse is installed under /eclipse, unzip the plug-ins into /eclipse.<br>
+<br>
+</li>
+<li>Create a simple project in Eclipse and add the Apache Derby nature to the project. Verify the following jar files have been added to the project and the Java Build path of the project contains the following: derby.jar, derbynet.jar, derbyclient.jar, derbytools.jar.<br>The Java Build path can be verified by right-clicking the project and selecting Properties. Once the Properties window appears select Java Build Path from the left frame, then select the Libraries tab. The Libraries tab should contain all of the jar files mentioned above.<br>
+<br>
+</li>
+<li>Create a java project in Eclipse and add the Apache Derby nature to the project. Verify the following jar files have been added to the project and the Java Build path of the project contains the following: derby.jar, derbynet.jar, derbyclient.jar, derbytools.jar.<br>
+<br>
+</li>
+<li>From one of the projects created above, start the derby network server at the default port on the localhost by right-clicking the project, then selecting <strong>Apache Derby &gt;&gt; Start Derby Network Server</strong>. Verify it starts.<br>
+<br>
+</li>
+<li>From the project which started the network server, select <strong>Apache Derby &gt;&gt; ij (Interactive SQL)</strong>, from the menu. Verify connection to the network server with a database URL in this format:<br>
+<br>
+<pre>connect 'jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine';
+</pre>
+</li>
+<li>After the connection is made to the network server via ij, create a table in the myDB database, and verify rows can be inserted into the table.<br>
+<br>
+</li>
+<li>Issue a disconnect and exit from ij. Verify the ij console window terminates.<br>
+<br>
+</li>
+<li>From the project which started the network server, create a new file, <strong>File &gt;&gt; New &gt;&gt; File</strong>, and give it a .sql extension. Enter the following SQL in the file, once the file appears in the editor.<br>
+<br>
+<pre>connect 'jdbc:derby://localhost:1527/myDB;user=me;password=mine';
+create table foo (id integer, name varchar(20));
+insert into foo values (1, 'derby');
+insert into foo values (2, 'derby plug-ins');
+disconnect;
+exit;
+</pre>Right click the file just created and select <strong>Apache Derby &gt;&gt; Run SQL Script using 'ij'</strong>. Verify the script ran correctly, including connecting to the existing myDB database and inserting values into the foo table.<br>
+<br>
+</li>
+<li>From the same project the network server was started from, stop the derby network server at the default port on the localhost. Verify it stops.<br>
+<br>
+</li>
+<li>Select a project which has the Apache Derby nature added to it and select the menu item <strong>Apache Derby &gt;&gt; sysinfo (Derby System Information)</strong>. Ensure the Derby Information section includes the following jar files: derby.jar, derbynet.jar, derbyclient.jar and derbytools.jar.<br>
+<br>
+</li>
+<li>Select a project which has the Apache Derby nature added to it and select the menu item <strong>Properties</strong>. Verify in the Properties window the Apache Derby item is available in the left hand frame. Select it. Change the value of the Network Server Port to some other available port number (not 1527, the default value), and change the Network Server Host value to the ip address of the host running eclipse. For instance, 9.10.111.11. Change the value of the derby.system.home Derby System Property to a path on the file system. For instance, /eclipse/mynewdir on Unix and Linux, or C:/temp, on Windows. Apply the changes, then click OK.<br>
+<br>
+</li>
+<li>Select the project just modified above with new values for the network server and derby.system.home settings. Start the Derby Network Server. Verify it starts on the newly set values for host and port.<br>
+<br>
+</li>
+<li>From the project which started the network server, launch <strong>ij (Interactive SQL)</strong>, from the menu. Verify connection to the network server with a database URL like this: <pre>connect 'jdbc:derby://9.10.111.11:9999/differentDB;create=true;user=me;password=mine';
+</pre>Substitute the actual values entered in the Properties window in step 11 above. Verify the database, differentDB, was actually created in the directory for derby.system.home entered in step 11. For instance, either in /eclipse/mynewdir or in C:/temp, there should now be a differentDB directory.<br>
+<br>
+</li>
+<li>From the same project the network server was started from, stop the derby network server. Verify it stops.<br>
+<br>
+</li>
+<li>Select a project which has the Apache Derby nature added to it and select the menu item <strong>Apache Derby &gt;&gt; Remove Apache Derby nature</strong>. Verify the following jar files have been removed from the project and the Java Build path of the project no longer contains the following: derby.jar, derbynet.jar, derbyclient.jar, derbytools.jar.<br>
+<br>
+</li>
+<li>Verify the Help documentation is installed. Select the menu item <strong>Help &gt;&gt; Help Contents &gt;&gt; Derby Plug-ins User Guide</strong>. Expand the Getting Started section to see the various topics.<br>
+<br>
+</li>
+<li>Follow each step, complete all examples and build and run the sample application contained in the Derby Plug-ins User Guide.</li>
+</ol>
+<hr>
+<a name="N10135"></a><a name="-N10135"></a>
+<h3 class="boxed">Documentation</h3>
+<p>The html files included with the help plug-in have been updated with the following changes to reflect the changes due to the addition of the derby network client being used to connect to the network server, instead of the DB2 JDBC Driver:</p>
+<ul>
+<li>package name</li>
+<li>jar file name</li>
+<li>database connection URL</li>
+<li>screen shots</li>
+</ul>
+<hr>
+<a name="N10147"></a><a name="-N10147"></a>
+<h3 class="boxed">TO DO or Questions to Resolve</h3>
+<p>This document has listed a few items which need to be resolved, and others that have not yet been mentioned. These items which need action or further discussion on the derby-dev mailing list are shown below.</p>
+<ol>
+<li>Determine source code structure for the repository of the UI source.</li>
+<li>Update BUILDING.TXT to include instructions on how to build the core plug-in. <ul>
+<li>Presently the instructions on how to build the core plug-in is only referenced in an email. These instructions need to be contained in the source tree.</li>
+</ul>
+</li>
+<li>Modify org.apache.derbyBuild.plugin.DerbyEclipsePlugin.java to add the new derbyclient.jar to the list of jars contained in the core plug-in.</li>
+<li>Provide a second document contained in the new source code structure explaining how to build the UI plugin in the Eclipse environment.</li>
+<li>Provide new documentation for the Apache Web site on how to use the new plug-ins.</li>
+<li>Updating existing documentation on the Apache Web site for the old plug-in.</li>
+<li>Provide the help files for the new plug-in on the Apache Web site.</li>
+</ol>
+<hr>
+</div>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+        Copyright &copy;
+         2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0integrate/func_spec_plugins.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>



Mime
View raw message