You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by jt...@apache.org on 2006/08/17 22:10:50 UTC
svn commit: r432371 - in /db/derby/site/trunk:
build/site/integrate/db_torque.html build/site/manuals/dita.html
src/documentation/content/xdocs/integrate/db_torque.xml
Author: jta
Date: Thu Aug 17 13:10:49 2006
New Revision: 432371
URL: http://svn.apache.org/viewvc?rev=432371&view=rev
Log:
Updated the "Running the Torque Tutorial on Derby" instructions on the Derby
web site:
+ Updated instructions to use derby 10.1.3.1 instead of 10.1.1.0
+ Verified the Torque Tutorial still works with the Derby 10.2 beta
+ Step 2: Removed "Torque Database Schema" section because the Torque
Tutorial fixed the problem that these instructions worked around
+ Step 3: change 3.2-rc2 to 3.2 (Torque's rc2 became the official release)
+ Step 6: change 3.2-rc2 to 3.2 (Torque's rc2 became the official release)
Modified:
db/derby/site/trunk/build/site/integrate/db_torque.html
db/derby/site/trunk/build/site/manuals/dita.html
db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_torque.xml
Modified: db/derby/site/trunk/build/site/integrate/db_torque.html
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/integrate/db_torque.html?rev=432371&r1=432370&r2=432371&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/integrate/db_torque.html (original)
+++ db/derby/site/trunk/build/site/integrate/db_torque.html Thu Aug 17 13:10:49 2006
@@ -337,9 +337,6 @@
<li>
<a href="#Torque+Generator+Properties">Torque Generator Properties</a>
</li>
-<li>
-<a href="#Torque+Database+Schema">Torque Database Schema</a>
-</li>
</ul>
</li>
<li>
@@ -396,12 +393,16 @@
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 driver;
+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.
+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>
@@ -459,28 +460,14 @@
# The hostname or IP address of your database server.
torque.database.host = 127.0.0.1
</pre>
-<a name="N1004A"></a><a name="Torque+Database+Schema"></a>
-<h3 class="boxed">Torque Database Schema</h3>
-<p>
- There is one problem with the <span class="codefrag">src/schema/project-schema.xml</span>
- file that the Torque Tutorial provides.
- Torque generates DDL statements in the same order that the objects are
- defined in this XML file.
- The BOOK table is listed first in the file and references
- the PUBLISHER and AUTHOR tables, which are defined later.
- Derby doesn't support forward references, so creating the BOOK table fails.
- To workaround this issue,
- move the XML definition for the BOOK table to the end of the file,
- after the definitions for the PUBLISHER and AUTHOR tables.
- </p>
</div>
-<a name="N10058"></a><a name="Step+3"></a>
+<a name="N1004B"></a><a name="Step+3"></a>
<h2 class="boxed">Step 3</h2>
<div class="section">
-<a name="N1005E"></a><a name="Adding+the+driver+to+the+maven+repository"></a>
+<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:
@@ -488,13 +475,13 @@
<pre class="code">
mkdir ~/.maven/repository/derby
mkdir ~/.maven/repository/derby/jars
- cp /opt/Apache/db-derby-10.1.1.0-bin/lib/derby.jar ~/.maven/repository/derby/jars/derby-10.1.1.0-bin.jar
+ 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="N1006F"></a><a name="Specifying+the+driver+dependency"></a>
+<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:
@@ -505,20 +492,20 @@
<groupId>torque</groupId>
<id>torque-tutorial</id>
<name>Torque</name>
- <currentVersion>3.2-rc2</currentVersion>
+ <currentVersion>3.2</currentVersion>
<dependencies>
<dependency>
<artifactId>derby</artifactId>
<groupId>derby</groupId>
- <version>10.1.1.0-bin</version>
+ <version>10.1.3.1-bin</version>
</dependency>
</dependencies>
</project>
</pre>
-<a name="N10080"></a><a name="Creating+the+database"></a>
+<a name="N10073"></a><a name="Creating+the+database"></a>
<h3 class="boxed">Creating the database</h3>
<p>
The Torque Tutorial instructions mention that
@@ -554,7 +541,7 @@
<pre class="code">
set DERBY_SYSTEM_HOME=C:\home\jta\Apache\TorqueTutorial
</pre>
-<a name="N100A8"></a><a name="Creating+the+tables"></a>
+<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.
@@ -562,10 +549,10 @@
</div>
-<a name="N100B3"></a><a name="Step+4"></a>
+<a name="N100A6"></a><a name="Step+4"></a>
<h2 class="boxed">Step 4</h2>
<div class="section">
-<a name="N100B9"></a><a name="Torque+Run-Time+Properties"></a>
+<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:
@@ -584,7 +571,7 @@
</div>
-<a name="N100CB"></a><a name="Step+5"></a>
+<a name="N100BE"></a><a name="Step+5"></a>
<h2 class="boxed">Step 5</h2>
<div class="section">
<p>
@@ -593,7 +580,7 @@
</div>
-<a name="N100D5"></a><a name="Step+6"></a>
+<a name="N100C8"></a><a name="Step+6"></a>
<h2 class="boxed">Step 6</h2>
<div class="section">
<p>
@@ -606,7 +593,7 @@
</li>
<li> Replace the mysql jar with the derby jar:
- <span class="codefrag">lib/derby-10.1.1.0-bin.jar</span>
+ <span class="codefrag">lib/derby-10.1.3.1-bin.jar</span>
</li>
@@ -615,12 +602,12 @@
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.1.0-bin.jar:lib/torque-3.2-rc2.jar:lib/village-2.0.jar com.kazmier.Bookstore
+ [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="N100F5"></a><a name="Got+Questions%3F"></a>
+<a name="N100E8"></a><a name="Got+Questions%3F"></a>
<h2 class="boxed">Got Questions?</h2>
<div class="section">
<p>
@@ -632,7 +619,7 @@
<p>
-<em>Last Updated: January 19, 2006</em>
+<em>Last Updated: August 17, 2006</em>
</p>
Modified: db/derby/site/trunk/build/site/manuals/dita.html
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/manuals/dita.html?rev=432371&r1=432370&r2=432371&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/manuals/dita.html (original)
+++ db/derby/site/trunk/build/site/manuals/dita.html Thu Aug 17 13:10:49 2006
@@ -545,7 +545,7 @@
<p>
-<em>Last Updated: August 16, 2006</em>
+<em>Last Updated: August 17, 2006</em>
</p>
</div>
Modified: db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_torque.xml
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_torque.xml?rev=432371&r1=432370&r2=432371&view=diff
==============================================================================
--- db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_torque.xml (original)
+++ db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_torque.xml Thu Aug 17 13:10:49 2006
@@ -36,13 +36,17 @@
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 driver;
+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.
+IBM DB2 Universal JDBC driver because of an issue with the Village software
+it uses.
Details are in
<a href="http://issues.apache.org/jira/browse/DERBY-142">DERBY-142</a>.
</p>
@@ -103,22 +107,6 @@
</section>
- <section>
- <title>Torque Database Schema</title>
-
- <p>
- There is one problem with the <code>src/schema/project-schema.xml</code>
- file that the Torque Tutorial provides.
- Torque generates DDL statements in the same order that the objects are
- defined in this XML file.
- The BOOK table is listed first in the file and references
- the PUBLISHER and AUTHOR tables, which are defined later.
- Derby doesn't support forward references, so creating the BOOK table fails.
- To workaround this issue,
- move the XML definition for the BOOK table to the end of the file,
- after the definitions for the PUBLISHER and AUTHOR tables.
- </p>
- </section>
</section>
@@ -135,7 +123,7 @@
<source>
mkdir ~/.maven/repository/derby
mkdir ~/.maven/repository/derby/jars
- cp /opt/Apache/db-derby-10.1.1.0-bin/lib/derby.jar ~/.maven/repository/derby/jars/derby-10.1.1.0-bin.jar
+ cp /opt/Apache/db-derby-10.1.3.1-bin/lib/derby.jar ~/.maven/repository/derby/jars/derby-10.1.3.1-bin.jar
</source>
<p>
@@ -158,14 +146,14 @@
<groupId>torque</groupId>
<id>torque-tutorial</id>
<name>Torque</name>
- <currentVersion>3.2-rc2</currentVersion>
+ <currentVersion>3.2</currentVersion>
<dependencies>
<dependency>
<artifactId>derby</artifactId>
<groupId>derby</groupId>
- <version>10.1.1.0-bin</version>
+ <version>10.1.3.1-bin</version>
</dependency>
</dependencies>
@@ -271,7 +259,7 @@
variable created in Step 3.
</li>
<li> Replace the mysql jar with the derby jar:
- <code>lib/derby-10.1.1.0-bin.jar</code>
+ <code>lib/derby-10.1.3.1-bin.jar</code>
</li>
</ul>
@@ -280,7 +268,7 @@
</p>
<source>
- [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.1.0-bin.jar:lib/torque-3.2-rc2.jar:lib/village-2.0.jar com.kazmier.Bookstore
+ [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
</source>
</section>
@@ -296,7 +284,7 @@
</section>
-<p><em>Last Updated: January 19, 2006</em></p>
+<p><em>Last Updated: August 17, 2006</em></p>
</body>
</document>