You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by tf...@apache.org on 2012/10/10 05:35:07 UTC
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/
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>
+<role-list>
+ <role
+ name="org.apache.torque.avalon.Torque"
+ shorthand="Torque"
+ default-class="org.apache.torque.avalon.TorqueComponent"/>
+</role-list>
+</pre></div>
+
+ <p>
+ Torque will need access to its configuration file, so the component
+ configuration looks like this:
+ </p>
+
+ <div class="source"><pre>
+<componentConfig>
+ <Torque>
+ <configFile>/WEB-INF/conf/Torque.properties</configFile>
+ </Torque>
+</componentConfig>
+</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 => _TABLE_NAME</li>
+ <li>DATABASE_NAME => _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>
+<table name="A"...>
+ ...
+ <column name="FOO" inheritance="single" type="VARCHAR".../>
+</table>
+</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>
+<table name="A"...>
+ ...
+ <column name="FOO" inheritance="single" type="CHAR" size="1"...>
+ <inheritance key="B" class="B" extends="com.mycompany.project.om.A"/>
+ <inheritance key="C" class="C" extends="com.mycompany.project.om.A"/>
+ <inheritance key="D" class="D" extends="com.mycompany.project.om.B"/>
+ </column>
+</table>
+</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>
+<table name="SCARAB_ISSUE_ATTRIBUTE_VALUE" idMethod="none"
+ javaName="AttributeValue">
+ <column name="ISSUE_ID" primaryKey="true" required="true"
+ type="INTEGER"/>
+ <column name="ATTRIBUTE_ID" primaryKey="true" required="true"
+ type="INTEGER" inheritance="single"/>
+ <column name="OPTION_ID" required="false" type="INTEGER"/>
+...
+ <foreign-key foreignTable="SCARAB_ISSUE">
+ <reference local="ISSUE_ID" foreign="ISSUE_ID"/>
+ </foreign-key>
+ <foreign-key foreignTable="SCARAB_ATTRIBUTE">
+ <reference local="ATTRIBUTE_ID" foreign="ATTRIBUTE_ID"/>
+ </foreign-key>
+ <foreign-key foreignTable="SCARAB_ATTRIBUTE_OPTION">
+ <reference local="OPTION_ID" foreign="OPTION_ID"/>
+ </foreign-key>
+...
+</table>
+</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 <table>
+ 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>
+...
+<table name="bookstore.book" description="Book table">
+...
+
+ </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>
+...
+<table name="bookstore.book" javaName="Book" description="Book table">
+...
+
+ </pre></div>
+
+
+ <p>
+ or you can use the attribute
+ defaultJavaNamingMethod="underscoreOmitSchema"
+ in the database definition:
+ </p>
+
+
+ <div class="source"><pre>
+...
+<database name="bookstore" defaultJavaNamingMethod="underscoreOmitSchema">
+...
+
+ </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 < 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