Description:
For a very complicated query the windows JDBC driver returns a value of 0 for getFetchSize(). However while (rs.next()) { ... } processes the correct number of rows returned.
I am only seeing this error for one query, but I can reproduce it.
The error does not occur in Linux
The error also occurs in connect 3.1.6
How to repeat:
SELECT class_assignment_id, grade.student_id student_id, student.student_code student_code, honorific.name honorific, person.first_name first_name, person.last_name last_name, curriculum.curriculum_id curriculum_id, grade_source.description description, year_code, semester.semester_id semester_id, section_number, class_unit.class_unit_id class_unit_id, semester.name semester_tname, semester.name_eng semester_ename, semester.AENm semester_AENm, semester.ATNm semester_ATNm, subject.subject_code subject_code, subject.name subject_tname, subject.name_eng subject_ename, subject.LectCrds subject_LectCrds, subject.NLectCrds subject_NLectCrds, subject.LectCost subject_LectCost, subject.NLectCost subject_NLectCost, subject.computerLabCredit computerLabCredit, subject.computerLabCost computerLabCost, major.FTName major_FTName, major.FEName major_FEName, faculty.FTName faculty_FTName, faculty.FEName faculty_FEName FROM student INNER JOIN person ON (student.person_id = person.person_id) INNER JOIN honorific ON (person.honorific_id = honorific.honorific_id) INNER JOIN curriculum ON (student.curriculum_id = curriculum.curriculum_id) INNER JOIN major ON (curriculum.major_id = major.major_id) INNER JOIN faculty ON (curriculum.faculty_id = faculty.faculty_id) INNER JOIN grade ON (student.student_id = grade.student_id) INNER JOIN subject ON (grade.subject_code = subject.subject_code) INNER JOIN class_unit ON (grade.class_unit_id = class_unit.class_unit_id) INNER JOIN semester ON (class_unit.semester_id = semester.semester_id) INNER JOIN grade_source ON (grade.grade_source_id = grade_source.grade_source_id) WHERE ( ( ( grade.student_id = 4770983 ) AND ( year_code = 2004 ) AND ( semester.semester_id = 101 ) ) ) ORDER BY class_assignment_id
Description: For a very complicated query the windows JDBC driver returns a value of 0 for getFetchSize(). However while (rs.next()) { ... } processes the correct number of rows returned. I am only seeing this error for one query, but I can reproduce it. The error does not occur in Linux The error also occurs in connect 3.1.6 How to repeat: SELECT class_assignment_id, grade.student_id student_id, student.student_code student_code, honorific.name honorific, person.first_name first_name, person.last_name last_name, curriculum.curriculum_id curriculum_id, grade_source.description description, year_code, semester.semester_id semester_id, section_number, class_unit.class_unit_id class_unit_id, semester.name semester_tname, semester.name_eng semester_ename, semester.AENm semester_AENm, semester.ATNm semester_ATNm, subject.subject_code subject_code, subject.name subject_tname, subject.name_eng subject_ename, subject.LectCrds subject_LectCrds, subject.NLectCrds subject_NLectCrds, subject.LectCost subject_LectCost, subject.NLectCost subject_NLectCost, subject.computerLabCredit computerLabCredit, subject.computerLabCost computerLabCost, major.FTName major_FTName, major.FEName major_FEName, faculty.FTName faculty_FTName, faculty.FEName faculty_FEName FROM student INNER JOIN person ON (student.person_id = person.person_id) INNER JOIN honorific ON (person.honorific_id = honorific.honorific_id) INNER JOIN curriculum ON (student.curriculum_id = curriculum.curriculum_id) INNER JOIN major ON (curriculum.major_id = major.major_id) INNER JOIN faculty ON (curriculum.faculty_id = faculty.faculty_id) INNER JOIN grade ON (student.student_id = grade.student_id) INNER JOIN subject ON (grade.subject_code = subject.subject_code) INNER JOIN class_unit ON (grade.class_unit_id = class_unit.class_unit_id) INNER JOIN semester ON (class_unit.semester_id = semester.semester_id) INNER JOIN grade_source ON (grade.grade_source_id = grade_source.grade_source_id) WHERE ( ( ( grade.student_id = 4770983 ) AND ( year_code = 2004 ) AND ( semester.semester_id = 101 ) ) ) ORDER BY class_assignment_id