/
positiveTxQueryParamCommitTest.jsp
76 lines (62 loc) · 3.02 KB
/
positiveTxQueryParamCommitTest.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
<%--
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="c" uri="jakarta.tags.core" %>
<%@ taglib prefix="sql" uri="jakarta.tags.sql" %>
<%@ taglib prefix="tck" uri="http://java.sun.com/jstltck/jstltck-util" %>
<%@ page import="javax.sql.*, java.util.*" %>
<tck:test testName="positiveTxQueryParamCommitTest">
<%
pageContext.setAttribute("key", new Integer("1"));
%>
<c:set var="expectedRows" value="${1}" />
<!-- Validate sql:transaction, sql:query sql:param actions
allow for the execution of a SQL statement -->
<h1>Validate sql:transaction, sql:query sql:param actions
allow for the execution of a SQL statement </h1>
<p>
<sql:transaction
dataSource='<%=(DataSource) pageContext.getAttribute("jstlDS", PageContext.APPLICATION_SCOPE) %>' >
<sql:query var="resultSet2"
sql='<%=((Properties)pageContext.getAttribute("sqlProps",PageContext.APPLICATION_SCOPE)).getProperty("Select_Jstl_Tab1_Using_Param_Query") %>' >
<sql:param value='<%=(Integer) pageContext.getAttribute("key") %>' />
</sql:query>
</sql:transaction>
<c:set var="rows2" value="${resultSet2.rowsByIndex}" />
<c:set var='column2' value='${resultSet2.columnNames}' />
<c:choose>
<c:when test="${resultSet2.rowCount != expectedRows}">
<H2>ERROR:</H2>
The query: <strong>
"<c:out value="${sqlProps.Select_Jstl_Tab1_Using_Param_Query}" />"
</strong> returned <strong>"<c:out value="${resultSet2.rowCount}" />"
</strong> rows and the expected number of rows was
<strong>"<c:out value="${expectedRows}" />"</strong>.
<p>
</c:when>
<c:when test="${rows2[0][0] != key}">
<H2>ERROR:</H2>
The query: <strong>
"<c:out value="${sqlProps.Select_Jstl_Tab1_Using_Param_Query}" />"
</strong> returned the incorrect value for the column<strong>
<c:out value="${column2[0]}" /></strong>. The expected
value was <strong>"<c:out value="${key}" />"</strong> and the
actual column value was <strong>"<c:out value="${rows2[0][0]}" />"</strong>.
<p>
</c:when>
<c:otherwise>
The query did return a Result Object that contained
<strong><c:out value="${expectedRows}" /></strong> row as expected.
<p>
</c:otherwise>
</c:choose>
</tck:test>