Index: doc/oql.xml
===================================================================
RCS file: /scm/castor/castor/src/doc/oql.xml,v
retrieving revision 1.5
diff -u -r1.5 oql.xml
--- doc/oql.xml	8 Oct 2004 08:57:10 -0000	1.5
+++ doc/oql.xml	31 Jul 2005 20:41:50 -0000
@@ -948,6 +948,37 @@
       
       <section title="Limit Clause">
       
+         <p>On a selected number of RDBMS, Castor JDO now supports the use of LIMIT/OFFSET
+			clauses.</p>
+			
+         <p>As per this release, the following RDBMS have full/partial support for this
+            feature.</p>
+
+                <table border="0" cellspacing="1" cellpadding="2" bgcolor="#990033"><tr><td>
+                    <table border="0" cellspacing="1" cellpadding="8" bgcolor="#EDEDED">
+                  <tr bgcolor="#990033" style="color:#FFFFFF">
+                            <th align="left">RDBMS</th><th>LIMIT</th><th>OFFSET</th>
+                        </tr><tr>
+                            <td>postgreSQL</td><td>Yes</td><td>Yes</td>
+                        </tr><tr>
+                            <td>mySQL</td><td>Yes</td><td>Yes</td>
+                        </tr><tr>
+                            <td>Oracle - 1)2)</td><td>Yes</td><td>Yes</td>
+                        </tr><tr>
+                            <td>HSQL</td><td>Yes</td><td>Yes</td>
+                        </tr><tr>
+                            <td>MS SQL</td><td>Yes</td><td>-</td>
+                        </tr><tr>
+                            <td>DB2</td><td>Yes</td><td>-</td>
+                        </tr>
+                    </table></td></tr>
+                </table>
+
+         <p>1) Oracle has full support for LIMIT/OFFSET clauses for release 8.1.6 and
+            later.</p>
+         <p>2) For the LIMIT/OFFSET clauses to work properly the OQL query is required
+			to include a ORDER BY clause.</p>
+
          <p>The following code fragment shows an OQL query that uses the LIMIT keyword 
             to select the first 10 ProductGroup instances.</p>
       
Index: doc/release-notes.xml
===================================================================
RCS file: /scm/castor/castor/src/doc/release-notes.xml,v
retrieving revision 1.73
diff -u -r1.73 release-notes.xml
--- doc/release-notes.xml	27 Jul 2005 11:54:21 -0000	1.73
+++ doc/release-notes.xml	31 Jul 2005 20:42:00 -0000
@@ -30,6 +30,26 @@
             <summary>
             </summary>
 			<bugs>
+                <bug id="1114" tool="jira">
+                    <description>
+		                Update docs on the limit clause support for OQL.
+                    </description>
+                    <contributor>
+                        <name>Ralf Joachim</name>
+                        <email>ralf.joachim@syscon-world.de</email>
+                    </contributor>
+                    <submitter>
+                        <name>Ralf Joachim</name>
+                        <email>ralf.joachim@syscon-world.de</email>
+                    </submitter>
+                    <reporter>
+                        <name>Bruce Snyder</name>
+                        <email>bruce DOT snyder AT gmail DOT com</email>
+					</reporter>
+                    <type>Enh.</type>
+                    <module>JDO</module>
+                    <date>20050731</date>
+                </bug>
                 <bug id="1169" tool="jira">
                     <description>
 		                Refactored access to caches, adding CacheEntry class and making OID and 
Index: etc/CHANGELOG
===================================================================
RCS file: /scm/castor/castor/src/etc/CHANGELOG,v
retrieving revision 1.236
diff -u -r1.236 CHANGELOG
--- etc/CHANGELOG	27 Jul 2005 11:54:21 -0000	1.236
+++ etc/CHANGELOG	31 Jul 2005 20:42:11 -0000
@@ -2,6 +2,11 @@
 Version (CVS)
 -------------
 
+JDO:   Fixed bug CASTOR-1114 using contribution from Ralf Joachim [ralf.joachim@syscon-world.de]
+       Update docs on the limit clause support for OQL.
+       Details: http://jira.codehaus.org/browse/CASTOR-1114
+       (Ralf - 20050731)
+
 JDO:   Fixed bug CASTOR-1169 using contribution from Werner Guttmann[werner.guttmann@gmx.net]
        Refactored access to caches, adding CacheEntry class and making OID and CacheEntry implement
        java.io.Serializable.