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 [8/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/tools/D4-Torque.xslt
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/tools/D4-Torque.xslt?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/tools/D4-Torque.xslt (added)
+++ db/torque/site-scmpublish/torque-3.3/tools/D4-Torque.xslt Wed Oct 10 03:35:04 2012
@@ -0,0 +1,203 @@
+<?xml version="1.0" encoding="ISO-8859-1"?>
+
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements.  See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership.  The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License.  You may obtain a copy of the License at
+
+   http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied.  See the License for the
+ specific language governing permissions and limitations
+ under the License.
+-->
+
+<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
+	<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" doctype-system="http://db.apache.org/torque/dtd/database_3_2.dtd"/>
+
+	<xsl:template match="/">
+		<xsl:apply-templates/>
+	</xsl:template>
+
+	<xsl:template match="DBMODEL">
+		<database>
+			<xsl:attribute name="name">
+				<xsl:value-of select="SETTINGS/GLOBALSETTINGS/@ModelName"/>
+			</xsl:attribute>
+			<xsl:apply-templates/>
+		</database>
+	</xsl:template>
+
+	<xsl:template match="METADATA">
+		<xsl:apply-templates/>
+	</xsl:template>
+
+	<xsl:template match="TABLES">
+		<xsl:for-each select="TABLE[@Tablename]">
+			<table>
+				<xsl:attribute name="name">
+					<xsl:value-of select="@Tablename"/>
+				</xsl:attribute>
+				<xsl:choose>
+					<xsl:when test="@nmTable = 1">
+						<xsl:attribute name="idMethod">none</xsl:attribute>
+					</xsl:when>
+					<xsl:otherwise>
+						<xsl:attribute name="idMethod">native</xsl:attribute>
+					</xsl:otherwise>
+				</xsl:choose>
+				<xsl:apply-templates/>
+			</table>
+		</xsl:for-each>
+	</xsl:template>
+
+	<xsl:template match="COLUMNS">
+		<xsl:for-each select="COLUMN[@ColName]">
+			<column>
+				<xsl:attribute name="name">
+					<xsl:value-of select="@ColName"/>
+				</xsl:attribute>
+				<xsl:if test="@PrimaryKey = 1">
+					<xsl:attribute name="primaryKey">true</xsl:attribute>
+				</xsl:if>
+				<xsl:if test="@NotNull = 1">
+					<xsl:attribute name="required">true</xsl:attribute>
+				</xsl:if>
+				<xsl:if test="@AutoInc = 1">
+					<xsl:attribute name="autoIncrement">true</xsl:attribute>
+				</xsl:if>
+				<xsl:if test="@idDatatype = 20">
+					<!-- VARCHAR -->
+					<xsl:attribute name="size">
+						<xsl:value-of select="substring-after(substring-before(@DatatypeParams, ')'),'(')"/>
+					</xsl:attribute>
+				</xsl:if>
+				<xsl:attribute name="type">
+					<xsl:variable name="d" select="@idDatatype"/>
+					<xsl:for-each select="//DATATYPE[@ID=$d]">
+						<xsl:choose>
+							<xsl:when test="@PhysicalMapping = 1">
+								<xsl:choose>
+									<xsl:when test="contains(@PhysicalTypeName, 'BOOL')">BOOLEANINT</xsl:when>
+									<xsl:when test="contains(@PhysicalTypeName, 'DATETIME')">TIMESTAMP</xsl:when>
+									<xsl:when test="contains(@PhysicalTypeName, 'MEDIUMTEXT')">LONGVARCHAR</xsl:when>
+									<xsl:otherwise>
+										<xsl:value-of select="@PhysicalTypeName"/>
+									</xsl:otherwise>
+								</xsl:choose>
+							</xsl:when>
+							<xsl:otherwise>
+								<xsl:choose>
+									<xsl:when test="contains(@TypeName, 'BOOL')">BOOLEANINT</xsl:when>
+									<xsl:when test="contains(@TypeName, 'DATETIME')">TIMESTAMP</xsl:when>
+									<xsl:when test="contains(@TypeName, 'MEDIUMTEXT')">LONGVARCHAR</xsl:when>
+									<xsl:otherwise>
+										<xsl:value-of select="@TypeName"/>
+									</xsl:otherwise>
+								</xsl:choose>
+							</xsl:otherwise>
+						</xsl:choose>
+					</xsl:for-each>
+				</xsl:attribute>
+				<xsl:if test="string-length(@DefaultValue) &gt; 0">
+					<xsl:attribute name="default">
+						<xsl:value-of select="@DefaultValue"/>
+					</xsl:attribute>
+				</xsl:if>
+				<xsl:apply-templates/>
+			</column>
+		</xsl:for-each>
+	</xsl:template>
+
+	<xsl:template match="RELATIONS_END">
+		<xsl:for-each select="RELATION_END[@ID]">
+			<foreign-key>
+				<xsl:variable name="id" select="@ID"/>
+				<xsl:for-each select="//RELATION[@ID=$id]">
+					<xsl:variable name="t" select="@SrcTable"/>
+					<xsl:for-each select="//TABLE[@ID=$t]">
+						<xsl:attribute name="foreignTable">
+							<xsl:value-of select="@Tablename"/>
+						</xsl:attribute>
+					</xsl:for-each>
+					<xsl:if test="@CreateRefDef = 1">
+						<xsl:attribute name="onUpdate">
+							<xsl:choose>
+								<xsl:when test="contains(@RefDef, 'OnUpdate=0')">restrict</xsl:when>
+								<xsl:when test="contains(@RefDef, 'OnUpdate=1')">cascade</xsl:when>
+								<xsl:when test="contains(@RefDef, 'OnUpdate=2')">setnull</xsl:when>
+								<xsl:otherwise>none</xsl:otherwise>
+							</xsl:choose>
+						</xsl:attribute>
+						<xsl:attribute name="onDelete">
+							<xsl:choose>
+								<xsl:when test="contains(@RefDef, 'OnDelete=0')">restrict</xsl:when>
+								<xsl:when test="contains(@RefDef, 'OnDelete=1')">cascade</xsl:when>
+								<xsl:when test="contains(@RefDef, 'OnDelete=2')">setnull</xsl:when>
+								<xsl:otherwise>none</xsl:otherwise>
+							</xsl:choose>
+						</xsl:attribute>
+					</xsl:if>
+					<reference>
+						<xsl:attribute name="local">
+							<xsl:value-of select="substring-after(substring-before(@FKFields, '\'), '=')"/>
+						</xsl:attribute>
+						<xsl:attribute name="foreign">
+							<xsl:value-of select="substring-before(@FKFields,'=')"/>
+						</xsl:attribute>
+					</reference>
+				</xsl:for-each>
+				<xsl:apply-templates/>
+			</foreign-key>
+		</xsl:for-each>
+	</xsl:template>
+
+	<xsl:template match="INDICES">
+		<xsl:for-each select="INDEX[@ID]">
+			<xsl:choose>
+				<xsl:when test="@IndexKind = 1">
+					<index>
+						<xsl:attribute name="name">
+							<xsl:value-of select="@IndexName"/>
+						</xsl:attribute>
+						<xsl:for-each select="INDEXCOLUMNS/INDEXCOLUMN[@idColumn]">
+						<index-column>
+							<xsl:variable name="c" select="@idColumn"/>
+							<xsl:for-each select="//COLUMN[@ID=$c]">
+								<xsl:attribute name="name">
+									<xsl:value-of select="@ColName"/>
+								</xsl:attribute>
+							</xsl:for-each>
+						</index-column>
+						</xsl:for-each>
+					</index>
+				</xsl:when>
+				<xsl:when test="@IndexKind = 2">
+					<unique>
+						<xsl:attribute name="name">
+							<xsl:value-of select="@IndexName"/>
+						</xsl:attribute>
+						<xsl:for-each select="INDEXCOLUMNS/INDEXCOLUMN[@idColumn]">
+						<unique-column>
+							<xsl:variable name="c" select="@idColumn"/>
+							<xsl:for-each select="//COLUMN[@ID=$c]">
+								<xsl:attribute name="name">
+									<xsl:value-of select="@ColName"/>
+								</xsl:attribute>
+							</xsl:for-each>
+						</unique-column>
+						</xsl:for-each>
+					</unique>
+				</xsl:when>
+			</xsl:choose>
+		</xsl:for-each>
+	</xsl:template>
+
+</xsl:stylesheet>
\ No newline at end of file

Added: db/torque/site-scmpublish/torque-3.3/tools/index.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/tools/index.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/tools/index.html (added)
+++ db/torque/site-scmpublish/torque-3.3/tools/index.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,49 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Transforming other Formats from/to Torque Format - 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><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"><strong><a href="../tools/index.html">Tools</a></strong></li><li class="collapsed"><a href="../developer-info/index.html">Developer Information</a></li><li class="none"><a href="http://www.apache.org/f
 oundation/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/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"><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="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="DBDesigner"></a><h2>DBDesigner</h2>
+     <p>
+       <a href="http://fabforce.net/dbdesigner4/" class="externalLink" title="External Link">DBDesigner</a> is a tool which 
+       helps with database design. It is made for MySQL databases, mostly. 
+       DBDesigner kindly stores the model in XML files which contain most 
+       information that we need in the Torque schema. So this script was
+       created to transform one form into the other.
+     </p>
+     <p>
+       To use the script <a href="D4-Torque.xslt"><code>D4-Torque.xslt</code></a>,
+       simply fire up the XSLT-processor of your choice and give it the DBDesigner
+       model as an input.
+     </p>
+     <p>
+       This script was made for transforming a certain model into the associated
+       Torque schema. So basically, "It works for me". Mostly the mapping
+       of DBDesigner types into Torque types is incomplete. Any patches are welcome
+       (as always).
+     </p>
+     <p>
+       DBDesigner is no longer actively being developed. It's successor,
+       <a href="http://dev.mysql.com/downloads/workbench/" class="externalLink" title="External Link">MySQL Workbench</a>,
+       is currently in Beta status. As far as we can see, the format of the
+       model files will need adjustment when it's ready.
+     </p>
+   </div><div class="section"><a name="Mogwai_ERDesigner"></a><h2>Mogwai ERDesigner</h2>
+     <p>
+       <a href="http://mogwai.sourceforge.net/erdesigner/erdesigner.html" class="externalLink" title="External Link">Mogwai ERDesigner</a>
+       is a tool for vizualizing the Database structure which uses an
+       XML-based file format.
+       The stylesheet <a href="schema2erd.xsl">schema2erd.xsl</a> translates
+       a Torque-schema into the mogwai-format.  It transforms entities
+       (=tables), attributes (=columns) and relations (=foreign-keys).
+     </p>
+      
+     <p>
+       Only the location of the entities is missing so you have to arrange
+       them by yourself.  If somebody uses mogwai and Torque, this stylesheet
+       may be helpful.
+     </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/tools/schema2erd.xsl
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/tools/schema2erd.xsl?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/tools/schema2erd.xsl (added)
+++ db/torque/site-scmpublish/torque-3.3/tools/schema2erd.xsl Wed Oct 10 03:35:04 2012
@@ -0,0 +1,59 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+
+<!--
+    Document   : schema2erd.xsl
+    Created on : 7. September 2004, 13:12
+    Author     : carlptr
+
+-->
+
+<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
+    <xsl:output method="html"/>
+
+    <xsl:template match="database">
+        <ERDesignerModel version="0.9.2">
+            
+            <Entities>
+                <xsl:apply-templates select="table"/>
+            </Entities>
+            <Relations>
+                <xsl:for-each select="table/foreign-key">
+                    <xsl:call-template name="f-key"/>
+                </xsl:for-each>
+            </Relations>
+        </ERDesignerModel>
+    </xsl:template>
+
+    
+    <xsl:template match="table">
+        <Entity>
+            <xsl:attribute name="name"><xsl:value-of select="@name"/></xsl:attribute>
+            <xsl:attribute name="comment"><xsl:value-of select="@description"/></xsl:attribute>
+            <xsl:apply-templates/>
+        </Entity>
+    </xsl:template>
+    
+    <xsl:template match="column">
+        <Attribute>
+            <xsl:attribute name="name"><xsl:value-of select="@name"/></xsl:attribute>
+            <xsl:attribute name="isrequired"><xsl:value-of select="@required"/></xsl:attribute>
+            <xsl:attribute name="isprimarykey"><xsl:value-of select="@primaryKey"/></xsl:attribute>
+            <xsl:attribute name="defaultvalue"><xsl:value-of select="@default"/></xsl:attribute>
+            <xsl:attribute name="comment"><xsl:value-of select="@description"/></xsl:attribute>
+        </Attribute>
+    </xsl:template>
+    
+    <xsl:template name="f-key">
+        <Relation>
+            <xsl:attribute name="type">non-identifying</xsl:attribute>
+            <xsl:attribute name="delete-rule">DATABASE_DEFAULT</xsl:attribute>
+            <xsl:attribute name="name"><xsl:value-of select="@name"/></xsl:attribute>
+            <xsl:attribute name="primary"><xsl:value-of select="@foreignTable"/></xsl:attribute>
+            <xsl:attribute name="secondary"><xsl:value-of select="parent::table/@name"/></xsl:attribute>
+            <Mapping>
+                <xsl:attribute name="primary"><xsl:value-of select="reference/@foreign"/></xsl:attribute>
+                <xsl:attribute name="secondary"><xsl:value-of select="reference/@local"/></xsl:attribute>                
+            </Mapping>
+        </Relation>
+    </xsl:template>
+</xsl:stylesheet>

Added: db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/hsqldb-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/hsqldb-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/hsqldb-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/hsqldb-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,38 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>HSQLDB 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@seitenbbau.d"></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="expanded"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a><ul><li class="none"><a href="../../version-specific/database-howtos/mssql-howto.html">MS SQL Server</a></li><li class="none"><a href="../../version-specific/database-howtos/oracle-howto.html">Oracle</a></li><li class="none"><a href=
 "../../version-specific/database-howtos/postgres-howto.html">Postgres</a></li><li class="none"><a href="../../version-specific/database-howtos/sybase-howto.html">Sybase</a></li><li class="none"><strong><a href="../../version-specific/database-howtos/hsqldb-howto.html">HSQLDB</a></strong></li></ul></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="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="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="Introduction"></a><h2>Introduction</h2>
+    This document contains hints for using Torque with HSQLDB.
+  </div><div class="section"><a name="HSQLDB_1_7_x"></a><h2>HSQLDB 1.7.x</h2>
+
+    <p>
+      In Torque 3.3, the drop table statement was changed from 
+    </p>
+    
+
+    <div class="source"><pre>
+drop table $table.Name if exists;</pre></div>
+  
+    
+    <p>
+      to
+    </p>
+    
+
+    <div class="source"><pre>
+drop table $table.Name if exists CASCADE;</pre></div>
+  
+
+    <p>
+      This does not work with HSQLDB 1.7.x any more. For supporting drop table
+      statements in HSQLDB 1.7.x, remove the "CASCADE" from the file 
+      sql/base/hypersonic/drop.vm in your templates jar and repackage 
+      the jar file.
+    </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/database-howtos/index.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/index.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/index.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/index.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,15 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Torque Database 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="expanded"><strong><a href="../../version-specific/database-howtos/index.html">Database Howtos</a></strong><ul><li class="none"><a href="../../version-specific/database-howtos/mssql-howto.html">MS SQL Server</a></li><li class="none"><a href="../../version-specific/database-howtos/oracle-howto.html">Oracle</a></li><li clas
 s="none"><a href="../../version-specific/database-howtos/postgres-howto.html">Postgres</a></li><li class="none"><a href="../../version-specific/database-howtos/sybase-howto.html">Sybase</a></li><li class="none"><a href="../../version-specific/database-howtos/hsqldb-howto.html">HSQLDB</a></li></ul></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="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="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="Database_Howtos"></a><h2>Database Howtos</h2>
+
+    <p>
+      This section contains howto guides for specific Databases.
+    </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/database-howtos/mssql-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/mssql-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/mssql-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/mssql-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,207 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Microsoft SQL Server™ 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=""></meta><meta name="email" content="djpolito@apache.org"></meta><meta name="author" content=""></meta><meta name="email" content="monroe@dukece.com"></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="expanded"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a><ul><li class="none"><strong><a href="../../version-specific/database-howtos/mssql-howto.html">MS SQL Server</a></strong></li><li class="none"><a href="../../version-specific/database-howtos/oracle-howto.html">Oracle</a></li><li clas
 s="none"><a href="../../version-specific/database-howtos/postgres-howto.html">Postgres</a></li><li class="none"><a href="../../version-specific/database-howtos/sybase-howto.html">Sybase</a></li><li class="none"><a href="../../version-specific/database-howtos/hsqldb-howto.html">HSQLDB</a></li></ul></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="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="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="Microsoft_SQL_Server™_Howto"></a><h2>Microsoft SQL Server™ Howto</h2>
+<div class="subsection"><a name="Introductory_note"></a><h3>Introductory note</h3>
+
+<p>
+This HowTo contains configuration help on using MS SQL Server with Torque.
+Contributions towards updating the information below can be submitted to the
+<a href="mailto:torque-dev@db.apache.org">Torque Dev mailing list</a>.
+</p>
+
+</div>
+</div><div class="section"><a name="Create_Microsoft_SQL_Server™_Database"></a><h2>Create Microsoft SQL Server™ Database</h2>
+<p>
+Use the SQL Server Enterprise Manager to create the database. When using the TDK,
+it helps to name the database the same name as your project. If the name is not
+the same, you will need to manually change the database name in your properties
+files. After the database is created, you will need to create a new user, or
+give an existing user permissions to the new database. Create the new user with
+SQL Server Authentication, and assign the users default database to the newly
+created database. Make sure the database user has the db_owner role. Please
+refer to SQL Server documentation for further details.
+</p>
+
+</div><div class="section"><a name="JDBC_Driver"></a><h2>JDBC Driver</h2>
+<p>
+There is an excellent open source driver for MS SQL called 
+<a href="http://jtds.sourceforge.net/" class="externalLink" title="External Link">jTDS</a>.  This driver is
+being used in production mode with Torque and many other JDBC applications.
+The information in this HowTo has been verified with this driver, other
+drivers should work the same, but your milage may vary.
+</p>
+<p>
+In addition, Microsoft has a JDBC driver for MS SQL Server available from their <a href="http://www.microsoft.com/sql/downloads/" class="externalLink" title="External Link">SQL Downloads page</a>. Please not 
+that this driver is limited to MS SQL 2000 and above and will not work with 7.0.
+</p>
+<p>
+Alternatively, there are a wide variety of third party commercial drivers available.
+See <a href="http://developers.sun.com/product/jdbc/drivers" class="externalLink" title="External Link">JDBC(TM)
+Technology - Drivers</a> for a comprehensive list.
+</p>
+
+<p>
+Finally, for completeness, there is the JDBC-ODBC bridge driver from Sun 
+that is included with the Java 2 SDK Standard Edition as package 
+sun.jdbc.odbc. Sun's statement on this driver is,
+"Note that the bridge driver included in the SDK is appropriate only for
+experimental use or when no other driver is available." So use at your own
+risk. Also, if you are using a non-windows box to run Torque, you will need to
+find ODBC drivers for SQL server for that platform. For UNIX environments, you
+can use <a href="http://www.odbc.org" class="externalLink" title="External Link">unixODBC</a>. Please follow the ODBC
+driver instructions and setup a DSN for the new database.  You must uncheck the
+box that says, "Use ANSI nulls, paddings and warnings.".
+</p>
+
+</div><div class="section"><a name="The_Generator_build_properties_file"></a><h2>The Generator build.properties file</h2>
+<p>
+In the build.properties file make sure that:
+</p>
+
+
+    <div class="source"><pre>
+torque.database = mssql
+torque.database.type = mssql
+</pre></div>
+  
+
+<p>
+And set the JDBC connection information:
+</p>
+
+
+    <div class="source"><pre>
+torque.database.createUrl = [Follow JDBC Driver Docs]
+torque.database.buildUrl = [Follow JDBC Driver Docs]
+torque.database.url = [Follow JDBC Driver Docs]
+torque.database.driver = [JDBC Driver class]
+torque.database.user = [db username created above]
+torque.database.password = [db user password]
+torque.database.host = [hostname]
+torque.database.name = [name of db created above]
+torque.database.schema = [db username created above]
+</pre></div>
+  
+
+<p>
+If you are using the jTDS driver, these settings would look like the entries below (
+(replace [hostname] and [db name]!)  Note that if you are using MS SQL 7.0, you 
+should add ;TDS=7.0 after the [db name]:
+</p>
+
+    <div class="source"><pre>
+torque.database.createUrl = jdbc:jtds:sqlserver://[hostname]:1433/template1
+torque.database.buildUrl = jdbc:jtds:sqlserver://[hostname]:1433/[db name]
+torque.database.url = jdbc:jtds:sqlserver://[hostname]:1433/[db name]
+torque.database.driver = net.sourceforge.jtds.jdbc.Driver
+</pre></div>
+  
+
+<p>
+If you are using the Microsoft driver
+(i.e. <code>com.microsoft.jdbc.sqlserver.SQLServerDriver</code>),
+you'll need to use the <code>SelectMethod=cursor</code> parameter in
+the JDBC connection string (as outlined by <a href="http://forum.java.sun.com/thread.jsp?forum=48&amp;thread=184797" class="externalLink" title="External Link">this
+JDC thread</a>).  Your <code>databaseUrl</code> would look something
+like the following:
+</p>
+
+
+    <div class="source"><pre>
+jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb;SelectMethod=cursor
+</pre></div>
+  
+
+<p>
+If you are using the JDBC-ODBC bridge driver, see the Sun documents related
+to this for the values to use.
+</p>
+</div><div class="section"><a name="Generated_Task_Notes"></a><h2>Generated Task Notes</h2>
+<div class="subsection"><a name="Generated_SQL_Code"></a><h3>Generated SQL Code</h3>
+<p>
+SQL Scripts generated by the Ant sql target do not contain the fully qualified 
+table names, e.g. user.table.  When manually running these scripts, do this 
+as the user you want to own the tables.  I.e., if you run it as 'SA', your
+tables will be created as dbo.table rather than user.table.  This can lead
+to problems in determining which table gets used.  General rule of thumb is 
+that the tables should be owned by the user you connect with.
+</p>
+<p>
+SQL Scripts generated by the datasql Ant targetData may include autoincrement fields
+that MS SQL will not allow to be set via SQL unless surrounded the following statements:
+</p>
+
+    <div class="source"><pre>
+SET IDENTITY_INSERT &lt;table&gt;  ON
+
+SET IDENTITY_INSERT &lt;table&gt;  OFF
+</pre></div>
+  
+<p>
+In addition, the order does not take foreign keys into consideration.  The 
+order in which tables are populated may need to be manually changed to insure
+the "key" tables get created first.
+</p>
+
+</div>
+<div class="subsection"><a name="XML_Schema_Notes"></a><h3>XML Schema Notes</h3>
+<p>
+Beware the use of MS SQL keywords in table and column names.  This will cause 
+problems in the generated SQL.
+</p>
+<p>
+MS SQL supports defaultIdMethod="native" attribute of the database tag for autogenerated 
+fields.
+</p>
+<p>
+The Ant jdbc target will generate an almost correct schema for all tables owned 
+by the SQL user specified in the torque.database.schema property.  If this 
+property is not set, no tables will be processed.
+</p>
+<p>
+The schema.xml file generated by the jdbc target will be missing various important
+items, like autogenerated field tags, unique field specifications, and index 
+definitions.  In addition, the order of the tables may need to be redone to 
+create the tables with key fields first.  But in general, the jdbc task is
+a good way to use GUI tools to create your table structure and then extract
+the basics to Torque XML.
+</p>
+</div>
+</div><div class="section"><a name="The_Runtime_Torque_properties_file"></a><h2>The Runtime Torque.properties file</h2>
+<p>
+There are various ways to set up your runtime torque.properties file.  The easiest 
+is to use the build.xml process in the master directory of runtime package.  Just 
+make sure that the generation build.properties are in your user.home directory and
+run ant in the master directory.  A properly configured Torque.properties should 
+be created in the directory above this one.
+</p>
+<p>
+If you are configuring the properties manually, the folling settings are MSSQL 
+specific.  Note that there are several generic settings you will need to 
+look at as well.
+</p>
+
+
+    <div class="source"><pre>
+torque.database.default=[data base ref] (e.g. default, or the project name)
+torque.database.wacs.adapter=mssql
+
+torque.dsfactory.[data base ref].connection.driver = [JDBC Driver class]
+torque.dsfactory.[data base ref].connection.url = [Follow JDBC Driver Docs]
+torque.dsfactory.[data base ref].connection.user =  [db username created above]
+torque.dsfactory.[data base ref].connection.password = [db user password]
+</pre></div>
+  
+
+
+</div><div class="section"><a name="MSSQL_7_support"></a><h2>MSSQL 7 support</h2>
+See the jira issue
+<a href="http://issues.apache.org/jira/browse/TORQUE-46" class="externalLink" title="External Link">TORQUE-46</a>
+for the changes necessary to run Torque with MSSQL 7.
+</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/database-howtos/oracle-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/oracle-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/oracle-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/oracle-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,283 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Oracle 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="Torque Documentation Team"></meta><meta name="email" content="torque-dev@db.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="expanded"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a><ul><li class="none"><a href="../../version-specific/database-howtos/mssql-howto.html">MS SQL Server</a></li><li class="none"><strong><a href="../../version-specific/database-howtos/oracle-howto.html">Oracle</a></strong></li><li clas
 s="none"><a href="../../version-specific/database-howtos/postgres-howto.html">Postgres</a></li><li class="none"><a href="../../version-specific/database-howtos/sybase-howto.html">Sybase</a></li><li class="none"><a href="../../version-specific/database-howtos/hsqldb-howto.html">HSQLDB</a></li></ul></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="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="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="Oracle_Howto"></a><h2>Oracle Howto</h2>
+
+    <p>
+      Oracle has long used a custom way to access and write LOB objects,
+      and did not support standard LOB usage. However, this has changed
+      with the 10.2.0.1 version of the oracle jdbc driver.
+      <br></br>
+      For older drivers, Saravana Kannan is maintaining a patched version
+      of Village that supports Oracle LOBs:
+      <a href="https://sweb.uky.edu/~skkann2/village/index.html" class="externalLink" title="External Link">Village 2.0
+      Patched for Oracle LOBs - For use with Torque 3.1 and later</a>.
+      <br></br>
+      For the 10.2.0.1 drivers and later, the standard village library can be
+      used. However, village 2.0. has an issue concerning null values in
+      lob columns, so empty lobs still can not be read.
+    </p>
+
+    <p>
+      The data type TIME only has day accuracy for Oracle. This is due to the
+      underlying village library and the fact that oracle does not support
+      a SQL type TIME.
+      If you are using Oracle 9i and later, you can use the type TIMESTAMP
+      instead which gives you millisecond accuracy.
+    </p>
+
+    <p>
+      Oracle does not distinguish between empty strings and null strings.
+      If an empty string is inserted into a table, it will be treated as null.
+      If you want to re-read this column by selecting records which contain
+      an empty string, oracle will return no columns. The only way to select
+      the column is to query for records which contain null in that column.
+      <br></br>
+      This behaviour is different in most other databases. So if you
+      want to write code which works for other databases and oracle, you need
+      to consider both cases - the column might be null and it might contain
+      an empty string. For example:
+    </p>
+
+
+    <div class="source"><pre>
+Criteria.Criterion c1 = criteria.getNewCriterion(COLUMN, "", Criteria.EQUAL);
+Criteria.Criterion c2 = criteria.getNewCriterion(COLUMN, (Object)null, Criteria.ISNULL);
+criteria.add(c1.or(c2));
+</pre></div>
+  
+
+    <div class="subsection"><a name="Oracle_versions"></a><h3>Oracle versions</h3>
+      <p>
+        This version of Torque is optimized for Oracle 9i and later.
+        The following issues exist for older versions of Oracle:
+      </p>
+
+      <p>
+        The data type TIMESTAMP is not supported up to and including
+        Oracle 8.1.7. Either use the types DATE or TIME instead of TIMESTAMP
+        or change the following line in the class
+        org.apache.torque.engine.platform.PlatformOracleImpl
+        in the generator source
+      </p>
+
+      
+    <div class="source"><pre>
+setSchemaDomainMapping(new Domain(SchemaType.TIMESTAMP, "TIMESTAMP"));</pre></div>
+  
+
+      <p>
+        to
+      </p>
+
+      
+    <div class="source"><pre>
+setSchemaDomainMapping(new Domain(SchemaType.TIMESTAMP, "DATE"));</pre></div>
+  
+
+      <p>
+        and rebuild the generator from source.
+        However, both possibilities will give you only day accuracy for the
+        data types DATE, TIME and TIMESTAMP
+      </p>
+
+    </div>
+
+  </div><div class="section"><a name="Introductory_note_for_the_following_sections"></a><h2>Introductory note for the following sections</h2>
+
+<p>
+The following part of this HOWTO was written some time ago and was
+targeted at Oracle 8i and the version of Torque that was coupled with the
+<a href="http://turbine.apache.org/" class="externalLink" title="External Link">Turbine</a> application framework.
+Contributions towards updating the information below can be submitted to the
+<a href="mailto:torque-dev@db.apache.org">Torque Dev mailing list</a>.
+</p>
+
+</div><div class="section"><a name="Oracle_Howto_for_Turbine"></a><h2>Oracle Howto for Turbine</h2>
+
+<p>
+This HOWTO aims to be a simple guide to make Turbine run with an existing
+Oracle 8i database. The process of making Turbine run is not covered in
+this guide, proceed to the
+<a href="http://turbine.apache.org/" class="externalLink" title="External Link">Turbine</a> site for
+help on how to install Turbine.
+</p>
+
+</div><div class="section"><a name="Creating_the_Database"></a><h2>Creating the Database</h2>
+
+<p>
+If you do not have a database already set up, you will need to create one so
+we can create the necessary tables for Turbine. The steps below are simple
+steps to take to create a new database. If you already have a database ready for
+use, you can skip this part.
+</p>
+
+<p>
+1. Open the Oracle Database Configuration assistant
+</p>
+
+<p>
+2. Create a database with the Global Database Name 'turbine.project' and
+SID 'turbine'
+</p>
+  <ul>
+  <li>Global Database Name : turbine.project</li>
+  <li>SID : turbine</li>
+  <li>SYSTEM account password : manager</li>
+  <li>SYS account password : change_on_install</li>
+  </ul>
+
+<p>
+3. Wait for the database to be created.
+</p>
+
+<p>
+4. Good idea to stop the services from running if the Oracle database
+isn't being used as they are memory hungry for a development desktop machine.
+Check if the Oracle TNS Listener and the correct service are running when
+trying to connect.
+</p>
+
+</div><div class="section"><a name="Populating_the_Database_from_the__sql_Scripts"></a><h2>Populating the Database from the .sql Scripts</h2>
+
+<p>
+5. Start SQL *PLUS and login to the database using the username and
+password for the database. You may want to use the same username and password you will
+use for Turbine, or you will need to create synonyms for the tables and grant the
+necessary privilieges (SELECT, UPDATE, INSERT, etc), so Turbine can access the
+tables directly without using "user"."table_name".
+</p>
+
+<p>
+6. Run the Oracle specific scripts.  For the cvs version of Turbine,
+these can be found in turbine/src/sql .  In SQL*PLUS type :
+</p>
+<p>
+<font face="courier">@path/to/oracle-turbine.sql</font>
+</p>
+
+<p>
+7.The oracle-turbine.sql script creates an oracle sequence
+for each turbine table.  To use these sequences for primary
+key generation, the oracle-turbine-security.sql script should
+be modified.  For example, the following command from the script :
+</p>
+<p>
+<font face="courier">INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME)
+VALUES (0, 'turbine', 'turbine', 'turbine', 'turbine');</font>
+</p>
+<p>
+would be changed to something like :
+</p>
+<p>
+<font face="courier">INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME)
+VALUES (TURBINE_USER_SEQ.nextval, 'turbine', 'turbine', 'turbine', 'turbine');</font>
+</p>
+<p>
+When your changes, if any, are made to the script, run it from SQL*PLUS :
+</p>
+<p>
+<font face="courier">@path/to/oracle-turbine-security.sql</font>
+</p>
+
+<p>
+8.If you would rather use Turbine's id-broker to generate
+primary keys, run the following scripts to create and populate the
+id-broker table :
+</p>
+<p>
+<font face="courier">@path/to/oracle-id-table-schema.sql</font>
+</p>
+<p>
+<font face="courier">@path/to/oracle-turbine-id-table-init.sql</font>
+</p>
+
+</div><div class="section"><a name="Setting_up_Turbine_to_Connect_to_Oracle"></a><h2>Setting up Turbine to Connect to Oracle</h2>
+
+<p>
+9. Download and install the Oracle 8i JDBC type 4 Thin driver for JDK
+1.2.x from the Oracle website. Add the classes12_01.zip file to the
+classpath of the servlet engine. In JServ add to the jserv.properties file
+the line:
+</p>
+   <ul>
+   <p><font face="courier">
+   wrapper.classpath=/path/to/classes12_01.zip
+   </font></p>
+   </ul>
+
+
+<p>
+10. Ensure that the OracleoracleTNSListener service and the
+OracleServiceTURBINE service is running before using the driver.
+</p>
+
+
+<p>
+11.  Follow the Turbine installation document
+for Turbine with the following differences. To link up the Oracle
+database and driver to Turbine, edit the TurbineResources.properties file;
+</p>
+
+<ul>
+  <li>Uncomment the lines:</li>
+
+   <ul>
+    database.default.driver=oracle.jdbc.driver.OracleDriver<br></br>
+    database.default.url=jdbc:oracle:thin:@localhost:1521:ORCL
+   </ul>
+
+    <p>
+        and ensure no other database.default.driver or database.default.url
+        is left uncommented.</p>
+
+    <li>Edit the database.default.url to the oracle thin driver
+        format drivername:@servername:portnumber:SID</li>
+
+    <ul>
+        database.default.driver=oracle.jdbc.driver.OracleDriver<br></br>
+        database.default.url=jdbc:oracle:thin:@localhost:1521:turbine
+    </ul>
+
+
+    <p>
+    The  servername is the Oracle server name and the port is the port
+    that oracle uses. It is important not to confuse the Oracle servername
+    and port with the Apache server name and port. Refer to the Oracle 8i
+    documentation if there are any conflicts in this regard.
+    Take care to use the correct SID for the database you have set up.
+    </p>
+
+
+    <li>Edit the database.default.username and
+        database.default.password to match the username and password of your
+        database.</li>
+
+    <p>
+    You may need to check if a Turbine database adaptor has been setup for Oracle.
+    Look for the following lines in TurbineResources.properties, and add them in
+    case you do not find:
+    </p>
+
+    <ul>
+        database.adaptor=DBOracle<br></br>
+        database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
+    </ul>
+
+ </ul>
+
+</div><div class="section"><a name="Connecting_to_the_Oracle_Database"></a><h2>Connecting to the Oracle Database</h2>
+
+<p>
+12. Point your web browser at http://servername:port/servlets/Turbine
+(the URL may vary depending on your servlet engine) and login as username
+turbine, password turbine. After logging in you should see the congratulatory
+"Welcome To The Default Screen".
+</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/database-howtos/postgres-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/postgres-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/postgres-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/postgres-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,133 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>PostgreSQL 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="Nissim Karpenstein"></meta><meta name="email" content="nissim@nksystems.com"></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="expanded"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a><ul><li class="none"><a href="../../version-specific/database-howtos/mssql-howto.html">MS SQL Server</a></li><li class="none"><a href="../../version-specific/database-howtos/oracle-howto.html">Oracle</a></li><li class="none"><strong>
 <a href="../../version-specific/database-howtos/postgres-howto.html">Postgres</a></strong></li><li class="none"><a href="../../version-specific/database-howtos/sybase-howto.html">Sybase</a></li><li class="none"><a href="../../version-specific/database-howtos/hsqldb-howto.html">HSQLDB</a></li></ul></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="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="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="PostgreSQL_versions"></a><h2>PostgreSQL versions</h2>
+    <p>
+      The generator templates in Torque 3.3 are optimized for
+      PostgreSQL 7.3 and later.
+      To use an older version of PostgreSQL, do the following:
+    </p>
+
+    <p>
+      In the generator, locate the template
+      templates/sql/base/postgresql/drop.vm
+      and replace the line
+    </p>
+
+    
+    <div class="source"><pre>
+DROP TABLE $table.Name CASCADE;</pre></div>
+  
+
+    <p>
+      by
+    </p>
+
+    
+    <div class="source"><pre>
+DROP TABLE $table.Name;</pre></div>
+  
+
+  </div><div class="section"><a name="Note"></a><h2>Note</h2>
+
+<p>
+The following sections of this HOWTO were written some time ago
+and were targeted at the version of Torque that was coupled with the
+<a href="http://turbine.apache.org/" class="externalLink" title="External Link">Turbine</a> application framework.
+Contributions towards updating the information below can be submitted to the
+<a href="mailto:torque-dev@db.apache.org">Torque Dev mailing list</a>.
+</p>
+
+</div><div class="section"><a name="PostgreSQL_Howto"></a><h2>PostgreSQL Howto</h2>
+
+<p>
+Turbine comes with a default User implementation which utilizes some libraries,
+and code that are not 100% compatible with <a href="http://www.postgresql.org" class="externalLink" title="External Link">
+PostgreSQL</a>. This document will explain  what you need to get the default
+Turbine User Implementation running with PostgreSQL. The user management code is
+only a small part of Turbine, and the default implementation is easily
+replacable. Rather than following the steps in this document, you can always
+create your own User implementation which does not require large object support.
+</p>
+
+</div><div class="section"><a name="JDBC_Driver"></a><h2>JDBC Driver</h2>
+
+<p>
+First of all, the TurbineUser class which comes with Turbine uses a hashtable
+to store data relevant to the user.  Any data in this hashtable which does
+not map to one of the columns in the visitor table is written to a large
+object field in the database.  Database actions in the TurbineUserPeer and
+BasePeer classes are done through the
+<a href="../../releases/torque-3.3/village/index.html">Village API</a>.
+The village API uses the ResultSetMetaData returned by your JDBC driver to
+determine the types of the columns in a SQL result set.  Unfortunately,
+in PostgreSQL large objects are referenced using an OID column (which is a
+pointer to the data), and the metadata in the JDBC driver says that columns
+of type OID are java.sql.Types.INTEGER.
+</p>
+
+<p>
+There is also a bug in the released versions of the PostgreSQL which causes
+problems when reading and writing Timestamps.  This is fixed in CVS.  So to
+run Turbine with PostgreSQL you need to get the latest JDBC driver code from
+the PostgreSQL CVS server: :pserver:anoncvs@anoncvs.postgresql.org:/projects/cvsroot
+(leave the password blank).  Before compiling the driver though, you must apply
+a patch so the metadata says that OID columns are java.sql.Types.VARBINARY, not
+java.sql.Types.INTEGER.  <strong>Important: If you need the metadata to report
+that OID columns are integers for another application, this patch will break
+that app.</strong>  If you've never heard of an OID before, or you only use OID's
+to reference large objects, you don't need to worry about it.
+</p>
+
+<p>
+Another problem is solved in the more recent JDBC drivers.  The test case
+JDBCToXMLSchema fails with the driver packaged with at least PostgreSQL
+7.1.3 and maybe others.  This problem is fixed in the 7.2dev1.2 version
+(build date 2001-11-25).
+That and other PostgreSQL JDBC resources can be found here:
+<a href="http://jdbc.postgresql.org/download.html" class="externalLink" title="External Link">http://jdbc.postgresql.org/download.html</a>
+</p>
+
+</div><div class="section"><a name="Patch"></a><h2>Patch</h2>
+<p>
+This patch may or may not be necessary. If you are having problems with
+the driver, please try it out. You may also wish to try upgrading to a
+more recent version of the Postgrest driver and also make sure that you
+are using the latest released version of
+<a href="../../releases/torque-3.3/village/index.html">Village</a>.
+</p>
+
+
+    <div class="source"><pre>
+/home/projects/pgsql/cvsroot/pgsql/src/interfaces/jdbc/org/postgresql/Field.java,v
+retrieving revision 1.1
+diff -r1.1 Field.java
+147c147
+&lt;     "int4","oid",
+---
+&gt;     "int4",
+158a159
+&gt;     "oid",
+172c173
+&lt;     Types.INTEGER,Types.INTEGER,
+---
+&gt;     Types.INTEGER,
+183a185
+&gt;     Types.VARBINARY,
+</pre></div>
+  
+
+<p>
+After applying that patch, compile the driver, and you should be ready to go.
+One more problem though is that all actions involving large objects in
+PostgreSQL require transactions.  There is code in CVS now which automatically
+sets up the transaction if necessary, so make sure you're running the recent
+snapshots.
+</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/database-howtos/sybase-howto.html
URL: http://svn.apache.org/viewvc/db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/sybase-howto.html?rev=1396460&view=auto
==============================================================================
--- db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/sybase-howto.html (added)
+++ db/torque/site-scmpublish/torque-3.3/version-specific/database-howtos/sybase-howto.html Wed Oct 10 03:35:04 2012
@@ -0,0 +1,65 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head><title>Sybase ASE 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="Torque Documentation Team"></meta><meta name="email" content="torque-dev@db.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="expanded"><a href="../../version-specific/database-howtos/index.html">Database Howtos</a><ul><li class="none"><a href="../../version-specific/database-howtos/mssql-howto.html">MS SQL Server</a></li><li class="none"><a href="../../version-specific/database-howtos/oracle-howto.html">Oracle</a></li><li class="none"><a href=
 "../../version-specific/database-howtos/postgres-howto.html">Postgres</a></li><li class="none"><strong><a href="../../version-specific/database-howtos/sybase-howto.html">Sybase</a></strong></li><li class="none"><a href="../../version-specific/database-howtos/hsqldb-howto.html">HSQLDB</a></li></ul></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="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="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="Introductory_note"></a><h2>Introductory note</h2>
+
+<p>
+This HOWTO was written some time ago and was targeted at the
+version of Torque that was coupled with the
+<a href="http://turbine.apache.org/" class="externalLink" title="External Link">Turbine</a> application framework.
+Contributions towards updating the information below can be submitted to the
+<a href="mailto:torque-dev@db.apache.org">Torque Dev mailing list</a>.
+</p>
+
+</div><div class="section"><a name="Sybase_Howto"></a><h2>Sybase Howto</h2>
+
+<p>
+This text is a description of integration of Sybase ASE as the target
+database in a TDK generated application.
+</p>
+
+</div><div class="section"><a name="JDBC_Driver_Information"></a><h2>JDBC Driver Information</h2>
+
+<p>
+Sybase has a pure java jdbc driver, jConnect, that is free to use, but not
+open source.  You may download this driver from
+<a href="http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect" class="externalLink" title="External Link">Sybase</a>.
+</p>
+</div><div class="section"><a name="Integration_Steps"></a><h2>Integration Steps</h2>
+
+<OL>
+<LI>Generate your application with the TDK as normal.</LI>
+<LI>Edit the project properties as instructed by the TDK.</LI>
+<LI>
+Before you run 'build.sh init' you will need to create the
+database.  Automatic database creation for Sybase does not currently
+work, so the database must be created first.
+</LI>
+<LI>Place the jConnect jar file in your WEB-INF/lib directory.</LI>
+<LI>Run 'build.sh init' to generate and initialize the project.</LI>
+</OL>
+
+</div><div class="section"><a name="Notes"></a><h2>Notes</h2>
+
+<p>
+<UL>
+<LI>
+The .sql files that the TDK build process generates files with the
+sql command terminated by a ; for use in the sql directive provided by
+the Ant build system.  These scripts will not work properly if run by
+hand via the 'isql' command.
+</LI>
+<LI>
+The .sql files to create the tables, do not correctly remove any
+constraints on the tables currently and may fail.  Drop the tables by
+hand, then re-run 'build-project.sh insert-sql' to re-create and
+populate the tables.
+</LI>
+</UL>
+</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