Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "No ResultSet set was produced" error when using JDBC

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US