Groups > comp.lang.java.databases > #376

java.sql.SQLException: Re

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> (permalink)
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

Show key headers only | View raw

  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

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

java.sql.SQLException: Re "Zhane" <zhane@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000

csiph-web