{"id":8,"date":"2009-06-19T11:23:14","date_gmt":"2009-06-19T17:23:14","guid":{"rendered":"http:\/\/www.klsoftware.com\/blog\/2009\/06\/using-jstl-exception-handling-in-jdev-1012-portlet\/"},"modified":"2009-07-14T07:27:53","modified_gmt":"2009-07-14T13:27:53","slug":"using-jstl-exception-handling-in-jdev-1012-portlet","status":"publish","type":"post","link":"https:\/\/www.klsoftware.com\/blog\/?p=8","title":{"rendered":"Using JSTL Exception Handling in JDev 10.1.2 Portlet"},"content":{"rendered":"

The following is a portlet I recently updated for Oracle Portal. The dates were not formatting properly, so I added a JSTL catch tag. This also uses choice tags which help when you need an else tag after an if tag.<\/p>\n

<%@ taglib uri=\"http:\/\/java.sun.com\/jstl\/fmt\" prefix=\"fmt\"%>\r\n<%@ taglib uri=\"http:\/\/java.sun.com\/jstl\/core\" prefix=\"c\"%>\r\n<%@ taglib uri=\"http:\/\/xmlns.oracle.com\/adf\/ui\/jsp\/adftags\" prefix=\"adf\"%>\r\n\r\n<%@page contentType=\"text\/html; charset=UTF-8\"%>\r\n<%@page import=\"oracle.portal.provider.v2.http.HttpCommonConstants\"%>\r\n<%@page import=\"oracle.portal.provider.v2.render.PortletRenderRequest\"%>\r\n<%@page import=\"oracle.portal.provider.v2.render.http.HttpPortletRendererUtil\"%>\r\n<%@page import=\"oracle.portal.provider.v2.url.UrlUtils\"%>\r\n\r\n<adf:uimodelreference\r\nmodel=\"htdocs_busroutesportlet_BusRoutesPortletShowPageUIModel\" \/>\r\n<jsp:useBean id=\"now\" class=\"java.util.Date\" \/>\r\n\r\n<script type=\"text\/javascript\"\r\nsrc=\"\/BusRoutes2009Portlet\/scripts\/busroutes2009.js\"><\/script>\r\n\r\n<c:set var=\"nowdate\" scope=\"page\"><fmt:formatDate value=\"${now}\" \/><\/c:set>\r\n<c:set var=\"school\" scope=\"page\" value=\"\" \/>\r\n\r\n<%\r\nPortletRenderRequest pReq =\r\n(PortletRenderRequest)\r\nrequest.getAttribute(HttpCommonConstants.PORTLET_RENDER_REQUEST);\r\n\r\nString paramNameSchool = \"sch\";\r\nString sSQLQuery = \"\";\r\nString paramNameSubmit = \"submit\";\r\n\r\nString qualParamNameSchool =\r\nHttpPortletRendererUtil.portletParameter(pReq, paramNameSchool);\r\nString qualParamNameSubmit =\r\nHttpPortletRendererUtil.portletParameter(pReq, paramNameSubmit);\r\n\r\nString sSchoolValue = pReq.getQualifiedParameter(paramNameSchool);\r\n\r\nString formName = UrlUtils.htmlFormName(pReq,\"busroutes_form\");\r\n\r\npageContext.setAttribute(\"school\",(Object)sSchoolValue);\r\n%>\r\n\r\n<script>\r\nvar sSch = <%=sSchoolValue%>;\r\n<\/script>\r\n\r\n<c:set var=\"sch\"><%=sSchoolValue%><\/c:set>\r\n\r\n<form name=<%=formName %> method=\"POST\"\r\naction=\"<%= UrlUtils.htmlFormActionLink(pReq,UrlUtils.PAGE_LINK) %>\">\r\n<%= UrlUtils.htmlFormHiddenFields(pReq,UrlUtils.PAGE_LINK, formName) %>\r\nSelect School and press submit to see schedule.\r\nClick on column heading to sort.<br \/>\r\n<br \/>\r\nSchool:\r\n<select name=\"<%=qualParamNameSchool%>\" id=\"ctlSchool\">\r\n<option value=\"0\" >-- Select a School --<\/option>\r\n<c:forEach var=\"row\" items=\"${bindings.SchoolsView1.rangeSet}\">\r\n<c:choose>\r\n<c:when test=\"${sch == row.Id}\">\r\n<option value=\"<c:out value=\"${row.Id}\"\/>\" selected=\"selected\">\r\n<c:set var=\"mapurl\" scope=\"page\">\r\n<c:out value=\"${row.MapUrl}\" \/>\r\n<\/c:set>\r\n<c:set var=\"websiteurl\" scope=\"page\">\r\n<c:out value=\"${row.WebsiteUrl}\" \/>\r\n<\/c:set>\r\n<c:set var=\"schooltype\" scope=\"page\">\r\n<c:out value=\"${row.TypeId}\" \/>\r\n<\/c:set>\r\n<\/c:when>\r\n<c:otherwise>\r\n<option value=\"<c:out value=\"${row.Id}\"\/>\">\r\n<\/c:otherwise>\r\n<\/c:choose>\r\n<c:out value=\"${row.School}\" \/>\r\n<\/option>\r\n<\/c:forEach>\r\n<\/select>\r\n<br \/>\r\n<br \/>\r\n<input type=submit name=\"<%= qualParamNameSubmit %>\" value=\"submit\" \/>\r\n<\/form>\r\n\r\n<br \/>\r\n<br \/>\r\n\r\n<table border=\"0\" id=\"urls\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<c:choose>\r\n<c:when test=\"${not empty mapurl}\">\r\n<a href=\"<c:out value=\"${mapurl}\"\/>\"\r\ntarget=\"_blank\">\r\n<font class=\"titleorimageid1siteid53\">\r\nBus Route Map\r\n<\/font>\r\n<\/a>\r\n<\/c:when>\r\n<c:otherwise>\r\n&nbsp;\r\n<\/c:otherwise>\r\n<\/c:choose>\r\n<\/td>\r\n<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/td>\r\n<td>\r\n<c:choose>\r\n<c:when test=\"${not empty websiteurl}\">\r\n<a href=\"<c:out value=\"${websiteurl}\"\/>\"\r\ntarget=\"_blank\">\r\n<font class=\"titleorimageid1siteid53\">\r\nSchool Web Site\r\n<\/font>\r\n<\/a>\r\n<\/c:when>\r\n<c:otherwise>\r\n&nbsp;\r\n<\/c:otherwise>\r\n<\/c:choose>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\r\n<br \/>\r\n<br \/>\r\n\r\n<c:set var=\"vo\" scope=\"page\" value=\"${bindings.BRView_2009_1.viewObject}\" \/>\r\n<%\r\ntry {\r\nObject o = pageContext.getAttribute(\"vo\");\r\noracle.jbo.ViewObject vo = (oracle.jbo.ViewObject)o;\r\nString sWhereClause = \"SCHOOL_ID = \"   sSchoolValue   \" \";\r\n\r\nvo.setWhereClause(sWhereClause);\r\nsSQLQuery = vo.getQuery();\r\n\r\nvo.executeQuery();\r\nSystem.out.println(\"Query: \"   vo.getQuery());\r\nSystem.out.println(\"sSchoolValue: \"   sSchoolValue);\r\n} catch (Exception e) {\r\nSystem.out.println(\"Error:\"   e.getMessage());\r\nSystem.out.println(\"sSchoolValue = \"   sSchoolValue);\r\n}\r\n%>\r\n\r\n<br \/>\r\n<br \/>\r\n\r\n<table id=\"example\" class=\"tablesorter\" border=\"1\" width=\"100%\">\r\n<thead>\r\n<tr>\r\n<th style=\"text-align: center\"><c:out value=\"Route\" \/><\/th>\r\n<c:choose>\r\n<c:when test=\"${schooltype == 3}\">\r\n<th style=\"text-align: center\"><c:out value=\"Route Animal\" \/><\/th>\r\n<\/c:when>\r\n<c:otherwise>\r\n<th style=\"text-align: center\">&nbsp;<\/th>\r\n<\/c:otherwise>\r\n<\/c:choose>\r\n<th><c:out value=\"Stop\" \/><\/th>\r\n<th style=\"text-align: center\"><c:out value=\"AM\" \/><\/th>\r\n<th style=\"text-align: center\"><c:out value=\"PM\" \/><\/th>\r\n<th style=\"text-align: center\"><c:out value=\"Start Date\" \/><\/th>\r\n<th style=\"text-align: center\"><c:out value=\"Stop Date\" \/><\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<c:forEach var=\"Row\" items=\"${bindings.BRView_2009_1.rangeSet}\" >\r\n<c:catch var=\"errorvalue\">\r\n<fmt:parseDate value=\"${Row['StartServiceDate']}\"\r\nvar=\"startdate\"\r\npattern=\"MM-dd-yyyy\" \/>\r\n<fmt:parseDate value=\"${Row['StopServiceDate']}\"\r\nvar=\"stopdate\"\r\npattern=\"MM-dd-yyyy\" \/>\r\n<\/c:catch>\r\n\r\n<c:if test=\"${not empty startdate}\">\r\n<c:set var=\"startdatedisplay\" scope=\"page\">\r\n<fmt:formatDate value=\"${startdate}\" \/>\r\n<\/c:set>\r\n<\/c:if>\r\n\r\n<c:if test=\"${not empty stopdate}\">\r\n<c:set var=\"stopdatedisplay\" scope=\"page\">\r\n<fmt:formatDate value=\"${stopdate}\" \/>\r\n<\/c:set>\r\n<\/c:if>\r\n\r\n<tr>\r\n<td align=center><c:out value=\"${Row['Route']}\" \/>&nbsp;<\/td>\r\n<c:choose>\r\n<c:when test=\"${schooltype == 3}\">\r\n<td align=center>\r\n<img src=\"someurl.retrieve_image?p_id=<c:out value=\"${Row['ImageId']}\" \/>\"\r\nalt=\"no image\" \/><\/td>\r\n<\/c:when>\r\n<c:otherwise>\r\n<td align=center>&nbsp;<\/td>\r\n<\/c:otherwise>\r\n<\/c:choose>\r\n<td><c:out value=\"${Row['Stop']}\" \/>&nbsp;<\/td>\r\n<td align=center><c:out value=\"${Row['Am']}\" \/>&nbsp;<\/td>\r\n<td align=center><c:out value=\"${Row['Pm']}\" \/>&nbsp;<\/td>\r\n<c:choose>\r\n<c:when test=\"${now ge startdate}\">\r\n<td align=center>&nbsp;<\/td>\r\n<\/c:when>\r\n<c:when test=\"${now lt startdate}\">\r\n<td align=center style=\"color: blue;\">\r\n<c:out value=\"${startdatedisplay}\" \/>&nbsp;\r\n<\/td>\r\n<\/c:when>\r\n<c:otherwise>\r\n<td align=center><c:out value=\"${startdatedisplay}\" \/>&nbsp;<\/td>\r\n<\/c:otherwise>\r\n<\/c:choose>\r\n<c:choose>\r\n<c:when test=\"${now lt stopdate}\">\r\n<td align=center style=\"color: red;\">\r\n<c:out value=\"${stopdatedisplay}\" \/>&nbsp;\r\n<\/td>\r\n<\/c:when>\r\n<c:otherwise>\r\n<td align=center><c:out value=\"${stopdatedisplay}\" \/>&nbsp;<\/td>\r\n<\/c:otherwise>\r\n<\/c:choose>\r\n<\/tr>\r\n<\/c:forEach>\r\n<\/tbody>\r\n<\/table>\r\n\r\n<br \/>\r\n<br \/><\/pre>\n","protected":false},"excerpt":{"rendered":"
The following is a portlet I recently updated for Oracle Portal. The dates were not formatting properly, so I added a JSTL catch tag. This also uses choice tags which help when you need an else tag after an if tag. <%@ taglib uri=”http:\/\/java.sun.com\/jstl\/fmt” prefix=”fmt”%> <%@ taglib uri=”http:\/\/java.sun.com\/jstl\/core” prefix=”c”%> <%@ taglib uri=”http:\/\/xmlns.oracle.com\/adf\/ui\/jsp\/adftags” prefix=”adf”%> <%@page contentType=”text\/html; […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[8],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-jdev1012-portlet-jstl"],"_links":{"self":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8"}],"version-history":[{"count":4,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8\/revisions"}],"predecessor-version":[{"id":12,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8\/revisions\/12"}],"wp:attachment":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}