jmcnally 02/05/20 11:45:55
Modified: src/java/org/apache/torque/util BasePeer.java
Log:
patch by Bill Schneider <[EMAIL PROTECTED]> to add native limit
support for oracle
Revision Changes Path
1.40 +12 -2
jakarta-turbine-torque/src/java/org/apache/torque/util/BasePeer.java
Index: BasePeer.java
===================================================================
RCS file:
/home/cvs/jakarta-turbine-torque/src/java/org/apache/torque/util/BasePeer.java,v
retrieving revision 1.39
retrieving revision 1.40
diff -u -r1.39 -r1.40
--- BasePeer.java 7 May 2002 05:57:19 -0000 1.39
+++ BasePeer.java 20 May 2002 18:45:55 -0000 1.40
@@ -106,7 +106,7 @@
* @author <a href="mailto:[EMAIL PROTECTED]";>Frank Y. Kim</a>
* @author <a href="mailto:[EMAIL PROTECTED]";>John D. McNally</a>
* @author <a href="mailto:[EMAIL PROTECTED]";>Brett McLaughlin</a>
- * @version $Id: BasePeer.java,v 1.39 2002/05/07 05:57:19 dobbs Exp $
+ * @version $Id: BasePeer.java,v 1.40 2002/05/20 18:45:55 jmcnally Exp $
*/
public abstract class BasePeer implements java.io.Serializable
{
@@ -1325,7 +1325,17 @@
criteria.setLimit(-1);
}
- if (limitString != null) query.setLimit(limitString);
+ if (limitString != null)
+ {
+ switch (db.getLimitStyle())
+ {
+ case DB.LIMIT_STYLE_ORACLE:
+ whereClause.add("rownum <= " + limitString);
+ break;
+ default:
+ query.setLimit(limitString);
+ }
+ }
String sql = query.toString();
category.debug(sql);
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
