db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tfisc...@apache.org
Subject svn commit: r1396460 [9/9] - in /db/torque/site-scmpublish/torque-3.3: ./ developer-info/ documentation/ dtd/ images/ images/logos/ style/ tools/ version-specific/ version-specific/database-howtos/ version-specific/other-howtos/
Date Wed, 10 Oct 2012 03:35:07 GMT
Added: db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/avalon-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/avalon-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/avalon-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/avalon-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,57 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Using Torque as an Avalon Component - Torque</title><style type="text/css" media="all">
+          @import url("../../style/maven-base.css");
+          
+          @import url("../../style/maven-theme.css");</style><link rel="stylesheet" href="../../style/print.css" type="text/css" media="print"></link><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></meta><meta name="author" content="Thomas Vandahl"></meta><meta name="email" content="tv@apache.org"></meta></head><body class="composite"><div id="banner"><a href="http://db.apache.org/" id="organizationLogo"><img alt="Apache Software Foundation" src="../../images/db-logo-white.png"></img></a><a href="http://db.apache.org/torque/" id="projectLogo"><img alt="Torque Site" src="../../images/torque-logo-new.png"></img></a><div class="clear"><hr></hr></div></div><div id="breadcrumbs"><div class="xleft">Last published: 10 October 2012
+                <span class="separator">|</span> Doc for  3.3.1-SNAPSHOT
+                </div><div class="xright">
+        
+        <a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a>
+      </div><div class="clear"><hr></hr></div></div><div id="leftColumn"><div id="navcolumn"><div id="menuTorque"><h5>Torque</h5><ul><li class="none"><a href="../../index.html">Overview</a></li><li class="none"><a href="../../status.html">News and Status</a></li><li class="none"><a href="../../download.html">Downloads</a></li><li class="none"><a href="../../../torque-4.0/index.html">Torque 4</a></li><li class="none"><a href="../../addons.html">Addons</a></li><li class="none"><a href="../../changes-report.html">Changes</a></li><li class="none"><a href="http://wiki.apache.org/db-torque/" class="externalLink" title="External Link">Wiki</a></li><li class="none"><a href="../../issue-tracking.html">Issue tracker</a></li><li class="none"><a href="../../mail-lists.html">Mailing lists</a></li><li class="none"><a href="../../tools/index.html">Tools</a></li><li class="collapsed"><a href="../../developer-info/index.html">Developer Information</a></li><li class="none"><a href="http://www
 .apache.org/foundation/sponsorship.html" class="externalLink" title="External Link">Sponsorship</a></li><li class="none"><a href="http://www.apache.org/security/" class="externalLink" title="External Link">Security</a></li><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Thanks</a></li><li class="none"><a href="http://www.apache.org/licenses/" class="externalLink" title="External Link">License</a></li><li class="none"><a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a></li></ul></div><div id="menuModule_Documentation"><h5>Module Documentation</h5><ul><li class="none"><a href="../../documentation/index.html">Overview</a></li><li class="expanded"><a href="../../documentation/torque-3.3.html">Torque 3.3</a><ul><li class="collapsed"><a href="../../releases/torque-3.3/generator/index.html">Generator</a></li><li class="collapsed"><a href="../../releases/torque-3.3/maven-plugin/inde
 x.html">Maven 1 Plugin</a></li><li class="none"><a href="../../releases/torque-3.3/maven2-plugin/index.html" class="newWindow" title="New Window" target="_blank">Maven 2 Plugin</a></li><li class="collapsed"><a href="../../releases/torque-3.3/runtime/index.html">Runtime</a></li><li class="collapsed"><a href="../../releases/torque-3.3/tutorial/index.html">Tutorial</a></li><li class="collapsed"><a href="../../releases/torque-3.3/village/index.html">Village</a></li></ul></li></ul></div><div id="menuOther_Documentation"><h5>Other Documentation</h5><ul><li class="none"><a href="../../version-specific/supported-databases.html">Supported Databases</a></li><li class="collapsed"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a></li><li class="expanded"><a href="../../version-specific/other-howtos/index.html">Other Howtos</a><ul><li class="none"><a href="../../version-specific/other-howtos/database-layout-howto.html">Database Layout</a></li><li class="none
 "><a href="../../version-specific/other-howtos/schema-howto.html">DB Schema Support</a></li><li class="none"><a href="../../version-specific/other-howtos/inheritance-guide.html">Inheritance</a></li><li class="none"><strong><a href="../../version-specific/other-howtos/avalon-howto.html">Avalon Component</a></strong></li></ul></li></ul></div><div id="menuProject_Documentation"><h5>Project Documentation</h5><ul><li class="collapsed"><a href="../../project-info.html">Project info</a></li><li class="collapsed"><a href="../../project-reports.html">Site Project Reports</a></li></ul></div><div id="menuMiscellaneous"><h5>Miscellaneous</h5><ul><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Sponsors</a></li></ul></div><div id="legend"><h5>Legend</h5><ul><li class="externalLink">External Link</li><li class="newWindow">Opens in a new window</li></ul></div><a href="http://maven.apache.org/" title="Built by Maven" id="powe
 redBy"><img alt="Built by Maven" src="../../images/logos/maven-button-1.png"></img></a></div></div><div id="bodyColumn"><div class="contentBox"><div class="section"><a name="General"></a><h2>General</h2>
+    <p>
+     Torque has provided Avalon Component support for some time now. This little
+     HowTo should provide the necessary information to use Torque with some Avalon 
+     containers, namely ECM, Merlin and Fulcrum-YAAFI.
+    </p>
+  </div><div class="section"><a name="Configuration"></a><h2>Configuration</h2>
+    <p>
+     The configuration is straightforward. Use the following snippet to make
+     the Torque component available in your container:
+    </p>
+    
+    <div class="source"><pre>
+&lt;role-list&gt;
+    &lt;role
+        name="org.apache.torque.avalon.Torque"
+        shorthand="Torque"
+        default-class="org.apache.torque.avalon.TorqueComponent"/&gt;
+&lt;/role-list&gt;
+</pre></div>
+  
+    <p>
+     Torque will need access to its configuration file, so the component 
+     configuration looks like this:
+    </p>
+    
+    <div class="source"><pre>
+&lt;componentConfig&gt;
+    &lt;Torque&gt;
+      &lt;configFile&gt;/WEB-INF/conf/Torque.properties&lt;/configFile&gt;
+    &lt;/Torque&gt;
+&lt;/componentConfig&gt;
+</pre></div>
+  
+    <p>
+     The path of the configuration file is relative to the application root
+     of the container.
+    </p>
+  </div><div class="section"><a name="Use"></a><h2>Use</h2>
+
+    <p>
+     All access to the Torque component should go through the 
+     <code>org.apache.torque.avalon.Torque</code> interface. It provides all methods
+     available in <code>TorqueInstance</code>.
+     The role name to lookup the component in your container is also
+     <code>org.apache.torque.avalon.Torque</code>.
+    </p>
+
+  </div></div></div><div class="clear"><hr></hr></div><div id="footer"><div class="xright">© 2000-2012, Apache Software Foundation</div><div class="clear"><hr></hr></div></div></body></html>
\ No newline at end of file

Added: db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/database-layout-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/database-layout-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/database-layout-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/database-layout-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,124 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Database Layout Howto - Torque</title><style type="text/css" media="all">
+          @import url("../../style/maven-base.css");
+          
+          @import url("../../style/maven-theme.css");</style><link rel="stylesheet" href="../../style/print.css" type="text/css" media="print"></link><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></meta><meta name="author" content="Thomas Fischer"></meta><meta name="email" content="fischer@seitenbau.de"></meta></head><body class="composite"><div id="banner"><a href="http://db.apache.org/" id="organizationLogo"><img alt="Apache Software Foundation" src="../../images/db-logo-white.png"></img></a><a href="http://db.apache.org/torque/" id="projectLogo"><img alt="Torque Site" src="../../images/torque-logo-new.png"></img></a><div class="clear"><hr></hr></div></div><div id="breadcrumbs"><div class="xleft">Last published: 10 October 2012
+                <span class="separator">|</span> Doc for  3.3.1-SNAPSHOT
+                </div><div class="xright">
+        
+        <a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a>
+      </div><div class="clear"><hr></hr></div></div><div id="leftColumn"><div id="navcolumn"><div id="menuTorque"><h5>Torque</h5><ul><li class="none"><a href="../../index.html">Overview</a></li><li class="none"><a href="../../status.html">News and Status</a></li><li class="none"><a href="../../download.html">Downloads</a></li><li class="none"><a href="../../../torque-4.0/index.html">Torque 4</a></li><li class="none"><a href="../../addons.html">Addons</a></li><li class="none"><a href="../../changes-report.html">Changes</a></li><li class="none"><a href="http://wiki.apache.org/db-torque/" class="externalLink" title="External Link">Wiki</a></li><li class="none"><a href="../../issue-tracking.html">Issue tracker</a></li><li class="none"><a href="../../mail-lists.html">Mailing lists</a></li><li class="none"><a href="../../tools/index.html">Tools</a></li><li class="collapsed"><a href="../../developer-info/index.html">Developer Information</a></li><li class="none"><a href="http://www
 .apache.org/foundation/sponsorship.html" class="externalLink" title="External Link">Sponsorship</a></li><li class="none"><a href="http://www.apache.org/security/" class="externalLink" title="External Link">Security</a></li><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Thanks</a></li><li class="none"><a href="http://www.apache.org/licenses/" class="externalLink" title="External Link">License</a></li><li class="none"><a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a></li></ul></div><div id="menuModule_Documentation"><h5>Module Documentation</h5><ul><li class="none"><a href="../../documentation/index.html">Overview</a></li><li class="expanded"><a href="../../documentation/torque-3.3.html">Torque 3.3</a><ul><li class="collapsed"><a href="../../releases/torque-3.3/generator/index.html">Generator</a></li><li class="collapsed"><a href="../../releases/torque-3.3/maven-plugin/inde
 x.html">Maven 1 Plugin</a></li><li class="none"><a href="../../releases/torque-3.3/maven2-plugin/index.html" class="newWindow" title="New Window" target="_blank">Maven 2 Plugin</a></li><li class="collapsed"><a href="../../releases/torque-3.3/runtime/index.html">Runtime</a></li><li class="collapsed"><a href="../../releases/torque-3.3/tutorial/index.html">Tutorial</a></li><li class="collapsed"><a href="../../releases/torque-3.3/village/index.html">Village</a></li></ul></li></ul></div><div id="menuOther_Documentation"><h5>Other Documentation</h5><ul><li class="none"><a href="../../version-specific/supported-databases.html">Supported Databases</a></li><li class="collapsed"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a></li><li class="expanded"><a href="../../version-specific/other-howtos/index.html">Other Howtos</a><ul><li class="none"><strong><a href="../../version-specific/other-howtos/database-layout-howto.html">Database Layout</a></strong></l
 i><li class="none"><a href="../../version-specific/other-howtos/schema-howto.html">DB Schema Support</a></li><li class="none"><a href="../../version-specific/other-howtos/inheritance-guide.html">Inheritance</a></li><li class="none"><a href="../../version-specific/other-howtos/avalon-howto.html">Avalon Component</a></li></ul></li></ul></div><div id="menuProject_Documentation"><h5>Project Documentation</h5><ul><li class="collapsed"><a href="../../project-info.html">Project info</a></li><li class="collapsed"><a href="../../project-reports.html">Site Project Reports</a></li></ul></div><div id="menuMiscellaneous"><h5>Miscellaneous</h5><ul><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Sponsors</a></li></ul></div><div id="legend"><h5>Legend</h5><ul><li class="externalLink">External Link</li><li class="newWindow">Opens in a new window</li></ul></div><a href="http://maven.apache.org/" title="Built by Maven" id="powe
 redBy"><img alt="Built by Maven" src="../../images/logos/maven-button-1.png"></img></a></div></div><div id="bodyColumn"><div class="contentBox"><div class="section"><a name="What_this_guide_is_NOT_about"></a><h2>What this guide is NOT about</h2>
+  
+    <p>
+     This Howto is NOT meant as a complete guide of how to design a database.
+     On the contrary, it is meant as a kind of addon, in the sense of
+     "If I know in general how to design a databasein general, what do I have to
+     keep in mind if I use Torque to access that database"
+    </p>
+    
+  </div><div class="section"><a name="Things_not_supported_by_Torque"></a><h2>Things not supported by Torque</h2>
+
+   <div class="subsection"><a name="Column_names"></a><h3>Column names</h3>
+
+    <p>
+     There are some column names which you can not use in Torque although
+     your database would support them. These are any column name that contains
+     characters that are not in Java's variable identifier character set.  
+     The reason is that column names are used as variable names in the OM Peer
+     classes and these columns will cause the Torque generated code to not 
+     compile.  
+     </p>
+     
+     <p>
+     Note however, that SQL92 standard and up uses the same identifier
+     characters as Java for non-delimited columns. So this should only apply 
+     to columns defined by the SQL standard as delimited columns, i.e. 
+     columns referred to surrounded by double quotes.  Delimited column 
+     are considered to be case sensitive and/or contain non-standard 
+     characters.  However, most good cross DB server designs should avoid 
+     these special types of column since some servers don't support delimited 
+     columns.
+     </p>
+     
+     <p>
+     In addition, there are two column names that are handled slighly 
+     differently in the OM Peer classes.  This is so they will not produce 
+     constants twice in the generated code. The following column names (case is 
+     ignored) will have an "_" prefixed in front of them in the Peer
+     classes:
+     <ul>
+      <li>TABLE_NAME =&gt; _TABLE_NAME</li>
+      <li>DATABASE_NAME =&gt; _DATABASE_NAME</li>
+     </ul>
+    </p>
+    
+    <p>
+    Note that prior to Release 3.3, using these two column names WILL produce
+    duplicate constants and uncompilable code.
+    </p>
+
+    <p>
+     Furthermore, it is recommended that you do not use words which have
+     a defined meaning in SQL as column names. Even if you can trick your
+     database into using them, it is not sure whether Torque can do the same.
+     And besides, even if it works for one database, if you ever decide
+     to use another database, you may run into trouble then.
+    </p>
+
+   </div>
+
+  </div><div class="section"><a name="Design_considerations"></a><h2>Design considerations</h2>
+
+   <p>
+    These design considerations apply to the most common uses of a database.
+    In some cases where you have to meet very special challanges, there will
+    be reasons not to follow the advice given here. But in general,
+    you will be fine if you follow these guidelines.
+   </p>
+
+   <div class="subsection"><a name="Primary_keys"></a><h3>Primary keys</h3>
+
+    <p>
+     For every table, you should create a primary key which has no meaning
+     in real life. The reasons for this are:
+    </p>
+
+    <p>
+     You should use a primary key at all because it creates a well-defined
+     link between the objects in the database and the objects in memory.
+     Often, one has to decide whether a java object in memory describes
+     "the same" object as a certain row in the database. For example,
+     if you read an object from a database, change a field value and
+     write it again to the database, you would usually want to update the
+     row you read from. This is only possible if Torque can find the row
+     in the database from which the object originated. For this, the
+     primary key is used in relational databases. If two java objects have
+     the same primary key, they describe "the same thing" and refer
+     to the same row in the database. If you do not have
+     a primary key, there is no well-defined way to decide if two java
+     objects describe "the same thing". You might run into not
+     being able to update an object.
+    </p>
+
+    <p>
+     Now that we know why we want to have a primary key at all, why should
+     it have no meaning in real life ? This can be explained best by an
+     example. Consider a table which holds manufactured parts. Each part
+     has an unique serial number. So it is tempting to use the serial number
+     as a primary key. But now imagine that we have registered the wrong
+     serial number for a certain part in the database. Remember that
+     the primary key is used to decide "is it the same object?"
+     So we cannot change the serial number of a specified object without
+     making it another object.
+    </p>
+
+    <p>
+     In Torque, this problem manifests itself in that there is no easy way
+     to change the primary key of an object; you must trick Torque into it
+     by using Torque's internals. This should be avoided if possible.
+     If you use an additional primary key which
+     has no meaning in real life, you do not run into that trouble.
+    </p>
+
+   </div>
+
+  </div></div></div><div class="clear"><hr></hr></div><div id="footer"><div class="xright">© 2000-2012, Apache Software Foundation</div><div class="clear"><hr></hr></div></div></body></html>
\ No newline at end of file

Added: db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/index.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/index.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/index.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/index.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,16 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Torque Other Howtos - Torque</title><style type="text/css" media="all">
+          @import url("../../style/maven-base.css");
+          
+          @import url("../../style/maven-theme.css");</style><link rel="stylesheet" href="../../style/print.css" type="text/css" media="print"></link><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></meta><meta name="author" content="Thomas Fischer"></meta><meta name="email" content="fischer@seitenbau.de"></meta></head><body class="composite"><div id="banner"><a href="http://db.apache.org/" id="organizationLogo"><img alt="Apache Software Foundation" src="../../images/db-logo-white.png"></img></a><a href="http://db.apache.org/torque/" id="projectLogo"><img alt="Torque Site" src="../../images/torque-logo-new.png"></img></a><div class="clear"><hr></hr></div></div><div id="breadcrumbs"><div class="xleft">Last published: 10 October 2012
+                <span class="separator">|</span> Doc for  3.3.1-SNAPSHOT
+                </div><div class="xright">
+        
+        <a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a>
+      </div><div class="clear"><hr></hr></div></div><div id="leftColumn"><div id="navcolumn"><div id="menuTorque"><h5>Torque</h5><ul><li class="none"><a href="../../index.html">Overview</a></li><li class="none"><a href="../../status.html">News and Status</a></li><li class="none"><a href="../../download.html">Downloads</a></li><li class="none"><a href="../../../torque-4.0/index.html">Torque 4</a></li><li class="none"><a href="../../addons.html">Addons</a></li><li class="none"><a href="../../changes-report.html">Changes</a></li><li class="none"><a href="http://wiki.apache.org/db-torque/" class="externalLink" title="External Link">Wiki</a></li><li class="none"><a href="../../issue-tracking.html">Issue tracker</a></li><li class="none"><a href="../../mail-lists.html">Mailing lists</a></li><li class="none"><a href="../../tools/index.html">Tools</a></li><li class="collapsed"><a href="../../developer-info/index.html">Developer Information</a></li><li class="none"><a href="http://www
 .apache.org/foundation/sponsorship.html" class="externalLink" title="External Link">Sponsorship</a></li><li class="none"><a href="http://www.apache.org/security/" class="externalLink" title="External Link">Security</a></li><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Thanks</a></li><li class="none"><a href="http://www.apache.org/licenses/" class="externalLink" title="External Link">License</a></li><li class="none"><a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a></li></ul></div><div id="menuModule_Documentation"><h5>Module Documentation</h5><ul><li class="none"><a href="../../documentation/index.html">Overview</a></li><li class="expanded"><a href="../../documentation/torque-3.3.html">Torque 3.3</a><ul><li class="collapsed"><a href="../../releases/torque-3.3/generator/index.html">Generator</a></li><li class="collapsed"><a href="../../releases/torque-3.3/maven-plugin/inde
 x.html">Maven 1 Plugin</a></li><li class="none"><a href="../../releases/torque-3.3/maven2-plugin/index.html" class="newWindow" title="New Window" target="_blank">Maven 2 Plugin</a></li><li class="collapsed"><a href="../../releases/torque-3.3/runtime/index.html">Runtime</a></li><li class="collapsed"><a href="../../releases/torque-3.3/tutorial/index.html">Tutorial</a></li><li class="collapsed"><a href="../../releases/torque-3.3/village/index.html">Village</a></li></ul></li></ul></div><div id="menuOther_Documentation"><h5>Other Documentation</h5><ul><li class="none"><a href="../../version-specific/supported-databases.html">Supported Databases</a></li><li class="collapsed"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a></li><li class="expanded"><strong><a href="../../version-specific/other-howtos/index.html">Other Howtos</a></strong><ul><li class="none"><a href="../../version-specific/other-howtos/database-layout-howto.html">Database Layout</a></l
 i><li class="none"><a href="../../version-specific/other-howtos/schema-howto.html">DB Schema Support</a></li><li class="none"><a href="../../version-specific/other-howtos/inheritance-guide.html">Inheritance</a></li><li class="none"><a href="../../version-specific/other-howtos/avalon-howto.html">Avalon Component</a></li></ul></li></ul></div><div id="menuProject_Documentation"><h5>Project Documentation</h5><ul><li class="collapsed"><a href="../../project-info.html">Project info</a></li><li class="collapsed"><a href="../../project-reports.html">Site Project Reports</a></li></ul></div><div id="menuMiscellaneous"><h5>Miscellaneous</h5><ul><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Sponsors</a></li></ul></div><div id="legend"><h5>Legend</h5><ul><li class="externalLink">External Link</li><li class="newWindow">Opens in a new window</li></ul></div><a href="http://maven.apache.org/" title="Built by Maven" id="powe
 redBy"><img alt="Built by Maven" src="../../images/logos/maven-button-1.png"></img></a></div></div><div id="bodyColumn"><div class="contentBox"><div class="section"><a name="Other_Howtos"></a><h2>Other Howtos</h2>
+
+    <p>
+      This section contains howto guides which cannot be ascribed to a single
+      component of Torque.
+    </p>
+    
+  </div></div></div><div class="clear"><hr></hr></div><div id="footer"><div class="xright">© 2000-2012, Apache Software Foundation</div><div class="clear"><hr></hr></div></div></body></html>
\ No newline at end of file

Added: db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/inheritance-guide.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/inheritance-guide.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/inheritance-guide.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/inheritance-guide.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,268 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Torque Inheritance Guide - Torque</title><style type="text/css" media="all">
+          @import url("../../style/maven-base.css");
+          
+          @import url("../../style/maven-theme.css");</style><link rel="stylesheet" href="../../style/print.css" type="text/css" media="print"></link><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></meta><meta name="author" content="Jason van Zyl"></meta><meta name="email" content="jvanzyl@apache.org"></meta><meta name="author" content="Martin Poeschl"></meta><meta name="email" content="mpoeschl@marmot.at"></meta><meta name="author" content="Thomas Fischer"></meta><meta name="email" content="fischer@seitenbau.de"></meta></head><body class="composite"><div id="banner"><a href="http://db.apache.org/" id="organizationLogo"><img alt="Apache Software Foundation" src="../../images/db-logo-white.png"></img></a><a href="http://db.apache.org/torque/" id="projectLogo"><img alt="Torque Site" src="../../images/torque-logo-new.png"></img></a><div class="clear"><hr></hr></div></div><div id="breadcrumbs"><div class="xleft">Last published: 10 October 2012
+                <span class="separator">|</span> Doc for  3.3.1-SNAPSHOT
+                </div><div class="xright">
+        
+        <a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a>
+      </div><div class="clear"><hr></hr></div></div><div id="leftColumn"><div id="navcolumn"><div id="menuTorque"><h5>Torque</h5><ul><li class="none"><a href="../../index.html">Overview</a></li><li class="none"><a href="../../status.html">News and Status</a></li><li class="none"><a href="../../download.html">Downloads</a></li><li class="none"><a href="../../../torque-4.0/index.html">Torque 4</a></li><li class="none"><a href="../../addons.html">Addons</a></li><li class="none"><a href="../../changes-report.html">Changes</a></li><li class="none"><a href="http://wiki.apache.org/db-torque/" class="externalLink" title="External Link">Wiki</a></li><li class="none"><a href="../../issue-tracking.html">Issue tracker</a></li><li class="none"><a href="../../mail-lists.html">Mailing lists</a></li><li class="none"><a href="../../tools/index.html">Tools</a></li><li class="collapsed"><a href="../../developer-info/index.html">Developer Information</a></li><li class="none"><a href="http://www
 .apache.org/foundation/sponsorship.html" class="externalLink" title="External Link">Sponsorship</a></li><li class="none"><a href="http://www.apache.org/security/" class="externalLink" title="External Link">Security</a></li><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Thanks</a></li><li class="none"><a href="http://www.apache.org/licenses/" class="externalLink" title="External Link">License</a></li><li class="none"><a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a></li></ul></div><div id="menuModule_Documentation"><h5>Module Documentation</h5><ul><li class="none"><a href="../../documentation/index.html">Overview</a></li><li class="expanded"><a href="../../documentation/torque-3.3.html">Torque 3.3</a><ul><li class="collapsed"><a href="../../releases/torque-3.3/generator/index.html">Generator</a></li><li class="collapsed"><a href="../../releases/torque-3.3/maven-plugin/inde
 x.html">Maven 1 Plugin</a></li><li class="none"><a href="../../releases/torque-3.3/maven2-plugin/index.html" class="newWindow" title="New Window" target="_blank">Maven 2 Plugin</a></li><li class="collapsed"><a href="../../releases/torque-3.3/runtime/index.html">Runtime</a></li><li class="collapsed"><a href="../../releases/torque-3.3/tutorial/index.html">Tutorial</a></li><li class="collapsed"><a href="../../releases/torque-3.3/village/index.html">Village</a></li></ul></li></ul></div><div id="menuOther_Documentation"><h5>Other Documentation</h5><ul><li class="none"><a href="../../version-specific/supported-databases.html">Supported Databases</a></li><li class="collapsed"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a></li><li class="expanded"><a href="../../version-specific/other-howtos/index.html">Other Howtos</a><ul><li class="none"><a href="../../version-specific/other-howtos/database-layout-howto.html">Database Layout</a></li><li class="none
 "><a href="../../version-specific/other-howtos/schema-howto.html">DB Schema Support</a></li><li class="none"><strong><a href="../../version-specific/other-howtos/inheritance-guide.html">Inheritance</a></strong></li><li class="none"><a href="../../version-specific/other-howtos/avalon-howto.html">Avalon Component</a></li></ul></li></ul></div><div id="menuProject_Documentation"><h5>Project Documentation</h5><ul><li class="collapsed"><a href="../../project-info.html">Project info</a></li><li class="collapsed"><a href="../../project-reports.html">Site Project Reports</a></li></ul></div><div id="menuMiscellaneous"><h5>Miscellaneous</h5><ul><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Sponsors</a></li></ul></div><div id="legend"><h5>Legend</h5><ul><li class="externalLink">External Link</li><li class="newWindow">Opens in a new window</li></ul></div><a href="http://maven.apache.org/" title="Built by Maven" id="powe
 redBy"><img alt="Built by Maven" src="../../images/logos/maven-button-1.png"></img></a></div></div><div id="bodyColumn"><div class="contentBox"><div class="section"><a name="Table_of_Contents"></a><h2>Table of Contents</h2>
+
+<p>
+  <ol>
+    <li>
+      <a href="#About_this_Guide">About this Guide</a>
+    </li>
+    <li>
+      <a href="#Inheritance_and_the_Object_Relational_Map">
+        Inheritance and the Object Relational Map
+      </a>
+    </li>
+    <li>
+      <a href="#A_Class_Hierarchy">A Class Hierarchy</a>
+    </li>
+    <li>
+      <a href="#Overriding_the_Default_Behavior">
+        Overriding the Default Behavior
+      </a>
+    </li>
+  </ol>
+</p>
+
+</div><div class="section"><a name="About_this_Guide"></a><h2>About this Guide</h2>
+
+<p>
+
+  The inheritance guide is intended to help those who want to use class 
+  hierarchies with Torque.  For example, you would use Torque's inheritance
+  support if you have a class that extends another class, 
+  and both classes should be saved into and read from the database.
+
+</p>
+
+</div><div class="section"><a name="Inheritance_and_the_Object_Relational_Map"></a><h2>Inheritance and the Object Relational Map</h2>
+
+<p>
+
+  Torque can handle object-oriented inheritance.  There are generally
+  considered to be 3 methods of object-relational mapping designs.  Torque
+  uses one of the fastest, mapping all objects in a class hierarchy to a
+  single table.  All attributes for every class in the hierarchy are stored
+  in the table.  Consider an abstract ComputerComponent class that has Monitor
+  and Keyboard subclasses. There would only be one table - both Monitor and
+  Keyboard objects would be persisted to the same place. The table would
+  consist of all ComputerComponent attributes, any unique Monitor attributes,
+  and any unique Keyboard attributes. Keyboard table rows would have NULL for
+  any unique Monitor data columns, and vice versa.
+
+</p>
+<p>
+
+  The other fast method is to map each concrete class to a distinct
+  table. Every object stores all attributes in a single row in the class table.
+  An example would be that if we had a Kitchen class that inherited from Room,
+  two tables would be needed for storage. The Kitchen table would contain all
+  of the columns of the Room table, plus any additional data columns needed to
+  describe the additional Kitchen attributes.
+
+</p>
+<p>
+
+  The slowest, but most object-oriented method is to store each class in its
+  own table. Only attributes that are added to a derived class are stored in
+  its table. The persistence layer would need to join tables to read an object
+  out of storage. Saving objects would be more complex, because objects will
+  need to be distributed across multiple tables.  For our Kitchen and Room
+  example, there would also be two tables, Kitchen and Room, but the Kitchen
+  table would only contain those attributes which weren't part of the Room
+  class.
+
+</p>
+<p>
+
+  One of the advantages of the first method (the one Torque uses) is that it
+  does not require joins like the third method described above. Another
+  advantage is that the data model is easier to maintain than the second
+  method.  It falls short in modelling a class hierarchy where the related
+  classes have a non intersecting collection of attributes, as in this case
+  a row in the table will have several null columns.
+
+</p>
+<p>
+
+  For more information, visit Scott Ambler's excellent web site,
+  <a href="http://www.ambysoft.com/" class="externalLink" title="External Link">AmbySoft.com</a>, where he discusses
+  object mapping to relational databases.
+
+</p>
+
+</div><div class="section"><a name="A_Class_Hierarchy"></a><h2>A Class Hierarchy</h2>
+
+
+    <div class="source"><pre>
+       A
+       |
+     -----
+    |     |
+    B     C
+    |
+    D
+</pre></div>
+  
+
+<p>
+
+  There are two ways that are built into the torque generated Peers in order
+  to specify what class a particular row in the table A represents.  A row
+  will need to have some information that can distinguish the class.  You
+  should specify the column in the table that serves this purpose with the
+  attribute "inheritance"
+
+</p>
+
+
+    <div class="source"><pre>
+&lt;table name="A"...&gt;
+  ...
+  &lt;column name="FOO" inheritance="single" type="VARCHAR".../&gt;
+&lt;/table&gt;
+</pre></div>
+  
+
+<p>
+  In this case you would need to specify the full className in column FOO, so
+  the valid values of FOO would be:
+</p>
+
+
+    <div class="source"><pre>
+com.mycompany.project.om.A
+com.mycompany.project.om.B
+com.mycompany.project.om.C
+com.mycompany.project.om.D
+</pre></div>
+  
+
+<p>
+  This is slightly inefficient in storage and also generates some inefficient
+  code in the Peers because the Peer cannot know what classes are available
+  until it gets each record and so will call Class.forName(FOO's value) for each
+  row.
+</p>
+
+<p>
+  The efficiency can be improved in the case where the class hierarchy is
+  known, which would be in most circumstances.  So you can specify the
+  classes in the xml specification:
+</p>
+
+
+    <div class="source"><pre>
+&lt;table name="A"...&gt;
+  ...
+  &lt;column name="FOO" inheritance="single" type="CHAR" size="1"...&gt;
+    &lt;inheritance key="B" class="B" extends="com.mycompany.project.om.A"/&gt;
+    &lt;inheritance key="C" class="C" extends="com.mycompany.project.om.A"/&gt;
+    &lt;inheritance key="D" class="D" extends="com.mycompany.project.om.B"/&gt;
+  &lt;/column&gt;
+&lt;/table&gt;
+</pre></div>
+  
+
+<p>
+  where in the above we are using NULL (or any other value) to stand for class
+  "A".  An numeric column could also be used for the key.  Using the above
+  method, torque will cache a copy of each class, so the Class.forName is only
+  done during APeer's initial load into memory.
+</p>
+
+</div><div class="section"><a name="Overriding_the_Default_Behavior"></a><h2>Overriding the Default Behavior</h2>
+
+<p>
+  The following example comes from <a href="http://scarab.tigris.org" class="externalLink" title="External Link">Scarab</a>
+  (an issue tracking system). In Scarab a class hierarchy definition is
+  described in a few tables, this provides for an evolving hierarchy.  This
+  arrangement can be provided for using the following extensions.  In the
+  xml specification, the column responsible for determining the class
+  is marked using the inheritance="single" attribute.
+</p>
+
+
+    <div class="source"><pre>
+&lt;table name="SCARAB_ISSUE_ATTRIBUTE_VALUE" idMethod="none"
+        javaName="AttributeValue"&gt;
+    &lt;column name="ISSUE_ID" primaryKey="true" required="true"
+            type="INTEGER"/&gt;
+    &lt;column name="ATTRIBUTE_ID" primaryKey="true" required="true"
+            type="INTEGER" inheritance="single"/&gt;
+    &lt;column name="OPTION_ID" required="false" type="INTEGER"/&gt;
+...
+    &lt;foreign-key foreignTable="SCARAB_ISSUE"&gt;
+        &lt;reference local="ISSUE_ID" foreign="ISSUE_ID"/&gt;
+    &lt;/foreign-key&gt;
+    &lt;foreign-key foreignTable="SCARAB_ATTRIBUTE"&gt;
+        &lt;reference local="ATTRIBUTE_ID" foreign="ATTRIBUTE_ID"/&gt;
+    &lt;/foreign-key&gt;
+    &lt;foreign-key foreignTable="SCARAB_ATTRIBUTE_OPTION"&gt;
+        &lt;reference local="OPTION_ID" foreign="OPTION_ID"/&gt;
+    &lt;/foreign-key&gt;
+...
+&lt;/table&gt;
+</pre></div>
+  
+
+<p>
+  It might be interesting to note that the column responsible for the determining
+  the class is also a primary and foreign key.  Marking the column this way
+  will cause torque to generate an BaseAttributeValuePeer.getOMClass method.The
+  code in this method will be attempting to create a class from the information
+  provided in column which is an integer.  This is obviously wrong, but it
+  gives us a method to override to provide the correct information.
+</p>
+
+<p>
+  So in AttributeValuePeer, we override the method:
+</p>
+
+
+    <div class="source"><pre>
+/**
+ * Get the className appropriate for a row in the
+ * SCARAB_ISSUE_ATTRIBUTE_VALUE table
+ */
+public static Class getOMClass(Record record, int offset)
+    throws Exception
+{
+    NumberKey attId = new NumberKey(record.getValue(offset-1 + 2).asString());
+    Attribute attribute = Attribute.getInstance(attId);
+    String className = attribute.getAttributeType().getJavaClassName();
+
+    TurbineGlobalCacheService tgcs =
+        (TurbineGlobalCacheService) TurbineServices
+        .getInstance().getService(GlobalCacheService.SERVICE_NAME);
+
+    String key = getClassCacheKey(className);
+    Class c = null;
+    try
+    {
+        c = (Class) tgcs.getObject(key).getContents();
+    }
+    catch (ObjectExpiredException oee)
+    {
+        c = Class.forName(className);
+        tgcs.addObject(key, new CachedObject(c));
+    }
+    return c;
+}
+</pre></div>
+  
+
+<p>
+  where in the above method, we use the foreign key(s) to traverse
+  the tables to get the class information.  Then we cache the Class to
+  avoid the inefficiency of Class.forName on each row.  (We also cache
+  the contents of the class hierarchy tables, since the dataset is
+  quite small and static.)
+</p>
+
+</div></div></div><div class="clear"><hr></hr></div><div id="footer"><div class="xright">© 2000-2012, Apache Software Foundation</div><div class="clear"><hr></hr></div></div></body></html>
\ No newline at end of file

Added: db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/schema-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/schema-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/schema-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/other-howtos/schema-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,147 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Database Schema Howto - Torque</title><style type="text/css" media="all">
+          @import url("../../style/maven-base.css");
+          
+          @import url("../../style/maven-theme.css");</style><link rel="stylesheet" href="../../style/print.css" type="text/css" media="print"></link><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></meta><meta name="author" content="Henning P. Schmiedehausen"></meta><meta name="email" content="hps@intermeta.de"></meta></head><body class="composite"><div id="banner"><a href="http://db.apache.org/" id="organizationLogo"><img alt="Apache Software Foundation" src="../../images/db-logo-white.png"></img></a><a href="http://db.apache.org/torque/" id="projectLogo"><img alt="Torque Site" src="../../images/torque-logo-new.png"></img></a><div class="clear"><hr></hr></div></div><div id="breadcrumbs"><div class="xleft">Last published: 10 October 2012
+                <span class="separator">|</span> Doc for  3.3.1-SNAPSHOT
+                </div><div class="xright">
+        
+        <a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a>
+      </div><div class="clear"><hr></hr></div></div><div id="leftColumn"><div id="navcolumn"><div id="menuTorque"><h5>Torque</h5><ul><li class="none"><a href="../../index.html">Overview</a></li><li class="none"><a href="../../status.html">News and Status</a></li><li class="none"><a href="../../download.html">Downloads</a></li><li class="none"><a href="../../../torque-4.0/index.html">Torque 4</a></li><li class="none"><a href="../../addons.html">Addons</a></li><li class="none"><a href="../../changes-report.html">Changes</a></li><li class="none"><a href="http://wiki.apache.org/db-torque/" class="externalLink" title="External Link">Wiki</a></li><li class="none"><a href="../../issue-tracking.html">Issue tracker</a></li><li class="none"><a href="../../mail-lists.html">Mailing lists</a></li><li class="none"><a href="../../tools/index.html">Tools</a></li><li class="collapsed"><a href="../../developer-info/index.html">Developer Information</a></li><li class="none"><a href="http://www
 .apache.org/foundation/sponsorship.html" class="externalLink" title="External Link">Sponsorship</a></li><li class="none"><a href="http://www.apache.org/security/" class="externalLink" title="External Link">Security</a></li><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Thanks</a></li><li class="none"><a href="http://www.apache.org/licenses/" class="externalLink" title="External Link">License</a></li><li class="none"><a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a></li></ul></div><div id="menuModule_Documentation"><h5>Module Documentation</h5><ul><li class="none"><a href="../../documentation/index.html">Overview</a></li><li class="expanded"><a href="../../documentation/torque-3.3.html">Torque 3.3</a><ul><li class="collapsed"><a href="../../releases/torque-3.3/generator/index.html">Generator</a></li><li class="collapsed"><a href="../../releases/torque-3.3/maven-plugin/inde
 x.html">Maven 1 Plugin</a></li><li class="none"><a href="../../releases/torque-3.3/maven2-plugin/index.html" class="newWindow" title="New Window" target="_blank">Maven 2 Plugin</a></li><li class="collapsed"><a href="../../releases/torque-3.3/runtime/index.html">Runtime</a></li><li class="collapsed"><a href="../../releases/torque-3.3/tutorial/index.html">Tutorial</a></li><li class="collapsed"><a href="../../releases/torque-3.3/village/index.html">Village</a></li></ul></li></ul></div><div id="menuOther_Documentation"><h5>Other Documentation</h5><ul><li class="none"><a href="../../version-specific/supported-databases.html">Supported Databases</a></li><li class="collapsed"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a></li><li class="expanded"><a href="../../version-specific/other-howtos/index.html">Other Howtos</a><ul><li class="none"><a href="../../version-specific/other-howtos/database-layout-howto.html">Database Layout</a></li><li class="none
 "><strong><a href="../../version-specific/other-howtos/schema-howto.html">DB Schema Support</a></strong></li><li class="none"><a href="../../version-specific/other-howtos/inheritance-guide.html">Inheritance</a></li><li class="none"><a href="../../version-specific/other-howtos/avalon-howto.html">Avalon Component</a></li></ul></li></ul></div><div id="menuProject_Documentation"><h5>Project Documentation</h5><ul><li class="collapsed"><a href="../../project-info.html">Project info</a></li><li class="collapsed"><a href="../../project-reports.html">Site Project Reports</a></li></ul></div><div id="menuMiscellaneous"><h5>Miscellaneous</h5><ul><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Sponsors</a></li></ul></div><div id="legend"><h5>Legend</h5><ul><li class="externalLink">External Link</li><li class="newWindow">Opens in a new window</li></ul></div><a href="http://maven.apache.org/" title="Built by Maven" id="powe
 redBy"><img alt="Built by Maven" src="../../images/logos/maven-button-1.png"></img></a></div></div><div id="bodyColumn"><div class="contentBox"><div class="section"><a name="Using_Database_Schemas__Namespaces_"></a><h2>Using Database Schemas (Namespaces)</h2>
+
+<p>
+The word "Schema" is unfortunately quite overloaded with
+Torque. In this document, we will briefly talk about Database
+namespaces called Schema, as described <a href="http://www.postgresql.org/docs/7.3/static/ddl-schemas.html" class="externalLink" title="External Link">in
+the PostgreSQL documentation</a>. According to the docs, Schemas are a
+part of the SQL standard. YMMV, however.</p>
+
+<p>
+Torque has some rudimentary support for Database schemas when
+accessing a database. Schema names can either be specified when
+generating classes via the generator, or they can be specified
+in the runtime.
+</p>
+
+</div><div class="section"><a name="Configuring_Schema_Names_at_Runtime"></a><h2>Configuring Schema Names at Runtime</h2>
+
+<p>
+Schema support happens "per-DataSourceFactory". This might
+look counter-intuitive to you but is actually the easiest way to get
+this done. In the <code>torque.properties</code> file you can add use
+the following statements:
+</p>
+
+
+    <div class="source"><pre>
+##
+## Selecting a database schema for all data sources:
+##
+
+# All data sources use the public schema unless overridden
+torque.defaults.schema = public
+
+##
+## Selecting the schema 'foo' for the datasource "bar"
+
+# use the foo datasource
+torque.dsfactory.bar.schema = foo
+
+</pre></div>
+  
+
+<p>
+If no schema is configured in the torque properties, Torque will not
+qualify its table names.
+</p>
+
+</div><div class="section"><a name="Changing_the_current_Schema_on_the_fly"></a><h2>Changing the current Schema on the fly</h2>
+
+<p>
+The schema support happens per-Datasource. However, the schema name is
+queried dynamically whenever a Torque command accesses the database
+and can be changed (if you have the same table layout on multiple
+schemas, you can reuse your Peer classes thus reducing the number of
+classes used).
+</p>
+
+
+    <div class="source"><pre>
+
+/* Set the schema name for datasource "bar" to "foo" */
+
+Torque.setSchema("bar", "foo");
+
+/* Reset the schema names (no longer qualify
+ * accesses to the tables of the "bar" datasource
+ */
+Torque.setSchema("bar", null);
+
+/* Get the current schema for the "bar" data source */
+String barSchema = Torque.getSchema("bar");
+
+</pre></div>
+  
+
+</div><div class="section"><a name="Using_Schema_Names_at_generate_time"></a><h2>Using Schema Names at generate time</h2>
+
+    <p>
+      To define the schema of a table in the schema.xml, use the
+      fully qualified table name as name attribute in the &lt;table&gt;
+      element of your schema.xml.
+      For example, to use the schema "bookstore" for the table "book",
+      use the following table definition:
+    </p>
+
+    
+    <div class="source"><pre>
+...
+&lt;table name="bookstore.book" description="Book table"&gt;
+...
+
+    </pre></div>
+  
+
+    <p>
+      If the standard naming method is used, the resulting
+      java class will be named BookstoreBook. If you want to omit
+      the schema name in the java name
+      (i.e. the resulting java class should be named "Book"),
+      you can either use the javaName attribute of the table definition:
+    </p>
+
+    
+    <div class="source"><pre>
+...
+&lt;table name="bookstore.book" javaName="Book" description="Book table"&gt;
+...
+
+    </pre></div>
+  
+
+    <p>
+      or you can use the attribute
+      defaultJavaNamingMethod="underscoreOmitSchema"
+      in the database definition:
+    </p>
+
+    
+    <div class="source"><pre>
+...
+&lt;database name="bookstore" defaultJavaNamingMethod="underscoreOmitSchema"&gt;
+...
+
+      </pre></div>
+  
+
+    <p>
+      Note that the defaultJavaNamingMethod attribute of a table
+      will only affect the column names in the table and cannot
+      be used to change the name of the table itself.
+    </p>
+
+    <p>
+      If you use a sequence to autogenerate ids, the sequence will be generated in the same schema
+      as the table.
+    </p>
+
+  </div></div></div><div class="clear"><hr></hr></div><div id="footer"><div class="xright">© 2000-2012, Apache Software Foundation</div><div class="clear"><hr></hr></div></div></body></html>
\ No newline at end of file

Added: db/torque/site-scmpublish/torque-3.3/version-specific/supported-databases.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/supported-databases.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/supported-databases.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/supported-databases.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,147 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Torque - Supported Databases - Torque</title><style type="text/css" media="all">
+          @import url("../style/maven-base.css");
+          
+          @import url("../style/maven-theme.css");</style><link rel="stylesheet" href="../style/print.css" type="text/css" media="print"></link><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></meta><meta name="author" content="Jason van Zyl"></meta><meta name="email" content="jvanzyl@apache.com"></meta><meta name="author" content="Martin Poeschl"></meta><meta name="email" content="mpoeschl@marmot.at"></meta><meta name="author" content="Scott Eade"></meta><meta name="email" content="seade@backstagetech.com.au"></meta><meta name="author" content="Thomas Fischer"></meta><meta name="email" content="fischer@seitenbau.de"></meta></head><body class="composite"><div id="banner"><a href="http://db.apache.org/" id="organizationLogo"><img alt="Apache Software Foundation" src="../images/db-logo-white.png"></img></a><a href="http://db.apache.org/torque/" id="projectLogo"><img alt="Torque Site" src="../images/torque-logo-new.png"></img></a><div class="clear"><hr><
 /hr></div></div><div id="breadcrumbs"><div class="xleft">Last published: 10 October 2012
+                <span class="separator">|</span> Doc for  3.3.1-SNAPSHOT
+                </div><div class="xright">
+        
+        <a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a>
+      </div><div class="clear"><hr></hr></div></div><div id="leftColumn"><div id="navcolumn"><div id="menuTorque"><h5>Torque</h5><ul><li class="none"><a href="../index.html">Overview</a></li><li class="none"><a href="../status.html">News and Status</a></li><li class="none"><a href="../download.html">Downloads</a></li><li class="none"><a href="../../torque-4.0/index.html">Torque 4</a></li><li class="none"><a href="../addons.html">Addons</a></li><li class="none"><a href="../changes-report.html">Changes</a></li><li class="none"><a href="http://wiki.apache.org/db-torque/" class="externalLink" title="External Link">Wiki</a></li><li class="none"><a href="../issue-tracking.html">Issue tracker</a></li><li class="none"><a href="../mail-lists.html">Mailing lists</a></li><li class="none"><a href="../tools/index.html">Tools</a></li><li class="collapsed"><a href="../developer-info/index.html">Developer Information</a></li><li class="none"><a href="http://www.apache.org/foundation/sponsor
 ship.html" class="externalLink" title="External Link">Sponsorship</a></li><li class="none"><a href="http://www.apache.org/security/" class="externalLink" title="External Link">Security</a></li><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Thanks</a></li><li class="none"><a href="http://www.apache.org/licenses/" class="externalLink" title="External Link">License</a></li><li class="none"><a href="http://www.apache.org/" class="externalLink" title="External Link">Apache</a></li></ul></div><div id="menuModule_Documentation"><h5>Module Documentation</h5><ul><li class="none"><a href="../documentation/index.html">Overview</a></li><li class="expanded"><a href="../documentation/torque-3.3.html">Torque 3.3</a><ul><li class="collapsed"><a href="../releases/torque-3.3/generator/index.html">Generator</a></li><li class="collapsed"><a href="../releases/torque-3.3/maven-plugin/index.html">Maven 1 Plugin</a></li><li class="
 none"><a href="../releases/torque-3.3/maven2-plugin/index.html" class="newWindow" title="New Window" target="_blank">Maven 2 Plugin</a></li><li class="collapsed"><a href="../releases/torque-3.3/runtime/index.html">Runtime</a></li><li class="collapsed"><a href="../releases/torque-3.3/tutorial/index.html">Tutorial</a></li><li class="collapsed"><a href="../releases/torque-3.3/village/index.html">Village</a></li></ul></li></ul></div><div id="menuOther_Documentation"><h5>Other Documentation</h5><ul><li class="none"><strong><a href="../version-specific/supported-databases.html">Supported Databases</a></strong></li><li class="collapsed"><a href="../version-specific/database-howtos/index.html">Database Howtos</a></li><li class="collapsed"><a href="../version-specific/other-howtos/index.html">Other Howtos</a></li></ul></div><div id="menuProject_Documentation"><h5>Project Documentation</h5><ul><li class="collapsed"><a href="../project-info.html">Project info</a></li><li class="collaps
 ed"><a href="../project-reports.html">Site Project Reports</a></li></ul></div><div id="menuMiscellaneous"><h5>Miscellaneous</h5><ul><li class="none"><a href="http://www.apache.org/foundation/thanks.html" class="externalLink" title="External Link">Sponsors</a></li></ul></div><div id="legend"><h5>Legend</h5><ul><li class="externalLink">External Link</li><li class="newWindow">Opens in a new window</li></ul></div><a href="http://maven.apache.org/" title="Built by Maven" id="poweredBy"><img alt="Built by Maven" src="../images/logos/maven-button-1.png"></img></a></div></div><div id="bodyColumn"><div class="contentBox"><div class="section"><a name="Supported_RDBMS"></a><h2>Supported RDBMS</h2>
+      <table class="bodyTable">
+        <tr class="a">
+          <th>RDBMS</th>
+          <th>Driver</th>
+          <th>Status</th>
+          <th>Tester</th>
+        </tr>
+        <tr class="b">
+          <td>Axion</td>
+          <td>org.axiondb.jdbc.AxionDriver</td>
+          <td>Alpha, Runtime only</td>
+          <td></td>
+        </tr>
+        <tr class="a">
+          <td>Cloudscape</td>
+          <td>COM.cloudscape.core.JDBCDriver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="b">
+          <td>DB2</td>
+          <td>COM.ibm.db2.jdbc.{app|net}.DB2Driver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="a">
+          <td>DB2/AS400</td>
+          <td>com.ibm.as400.access.AS400JDBCDriver</td>
+          <td>Possible case-insensitivity issues</td>
+          <td><a href="mailto:Sweaver@rippe.com">Scott Weaver</a></td>
+        </tr>
+        <tr class="b">
+          <td>Derby</td>
+          <td>org.apache.derby.jdbc.EmbeddedDriver</td>
+          <td>Only the embedded driver works.</td>
+          <td><a href="mailto:fischer@seitenbau.de">Thomas Fischer</a></td>
+        </tr>
+        <tr class="a">
+          <td>Firebird</td>
+          <td>org.firebirdsql.jdbc.FBDriver</td>
+          <td>idMethod="native" does not work</td>
+          <td><a href="mailto:fischer@seitenbau.de">Thomas Fischer</a></td>
+        </tr>
+        <tr class="b">
+          <td>Hypersonic</td>
+          <td>org.hsql.jdbcDriver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="a">
+          <td>Informix</td>
+          <td>com.informix.jdbc.IfxDriver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="b">
+          <td>InstantDB</td>
+          <td>org.enhydra.instantdb.jdbc.idbDriver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="a">
+          <td>Interbase</td>
+          <td>interbase.interclient.Driver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="b">
+          <td>MS Access</td>
+          <td>sun.jdbc.odbc.JdbcOdbcDriver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="a">
+          <td><a href="database-howtos/mssql-howto.html">MS SQL</a></td>
+          <td>com.microsoft.jdbc.sqlserver.SQLServerDriver</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="b">
+          <td>MS SQL</td>
+          <td>net.sourceforge.jtds.jdbc.Driver</td>
+          <td>No known problems with SQL 2000. See add-ons for V7.0</td>
+          <td><a href="mailto:Greg.Monroe@DukeCE.com">Greg Monroe</a></td>
+        </tr>
+        <tr class="a">
+          <td>MySQL</td>
+          <td>org.gjt.mm.mysql.Driver</td>
+          <td>No subselects for mysql &lt; 4.1</td>
+          <td><a href="mailto:seade@backstagetech.com.au">Scott Eade</a></td>
+        </tr>
+        <tr class="b">
+          <td><a href="database-howtos/oracle-howto.html">Oracle</a></td>
+          <td>oracle.jdbc.driver.OracleDriver</td>
+          <td>Issues with LOBs</td>
+          <td></td>
+        </tr>
+        <tr class="a">
+          <td><a href="database-howtos/postgres-howto.html">Postgres</a></td>
+          <td>org.postgresql.Driver</td>
+          <td>No known problems</td>
+          <td><a href="mailto:seade@backstagetech.com.au">Scott Eade</a></td>
+        </tr>
+        <tr class="b">
+          <td>SapDB</td>
+          <td>com.sap.dbtech.jdbc.DriverSapDB</td>
+          <td></td>
+          <td></td>
+        </tr>
+        <tr class="a">
+          <td><a href="database-howtos/sybase-howto.html">Sybase</a></td>
+          <td>com.sybase.jdbc2.jdbc.SybDriver</td>
+          <td>
+          JDBCToXMLSchema task will not generate the schema properly.
+          All other tests pass.
+          </td>
+          <td><a href="mailto:brekke@apache.org">Jeffrey D. Brekke</a></td>
+        </tr>
+        <tr class="b">
+          <td>Weblogic</td>
+          <td>weblogic.jdbc.pool.Driver</td>
+          <td></td>
+          <td></td>
+        </tr>
+      </table>
+
+      <p>
+        If your RDBMS is not listed here, please read the document about
+        <a href="../releases/torque-3.3/runtime/reference/new-database-support.html">writing DB Adapters</a>.
+      </p>
+      <p>
+        If there is no tester for your RDBMS and you want to help, please read
+        the <a href="../developer-info/test-project.html">test project guide</a>, 
+        run the tests and send your results (and bugfixes ;) to the
+        <a href="mailto:torque-dev@db.apache.org">torque-dev@db.apache.org</a>
+        list.
+      </p>
+    </div></div></div><div class="clear"><hr></hr></div><div id="footer"><div class="xright">© 2000-2012, Apache Software Foundation</div><div class="clear"><hr></hr></div></div></body></html>
\ No newline at end of file



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message