Author: buildbot
Date: Thu Jan 31 14:29:26 2013
New Revision: 848766
Log:
Staging update by buildbot for vcl
Added:
websites/staging/vcl/trunk/content/comm/commprojects/apache-derby-database.html
Removed:
websites/staging/vcl/trunk/content/confluence_export/apache-derby-database.html
Modified:
websites/staging/vcl/trunk/content/ (props changed)
Propchange: websites/staging/vcl/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Thu Jan 31 14:29:26 2013
@@ -1 +1 @@
-1440976
+1440977
Added:
websites/staging/vcl/trunk/content/comm/commprojects/apache-derby-database.html
==============================================================================
---
websites/staging/vcl/trunk/content/comm/commprojects/apache-derby-database.html
(added)
+++
websites/staging/vcl/trunk/content/comm/commprojects/apache-derby-database.html
Thu Jan 31 14:29:26 2013
@@ -0,0 +1,223 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd";>
+<html>
+<head>
+<!--
+
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE- 2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+
+ <link href="/css/vcl.css" rel="stylesheet" type="text/css">
+ <link href="/css/code.css" rel="stylesheet" type="text/css">
+ <title>Apache VCL - Apache Derby Database</title>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+</head>
+
+<body>
+ <div id="sitetitle">
+ <table width="100%" border="0" cellspacing="0" cellpadding="5">
+ <tr>
+ <td><a href="/index.html"><img src="/img/vcl-logo.png" height="100"
align="left" alt="Apache VCL logo"></a></td>
+ <td><a href="http://www.apache.org";><img src="/img/asf-logo.png"
align="right" alt="Apache Software Foundation logo"></a></td>
+ </tr>
+ </table>
+ </div>
+
+ <div id="navigation">
+ <ul>
+<li>Information<ul>
+<li><a href="/info/about.html">What is VCL?</a></li>
+<li><a href="/info/features.html">Features</a></li>
+<li><a href="/info/architecture.html">Architecture</a></li>
+<li><a href="/info/use-cases.html">Use Cases</a></li>
+<li><a href="/downloads/download.cgi">Download</a></li>
+<li><a href="http://www.apache.org/licenses/LICENSE-2.0.html";>License</a></li>
+<li><a href="/info/faq.html">FAQ</a></li>
+</ul>
+</li>
+<li><a href="/docs/index.html">Documentation</a><ul>
+<li><a href="/docs/using-vcl.html">Using VCL</a></li>
+<li><a href="/docs/image-creation.html">Image Creation</a></li>
+<li><a href="/docs/administration.html">Administration</a></li>
+<li><a href="/docs/installation.html">Installation</a></li>
+<li><a href="/docs/deployment-planning.html">Deployment Planning</a></li>
+</ul>
+</li>
+<li><a href="/comm/index.html">Community</a><ul>
+<li><a href="/comm/index.html#getInvolved">Getting Involved</a></li>
+<li><a href="/comm/index.html#mail-list">Mailing Lists</a></li>
+<li><a href="/comm/index.html#how-do-i-join-the-project">How can I
Join</a></li>
+<li><a href="/comm/wiki.html">Wiki</a></li>
+<li><a href="/dev/index.html">Development</a><ul>
+<li><a href="/dev/jira.html">Issue Tracking</a></li>
+<li><a href="/dev/code-documentation.html">Code Documentation</a></li>
+<li><a href="/dev/roadmap.html">Roadmap</a></li>
+</ul>
+</li>
+</ul>
+</li>
+<li><a href="http://www.apache.org";>Apache Software Foundation</a><ul>
+<li><a href="http://www.apache.org/foundation/thanks.html";>Thanks</a></li>
+<li><a href="http://www.apache.org/foundation/sponsorship.html";>Become a
Sponsor</a></li>
+</ul>
+</li>
+</ul>
+ </div>
+
+ <div id="content">
+ <h1 class="title">Apache Derby Database</h1>
+ <h1 id="using-apache-derby-database">Using Apache Derby Database</h1>
+<p><big><font color="red"><strong>NOTE: The current code in the trunk does not
support Derby
+(21 Aug 2009)</strong></font></big></p>
+<h2 id="prerequisites">Prerequisites</h2>
+<p>You should have installed:</p>
+<ul>
+<li>JDK (it is maybe possible to work with jre only)</li>
+</ul>
+<h2 id="downloading-and-setting-up-the-database-for-vcl">Downloading and
Setting Up the Database for VCL</h2>
+<ol>
+<li>
+<p>Download Apache Derby and install it.</p>
+<div class="codehilite"><pre>cd ~
+wget
http://apache.g5searchmarketing.com/db/derby/db-derby-10.5.1.1/db-derby-10.5.1.1-bin.tar.gz
+tar -xzf db-derby-10.5.1.1-bin.tar.gz
+mkdir /opt/Apache
+mv db-derby-10.5.1.1-bin /opt/Apache/derby
+export DERBY_HOME="/opt/Apache/derby"
+export CLASSPATH="<span class="cp">${</span><span
class="n">DERBY_HOME</span><span class="cp">}</span>/lib/derby.jar:<span
class="cp">${</span><span class="n">DERBY_HOME</span><span
class="cp">}</span>/lib/derbytools.jar:<span class="cp">${</span><span
class="n">CLASSPATH</span><span class="cp">}</span>"
+PATH="<span class="nv">$DERBY_HOME</span>/bin:<span
class="nv">$PATH</span>"
+</pre></div>
+
+
+</li>
+<li>
+<p>Create a database in Apache Derby. The database has to be placed in the
+path <em>/opt/</em>.
+ Replace <em>'vcluser'</em> and <em>'vcluserpassword'</em> with the user and
password
+you want.</p>
+<div class="codehilite"><pre><span class="n">cd</span> <span
class="sr">/opt/</span>
+<span class="n">ij</span>
+<span class="nb">connect</span> <span
class="s">'jdbc:derby:vcl1;create=true;user='</span><span
class="n">vcluser</span><span class="s">';password='</span><span
class="n">vcluserpassword</span><span class="s">';'</span><span
class="p">;</span>
+<span class="nb">exit</span><span class="p">;</span>
+</pre></div>
+
+
+</li>
+<li>
+<p>Download <a
href="https://svn.apache.org/repos/asf/vcl/trunk/mysql/vcl.sql";>vcl.sql</a>
+and the
+<a href="/comm/commprojects/derby-parser.pl">derby-parser.pl</a>.
+ Edit the file <em>'derby-parser.pl'</em>. The variables corresponding to the
+<em>'user'</em> and <em>'password'</em> should match your database.</p>
+<div class="codehilite"><pre><span class="n">svn</span> <span
class="n">export</span> <span class="n">https:</span><span
class="sr">//s</span><span class="n">vn</span><span class="o">.</span><span
class="n">apache</span><span class="o">.</span><span class="n">org</span><span
class="sr">/repos/</span><span class="n">asf</span><span
class="sr">/vcl/</span><span class="n">trunk</span><span
class="sr">/mysql/</span><span class="n">vcl</span><span
class="o">.</span><span class="n">sql</span>
+<span class="n">wget</span> <span class="n">http:</span><span
class="sr">//</span><span class="n">vcl</span><span class="o">.</span><span
class="n">apache</span><span class="o">.</span><span class="n">org</span><span
class="sr">/comm/comm</span><span class="n">projects</span><span
class="o">/</span><span class="n">derby</span><span class="o">-</span><span
class="n">parser</span><span class="o">.</span><span class="n">pl</span>
+<span class="nb">chmod</span> <span class="n">a</span><span
class="o">+</span><span class="n">x</span> <span class="n">derby</span><span
class="o">-</span><span class="n">parser</span><span class="o">.</span><span
class="n">pl</span>
+<span class="o">./</span><span class="n">derby</span><span
class="o">-</span><span class="n">parser</span><span class="o">.</span><span
class="n">pl</span>
+</pre></div>
+
+
+</li>
+<li>
+<p>Import vcl-derby.sql file into database. It is a good idea to direct the
+output to file and check if there were any errors.</p>
+<div class="codehilite"><pre><span class="n">ij</span> <span
class="n">vcl</span><span class="o">-</span><span class="n">derby</span><span
class="o">.</span><span class="n">sql</span> <span class="o">></span> <span
class="nb">import</span><span class="o">.</span><span class="nb">log</span>
+</pre></div>
+
+
+</li>
+</ol>
+<h2 id="setting-up-the-dbd_jdbc-server">Setting up the dbd_jdbc Server</h2>
+<ol>
+<li>
+<p>Install log4j</p>
+<div class="codehilite"><pre><span class="n">cd</span> <span class="o">~</span>
+<span class="n">wget</span> <span class="n">http:</span><span
class="sr">//</span><span class="n">www</span><span class="o">.</span><span
class="n">apache</span><span class="o">.</span><span class="n">org</span><span
class="sr">/dyn/c</span><span class="n">loser</span><span
class="o">.</span><span class="n">cgi</span><span
class="sr">/logging/</span><span class="n">log4j</span><span
class="sr">/1.2.15/</span><span class="n">apache</span><span
class="o">-</span><span class="n">log4j</span><span class="o">-</span><span
class="mf">1.2.15</span><span class="o">.</span><span class="n">tar</span><span
class="o">.</span><span class="n">gz</span>
+<span class="n">tar</span> <span class="o">-</span><span class="n">zxf</span>
<span class="n">apache</span><span class="o">-</span><span
class="n">log4j</span><span class="o">-</span><span
class="mf">1.2.15</span><span class="o">.</span><span class="n">tar</span><span
class="o">.</span><span class="n">gz</span>
+<span class="n">mv</span> <span class="n">apache</span><span
class="o">-</span><span class="n">log4j</span><span class="o">-</span><span
class="mf">1.2.15</span> <span class="sr">/opt/</span><span
class="n">Apache</span><span class="sr">/derby/</span><span
class="n">lib</span><span class="o">/</span>
+</pre></div>
+
+
+</li>
+<li>
+<p>When installing the perl modules using the <em>'install_perl_libs.pl'</em>
+(<em>/usr/local/vcl/bin/install_perl_libs.pl</em>) two extra modules need to
the
+installed for Derby. Open the file <em>'install_perl_libs.pl'</em> and in the
list
+of modules to download add the following two modules.</p>
+<div class="codehilite"><pre><span class="n">http:</span><span
class="sr">//s</span><span class="n">earch</span><span class="o">.</span><span
class="n">cpan</span><span class="o">.</span><span class="n">org</span><span
class="sr">/CPAN/</span><span class="n">authors</span><span
class="sr">/id/</span><span class="n">G</span><span class="sr">/GB/</span><span
class="n">GBARR</span><span class="o">/</span><span
class="n">Convert</span><span class="o">-</span><span class="n">BER</span><span
class="o">-</span><span class="mf">1.3101</span><span class="o">.</span><span
class="n">tar</span><span class="o">.</span><span class="n">gz</span>
+<span class="n">http:</span><span class="sr">//s</span><span
class="n">earch</span><span class="o">.</span><span class="n">cpan</span><span
class="o">.</span><span class="n">org</span><span class="sr">/CPAN/</span><span
class="n">authors</span><span class="sr">/id/</span><span
class="n">V</span><span class="sr">/VI/</span><span
class="n">VIZDOM</span><span class="o">/</span><span class="n">DBD</span><span
class="o">-</span><span class="n">JDBC</span><span class="o">-</span><span
class="mf">0.71</span><span class="o">.</span><span class="n">tar</span><span
class="o">.</span><span class="n">gz</span>
+</pre></div>
+
+
+</li>
+<li>
+<p>Run the scrips as normal</p>
+<div class="codehilite"><pre><span class="n">perl</span> <span
class="sr">/usr/</span><span class="nb">local</span><span
class="sr">/vcl/</span><span class="n">bin</span><span class="o">/</span><span
class="n">install_perl_libs</span><span class="o">.</span><span
class="n">pl</span>
+</pre></div>
+
+
+</li>
+<li>
+<p>Copy some file from the modules to Derby directory</p>
+<div class="codehilite"><pre><span class="n">cp</span> <span
class="sr">/tmp/</span><span class="n">perl</span><span class="o">-</span><span
class="n">modules</span><span class="sr">/DBD-JDBC-0.71/</span><span
class="n">dbd_jdbc</span><span class="o">.</span><span class="n">jar</span>
<span class="sr">/opt/</span><span class="n">Apache</span><span
class="sr">/derby/</span><span class="n">lib</span><span class="o">/</span>
+<span class="n">cp</span> <span class="sr">/tmp/</span><span
class="n">perl</span><span class="o">-</span><span
class="n">modules</span><span class="sr">/DBD-JDBC-0.71/</span><span
class="n">log4j</span><span class="o">.</span><span class="n">properties</span>
<span class="sr">/opt/</span><span class="n">Apache</span><span
class="sr">/derby/</span><span class="n">lib</span><span
class="o">/</span><span class="n">apache</span><span class="o">-</span><span
class="n">log4j</span><span class="o">-</span><span class="mf">1.2.15</span>
+</pre></div>
+
+
+</li>
+<li>
+<p>Create a script file which will launch the dbd_jdbc Server. Save it under
+any name and directory (e.g. /opt/server.sh), only remember that this
+scrips needs to be executed every time you start up the server. The file
+should contain</p>
+<div class="codehilite"><pre><span class="c">#!/usr/bin/bash</span>
+java -Djdbc.drivers<span class="o">=</span>org.apache.derby.EmbeddedDriver
-Ddbd.port<span class="o">=</span>12345 -classpath
/opt/Apache/derby/lib/derby.jar:/opt/Apache/derby/lib/dbd_jdbc.jar:/opt/Apache/derby/lib/apache-log4j-1.2.15/log4j-1.2.15.jar:/opt/Apache/derby/lib/apache-log4j-1.2.15/
com.vizdom.dbd.jdbc.Server &
+</pre></div>
+
+
+<p>Note1: if some of your paths are different you need make the changes in
+this scrips file as well<br>
+Note2: currently port 12345 is used for connecting to Derby, this is hard
+coded. Can be changed on a later stage.</p>
+</li>
+<li>
+<p>Make the script executable</p>
+<div class="codehilite"><pre><span class="nb">chmod</span> <span
class="n">a</span><span class="o">+</span><span class="n">x</span> <span
class="sr">/opt/s</span><span class="n">erver</span>
+</pre></div>
+
+
+</li>
+<li>
+<p>Start the Server</p>
+<div class="codehilite"><pre><span class="sr">/opt/s</span><span
class="n">erver</span>
+</pre></div>
+
+
+</li>
+</ol>
+ </div>
+
+ <div id="footer">
+ <div class="copyright">
+ <p>
+ Copyright © 2012 The Apache Software Foundation, Licensed under
+ the <a href="http://www.apache.org/licenses/LICENSE-2.0";>Apache
License, Version 2.0</a>.
+ <br />
+ Apache and the Apache feather logo are trademarks of The Apache
Software Foundation.
+ </p>
+ </div>
+ </div>
+
+</body>
+</html>
