Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

java.sql.SQLException: Re

Show all headers | 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