Tue, 19 May 2020 19:34:57 +0200
removes the sub menu and removes the home module
fixes the queries in the PGIssueDao
adds placeholder for a breadcrumb menu
universe@7 | 1 | /* |
universe@7 | 2 | * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER. |
universe@34 | 3 | * |
universe@24 | 4 | * Copyright 2018 Mike Becker. All rights reserved. |
universe@34 | 5 | * |
universe@7 | 6 | * Redistribution and use in source and binary forms, with or without |
universe@7 | 7 | * modification, are permitted provided that the following conditions are met: |
universe@7 | 8 | * |
universe@7 | 9 | * 1. Redistributions of source code must retain the above copyright |
universe@7 | 10 | * notice, this list of conditions and the following disclaimer. |
universe@7 | 11 | * |
universe@7 | 12 | * 2. Redistributions in binary form must reproduce the above copyright |
universe@7 | 13 | * notice, this list of conditions and the following disclaimer in the |
universe@7 | 14 | * documentation and/or other materials provided with the distribution. |
universe@7 | 15 | * |
universe@7 | 16 | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" |
universe@7 | 17 | * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE |
universe@7 | 18 | * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE |
universe@7 | 19 | * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE |
universe@7 | 20 | * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR |
universe@7 | 21 | * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF |
universe@7 | 22 | * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS |
universe@7 | 23 | * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN |
universe@7 | 24 | * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) |
universe@7 | 25 | * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
universe@7 | 26 | * POSSIBILITY OF SUCH DAMAGE. |
universe@34 | 27 | * |
universe@7 | 28 | */ |
universe@7 | 29 | package de.uapcore.lightpit; |
universe@7 | 30 | |
universe@38 | 31 | import de.uapcore.lightpit.dao.DataAccessObjects; |
universe@38 | 32 | import de.uapcore.lightpit.dao.postgres.PGDataAccessObjects; |
universe@33 | 33 | import org.slf4j.Logger; |
universe@33 | 34 | import org.slf4j.LoggerFactory; |
universe@33 | 35 | |
universe@7 | 36 | import javax.servlet.ServletException; |
universe@7 | 37 | import javax.servlet.http.HttpServlet; |
universe@7 | 38 | import javax.servlet.http.HttpServletRequest; |
universe@7 | 39 | import javax.servlet.http.HttpServletResponse; |
universe@13 | 40 | import javax.servlet.http.HttpSession; |
universe@33 | 41 | import java.io.IOException; |
universe@47 | 42 | import java.lang.reflect.Constructor; |
universe@33 | 43 | import java.lang.reflect.Method; |
universe@33 | 44 | import java.lang.reflect.Modifier; |
universe@38 | 45 | import java.sql.Connection; |
universe@38 | 46 | import java.sql.SQLException; |
universe@33 | 47 | import java.util.*; |
universe@63 | 48 | import java.util.function.Function; |
universe@7 | 49 | |
universe@7 | 50 | /** |
universe@7 | 51 | * A special implementation of a HTTPServlet which is focused on implementing |
universe@7 | 52 | * the necessary functionality for {@link LightPITModule}s. |
universe@7 | 53 | */ |
universe@9 | 54 | public abstract class AbstractLightPITServlet extends HttpServlet { |
universe@34 | 55 | |
universe@10 | 56 | private static final Logger LOG = LoggerFactory.getLogger(AbstractLightPITServlet.class); |
universe@34 | 57 | |
universe@43 | 58 | private static final String SITE_JSP = Functions.jspPath("site"); |
universe@33 | 59 | |
universe@11 | 60 | /** |
universe@11 | 61 | * The EL proxy is necessary, because the EL resolver cannot handle annotation properties. |
universe@11 | 62 | */ |
universe@36 | 63 | private LightPITModule.ELProxy moduleInfo = null; |
universe@33 | 64 | |
universe@63 | 65 | @FunctionalInterface |
universe@63 | 66 | protected interface SQLFindFunction<K, T> { |
universe@63 | 67 | T apply(K key) throws SQLException; |
universe@63 | 68 | |
universe@63 | 69 | default <V> SQLFindFunction<V, T> compose(Function<? super V, ? extends K> before) throws SQLException { |
universe@63 | 70 | Objects.requireNonNull(before); |
universe@63 | 71 | return (v) -> this.apply(before.apply(v)); |
universe@63 | 72 | } |
universe@63 | 73 | |
universe@63 | 74 | default <V> SQLFindFunction<K, V> andThen(Function<? super T, ? extends V> after) throws SQLException { |
universe@63 | 75 | Objects.requireNonNull(after); |
universe@63 | 76 | return (t) -> after.apply(this.apply(t)); |
universe@63 | 77 | } |
universe@63 | 78 | |
universe@63 | 79 | static <K> Function<K, K> identity() { |
universe@63 | 80 | return (t) -> t; |
universe@63 | 81 | } |
universe@63 | 82 | } |
universe@63 | 83 | |
universe@10 | 84 | /** |
universe@11 | 85 | * Invocation mapping gathered from the {@link RequestMapping} annotations. |
universe@34 | 86 | * <p> |
universe@18 | 87 | * Paths in this map must always start with a leading slash, although |
universe@18 | 88 | * the specification in the annotation must not start with a leading slash. |
universe@34 | 89 | * <p> |
universe@34 | 90 | * The reason for this is the different handling of empty paths in |
universe@18 | 91 | * {@link HttpServletRequest#getPathInfo()}. |
universe@11 | 92 | */ |
universe@39 | 93 | private final Map<HttpMethod, Map<String, Method>> mappings = new HashMap<>(); |
universe@11 | 94 | |
universe@11 | 95 | /** |
universe@10 | 96 | * Gives implementing modules access to the {@link ModuleManager}. |
universe@33 | 97 | * |
universe@10 | 98 | * @return the module manager |
universe@10 | 99 | */ |
universe@10 | 100 | protected final ModuleManager getModuleManager() { |
universe@10 | 101 | return (ModuleManager) getServletContext().getAttribute(ModuleManager.SC_ATTR_NAME); |
universe@10 | 102 | } |
universe@33 | 103 | |
universe@38 | 104 | |
universe@34 | 105 | /** |
universe@38 | 106 | * Creates a set of data access objects for the specified connection. |
universe@33 | 107 | * |
universe@38 | 108 | * @param connection the SQL connection |
universe@38 | 109 | * @return a set of data access objects |
universe@17 | 110 | */ |
universe@38 | 111 | private DataAccessObjects createDataAccessObjects(Connection connection) throws SQLException { |
universe@38 | 112 | final var df = (DatabaseFacade) getServletContext().getAttribute(DatabaseFacade.SC_ATTR_NAME); |
universe@39 | 113 | if (df.getSQLDialect() == DatabaseFacade.Dialect.Postgres) { |
universe@39 | 114 | return new PGDataAccessObjects(connection); |
universe@38 | 115 | } |
universe@39 | 116 | throw new AssertionError("Non-exhaustive if-else - this is a bug."); |
universe@17 | 117 | } |
universe@33 | 118 | |
universe@38 | 119 | private ResponseType invokeMapping(Method method, HttpServletRequest req, HttpServletResponse resp, DataAccessObjects dao) throws IOException { |
universe@11 | 120 | try { |
universe@14 | 121 | LOG.trace("invoke {}#{}", method.getDeclaringClass().getName(), method.getName()); |
universe@42 | 122 | final var paramTypes = method.getParameterTypes(); |
universe@42 | 123 | final var paramValues = new Object[paramTypes.length]; |
universe@42 | 124 | for (int i = 0; i < paramTypes.length; i++) { |
universe@42 | 125 | if (paramTypes[i].isAssignableFrom(HttpServletRequest.class)) { |
universe@42 | 126 | paramValues[i] = req; |
universe@42 | 127 | } else if (paramTypes[i].isAssignableFrom(HttpServletResponse.class)) { |
universe@42 | 128 | paramValues[i] = resp; |
universe@42 | 129 | } |
universe@42 | 130 | if (paramTypes[i].isAssignableFrom(DataAccessObjects.class)) { |
universe@42 | 131 | paramValues[i] = dao; |
universe@42 | 132 | } |
universe@42 | 133 | } |
universe@42 | 134 | return (ResponseType) method.invoke(this, paramValues); |
universe@12 | 135 | } catch (ReflectiveOperationException | ClassCastException ex) { |
universe@38 | 136 | LOG.error("invocation of method {} failed: {}", method.getName(), ex.getMessage()); |
universe@38 | 137 | LOG.debug("Details: ", ex); |
universe@12 | 138 | resp.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR); |
universe@12 | 139 | return ResponseType.NONE; |
universe@11 | 140 | } |
universe@11 | 141 | } |
universe@11 | 142 | |
universe@11 | 143 | @Override |
universe@11 | 144 | public void init() throws ServletException { |
universe@36 | 145 | moduleInfo = Optional.ofNullable(this.getClass().getAnnotation(LightPITModule.class)) |
universe@36 | 146 | .map(LightPITModule.ELProxy::new).orElse(null); |
universe@33 | 147 | |
universe@33 | 148 | if (moduleInfo != null) { |
universe@12 | 149 | scanForRequestMappings(); |
universe@12 | 150 | } |
universe@33 | 151 | |
universe@12 | 152 | LOG.trace("{} initialized", getServletName()); |
universe@12 | 153 | } |
universe@12 | 154 | |
universe@12 | 155 | private void scanForRequestMappings() { |
universe@12 | 156 | try { |
universe@11 | 157 | Method[] methods = getClass().getDeclaredMethods(); |
universe@11 | 158 | for (Method method : methods) { |
universe@11 | 159 | Optional<RequestMapping> mapping = Optional.ofNullable(method.getAnnotation(RequestMapping.class)); |
universe@11 | 160 | if (mapping.isPresent()) { |
universe@11 | 161 | if (!Modifier.isPublic(method.getModifiers())) { |
universe@11 | 162 | LOG.warn("{} is annotated with {} but is not public", |
universe@11 | 163 | method.getName(), RequestMapping.class.getSimpleName() |
universe@11 | 164 | ); |
universe@11 | 165 | continue; |
universe@11 | 166 | } |
universe@11 | 167 | if (Modifier.isAbstract(method.getModifiers())) { |
universe@11 | 168 | LOG.warn("{} is annotated with {} but is abstract", |
universe@11 | 169 | method.getName(), RequestMapping.class.getSimpleName() |
universe@11 | 170 | ); |
universe@11 | 171 | continue; |
universe@11 | 172 | } |
universe@12 | 173 | if (!ResponseType.class.isAssignableFrom(method.getReturnType())) { |
universe@12 | 174 | LOG.warn("{} is annotated with {} but has the wrong return type - 'ResponseType' required", |
universe@12 | 175 | method.getName(), RequestMapping.class.getSimpleName() |
universe@12 | 176 | ); |
universe@12 | 177 | continue; |
universe@12 | 178 | } |
universe@12 | 179 | |
universe@42 | 180 | boolean paramsInjectible = true; |
universe@42 | 181 | for (var param : method.getParameterTypes()) { |
universe@42 | 182 | paramsInjectible &= HttpServletRequest.class.isAssignableFrom(param) |
universe@42 | 183 | || HttpServletResponse.class.isAssignableFrom(param) |
universe@42 | 184 | || DataAccessObjects.class.isAssignableFrom(param); |
universe@42 | 185 | } |
universe@42 | 186 | if (paramsInjectible) { |
universe@58 | 187 | String requestPath = "/" + mapping.get().requestPath(); |
universe@12 | 188 | |
universe@39 | 189 | if (mappings |
universe@39 | 190 | .computeIfAbsent(mapping.get().method(), k -> new HashMap<>()) |
universe@39 | 191 | .putIfAbsent(requestPath, method) != null) { |
universe@11 | 192 | LOG.warn("{} {} has multiple mappings", |
universe@11 | 193 | mapping.get().method(), |
universe@11 | 194 | mapping.get().requestPath() |
universe@11 | 195 | ); |
universe@11 | 196 | } |
universe@12 | 197 | |
universe@22 | 198 | LOG.debug("{} {} maps to {}::{}", |
universe@11 | 199 | mapping.get().method(), |
universe@18 | 200 | requestPath, |
universe@22 | 201 | getClass().getSimpleName(), |
universe@11 | 202 | method.getName() |
universe@11 | 203 | ); |
universe@11 | 204 | } else { |
universe@42 | 205 | LOG.warn("{} is annotated with {} but has the wrong parameters - only HttpServletRequest. HttpServletResponse, and DataAccessObjects are allowed", |
universe@11 | 206 | method.getName(), RequestMapping.class.getSimpleName() |
universe@11 | 207 | ); |
universe@11 | 208 | } |
universe@11 | 209 | } |
universe@11 | 210 | } |
universe@12 | 211 | } catch (SecurityException ex) { |
universe@12 | 212 | LOG.error("Scan for request mappings on declared methods failed.", ex); |
universe@11 | 213 | } |
universe@11 | 214 | } |
universe@11 | 215 | |
universe@11 | 216 | @Override |
universe@11 | 217 | public void destroy() { |
universe@11 | 218 | mappings.clear(); |
universe@11 | 219 | LOG.trace("{} destroyed", getServletName()); |
universe@11 | 220 | } |
universe@34 | 221 | |
universe@13 | 222 | /** |
universe@13 | 223 | * Sets the name of the dynamic fragment. |
universe@34 | 224 | * <p> |
universe@13 | 225 | * It is sufficient to specify the name without any extension. The extension |
universe@13 | 226 | * is added automatically if not specified. |
universe@34 | 227 | * <p> |
universe@13 | 228 | * The fragment must be located in the dynamic fragments folder. |
universe@34 | 229 | * |
universe@34 | 230 | * @param req the servlet request object |
universe@13 | 231 | * @param fragmentName the name of the fragment |
universe@13 | 232 | * @see Constants#DYN_FRAGMENT_PATH_PREFIX |
universe@13 | 233 | */ |
universe@63 | 234 | protected void setDynamicFragment(HttpServletRequest req, String fragmentName) { |
universe@13 | 235 | req.setAttribute(Constants.REQ_ATTR_FRAGMENT, Functions.dynFragmentPath(fragmentName)); |
universe@13 | 236 | } |
universe@34 | 237 | |
universe@11 | 238 | /** |
universe@47 | 239 | * @param req the servlet request object |
universe@47 | 240 | * @param location the location where to redirect |
universe@47 | 241 | * @see Constants#REQ_ATTR_REDIRECT_LOCATION |
universe@47 | 242 | */ |
universe@63 | 243 | protected void setRedirectLocation(HttpServletRequest req, String location) { |
universe@47 | 244 | if (location.startsWith("./")) { |
universe@47 | 245 | location = location.replaceFirst("\\./", Functions.baseHref(req)); |
universe@47 | 246 | } |
universe@47 | 247 | req.setAttribute(Constants.REQ_ATTR_REDIRECT_LOCATION, location); |
universe@47 | 248 | } |
universe@47 | 249 | |
universe@47 | 250 | /** |
universe@13 | 251 | * Specifies the name of an additional stylesheet used by the module. |
universe@34 | 252 | * <p> |
universe@13 | 253 | * Setting an additional stylesheet is optional, but quite common for HTML |
universe@13 | 254 | * output. |
universe@34 | 255 | * <p> |
universe@13 | 256 | * It is sufficient to specify the name without any extension. The extension |
universe@13 | 257 | * is added automatically if not specified. |
universe@34 | 258 | * |
universe@34 | 259 | * @param req the servlet request object |
universe@13 | 260 | * @param stylesheet the name of the stylesheet |
universe@11 | 261 | */ |
universe@13 | 262 | public void setStylesheet(HttpServletRequest req, String stylesheet) { |
universe@13 | 263 | req.setAttribute(Constants.REQ_ATTR_STYLESHEET, Functions.enforceExt(stylesheet, ".css")); |
universe@10 | 264 | } |
universe@34 | 265 | |
universe@47 | 266 | /** |
universe@47 | 267 | * Obtains a request parameter of the specified type. |
universe@47 | 268 | * The specified type must have a single-argument constructor accepting a string to perform conversion. |
universe@47 | 269 | * The constructor of the specified type may throw an exception on conversion failures. |
universe@47 | 270 | * |
universe@47 | 271 | * @param req the servlet request object |
universe@47 | 272 | * @param clazz the class object of the expected type |
universe@47 | 273 | * @param name the name of the parameter |
universe@47 | 274 | * @param <T> the expected type |
universe@47 | 275 | * @return the parameter value or an empty optional, if no parameter with the specified name was found |
universe@47 | 276 | */ |
universe@63 | 277 | protected<T> Optional<T> getParameter(HttpServletRequest req, Class<T> clazz, String name) { |
universe@47 | 278 | final String paramValue = req.getParameter(name); |
universe@47 | 279 | if (paramValue == null) return Optional.empty(); |
universe@47 | 280 | if (clazz.equals(String.class)) return Optional.of((T)paramValue); |
universe@47 | 281 | try { |
universe@47 | 282 | final Constructor<T> ctor = clazz.getConstructor(String.class); |
universe@47 | 283 | return Optional.of(ctor.newInstance(paramValue)); |
universe@47 | 284 | } catch (ReflectiveOperationException e) { |
universe@47 | 285 | throw new RuntimeException(e); |
universe@47 | 286 | } |
universe@47 | 287 | |
universe@47 | 288 | } |
universe@47 | 289 | |
universe@63 | 290 | /** |
universe@63 | 291 | * Tries to look up an entity with a key obtained from a request parameter. |
universe@63 | 292 | * |
universe@63 | 293 | * @param req the servlet request object |
universe@63 | 294 | * @param clazz the class representing the type of the request parameter |
universe@63 | 295 | * @param name the name of the request parameter |
universe@63 | 296 | * @param find the find function (typically a DAO function) |
universe@63 | 297 | * @param <T> the type of the request parameter |
universe@63 | 298 | * @param <R> the type of the looked up entity |
universe@63 | 299 | * @return the retrieved entity or an empty optional if there is no such entity or the request parameter was missing |
universe@63 | 300 | * @throws SQLException if the find function throws an exception |
universe@63 | 301 | */ |
universe@63 | 302 | protected<T,R> Optional<R> findByParameter(HttpServletRequest req, Class<T> clazz, String name, SQLFindFunction<? super T, ? extends R> find) throws SQLException { |
universe@63 | 303 | final var param = getParameter(req, clazz, name); |
universe@63 | 304 | if (param.isPresent()) { |
universe@63 | 305 | return Optional.ofNullable(find.apply(param.get())); |
universe@63 | 306 | } else { |
universe@63 | 307 | return Optional.empty(); |
universe@63 | 308 | } |
universe@63 | 309 | } |
universe@63 | 310 | |
universe@10 | 311 | private void forwardToFullView(HttpServletRequest req, HttpServletResponse resp) |
universe@10 | 312 | throws IOException, ServletException { |
universe@34 | 313 | |
universe@36 | 314 | req.setAttribute(Constants.REQ_ATTR_MENU, getModuleManager().getMainMenu()); |
universe@43 | 315 | req.getRequestDispatcher(SITE_JSP).forward(req, resp); |
universe@10 | 316 | } |
universe@34 | 317 | |
universe@45 | 318 | private String sanitizeRequestPath(HttpServletRequest req) { |
universe@45 | 319 | return Optional.ofNullable(req.getPathInfo()).orElse("/"); |
universe@45 | 320 | } |
universe@45 | 321 | |
universe@39 | 322 | private Optional<Method> findMapping(HttpMethod method, HttpServletRequest req) { |
universe@45 | 323 | return Optional.ofNullable(mappings.get(method)).map(rm -> rm.get(sanitizeRequestPath(req))); |
universe@11 | 324 | } |
universe@34 | 325 | |
universe@34 | 326 | private void forwardAsSpecified(ResponseType type, HttpServletRequest req, HttpServletResponse resp) |
universe@12 | 327 | throws ServletException, IOException { |
universe@12 | 328 | switch (type) { |
universe@34 | 329 | case NONE: |
universe@34 | 330 | return; |
universe@43 | 331 | case HTML: |
universe@12 | 332 | forwardToFullView(req, resp); |
universe@12 | 333 | return; |
universe@12 | 334 | // TODO: implement remaining response types |
universe@12 | 335 | default: |
universe@34 | 336 | throw new AssertionError("ResponseType switch is not exhaustive - this is a bug!"); |
universe@12 | 337 | } |
universe@12 | 338 | } |
universe@34 | 339 | |
universe@38 | 340 | private void doProcess(HttpMethod method, HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { |
universe@27 | 341 | |
universe@13 | 342 | // choose the requested language as session language (if available) or fall back to english, otherwise |
universe@20 | 343 | HttpSession session = req.getSession(); |
universe@13 | 344 | if (session.getAttribute(Constants.SESSION_ATTR_LANGUAGE) == null) { |
universe@13 | 345 | Optional<List<String>> availableLanguages = Functions.availableLanguages(getServletContext()).map(Arrays::asList); |
universe@13 | 346 | Optional<Locale> reqLocale = Optional.of(req.getLocale()); |
universe@13 | 347 | Locale sessionLocale = reqLocale.filter((rl) -> availableLanguages.map((al) -> al.contains(rl.getLanguage())).orElse(false)).orElse(Locale.ENGLISH); |
universe@13 | 348 | session.setAttribute(Constants.SESSION_ATTR_LANGUAGE, sessionLocale); |
universe@34 | 349 | LOG.debug("Setting language for new session {}: {}", session.getId(), sessionLocale.getDisplayLanguage()); |
universe@14 | 350 | } else { |
universe@15 | 351 | Locale sessionLocale = (Locale) session.getAttribute(Constants.SESSION_ATTR_LANGUAGE); |
universe@15 | 352 | resp.setLocale(sessionLocale); |
universe@15 | 353 | LOG.trace("Continuing session {} with language {}", session.getId(), sessionLocale); |
universe@13 | 354 | } |
universe@34 | 355 | |
universe@21 | 356 | // set some internal request attributes |
universe@53 | 357 | final String fullPath = Functions.fullPath(req); |
universe@47 | 358 | req.setAttribute(Constants.REQ_ATTR_BASE_HREF, Functions.baseHref(req)); |
universe@53 | 359 | req.setAttribute(Constants.REQ_ATTR_PATH, fullPath); |
universe@36 | 360 | Optional.ofNullable(moduleInfo).ifPresent((proxy) -> req.setAttribute(Constants.REQ_ATTR_MODULE_INFO, proxy)); |
universe@34 | 361 | |
universe@53 | 362 | // if this is an error path, bypass the normal flow |
universe@53 | 363 | if (fullPath.startsWith("/error/")) { |
universe@53 | 364 | final var mapping = findMapping(method, req); |
universe@53 | 365 | if (mapping.isPresent()) { |
universe@53 | 366 | forwardAsSpecified(invokeMapping(mapping.get(), req, resp, null), req, resp); |
universe@53 | 367 | } |
universe@53 | 368 | return; |
universe@53 | 369 | } |
universe@53 | 370 | |
universe@38 | 371 | // obtain a connection and create the data access objects |
universe@38 | 372 | final var db = (DatabaseFacade) req.getServletContext().getAttribute(DatabaseFacade.SC_ATTR_NAME); |
universe@53 | 373 | final var ds = db.getDataSource(); |
universe@53 | 374 | if (ds == null) { |
universe@53 | 375 | resp.sendError(HttpServletResponse.SC_SERVICE_UNAVAILABLE, "JNDI DataSource lookup failed. See log for details."); |
universe@53 | 376 | return; |
universe@53 | 377 | } |
universe@53 | 378 | try (final var connection = ds.getConnection()) { |
universe@38 | 379 | final var dao = createDataAccessObjects(connection); |
universe@39 | 380 | try { |
universe@39 | 381 | connection.setAutoCommit(false); |
universe@39 | 382 | // call the handler, if available, or send an HTTP 404 error |
universe@39 | 383 | final var mapping = findMapping(method, req); |
universe@39 | 384 | if (mapping.isPresent()) { |
universe@39 | 385 | forwardAsSpecified(invokeMapping(mapping.get(), req, resp, dao), req, resp); |
universe@39 | 386 | } else { |
universe@39 | 387 | resp.sendError(HttpServletResponse.SC_NOT_FOUND); |
universe@39 | 388 | } |
universe@39 | 389 | connection.commit(); |
universe@39 | 390 | } catch (SQLException ex) { |
universe@39 | 391 | LOG.warn("Database transaction failed (Code {}): {}", ex.getErrorCode(), ex.getMessage()); |
universe@39 | 392 | LOG.debug("Details: ", ex); |
universe@54 | 393 | resp.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, "Unhandled Transaction Error - Code: " + ex.getErrorCode()); |
universe@39 | 394 | connection.rollback(); |
universe@38 | 395 | } |
universe@38 | 396 | } catch (SQLException ex) { |
universe@39 | 397 | LOG.error("Severe Database Exception (Code {}): {}", ex.getErrorCode(), ex.getMessage()); |
universe@38 | 398 | LOG.debug("Details: ", ex); |
universe@54 | 399 | resp.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, "Database Error - Code: " + ex.getErrorCode()); |
universe@12 | 400 | } |
universe@12 | 401 | } |
universe@34 | 402 | |
universe@7 | 403 | @Override |
universe@7 | 404 | protected final void doGet(HttpServletRequest req, HttpServletResponse resp) |
universe@7 | 405 | throws ServletException, IOException { |
universe@12 | 406 | doProcess(HttpMethod.GET, req, resp); |
universe@7 | 407 | } |
universe@7 | 408 | |
universe@7 | 409 | @Override |
universe@7 | 410 | protected final void doPost(HttpServletRequest req, HttpServletResponse resp) |
universe@7 | 411 | throws ServletException, IOException { |
universe@12 | 412 | doProcess(HttpMethod.POST, req, resp); |
universe@7 | 413 | } |
universe@7 | 414 | } |