public static Question getQuestionRowWithQuestionNo(String questionNo)
            throws SQLException {
        Connection conn = ConnectionManager.getInstance().getConnection();
        
        String sql = "{call selectQuestionRowWithQuestionNo(?)}";
        ResultSet rs = null;

        try (PreparedStatement stmt = conn.prepareStatement(sql);) {
            stmt.setString(1, questionNo);
            rs = stmt.executeQuery();
            if (rs.next()) {
                Question questionEntity = new Question();
                questionEntity.setQuestionNo(rs.getString("questionNo"));
                questionEntity.setQuestionType(rs.getString("questionType"));
                questionEntity.setQuestion(rs.getString("question"));
                questionEntity.setPoints(rs.getInt("points"));

                return questionEntity;
            }

            return null;

        } catch (SQLTransientConnectionException SQLtce) {
            return getQuestionRowWithQuestionNo(questionNo);
        } catch (SQLTransientException SQLte) {
            return getQuestionRowWithQuestionNo(questionNo);
        } catch (SQLException e) {
            System.err.println(e);
            return null;
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                conn.close();
            } catch (SQLException e) {
                System.err.println(e);
            }
        }
    }