/** * Populate the context for create_playoff_division.jsp. * * @param application */ public static void populateContext( final ServletContext application, final PageContext pageContext) { final DataSource datasource = ApplicationAttributes.getDataSource(application); Connection connection = null; try { connection = datasource.getConnection(); final int currentTournamentID = Queries.getCurrentTournament(connection); final List<String> judgingStations = Queries.getJudgingStations(connection, currentTournamentID); pageContext.setAttribute("judgingStations", judgingStations); final List<String> awardGroups = Queries.getAwardGroups(connection, currentTournamentID); pageContext.setAttribute("awardGroups", awardGroups); } catch (final SQLException sqle) { LOGGER.error(sqle, sqle); throw new RuntimeException("Error talking to the database", sqle); } finally { SQLFunctions.close(connection); } }