/
positiveSetDataSourceUpdateNoVarAttributeDataSourceTest.jsp
77 lines (60 loc) · 2.68 KB
/
positiveSetDataSourceUpdateNoVarAttributeDataSourceTest.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
<%--
Copyright (c) 2003, 2020 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="positiveSetDataSourceUpdateNoVarAttributeDataSourceTest">
<!-- Validate sql:update and sql:setDataSource actions by specifying a
DataSource Object for jakarta.servlet.jsp.jstl.sql.dataSource-->
<h1>Validate sql:update and sql:setDataSource actions by specifying a
DataSource object for jakarta.servlet.jsp.jstl.sql.dataSource </h1>
<p>
<c:catch var="ex3" >
<sql:setDataSource dataSource='<%=(DataSource) pageContext.getAttribute("jstlDS", PageContext.APPLICATION_SCOPE) %>'
/>
</c:catch>
<c:choose>
<c:when test="${!empty ex3}">
<H2>ERROR:</H2>
Could not create a dataSource using a <strong>DataSource Object
</strong> for jakarta.servlet.jsp.jstl.sql.dataSource! The Exception that
was raised is: <strong><c:out value='${ex3}' escapeXml='false' /></strong>.
<p>
</c:when>
<c:otherwise>
Successfully created a DataSource.
<p>
</c:otherwise>
</c:choose>
<c:catch var="ex4" >
<sql:update var="resultSet2" >
<c:out value="${sqlProps.Delete_NoRows_Query}" />
</sql:update>
</c:catch>
<c:choose>
<c:when test="${!empty ex4}">
<H2>ERROR:</H2>
Could not execute the query <strong><c:out value="${sqlProps.Delete_NoRows_Query}" />
</strong> when using a <strong>DataSource Object</strong> for
jakarta.servlet.jsp.jstl.sql.dataSource! The Exception that was raised is:
<strong><c:out value='${ex2}' escapeXml='false' /></strong>.
<p>
</c:when>
<c:otherwise>
Successfully executed the query when jakarta.servlet.jsp.jstl.sql.dataSource
was provided a DataSource Object.
<p>
</c:otherwise>
</c:choose>
</tck:test>