/
positiveResultIsLimitedByMaxRowsTest.jsp
133 lines (110 loc) · 5.26 KB
/
positiveResultIsLimitedByMaxRowsTest.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<%--
Copyright (c) 2003, 2018 Oracle and/or its affiliates. All rights reserved.
This program and the accompanying materials are made available under the
terms of the Eclipse Public License v. 2.0, which is available at
http://www.eclipse.org/legal/epl-2.0.
This Source Code may also be made available under the following Secondary
Licenses when the conditions for such availability set forth in the
Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
version 2 with the GNU Classpath Exception, which is available at
https://www.gnu.org/software/classpath/license.html.
SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0
--%>
<%@ taglib prefix="sql" uri="jakarta.tags.sql" %>
<%@ taglib prefix="c" uri="jakarta.tags.core" %>
<%@ taglib prefix="tck" uri="http://java.sun.com/jstltck/jstltck-util" %>
<%@ page import="javax.sql.*, java.util.*" %>
<tck:test testName="positiveResultIsLimitedByMaxRowsTest">
<%
pageContext.setAttribute("noMaxRows", new Integer("-1"));
pageContext.setAttribute("maxRowsLimit", new Integer("5"));
%>
<!-- Validate that a sql:query action and Result.isLimitedByMaxRows
will return the correct value -->
<h1>Validating sql:query action and Result.isLimitedByMaxRows </h1>
<p>
<sql:query var="resultSet4"
dataSource='<%=(DataSource) pageContext.getAttribute("jstlDS", PageContext.APPLICATION_SCOPE) %>' >
<%=((Properties)pageContext.getAttribute("sqlProps",PageContext.APPLICATION_SCOPE)).getProperty("Simple_Select_Query") %>
</sql:query>
<c:choose>
<c:when test="${resultSet4.limitedByMaxRows}">
<H2>ERROR:</H2>
The maxRows attribute was <strong>NOT</strong> specified. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
<strong>true</strong>. The expected value was <strong>false</strong>.
<p>
</c:when>
<c:otherwise>
The maxRows attribute was <strong>NOT</strong> specified. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
<strong>false</strong> as expected.
<p>
</c:otherwise>
</c:choose>
<sql:query var="resultSet5"
dataSource='<%=(DataSource) pageContext.getAttribute("jstlDS", PageContext.APPLICATION_SCOPE) %>'
maxRows='<%=((Integer) pageContext.getAttribute("noMaxRows")).intValue() %>' >
<%=((Properties)pageContext.getAttribute("sqlProps",PageContext.APPLICATION_SCOPE)).getProperty("Simple_Select_Query") %>
</sql:query>
<c:choose>
<c:when test="${resultSet5.limitedByMaxRows}">
<H2>ERROR:</H2>
The maxRows attribute was set to <strong>
<c:out value="${noMaxRows}" /></strong>. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
<strong>true</strong>. The expected value was <strong>false</strong>.
<p>
</c:when>
<c:otherwise>
The maxRows attribute was set to <strong>
<c:out value="${noMaxRows}" /></strong>. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
<strong>false</strong> as expected.
<p>
</c:otherwise>
</c:choose>
<sql:query var="resultSet6"
dataSource='<%=(DataSource) pageContext.getAttribute("jstlDS", PageContext.APPLICATION_SCOPE) %>'
maxRows='<%=((Integer) pageContext.getAttribute("maxRowsLimit")).intValue() %>' >
<%=((Properties)pageContext.getAttribute("sqlProps",PageContext.APPLICATION_SCOPE)).getProperty("Simple_Select_Query") %>
</sql:query>
<c:choose>
<c:when test="${resultSet6.limitedByMaxRows}">
The maxRows attribute was set to <strong>
<c:out value="${maxRowsLimit}" /></strong>. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
<strong>true</strong> as expected.
<p>
</c:when>
<c:otherwise>
<H2>ERROR:</H2>
The maxRows attribute was set to <strong>
<c:out value="${maxRowsLimit}" /></strong>. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
<strong>false</strong>. The expected value was <strong>true</strong>.
<p>
</c:otherwise>
</c:choose>
<%-- Hard code maxRows to the value of maxRowsLimit --%>
<sql:query var="resultSet7"
dataSource='<%=(DataSource) pageContext.getAttribute("jstlDS", PageContext.APPLICATION_SCOPE) %>'
maxRows='5' >
<%=((Properties)pageContext.getAttribute("sqlProps",PageContext.APPLICATION_SCOPE)).getProperty("Simple_Select_Query") %>
</sql:query>
<c:choose>
<c:when test="${resultSet7.limitedByMaxRows}">
The maxRows attribute was set to <strong>
<c:out value="${maxRowsLimit}" /></strong>. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
<strong>true</strong> as expected.
<p>
</c:when>
<c:otherwise>
<H2>ERROR:</H2>
The maxRows attribute was set to <strong>
<c:out value="${maxRowsLimit}" /></strong>. The value
returned from <strong>Result.isLimitedByMaxRows()</strong> was
</c:otherwise>
</c:choose>
</tck:test>