Hello,
I am having difficulties to fix this query. When it runs to JSP page, On browser side the following error message is coming! What should I do about it? Can anyone help me how to resolve this issue. Thanks in advance.
--------------------
ERROR PAGE
An error has occurred.

Look for this java.sql.SQLException: This Connection has either timed out or been closed, and it has returned to its pool. You must re-acquire the Connection.

select_roster = "SELECT wg_students.last_name ||', '|| wg_students.first_name AS fname, " +
"wg_section.dept_cd AS dept_cd, " +
"wg_section.crs_cd AS crs_cd, " +
"wg_section.crs_num AS crs_num, " +
"wg_section.sec_num AS sec_num, " +
"wg_section.crse_descr AS crse_descr, " +
"null AS term, " +
"wg_roster.grade AS grade, " +
"wg_roster.modify_flag AS modify_flag, " +
"wg_roster.student_id AS student_id, " +
"wg_roster.crs_cd AS crs_cd, " +
"CASE WHEN wg_students.probation_code='' THEN 'NO' ELSE 'YES' END AS probation, " +
"comment, wg_students.g_username AS guser " +
"FROM wg_roster," +
"wg_students," +
"wg_section " +
"WHERE wg_roster.student_id = wg_students.student_id and " +
" wg_roster.crs_cd = wg_section.crs_cd and " +
" wg_roster.crs_cd = '" + crs_code + "' AND " +
" wg_section.password = \'" + user_password + "\' " +
"ORDER BY wg_students.last_name ASC, " +
"wg_students.first_name ASC";