Re: "No ResultSet set was produced" error when using JDBC

From: <htran_at_collegeboard.org>
Date: 6 Apr 2005 08:45:58 -0700
Message-ID: <1112802358.952311.50570@f14g2000cwb.googlegroups.com>

Hans,
Thanks for responding so quickly.

Server: Oracle9i Enterprise Edition Release 9.2.0.3.0 jdbc:oracle:thin

This SQL below calculates,grouping by US states, the number of students sending applications (Volume abbrev as V ) for 4 colleges, the number of students sending apps (Overlap abbreviated as OVL ) to School 1 and School2, School 1 and 3, School 1 and 4. WITH

     T1 AS ( SELECT STATE, D.STUDENT_ID
               FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR
              WHERE D.DI_CD  = '2361'
                AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID
                AND ACADEMIC_YEAR = 2003


		   )

   , T2 AS ( SELECT STATE,  D.STUDENT_ID
               FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR
              WHERE D.DI_CD  = '2365'
                AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID
                AND ACADEMIC_YEAR = 2003


		   )

   , T3 AS ( SELECT STATE,  D.STUDENT_ID
               FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR
              WHERE D.DI_CD  = '2050'
                AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID
                AND ACADEMIC_YEAR = 2003


		   )

   , T4 AS ( SELECT STATE,  D.STUDENT_ID
               FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR
              WHERE D.DI_CD  = '2959'
                AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID
                AND ACADEMIC_YEAR = 2003


		   )

SELECT STATE_ABBREV
	   , V1, V2, OVL1, v3, OVL2, v4, OVL3
  FROM
        ( SELECT STATE, COUNT(*) OVL1
            FROM ( SELECT * FROM T1 INTERSECT SELECT * FROM T2 )
           GROUP BY STATE ) I1
     ,  ( SELECT STATE, COUNT(*) OVL2
            FROM ( SELECT * FROM T1 INTERSECT SELECT * FROM T3 )
           GROUP BY STATE ) I2
     ,  ( SELECT STATE, COUNT(*) OVL3
            FROM ( SELECT * FROM T1 INTERSECT SELECT * FROM T4 )
           GROUP BY STATE ) I3
	,  ( SELECT STATE, COUNT(*) V1 FROM T1 GROUP BY STATE ) V1
	,  ( SELECT STATE, COUNT(*) V2 FROM T2 GROUP BY STATE ) V2
	,  ( SELECT STATE, COUNT(*) V3 FROM T3 GROUP BY STATE ) V3
	,  ( SELECT STATE, COUNT(*) V4 FROM T4 GROUP BY STATE ) V4
	, STATE
 WHERE I1.STATE = I2.STATE (+)
   AND I1.STATE = I3.STATE (+)
   AND I1.STATE = V1.STATE (+)
   AND I1.STATE = V2.STATE (+)

   AND I1.STATE = V3.STATE (+)
   AND I1.STATE = V4.STATE (+)
   AND STATE.STATE_ABBREV = I1.STATE(+)
   AND area_id = 1
ORDER BY 1 Received on Wed Apr 06 2005 - 10:45:58 CDT