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 gm...@apache.org on 2010/12/03 16:31:41 UTC

svn commit: r1041879 - /db/torque/site/trunk/xdocs/changes.xml

Author: gmonroe
Date: Fri Dec  3 15:31:40 2010
New Revision: 1041879

URL: http://svn.apache.org/viewvc?rev=1041879&view=rev
Log:
Document SummaryHelper changes

Modified:
    db/torque/site/trunk/xdocs/changes.xml

Modified: db/torque/site/trunk/xdocs/changes.xml
URL: http://svn.apache.org/viewvc/db/torque/site/trunk/xdocs/changes.xml?rev=1041879&r1=1041878&r2=1041879&view=diff
==============================================================================
--- db/torque/site/trunk/xdocs/changes.xml (original)
+++ db/torque/site/trunk/xdocs/changes.xml Fri Dec  3 15:31:40 2010
@@ -32,6 +32,12 @@
   <body>
   <release version="3.4-dev" date="in SVN">
     <action type="update" dev="gmonroe">
+      Fixed SummaryHelper class issues caused by DB differences.
+      Added a ListOrderMapCI class to utils (case insensitive string keys).
+      Refactored the SummaryHelper class to use this.
+      Modified the SummaryHelperTest to work with all DB types.
+    </action>
+    <action type="update" dev="gmonroe">
       Changed the exception type thrown by doSelect calls when
       Criteria.isSingleRecord() true and more than one record is found.
       A TooManyRecordsException (ToqueException subclass) is now returned
@@ -41,7 +47,7 @@
       Added support for DB Adaptor specific SQL functions.
     </action>
     <action type="add" dev="gmonroe">
-      Add a SummaryHelper class which supports aggregate queries.  E.g. 
+      Add a SummaryHelper class which supports aggregate queries.  E.g.
       Select Sum(x) from table.
     </action>
   </release>
@@ -50,8 +56,8 @@
   <release version="3.3-RC3" date="2008-01-11">
     <action type="remove" dev="tfischer">
       maven2 plugin: removed the property idTableXmlFile from the sql and
-      id-table-init-sql goals. The property never was passed by the mojo and 
-      also does not work correctly in the generator. Use the goal 
+      id-table-init-sql goals. The property never was passed by the mojo and
+      also does not work correctly in the generator. Use the goal
       id-table-init-sql to create sql for id tables instead.
     </action>
     <action type="update" dev="tfischer">
@@ -66,7 +72,7 @@
     </action>
     <action type="add" dev="gmonroe">
       Removed Village meta data check for read only column status.  This is
-      not fully supported by a lot of JDBC drivers and causes Torque to 
+      not fully supported by a lot of JDBC drivers and causes Torque to
       fail with Derby's JDBC network driver.
     </action>
     <action type="add" dev="tfischer">
@@ -80,9 +86,9 @@
       sqlExec goal with default settings.
     </action>
     <action type="update" dev="tfischer" issue="TORQUE-105" due-to="Sylvain Benoist">
-      Sybase: Columns where the attribute &quot;required&quot; 
+      Sybase: Columns where the attribute &quot;required&quot;
       is not set or set to false are now created explicitly
-      with suffix &quot;NULL&quot;. 
+      with suffix &quot;NULL&quot;.
     </action>
     <action type="update" dev="tfischer">
       Changed Type Mappings for Sybase:
@@ -110,7 +116,7 @@
       the paperwork.
     </action>
     <action type="update" dev="gmonroe" issue="TORQUE-86" due-to="Will Glass-Husain">
-      The SQL statements generated for MS SQL by the torque:datasql target 
+      The SQL statements generated for MS SQL by the torque:datasql target
       will now be wrapped in SET IDENTITY_INSERT...ON /OFF statements if
       the idMethod is native and autogenerate is set on one or more fields.
     </action>
@@ -122,7 +128,7 @@
       Corrected invalid cast in TorqueRuntimeException.splitStackTrace.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-104" due-to="Sylvain Benoist">
-      Remove 'COMMENT ON...' output from generated SQL for Sybase 
+      Remove 'COMMENT ON...' output from generated SQL for Sybase
       as these commands do not exist in Sybase's sql.
     </action>
     <action type="update" dev="tfischer" issue="TORQUE-91">
@@ -140,11 +146,11 @@
       The suffix parameter to the Maven2-plugin's sql task now works.
     </action>
     <action type="add" dev="tfischer" issue="TORQUE-99" due-to="Tobias Hilka">
-      Added copy(..) and add&lt;ForeignKey&gt;(..) methods with a connection 
+      Added copy(..) and add&lt;ForeignKey&gt;(..) methods with a connection
       parameter.
     </action>
     <action type="update" dev="tv">
-      Updated JCS dependency to version 1.3 and fixed related deprecation 
+      Updated JCS dependency to version 1.3 and fixed related deprecation
       issues.
     </action>
     <action type="fix" dev="tv" issue="TORQUE-97" due-to="Markus Müller">
@@ -156,15 +162,15 @@
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-90" due-to="Sean Gilligan">
       Fixed Null Pointer Exceptions in Criteria.equals() and
-      Criteria.hashCode() if joins are null. 
+      Criteria.hashCode() if joins are null.
     </action>
     <action type="fix" dev="tfischer">
       Changed the maven2 plugin's datadump goal to accept only a single schema
-      xml. Multiple schema xmls produced illegal output. 
+      xml. Multiple schema xmls produced illegal output.
     </action>
     <action type="fix" dev="tfischer">
       Fixed the maven2 plugin's datasql goal to do the same as the ant and
-      maven1 datasql task. 
+      maven1 datasql task.
     </action>
     <action type="add" dev="tfischer">
       Added a datadtd goal to the maven2 plugin.
@@ -195,7 +201,7 @@
     </action>
     <action type="add" dev="gmonroe">
       Added torque.beanExtendsClass property that defines a fully qualified
-      class name (e.g. org.apache.struts.action.ActionForm) that the base 
+      class name (e.g. org.apache.struts.action.ActionForm) that the base
       bean classes will extend.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-88">
@@ -214,7 +220,7 @@
       Add documentation and test cases.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-80" due-to="Brian Telintelo">
-      In the JdbcTransformTask of the generator, the attribute 
+      In the JdbcTransformTask of the generator, the attribute
       &quot;default&quot; is only added to the generated schema if its value
       is not empty.
     </action>
@@ -261,7 +267,7 @@
     </action>
     <action type="fix" dev="gmonroe">
       Improved Derby generator platform implimentation to support correctly
-      sized BINARY and VARBINARY using the SizedAsBitDataDomain.  Also fixed 
+      sized BINARY and VARBINARY using the SizedAsBitDataDomain.  Also fixed
       problems with the BIT and TINYINT mappings.
     </action>
     <action type="add" dev="gmonroe">
@@ -270,35 +276,35 @@
     </action>
     <action type="fix" dev="gmonroe">
       Fixed template package references that caused bad code to be generated
-      if non-default packages were used.        
+      if non-default packages were used.
     </action>
   </release>
   <release version="3.3-RC1" date="2006-11-23">
     <action type="fix" dev="tfischer">
-      Fixed a synchronisation issue in the getDateString() method in 
-      the database adapter for postgresql.  
+      Fixed a synchronisation issue in the getDateString() method in
+      the database adapter for postgresql.
     </action>
     <action type="fix" dev="tv" issue="TORQUE-63" due-to="Ronny Völker">
-      Wrong caching of method calls with more than three arguments in MethodResultCache. 
+      Wrong caching of method calls with more than three arguments in MethodResultCache.
     </action>
     <action type="add" dev="tfischer" issue="TORQUE-44" due-to="Greg Monroe">
-      The Column names TABLE_NAME and DATABASE_NAME are now legal column names. 
+      The Column names TABLE_NAME and DATABASE_NAME are now legal column names.
     </action>
     <action type="add" dev="tfischer" issue="TORQUE-2" due-to="Raphael Pieroni">
-      Added a maven 2 plugin. 
+      Added a maven 2 plugin.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-57">
       Fixed handling of escaping (by backslashes) for LIKE clauses.
       This included fixing the general handling of backslashes
-      for several databases. 
+      for several databases.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-59">
       Booleanchar and Booleanint now work for chained (and'ed, or'ed)
-      Criterions. 
+      Criterions.
     </action>
     <action type="add" dev="tfischer" issue="TORQUE-27" due-to="Greg Monroe">
       Added support for option tags for most elements in the database.xml
-      for usage with custom templates. 
+      for usage with custom templates.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-10">
       Limit and Offset work now correctly if applied to joined
@@ -314,7 +320,7 @@
     <action type="add" dev="tv">
       Add a &quot;serialVersionUID&quot; to the generated classes that
       implement Serializable. The entry is generated if &quot;addTimeStamp&quot;
-      is true. This should remove quite a number of warnings when using 
+      is true. This should remove quite a number of warnings when using
       Torque generated classes.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-49">
@@ -326,7 +332,7 @@
       when torque.enableJava5Features is set to true.
     </action>
     <action type="update" dev="tfischer" issue="TORQUE-37" due-to="Greg Monroe">
-      The default package for generated classes was changed from 
+      The default package for generated classes was changed from
       org.apache.torque to torque.generated.
     </action>
     <action type="fix">
@@ -337,7 +343,7 @@
       Preserved case when generating the constants for column names
       in the Peers and the database maps. For example, for a table named book
       and a column namend author_id, the constant BaseBookPeer.AUTHOR_ID
-      is now set to book.author_id, whereas in former versions, this constant 
+      is now set to book.author_id, whereas in former versions, this constant
       would have been set to book.AUTHOR_ID.<br/>
       The old behaviour can be regained by setting the generator property
       torque.deprecated.uppercasePeer to true.
@@ -352,7 +358,7 @@
       Fixed MS-SQL failure in LargeSelect.
     </action>
     <action type="fix" dev="tv" issue="TORQUE-43" due-to="Thoralf Rickert">
-      Fixed several methods not using JavaName in Peer.vm. Thanks to 
+      Fixed several methods not using JavaName in Peer.vm. Thanks to
       Thoralf Rickert for the patch.
     </action>
     <action type="fix" dev="tv" issue="TORQUE-42" due-to="Federico Fissore">
@@ -361,25 +367,25 @@
       for the Criteria patch.
     </action>
     <action type="update" dev="tv">
-      Made DB an interface and changed all database adapters to extend 
+      Made DB an interface and changed all database adapters to extend
       AbstractDBAdapter. Moved generateLimits methods to the adapters and
       deprecated getLimitStyle and associated constants because this
       should be handled transparently for the user.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-41" due-to="Thoralf Rickert">
-      Caught SQL exception when foreign keys for a table or view 
+      Caught SQL exception when foreign keys for a table or view
       cannot be retrieved in the jdbc ant task in the generator.
       Now a warning is printed instead of stopping execution.
     </action>
     <action type="add" dev="tfischer" issue="TORQUE-33" due-to="Jacob Champlin">
       Refined guesswork for detecting column names out of functions, clauses
       etc. This is important e.g. for orderBy Statements like
-      &quot;order by table.column in (1,2,3)&quot; or 
+      &quot;order by table.column in (1,2,3)&quot; or
       &quot;order by 100 &lt; table.column&quot;.
     </action>
     <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 1.7. Consult the HSQLDB Howto for 
+      This will not work with HSQLDB 1.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">
@@ -414,7 +420,7 @@
       Corrected datatype Mapping for MS-SQL:
       <ul>
         <li>
-          Torque type BLOB is now mapped to MS-SQL type IMAGE 
+          Torque type BLOB is now mapped to MS-SQL type IMAGE
           (was BLOB in Torque 3.2, not working)
         </li>
         <li>
@@ -424,7 +430,7 @@
       </ul>
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-21" due-to="Nicolas Le Griel">
-      Fixed bug in bean generation when a table has several references 
+      Fixed bug in bean generation when a table has several references
       to another table.
     </action>
     <action type="fix" dev="tfischer" issue="TORQUE-4" due-to="Joerg Friedrich">
@@ -445,11 +451,11 @@
           Torque type char is now mapped to firebird type char (was varchar)
         </li>
         <li>
-          Torque type double is now mapped to firebird type double precision 
+          Torque type double is now mapped to firebird type double precision
           (was double)
         </li>
         <li>
-          Torque type booleanchar is now mapped to firebird type char(1) 
+          Torque type booleanchar is now mapped to firebird type char(1)
           (was varchar(1))
         </li>
       </ul>
@@ -467,7 +473,7 @@
       Thanks to Joerg Friedrich for reporting the error.
     </action>
     <action type="add" dev="tfischer">
-      Added a new convenience method, Transaction.begin(), 
+      Added a new convenience method, Transaction.begin(),
       which is the same as Transaction.begin(Torque.getDefaultDb()).
     </action>
     <action type="update" dev="tfischer">
@@ -476,7 +482,7 @@
       decentralized methods to access information about the databases.
     </action>
     <action type="update" dev="tfischer">
-      The IdBroker is now only started for a database if the IdMethod 
+      The IdBroker is now only started for a database if the IdMethod
       idBroker is used in that database.
     </action>
     <action type="fix" dev="seade">
@@ -495,7 +501,7 @@
       Thanks to Patrick Carl for an early version of the patch.
     </action>
     <action type="fix" dev="tfischer" issue="TRQS345">
-      IgnoreCase in PsSelects now also takes into account 
+      IgnoreCase in PsSelects now also takes into account
       Criterion's setIgnoreCase().
       Thanks to Robert Dietrick for an early version of the patch.
     </action>
@@ -508,11 +514,11 @@
 	  Changed behaviour for a limit of zero: (criteria.setLimit(0))
       <ul>
         <li>
-          If the db supports native limit, 
+          If the db supports native limit,
           a limit of zero returns zero datasets.
         </li>
         <li>
-          if the db does not support native limit, a limit of zero 
+          if the db does not support native limit, a limit of zero
           causes a TorqueException (thanks to village :-()
         </li>
       </ul>
@@ -536,7 +542,7 @@
     </action>
     <action type="add" dev="tfischer" issue="TRQS305">
       Subqueries are now supported.
-      This has caused Criterion.appendTo(StringBuffer) to declare throwing 
+      This has caused Criterion.appendTo(StringBuffer) to declare throwing
       a Torque Exception.
     </action>
     <action type="fix" dev="tfischer" issue="TRQS133">
@@ -551,11 +557,11 @@
           IdMethod native is now supported
         </li>
         <li>
-          Added mappings for Torque types 
+          Added mappings for Torque types
           LONGVARCHAR, BINARY and VARBINARY
         </li>
         <li>
-          Implemented the methods getMaxColumnNameLength(), 
+          Implemented the methods getMaxColumnNameLength(),
           hasScale() and hasSize() in PlatformDerbyImpl
         </li>
         <li>
@@ -564,19 +570,19 @@
           tables in the schema.xml
         </li>
         <li>
-          The SQL for the creation of Indices is now generated correctly 
+          The SQL for the creation of Indices is now generated correctly
           (a CRLF was missing at the end)
         </li>
       </ul>
-      Thanks to Johnny Macchione for the patches. 
+      Thanks to Johnny Macchione for the patches.
     </action>
     <action type="fix" dev="tfischer">
       Fixed foreign key support in mysql to allow the referenced table to
       be declared before the referencing table.
-      This is done by defining the foreign keys in an extra 
-      &quot;CREATE TABLE&quot; statement instead of defining them in the 
-      &quot;CREATE TABLE&quot; statement. 
-      Note that foreign keys are ignored by mysql except in InnoDB tables. 
+      This is done by defining the foreign keys in an extra
+      &quot;CREATE TABLE&quot; statement instead of defining them in the
+      &quot;CREATE TABLE&quot; statement.
+      Note that foreign keys are ignored by mysql except in InnoDB tables.
       <br />
       Thanks to Thoralf Rickert for suggesting the patch.
       Fixes also TRQS278.
@@ -588,7 +594,7 @@
       Fixed support for limit and offset for Derby in the runtime.
     </action>
     <action type="add" dev="tfischer">
-      Added hyperlinks to foreign key in the documentation to point to 
+      Added hyperlinks to foreign key in the documentation to point to
       the referenced table.
       Thanks to Hilco Wijbenga for an early version of the patch.
     </action>
@@ -598,7 +604,7 @@
       Thanks to Martin Goulet for a very early version of the serialization fix.
     </action>
     <action type="add" dev="tfischer">
-      Added scale (i.e number of digits after the decimal point) support 
+      Added scale (i.e number of digits after the decimal point) support
       for the sql data types NUMERIC and DECIMAL in the JDBCTransformTask
       (creating schema.xml from the database). Only scales which are > 0
       are added as an extra attribute to the generated schema.xml.
@@ -610,15 +616,15 @@
       Thanks to Robert Dietrick for the patch.
     </action>
     <action type="update" dev="tfischer">
-      The default values of the generator options 
+      The default values of the generator options
       torque.subpackage.base.bean,
       torque.subpackage.bean,
       and torque.subpackage.map
-      are now defined in the property files plugin.properties (for maven) 
+      are now defined in the property files plugin.properties (for maven)
       and default.properties (for ant) instead of in the templates
     </action>
     <action type="fix" dev="tfischer" issue="TRQS322">
-      The DataSourceFactory with the name "default" is created 
+      The DataSourceFactory with the name "default" is created
       automatically again. This was removed when fixing TRQS308,
       but is required by Turbine.
     </action>
@@ -634,8 +640,8 @@
       native limit and offset
     </action>
     <action type="fix" dev="tfischer" issue="TRQS320">
-      Added necessary addJoin() statenments to the generated Methods 
-      XXXPeer.doSelectAllExceptYYY(). 
+      Added necessary addJoin() statenments to the generated Methods
+      XXXPeer.doSelectAllExceptYYY().
       Thanks to Thomas Vandahl for the patch.
     </action>
     <action type="add" dev="tfischer">
@@ -645,7 +651,7 @@
           to the BaseManager.vm template
         </li>
         <li>
-          Added the method getXXX(Connection) for associated objects 
+          Added the method getXXX(Connection) for associated objects
           to the ObjectWithManager.vm template
         </li>
       </ul>



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