db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r843115 [9/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/css...
Date Wed, 19 Dec 2012 18:20:28 GMT
Added: websites/production/db/content/derby/integrate/JPetStoreGeronimo.html
==============================================================================
--- websites/production/db/content/derby/integrate/JPetStoreGeronimo.html (added)
+++ websites/production/db/content/derby/integrate/JPetStoreGeronimo.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,591 @@
+<!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>Using  Apache Derby with iBATIS JPetStore 4 running on the Geronimo J2EE server</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>Using  Apache Derby with iBATIS JPetStore 4 running on the Geronimo J2EE server</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Introduction">Introduction</a>
+</li>
+<li>
+<a href="#Typographic+Conventions+Used">Typographic Conventions Used</a>
+</li>
+<li>
+<a href="#Required+Software+%2F+Downloads">Required Software / Downloads</a>
+</li>
+<li>
+<a href="#Setup+Steps%3A">Setup Steps:</a>
+</li>
+<li>
+<a href="#Optional+Database+Setup+Instructions">Optional Database Setup Instructions</a>
+</li>
+<li>
+<a href="#Integration+Notes">Integration Notes</a>
+</li>
+<li>
+<a href="#Related+Links">Related Links</a>
+</li>
+</ul>
+</div>
+		
+<p>
+The first tasks performed when installing an application that uses a database are generally related to database setup.  These steps often involve compiling DBMS code (if the database system is not already installed) and creating and populating the physical database used by the application.  Such steps are required to create executables and files that can be used in the operating environment of the host computer.  By using a database like Derby that is implemented entirely in JAVA these build steps are not required.  Installation of the Derby DBMS can be as simple as copying a 2 Mb jarfile to a known location.  The fully initialized physical database can be bundled with the application thus reducing the database setup steps to a simple copy operation.  The following instructions demonstrate this by deploying the iBATIS JPetStore application along with a ready-to-go Derby database on a Geronimo server.   These instructions can be used on any machine with a functioning J2SE JVM
  using the ASCII codeset.  Conversion or recreation of the supporting files (but not the database) will be required for deployment in an EBCDIC environment.
+</p>
+		
+<a name="N10010"></a><a name="Introduction"></a>
+<h2 class="boxed">Introduction</h2>
+<div class="section">
+<p>
+This article demonstrates the ease with which a J2EE application that uses a Derby database (the iBATIS JPetStore 4.0 web-based sales application) can be setup and deployed on  the Geronimo J2EE server.  iBATIS JPetStore is based on Sun's J2EE Pet Store and can be setup to use a variety of databases and executed on a variety of J2EE or JSP Servers.  JPetStore was written by Clinton Begin as a comparison of the .NET and J2EE architectures.  JPetStore uses Struts, the iBATIS data mapper framework and JAVA to implement the application logic and user interface.  The three components used to implement this deployment of JPetStore, <a class="external" href="http://ibatis.apache.org">iBATIS</a>, <a class="external" href="http://geronimo.apache.org">Geronimo</a> and <a href="http://db.apache.org/derby">Derby</a>, are all being developed by the Apache community and are freely available thru the Apache Foundation Website.  
+</p>
+</div>
+				
+<a name="N10026"></a><a name="Typographic+Conventions+Used"></a>
+<h2 class="boxed">Typographic Conventions Used</h2>
+<div class="section">
+<p> The following codes in curly braces will be used to represent installation dependant file locations as described below:</p>
+<ul>
+				
+<li>{GERONIMO_HOME}: The installation directory for the Geronimo Server.  Note that this installation path should not contain any spaces.</li>
+				
+<li>{machine-name}: the hostname of the machine on which the server and application are installed.</li>
+				
+<li>{Derby_Jars}: the directory containing the Derby jar file(s).  The deployment files provided with this article use the derby jars provided with Geronimo.  Verify that the file <em>derby-10.0.2.1.jar</em> exists in the directory  {GERONIMO_HOME}\repository\incubator-derby\jars.</li>
+				
+<li>{Derby_System_Home}: the directory containing the <em>derby.log</em> file, Geronimo <em>SystemDatabase</em> and the application <em>Databases</em> directory tree.  To use the files provided with this article this location should be {GERONIMO_HOME}/var/derby.  Note that Geronimo creates this directory the first time it starts and sets the derby.system.home variable to this location.  The JPetStoreDB database will be located in the  <em>{Derby_System_Home}\Databases</em> subdirectory. </li>
+			
+</ul>
+</div>
+		
+<a name="N1004E"></a><a name="Required+Software+%2F+Downloads"></a>
+<h2 class="boxed">Required Software / Downloads</h2>
+<div class="section">
+<ul>
+				
+<li>If necessary, install a functional J2SE Java Developers Kit (JDK).  A JDK of version 1.4.1 or higher is recommended.  The JDK 'bin' directory should be included in your PATH.</li>
+				
+<li> Download the <a class="external" href="http://geronimo.apache.org/downloads.html">Geronimo 1.0 Milestone 4</a> release.  Extract the Geromino installation files to {GERONIMO_HOME}.       </li> 
+	
+<li>Download the <a href="../binaries/JPetStoreAPP4Geronimo.zip">JPetStoreAPP4Geronimo.zip</a> file associated with this article.  Extract the files to a convenient working directory.   </li>
+			
+</ul>
+</div>
+		
+<a name="N10069"></a><a name="Setup+Steps%3A"></a>
+<h2 class="boxed">Setup Steps:</h2>
+<div class="section">
+<ul>	
+<li>
+					
+<em>Extract the database zipfile and deployment files:</em> Unzip the files from JPetStoreAPP4Geronimo.zip into a working directory.</li>
+					
+<li>
+<em>Move deployment files to {GERONIMO_HOME}:</em>Move the following three files to the {GERONIMO_HOME} directory:<ul>
+						
+<li>
+<em>jpetstoreAPP.war</em> - The JPetstore application web archive file.</li>
+						
+<li>
+<em>jpetstoreAPP-geronimo-jetty.xml</em> - The Geronimo web application deployment descriptor.</li>
+						
+<li>
+<em>DbPoolDeployPlan.xml</em> - The Derby datasource deployment descriptor.</li>
+					
+</ul>
+					Using the file <em>setupM4.bat</em> as a template, create a script file for your platform that defines the locations on your machine of the Geromino installation, the Geronimo J2EE jarfile and the Java JRE or JDK.
+					</li>
+				
+<li>
+					
+<em>Start Geronimo:</em> In a command window/shell, execute the customized setupM4 script file then start the Geronimo server from {GERONIMO_HOME} using the command:  <span class="codefrag">java -jar bin\server.jar</span>
+</li>
+				
+<li>
+<em>Setup the JPetStoreDB database:</em> Unzip the files from JPetStoreAPP4Geronimo.zip into the {Derby_System_Home} directory ({GERONIMO_HOME}/var/derby).</li>
+   
+<li> 
+<em>Deploy and start the datasource:</em> In a new command shell/window execute the customized setupM4 script file then issue the following commands to deploy and start the JPetstore datasource:
+   <pre class="code">
+   &gt; java -jar bin/deployer.jar --user system --password manager distribute DbPoolDeployPlan.xml repository/tranql/rars/tranql-connector-1.0-20050716.rar
+      Distributed JPetStoreDB
+   &gt; java -jar bin/deployer.jar --user system --password manager start JPetStoreDB
+      Started JPetStoreDB
+     </pre>
+	   
+</li>
+				
+<li>
+					
+<em>Deploy and start the application:</em> Issue the following commands to deploy and start the iBATIS JPetStore application:
+					   <pre class="code">  
+    &gt;  java -jar bin\deployer.jar --user system --password manager distribute jpetstoreAPP.war jpetstoreAPP-geronimo-jetty.xml
+         Distributed JPetStoreAPP
+    &gt; java -jar bin/deployer.jar --user system --password manager start JPetStoreAPP
+          Started JPetStoreAPP
+					    </pre>
+	   
+</li>
+				
+<li>
+					
+<em>Test the JPetStoreAPP:</em>  Open your browser and enter the following URL:
+		   <pre class="code">
+   http://{machine-name}:8080/jpetstoreAPP
+		   </pre>
+				
+</li>
+			
+</ul>
+</div>
+		
+		
+<a name="N100BE"></a><a name="Optional+Database+Setup+Instructions"></a>
+<h2 class="boxed">Optional Database Setup Instructions</h2>
+<div class="section">
+<p>The following steps show how to build the Derby database from scratch.  Two files (*.sql) are supplied in the JPetStoreAPP4Geronimo.zip. file to perform the initial build and data inserts.  You will need to download the complete set of Derby jarfiles and use the IJ tool found in derbytools.jar to perform the build.  Place derbytools.jar in the {Derby_Jars} directory.   The IJ tool is used to process the SQL commands in the provided scripts.  For simplicity the examples below place all necessary files in the same directory and specify as much a possible (including the command to create the database) on the command line.</p>
+<ul>
+				
+<li>Copy the following SQL script files to the <em>{Derby_System_Home}\Databases</em> subdirectory where you will build the database: <span class="codefrag">,jpetstore-derby-schema.sql, jpetstore-derby-dataload.sql</span>.  Issue the following command to create the database, tables and indexes:
+	<pre class="code">
+   java -cp {Derby_Jars}/derby.jar;{Derby_Jars}/derbytools.jar -Dij.database=jdbc:derby:JPetStoreDB;create=true 
+	   org.apache.derby.tools.ij jpetstore-derby-schema.sql
+	</pre>
+				
+</li>
+				
+<li>Now load the data into the tables using the following command:
+	<pre class="code">
+	java -cp {Derby_Jars}/derby.jar;{Derby_Jars}/derbytools.jar -Dij.database=jdbc:derby:JPetStoreDB
+	   org.apache.derby.tools.ij jpetstore-derby-dataload.sql
+	</pre>
+				
+</li>
+			
+</ul>
+<p>You now have a fully populated database to use with the JPetStore application.</p>
+</div>
+					<!--			Integration Notes Section			-->
+		
+<a name="N100E4"></a><a name="Integration+Notes"></a>
+<h2 class="boxed">Integration Notes</h2>
+<div class="section">
+<p>
+J2EE Servers use multiple classloaders (aka hierarchies) to provide the isolation necessary to run many applications at once.  This Derby-JPetStore integration uses a server datasource to avoid problems that can occur when Derby is used in an environment using multiple classloaders.  Derby is written in Java and all its classes must be loaded by the same classloader.    When using a J2EE Server this can be assured by defining Derby datasources at the server level. This is particularly important when using Derby in it's embedded configuration.   When using a database or other datasource in a J2EE environment it is also a good design practice to access them via a J2EE resource managed by the server.    
+   	</p>
+<p>
+   	The zipfile provided contains a fully initialized database to demonstrate that a Derby database built and populated on one platform (in this case Windows) can be transferred to different platforms and work fine.  Try copying the database and derby jarfiles to different platforms and you will see that the system works without modification.  The text files included in the zipfile will not do well in an EBCDIC architecture but the Derby engine and supplied database will work fine. If you want to build the database from scratch you can use the SQL files supplied in the archive.  See the 'Optional Database Setup Instructions' section for how to use the IJ tools to build and populate the database.</p>
+<p>If you wish to build your own iBATIS JPetstore war file like the one supplied in the JPetStoreAPP4Geronimo.zip file  you will need to download the JPetStore application source code (see the 'Related Links' section) and make the following modifications to the source files before performing a build as described in the JPetStore build instructions: </p>
+<ul>
+					
+<li>
+					Edit the <span class="codefrag">sql-map-config.xml</span> file and replace the existing TransactionManager definition section with the this section that specifies a JNDI lookup should be performed to obtain the datasource to use:
+			<pre class="code">
+   &lt;transactionManager type="JDBC" &gt;
+      &lt;dataSource type="JNDI"&gt;
+         &lt;property name="DBJndiContext" value="jdbc/JPetStoreDB"/&gt;
+      &lt;/dataSource&gt;
+   &lt;/transactionManager&gt;
+   </pre> 
+</li>
+   
+<li>Edit the <span class="codefrag">web.xml</span> file and replace the existing resource-ref definition with the following:
+      <pre class="code">
+      &lt;resource-ref&gt; 
+   &lt;description&gt;JPetStore DataSource&lt;/description&gt;
+	&lt;res-ref-name&gt;jdbc/JPetStoreDB&lt;/res-ref-name&gt;
+	&lt;res-type&gt;javax.sql.DataSource&lt;/res-type&gt;
+	&lt;res-auth&gt;Container&lt;/res-auth&gt;
+	&lt;res-sharing-scope&gt;Shareable&lt;/res-sharing-scope&gt;
+   &lt;/resource-ref&gt;
+   </pre>  
+</li>
+   
+</ul>
+<p>
+  If you are interested in using Geronimo you may also want to check out the Gluecode SE application server.  The Gluecode SE application server bundles Geronimo and provides a GUI management console that simplifies and automates the operations outlined above. Rather than creating the XML descriptor files using a text editor the datasource and application deployments are performed from console screens. Starting the datasource(s) and application(s) can also be done from the console or defined to start automatically when the Gluecode server starts.  For more information see the Geronimo link in the 'Related Links' section of this document.
+   </p>
+</div>
+		
+		<!--		RELATED LINKS SECTION  -->
+		
+<a name="N10110"></a><a name="Related+Links"></a>
+<h2 class="boxed">Related Links</h2>
+<div class="section">
+<p>Required Downloads to perform this deployment: </p>
+<ul>
+				
+<li> 
+<a href="../binaries/JPetStoreAPP4Geronimo.zip">JPetStoreAPP4Geronimo.zip</a>
+				
+</li>	
+<li>	Geronimo Server M4
+	<a class="external" href="http://geronimo.apache.org/downloads.html">Geronimo Binaries</a>
+				
+</li> 				
+</ul>
+<p>Download links for software used in creating this deployment:</p>
+<ul>
+				
+<li>
+    
+<a href="http://db.apache.org/derby/releases/release-10.0.2.1.html">Apache Derby version 10.0.2.1</a> [Note: the *-bin archives contain the documentation as well as Derby].
+  </li>
+				
+<li>
+
+<a class="external" href="http://prdownloads.sourceforge.net/ibatisjpetstore/iBATIS_JPetStore-4.0.5.zip?download">iBATIS JPetStore version 4.0.5</a> 
+</li> 
+</ul>
+<p>Main websites references:</p>
+<ul> 
+<li>
+	For more information on Derby see the <a href="http://db.apache.org/derby/index.html">Apache Derby Project site</a>
+				
+</li>
+				
+<li>
+	For more information on iBATIS see the <a class="external" href="http://ibatis.apache.org">iBATIS Home page</a>
+				
+</li>
+				
+<li>For more information on Geronimo see the <a class="external" href="http://geronimo.apache.org">Apache Geronimo Project site</a>
+				
+</li>								
+				
+</ul>
+<p>Related products and artilces:</p>
+<ul>
+				
+<li>For information on Gluecode SE application server see the <a class="external" href="http://www.gluecode.com">Gluecode Software site</a>
+				
+</li>
+				
+<li>Follow this link for details of a similar deployemnt of <a href="JPetStoreWebSphere.html">JPetStore and Derby in a WebSphere</a> Server environment.</li>
+			
+</ul>
+</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/JPetStoreGeronimo.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/integrate/JPetStoreWebSphere.html
==============================================================================
--- websites/production/db/content/derby/integrate/JPetStoreWebSphere.html (added)
+++ websites/production/db/content/derby/integrate/JPetStoreWebSphere.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,730 @@
+<!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>Using Apache Derby with iBATIS JPetStore 4 on the WebSphere Server</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>Using Apache Derby with iBATIS JPetStore 4 on the WebSphere Server</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Introduction">Introduction</a>
+</li>
+<li>
+<a href="#Required+Software">Required Software</a>
+</li>
+<li>
+<a href="#Setup+Overview">Setup Overview</a>
+</li>
+<li>
+<a href="#CookBook+Details">CookBook Details</a>
+</li>
+<li>
+<a href="#Integration+Notes">Integration Notes</a>
+</li>
+<li>
+<a href="#Related+Links">Related Links</a>
+</li>
+</ul>
+</div>
+		
+<a name="N1000D"></a><a name="Introduction"></a>
+<h2 class="boxed">Introduction</h2>
+<div class="section">
+<p>
+JPetStore is a rewritten Pet Store application based on Sun's J2EE Pet Store.  It was originally designed to compare the .NET and J2EE architectures.  It is now the official example application for the iBATIS SQL Maps 2.0 and DAO 2.0 open source software products.  See the 'JPetStore' and 'iBATIS' links in the related links section below to download JPetStore and for more information on the application history and architecture.  
+</p>
+<p>
+This document demonstrates setting up the JPetStore 4.0 application to run on a J2EE Application Server using an embedded Apache Derby database as the persistence layer.  Apache Derby is a small footprint, open source, relational database engine written in Java.  It is ideally suited for use with J2EE and Web applications where reliability, portability, ease of use and low maintenance is important.  Derby is an Apache DB project.
+</p>
+<p>
+One of the more difficult parts of installing JPetStore is meeting the initial assumption that you have some sort of relational database installed and working.  Apache Derby, in it's embedded configuration, is a single 2 Mb jarfile that simply needs to be in the classpath of the application.  The jarfile can be bundled with the application files and in many cases the user is not aware that a database is in use at all.  Because it's java it does not matter what physical architecture the application will be deployed on.  The same database files and database classes can be copied directly to any platform and used as-is.  No local application or database build is required, only a functioning JVM is needed.
+</p>
+<p>
+The following outlines the steps needed to install and run JPetStore 4 using Apache Derby on WebSphere Application Server version 6.0.  Though WebSphere is used for this example, any J2EE Application Server could be used to run this demonstration.  Only the cookbook details portion on installing the application in WebSphere will differ.
+</p>
+</div>
+		
+<a name="N10020"></a><a name="Required+Software"></a>
+<h2 class="boxed">Required Software</h2>
+<div class="section">
+<ul>
+				
+<li>   Downloaded the <a class="external" href="http://prdownloads.sourceforge.net/ibatisjpetstore/iBATIS_JPetStore-4.0.5.zip?download">JPetStore</a> Demo - the download URL is also provided in  the Links section below.
+  </li>
+				
+<li> Downloaded the <a href="../binaries/JPetStoreAPP4WebSphere.zip">JPetStoreAPP4WebSphere.zip</a> file or plan to download Derby separately and manually edit the application configuration as described in the CookBook Details section below.  The downloads URLs are also provided in  the Links section below.
+  </li>
+				
+<li> WebShere Application Server version 6.0.1.  You can obtain an <a class="external" href="http://www-128.ibm.com/developerworks/downloads/ws/wasexp">evaluation</a> copy of WebSphere and the 6.0.1  <a class="external" href="http://www-1.ibm.com/support/docview.wss?rs=0&context=SW600&dc=D420&q1=WebSphere&uid=swg24009071&loc=en_US&cs=utf-8&cc=us&lang=en">upgrade</a> from IBM.  The downloads URLs are also provided in  the Links section below.
+  </li>
+			
+</ul>
+</div>
+		
+<a name="N10043"></a><a name="Setup+Overview"></a>
+<h2 class="boxed">Setup Overview</h2>
+<div class="section">
+<p> Details on the following steps can be found in the CookBook Details section below.
+   The following abbreviations will be used in the sections below:</p>
+<ul>
+				
+<li>WAS: WebSphere Application Server.</li>
+				
+<li>{machine-name}: the hostname of the machine on which the server and application are installed.</li>
+				
+<li>{SrvRoot}: the main directory of the WebSphere application server. </li>
+				
+<li>{Derby_Home}: the directory into which the Derby jar file(s) are placed.  In a Server environment a good choice would be {SvrRoot}/Derby.</li>
+				
+<li>{AppRoot}: the directory into which the JPetStore WAR file was installed by WebSphere ( if the default names are used this will be: {SrvRoot}/profiles/default/installedApps/{machine-name}Node01Cell/jpetstore_war.ear )</li>
+			
+</ul>
+<p>
+				
+<strong>Steps:</strong>
+			
+</p>
+<ul>
+				
+<li>Setup {Derby_Home}: Unzip JPetStoreAPP4WebSphere.zip and move the Derby directory from the zip file into {Derby_Home}. </li>
+				
+<li> Create the datasource: Define a Server JDBC datasource for the JPetStore database with the JNDI name of jdbc/JPetStoreDB.  Select 'Cloudscape' as the WAS database type and use the Derby embedded XA datasource.
+	   </li>
+				
+<li>   Install JPetStore.  Use the WAS Administration console to install the downloaded jpetstore.war file.  Enter the context root as "/jpetstore".  Accept all the defaults except:
+	   <ul>
+						
+<li>Step 1: Check "Deploy Web Services". </li>
+						
+<li>Step 3: Map the application to the datasource created above ( jdbc/JPetStoreDB)</li>
+					
+</ul>
+					
+<ul>
+						
+<li>Update the JPetStore sql-map-config.xml file with the one provided in the JPetStoreAPP4WebSphere.zip file</li>
+						
+<li> Restart WebSphere </li>
+						
+<li> Stat the JPetStore application by entering the following URL into your favorite browser:
+		   <pre class="code">
+   http://{machine-name}:9080/jpetstore
+		   </pre>
+						
+</li>
+					
+</ul>
+				
+</li>
+			
+</ul>
+</div>
+		
+<a name="N1008A"></a><a name="CookBook+Details"></a>
+<h2 class="boxed">CookBook Details</h2>
+<div class="section">
+<p>
+				
+<strong>Setup Derby</strong>
+			
+</p>
+<ul>
+				
+<li>Unzip the Derby folder from the JPetStoreAPP4WebSphere.zip file.  It is recommended this be placed in the {SrvRoot} directory.  The folder contains the initialized JPetStore database (the directory tree JPetStoreDB) the derby.jar file and the new sql-map-config.xml file needed to define the JNDI datasource to the iBATIS system.  Two sql files are also included so the database can be built from scratch if desired.  See the Integration Notes section for information on how to use the scripts.
+   </li>
+				
+<li>Starting the WebSphere 'First steps' program will provide an easy way to start and stop the server and the administrative console while performing the operations detailed below. </li>
+			
+</ul>
+<p>
+				
+<strong>Create the WebSphere datasource</strong>
+			
+</p>
+<ul>
+				
+<li> Start WAS and start the administrative console </li>
+				
+<li>Define a WAS environment variable for {Derby_Home} with the following steps:
+    <ul>
+						
+<li> Navigate the following links to the Node  level variable definition screen:  <span class="codefrag">Environment &gt; WebSphere Variables (check or set the NODE radio button active - click [APPLY] ) &gt; NEW</span>
+						
+</li>
+						
+<li> Enter the following information:
+		<pre class="code">
+   Name: DERBY_HOME
+   value: ${WAS_INSTALL_ROOT}/Derby
+   Description:  JPetStore Derby Files
+   Click: [SAVE]
+		</pre>
+						
+</li>
+					
+</ul>
+				
+</li>
+			
+</ul>
+<ul>
+				
+<li>Navigate the following links to the Server level JDBC Resource / datasource definition screens: <span class="codefrag">Resources &gt; JDBC providers (check or set the SERVER radio button active - click [APPLY]) &gt; NEW</span>
+					
+<ul>
+						
+<li>On the General Properties screen select from the drop down lists:
+	   <pre class="code">
+    database type: Cloudscape
+    provider type:  Cloudscape JDBC Provider
+    Implementation:  XA data source  
+    Click [NEXT]
+	   </pre>
+						
+</li>
+					
+</ul>
+					
+<ul>
+						
+<li>   On the JDBC Provider screen enter:  
+			<pre class="code">
+   Name:Derby JDBC Provider (XA)
+   Desc:Derby 10 embedded JDBC2-compliant Provider
+   Path:  ${DERBY_HOME}/derby.jar
+   Implementation class name :  org.apache.derby.jdbc.EmbeddedXADataSource
+   Click [APPLY]
+		   </pre>
+						
+</li>
+						
+<li>   Under 'Additional Properties' click  'Data Sources'.  On the Data Sources screen click 'New' and enter:
+	   <pre class="code">
+   Name: JPetStoreDB
+   JNDI Name:  jdbc/JPetStoreDB
+   Uncheck the checkbox labeled: Use this Data Source in container managed persistence (CMP)
+   Click the radio button labeled: Data store helper classes provided by WebSphere Application Server 
+   Select the "Generic Datastore Helper"
+   Click [APPLY]
+	   </pre>
+						
+</li>
+						
+<li>   Under 'Additional Properties' click 'Custom Properties' and enter: 
+	   <pre class="code">
+   NAME: databaseName
+   Value:  ${DERBY_HOME}/JPetStoreDB
+   Click [SAVE]
+	   </pre>
+						
+</li>
+						
+<li> In the 'messages' box at the top of the page click the 'save' link.  On the Application servers - Save screen click the button [SAVE] to save the new definitions</li>
+					
+</ul>
+				
+</li>
+			
+</ul>
+<p>
+				
+<strong>Install the JPetStore Application </strong>
+			
+</p>
+<ul>
+				
+<li>Unzip the iBATIS JPetStore files in your favorite developement area and locate the jpetstore.war supplied.  In the distribution I downloaded this was in:  {favorite-development-area}/build/wars</li>
+				
+<li>In the WebSphere Application Console click on 'Install New Application' - this is in the left navigation pane under Applications.  On the following screens accept the default values except as noted:
+   <pre class="code"> 
+      On the 'Preparing for the application installation - Specify..' screen:
+            Click the radio button:  'Local Filesystem'
+            Browse to the jpetstore.war file downloaded from iBATIS
+            Enter the context-root as: /jpetstore
+            Click [NEXT]
+      On the 'Preparing for the application installation - Bindings.' screen:
+		   Accept the defaults by clicking:  [NEXT]
+		   Dismiss the security warnings by clicking [CONTINUE]
+      On the Step 1 screen 
+            Select the checkbox:  'Deploy Web services'
+	            (note the application name defaults to: jpetstore_war )
+            Click [NEXT]
+      On the Step 2 screen 
+            Accept the defaults by clicking [NEXT]
+      On the Step 3 Map the JNDI datasource defined previously to the application:
+		   At the bottom of the screen 
+		         click the 'Select' checkbox next to the JPetStore Module
+		   In the 'javax.sql.DataSource' box (near the top) 
+		         select the JNDI datasource name from the dropdown list (e.g. jdbc/JPetStoreDB)
+		   Click the [APPLY] button next to the JNDI datasource name
+		   At the bottom check that the JNDI name appears in the JPetStore Module box.
+            Click [NEXT]
+      On the Step 4 screen accept the defaults by clicking [NEXT]
+      On the Step 5 screen accept the defaults by clicking [NEXT]
+      On the Step 6 screen review the SUMMARY, correct or click  [FINISH]
+       After the 'Installing...' reports '..installed successfully.' click the 'Save to Master Configuration' link.
+      The 'Changed documents' screen is displayed - click:  [SAVE]
+   </pre>
+				
+</li>
+			
+</ul>
+<p>
+				
+<strong>Replace the  <span class="codefrag">sql-map-config.xml</span> file in the application</strong>
+			
+</p>
+<ul>
+				
+<li>In the WebSphere Application Console click on 'Enterprise Applications' in the left navigation pane under Applications</li>
+				
+<li> Select the check box next to the JPetStore application (jpetstore_war).  The application will be stopped and have a red X next to it - this is not a problem.  The application will automatically start when WebSphere is started.</li>
+				
+<li>Click the 'Update' button</li>
+				
+<li>On the 'Preparing for the application installation' screen:
+		<pre class="code">
+    Select the 'Single File' radio button
+    Enter the path relative to {AppRoot} for the sql-map-config.xml file just installed (e.g. 
+       jpetstore.war/WEB-INF/classes/com/ibatis/jpetstore/persistence/sqlmapdao/sql/sql-map-config.xml)
+    Click the 'Local file system' radio button and browse to the directory where
+       you unzipped the JPetStoreAPP4WebSphere.zip file.  
+    Select the sql-map-config.xml file provided in the zipfile
+    Click [NEXT]
+    On the 'Confirmation' screen click [OK]
+    On the 'Update' screen click the 'Save to Master Configuration' link.
+    On the 'Changed documents' screen click:  [SAVE]
+		</pre>
+				
+</li>
+			
+</ul>
+<ul>
+				
+<li>
+					
+<strong>Restart the server and test the application</strong>
+				
+</li>
+			
+</ul>
+<p>
+				
+<strong>Optional instructions</strong>
+			
+</p>
+<p>The following steps show how to build the Derby database from scratch.  Two files are supplied in the JPetStoreAPP4WebSphere.zip file to perform the initial build and data inserts.  You will need to download the complete set of Derby jarfiles and place derbytools.jar in your classpath to perform the build as these instructions utilize the IJ tool to process the commands in the provided scripts.  For simplicity the examples below place all necessary files in the same directory and specify as much a possible (including the command to create the database) on the command line.</p>
+<ul>
+				
+<li>Copy the following files to the directory where you want to build the database: <span class="codefrag">derby.jar, derbytools.jar,jpetstore-derby-schema.sql, jpetstore-derby-dataload.sql</span> and issue the following command to create the database, tables and indexes:
+	<pre class="code">
+   java -cp ./derby.jar;./derbytools.jar -Dij.database=jdbc:derby:JPetStoreDB;create=true 
+	   org.apache.derby.tools.ij jpetstore-derby-schema.sql
+	</pre>
+				
+</li>
+				
+<li>Now load the data into the tables using the following command:
+	<pre class="code">
+	java -cp ./derby.jar;./derbytools.jar -Dij.database=jdbc:derby:JPetStoreDB
+	   org.apache.derby.tools.ij jpetstore-derby-dataload.sql
+	</pre>
+				
+</li>
+			
+</ul>
+<p>If you do not wish to use the <span class="codefrag">sql-map-config.xml</span> supplied in the JPetStoreAPP4WebSphere.zip file but prefer to modify the one supplied with the iBATIS JPetStore application do the following.  Edit the <span class="codefrag">sql-map-config.xml</span> file and replace the existing TransactionManager definition section with this definition:</p>
+<pre class="code">
+   &lt;transactionManager type="JDBC" &gt;
+      &lt;dataSource type="JNDI"&gt;
+         &lt;property name="DBJndiContext" value="jdbc/JPetStoreDB"/&gt;
+      &lt;/dataSource&gt;
+   &lt;/transactionManager&gt;
+   </pre>
+</div>
+		
+<a name="N1014F"></a><a name="Integration+Notes"></a>
+<h2 class="boxed">Integration Notes</h2>
+<div class="section">
+<p>
+J2EE Servers use multiple classloaders (aka hierarchies) to provide the isolation necessary to run many applications at once.  This Derby-JPetStore integration uses a server datasource to avoid problems that can occur when Derby is used in an environment using multiple classloaders.  Derby is written in Java and all its classes must be loaded by the same classloader.    When using a J2EE Server this can be assured by defining Derby datasources at the server level. This is particularly important when using Derby in it's embedded configuration.   When using a database or other datasource in a J2EE environment it is also a good design practice to access them via a J2EE resource managed by the server.    
+   	</p>
+<p>
+I recommend the following paper to people seriously interested in using Derby with WebSphere: <a class="external" href="http://www-128.ibm.com/developerworks/websphere/library/techarticles/0501_barghouthi/0501_barghouthi.html">Using IBM Cloudscape V10 with IBM WebSphere Application Server V6</a>.  It describes how to setup datasources to use the various drivers provided with Derby as well as how to create a helper class to assist with Derby usage rather than the Generic Datasource Helper used here.</p>
+<p>
+   	The zipfile provided contains a fully initialized database to demonstrate that a Derby database built and populated on one platform (in this case Windows) can be transferred to different platforms and work fine.  Try copying the database and derby jarfiles to different platforms and you will see that the system works without modification.  The text files included in the zipfile will not do well in an EBCDIC architecture but the Derby engine and supplied database will work fine. If you want to build the database from scratch you can use the SQL files supplied in the archive.  See the 'CookBook Details' section for how to use the IJ tools to build and populate the database.</p>
+</div>
+		
+<a name="N10163"></a><a name="Related+Links"></a>
+<h2 class="boxed">Related Links</h2>
+<div class="section">
+<ul>
+				
+<li>
+	Files needed for the Derby and JPetStore integration: 
+<a href="../binaries/JPetStoreAPP4WebSphere.zip">JPetStoreAPP4WebSphere.zip</a>
+				
+</li>
+				
+<li>
+    Download the complete <a href="http://db.apache.org/derby/derby_downloads.html#Official+Releases">Derby System</a> [Note: the *-bin archives contain the documentation as well as Derby]
+  </li>
+				
+<li>
+	Application download for
+<a class="external" href="http://prdownloads.sourceforge.net/ibatisjpetstore/iBATIS_JPetStore-4.0.5.zip?download">JPetStore</a>
+				
+</li>
+				
+<li>
+	WebSphere Express download - 60 day 
+	<a class="external" href="http://www-128.ibm.com/developerworks/downloads/ws/wasexp">Evaluation</a>
+				
+</li>
+				
+<li>
+	WebSphere 6.0.1 <a class="external" href="http://www-1.ibm.com/support/docview.wss?rs=0&context=SW600&dc=D420&q1=WebSphere&uid=swg24009071&loc=en_US&cs=utf-8&cc=us&lang=en">upgrade</a>
+				
+</li>
+				
+<li>
+	For more information on Derby see the <a href="http://db.apache.org/derby/index.html">Apache Derby site</a>
+				
+</li>
+				
+<li>
+	For more information on iBATIS see the <a class="external" href="http://ibatis.apache.org">  Apache iBATIS site</a>
+				
+</li>
+			
+</ul>
+<p>Related Aticles</p>
+<ul>
+				
+<li>Follow this link for details of a similar deployemnt of <a href="JPetStoreGeronimo.html">JPetStore and Derby in a Geronimo</a> Server environment.</li>
+			
+</ul>
+</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/JPetStoreWebSphere.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Added: websites/production/db/content/derby/integrate/Readme.html
==============================================================================
--- websites/production/db/content/derby/integrate/Readme.html (added)
+++ websites/production/db/content/derby/integrate/Readme.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,498 @@
+<!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>Obtaining the Source and Building the Derby 1.1 UI and Help Plug-ins</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="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="menupage">
+<div class="menupagetitle">Building 1.1 UI</div>
+</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>Obtaining the Source and Building the Derby 1.1 UI and Help Plug-ins</h1>
+
+    
+<p>This document describes how to obtain the source for the
+    Apache Derby 1.0 UI and Help plug-ins for Eclipse.  Instructions
+    for importing the source as an Eclipse project and packaging the
+    plug-ins as a zip file are also included.</p>
+
+
+<pre class="code">
+Contents:
+
+	I. Creating the Apache Derby UI and Help Plug-in Projects
+	II. Creating zip files for the Derby UI and Help Plug-ins via the Project
+
+=================================================================================
+
+I. Creating the Apache Derby UI and Help Plug-in projects:
+
+1) Check out the source for the UI and Help plug-ins via SVN (Subversion).
+
+   Refer to the detailed instructions on readying your environment
+   to check out any Derby source here: 
+
+   http://db.apache.org/derby/dev/derby_source.html
+
+   To check out the entire development trunk use this command:
+
+   svn checkout https://svn.apache.org/repos/asf/db/derby/code/trunk/
+
+   This includes the source for both the UI and Help plugins.  If you want to
+   check out only the UI and Help plugins, and not the entire Derby source code 
+   issue this command instead:
+
+   svn checkout https://svn.apache.org/repos/asf/db/derby/code/trunk/plugins
+
+  
+2) Install Eclipse 3.1 M6 or higher and the JDK needed
+
+3) Install the Apache Derby 10 Eclipse Core plug-in from:
+   http://db.apache.org/derby/derby_downloads.html
+
+   It is available as a zip file on each Derby release page:
+
+   for example; derby_core_plugin_10.2.2.485682.zip
+
+   Unzip this file into the directory where the eclipse executable is located.
+   For instance, if Eclipse is installed in C:\eclipse, unzip the Derby
+   Core plug-in zip file to C:\eclipse.
+
+4) Invoke the Eclipse IDE, provide an appropriate location as the workspace
+
+   for example: c:\derby\plugin
+
+5) Import the Apache Derby UI project:
+   File -&gt; Import -&gt; Existing Projects into Workspace
+   - Click Next
+   - Click Browse and point to the "org.apache.derby.ui" directory (created in 
+     Step 1, which is under the plugins/eclipse directory where you checked 
+     out the source)
+   - Click Finish
+
+6) Switch to the Plug-in perspective
+   Window -&gt; Open Perspective -&gt; Other -&gt; Select Plug-in Development
+
+7) To invoke and test the Apache Derby UI Plug-in in this development environment
+   
+   Run -&gt;Run As -&gt; Eclipse Application
+   
+   An alternate way would be to open the plugin.xml and select the 
+   'Launch a runtime workbench' link.
+
+   This will open a new Eclipse window with all the current plug-ins under 
+   development in its environment.
+
+Follow steps 4 - 7 as above for creating the Help plug-in project, substituting
+org.apache.derby.plugin.doc for org.apache.derby.ui.
+================================================================================
+
+II. Creating zip files for the Derby UI and Help Plug-ins via the Project
+
+In order to install the plug-ins easily in another Eclipse environment creating
+a zip file is useful.
+
+1) From within the Plug-in Development perspective, right-click the 
+org.apache.derby.ui project.  Select Export --&gt; Deployable plug-ins and 
+fragments, then the Next button.
+
+2) In the Export Deployable plug-ins and fragments window select the 
+org.apache.derby.ui project listed in the Available Plug-ins and Fragments 
+text area.  
+
+3) For the Export Destination select Archive file and browse to
+a directory to place the file, and name it org.apache.derby.ui_1.1.0.zip or
+the applicable version to indicate the source version of the plugin.  
+Select any Compiler Options or Export Options you desire.
+
+4) Finally, click Finish.
+
+5) Repeat the above steps for the Help plug-in, naming the zip file something
+appropriate like org.apache.derby.plugin.doc_1.1.0.zip.</pre>
+
+</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/Readme.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>



Mime
View raw message