Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!204.153.245.137.MISMATCH!pink.octanews.net!news-out.octanews.net!indigo.octanews.net!news.glorb.com!news-out.readnews.com!news-xxxfer.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From: "Zhane" <zhane@THRWHITE.remove-dii-this>
Subject: java.sql.SQLException: Re
Message-ID: <279af25b-bf8b-4920-bd38-be50ad24d563@n33g2000pri.googlegroups.com>
X-Comment-To: comp.lang.java.databases
Newsgroups: comp.lang.java.databases
Content-Type: text/plain; charset=IBM437
Content-Transfer-Encoding: 8bit
X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines: 31
Date: Wed, 27 Apr 2011 15:23:22 GMT
NNTP-Posting-Host: 96.60.20.240
X-Complaints-To: news@tds.net
X-Trace: newsreading01.news.tds.net 1303917802 96.60.20.240 (Wed, 27 Apr 2011 10:23:22 CDT)
NNTP-Posting-Date: Wed, 27 Apr 2011 10:23:22 CDT
Organization: TDS.net
Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:376

  To: comp.lang.java.databases
need some help here


                 findFoodCode.setString(1,input);
                 findFoodCode.setString(2,request.getParameter
("country"));

                 ResultSet rs2 = findFoodCode.executeQuery();
                 ResultSetMetaData metaData = rs2.getMetaData();

                 while(rs2.next()){
                    for(int i=1;i<metaData.getColumnCount()+1;i++)
                    {   out.print(rs2.getString(i)+";");
                    }
                    out.println("|"); // mark the end
                 }


Above is my code. I keep on getting the exception as stated in the
topic when i reach rs2.next(). My sql function when error happens
return nothing... but the error keeps on coming.

is there anyway for me to determine where the resultset is from?
whether it is an update or is it a data? or is there some other way to
go about it?

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24