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 2006/06/17 19:50:47 UTC
svn commit: r415037 - in /db/torque: site/trunk/xdocs/changes.xml
site/trunk/xdocs/navigation.xml
site/trunk/xdocs/version-specific/database-howtos/hsqldb-howto.xml
templates/trunk/src/templates/sql/base/hypersonic/drop.vm
Author: tfischer
Date: Sat Jun 17 10:50:46 2006
New Revision: 415037
URL: http://svn.apache.org/viewvc?rev=415037&view=rev
Log:
added the cascade option to drop table commands for HSQLDB.
This will break compatibility to HSQLDB7.
Resolves TOPRQUE-30.
Thanks to Patrick Carl for the patch.
Added:
db/torque/site/trunk/xdocs/version-specific/database-howtos/hsqldb-howto.xml
Modified:
db/torque/site/trunk/xdocs/changes.xml
db/torque/site/trunk/xdocs/navigation.xml
db/torque/templates/trunk/src/templates/sql/base/hypersonic/drop.vm
Modified: db/torque/site/trunk/xdocs/changes.xml
URL: http://svn.apache.org/viewvc/db/torque/site/trunk/xdocs/changes.xml?rev=415037&r1=415036&r2=415037&view=diff
==============================================================================
--- db/torque/site/trunk/xdocs/changes.xml (original)
+++ db/torque/site/trunk/xdocs/changes.xml Sat Jun 17 10:50:46 2006
@@ -29,6 +29,11 @@
<release version="3.2.1-dev" date="in SVN">
+ <action type="add" dev="tfischer" issue="TORQUE-30" due-to="Patrick Carl">
+ Added the CASCADE option to drop table statements for HSQLDB.
+ This will not work with HSQLDB 7. Consult the HSQLDB Howto for
+ information about reverting to the old behaviour.
+ </action>
<action type="add" dev="tfischer" issue="TORQUE-26" due-to="Greg Monroe">
Added setByName and setByPosition methods in the generated object classes
that match the already existing getByName and getByPosition methods.
Modified: db/torque/site/trunk/xdocs/navigation.xml
URL: http://svn.apache.org/viewvc/db/torque/site/trunk/xdocs/navigation.xml?rev=415037&r1=415036&r2=415037&view=diff
==============================================================================
--- db/torque/site/trunk/xdocs/navigation.xml (original)
+++ db/torque/site/trunk/xdocs/navigation.xml Sat Jun 17 10:50:46 2006
@@ -57,6 +57,7 @@
<item name="Oracle" href="/version-specific/database-howtos/oracle-howto.html"/>
<item name="Postgres" href="/version-specific/database-howtos/postgres-howto.html"/>
<item name="Sybase" href="/version-specific/database-howtos/sybase-howto.html"/>
+ <item name="HSQLDB" href="/version-specific/database-howtos/hsqldb-howto.html"/>
</item>
<item name="Other Howtos" href="/version-specific/other-howtos/index.html" collapse="true">
<item name="Database Layout" href="/version-specific/other-howtos/database-layout-howto.html"/>
Added: db/torque/site/trunk/xdocs/version-specific/database-howtos/hsqldb-howto.xml
URL: http://svn.apache.org/viewvc/db/torque/site/trunk/xdocs/version-specific/database-howtos/hsqldb-howto.xml?rev=415037&view=auto
==============================================================================
--- db/torque/site/trunk/xdocs/version-specific/database-howtos/hsqldb-howto.xml (added)
+++ db/torque/site/trunk/xdocs/version-specific/database-howtos/hsqldb-howto.xml Sat Jun 17 10:50:46 2006
@@ -0,0 +1,56 @@
+<?xml version="1.0"?>
+<!--
+ Copyright 2001-2005 The Apache Software Foundation.
+
+ Licensed 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.
+-->
+<document>
+
+ <properties>
+ <title>HSQLDB Howto</title>
+ <author email="fischer@seitenbbau.d">Thomas Fischer</author>
+ </properties>
+
+ <body>
+
+ <section name="Introduction">
+ This document contains hints for using Torque with HSQLDB.
+ </section>
+
+ <section name="HSQLDB 7">
+
+ <p>
+ In Torque 3.2.1, the drop table statement was changed from
+ </p>
+
+<source>
+drop table $table.Name if exists;</source>
+
+ <p>
+ to
+ </p>
+
+<source>
+drop table $table.Name if exists CASCADE;</source>
+
+ <p>
+ This does not work with HSQLDB 7 any more. For supporting drop table
+ statements in HSQLDB7, remove the "CASCADE" from the file
+ sql/base/hypersonic/drop.vm in your templates jar and repackage
+ the jar file.
+ </p>
+
+ </section>
+
+ </body>
+</document>
\ No newline at end of file
Modified: db/torque/templates/trunk/src/templates/sql/base/hypersonic/drop.vm
URL: http://svn.apache.org/viewvc/db/torque/templates/trunk/src/templates/sql/base/hypersonic/drop.vm?rev=415037&r1=415036&r2=415037&view=diff
==============================================================================
--- db/torque/templates/trunk/src/templates/sql/base/hypersonic/drop.vm (original)
+++ db/torque/templates/trunk/src/templates/sql/base/hypersonic/drop.vm Sat Jun 17 10:50:46 2006
@@ -11,4 +11,4 @@
## 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.
-drop table $table.Name if exists;
+drop table $table.Name if exists CASCADE;
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org