Re: java.sql.SQLException

From:

"Zhane" <zhane@THRWHITE.remove-dii-this>

Newsgroups:

comp.lang.java.databases

Date:

Wed, 27 Apr 2011 15:23:26 GMT

Message-ID:

<0d3339ec-c06f-424f-93f0-446d8d946cb6@a12g2000pro.googlegroups.com>

  To: comp.lang.java.databases
sorry...

this is the full error msg
-----------------------------------------------------------------------------------------
java.sql.SQLException: ResultSet is from UPDATE. No Data.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
1056)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
957)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
927)
        at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7014)
        at servlet.doPost(servlet.java:262)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:
738)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:
831)
        at
org.apache.catalina.core.ApplicationFilterChain.servletService
(ApplicationFilterChain.java:411)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:317)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:198)
        at
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter
(MonitorFilter.java:390)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:230)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:198)
        at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:288)
        at org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:271)
        at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:202)
        at org.apache.catalina.core.StandardPipeline.doInvoke
(StandardPipeline.java:632)
        at org.apache.catalina.core.StandardPipeline.doInvoke
(StandardPipeline.java:577)
        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:
94)
        at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:206)
        at org.apache.catalina.core.StandardPipeline.doInvoke
(StandardPipeline.java:632)
        at org.apache.catalina.core.StandardPipeline.doInvoke
(StandardPipeline.java:577)
        at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:571)
        at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:1080)
        at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:150)
        at org.apache.catalina.core.StandardPipeline.doInvoke
(StandardPipeline.java:632)
        at org.apache.catalina.core.StandardPipeline.doInvoke
(StandardPipeline.java:577)
        at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:571)
        at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:1080)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service
(CoyoteAdapter.java:272)
        at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter
(DefaultProcessorTask.java:637)
        at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess
(DefaultProcessorTask.java:568)
        at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process
(DefaultProcessorTask.java:813)
        at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask
(DefaultReadTask.java:341)
        at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask
(DefaultReadTask.java:263)
        at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask
(DefaultReadTask.java:214)
        at com.sun.enterprise.web.connector.grizzly.TaskBase.run
(TaskBase.java:265)
        at
com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run
(SSLWorkerThread.java:106)

-----------------------------------------------------------------------------------------
Error Happens when doing this :
where findFoodCode = connection.prepareStatement("CALL
getFoodCode(?,?)");
-----------------------------------------------------------------------------------------

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

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

    // if(metaData.getColumnCount()!=0){
                     while(rs2.next()){
                        for(int i=1;i<metaData.getColumnCount()+1;i++)
                        { out.print(rs2.getString(i)+";");
                        }

                     }
   // }

-----------------------------------------------------------------------------------------
GetFoodCode
-----------------------------------------------------------------------------------------
DROP PROCEDURE IF EXISTS getFoodCode;
delimiter $$
CREATE PROCEDURE getFoodCode (IN ifoodcode varchar(20),IN icountry
varchar(20))
BEGIN
    DECLARE returnvar INT;

    SET returnvar = (SELECT foodID FROM foodTable
        WHERE foodCode = ifoodcode);
    IF returnvar IS NOT NULL THEN

select
foodcode,foodname,fooddescription,foodrating,locationCountry,locationCurrency,ROUND
(AVG(locationPrice),2),manufacturerName,lastUpdated from
manufacturerTable,foodtable,locationsTable,food_locationTable where
foodtable.foodID = returnvar and food_locationTable.foodID=returnvar
and locationsTable.locationID=food_locationTable.locationID and
locationsTable.locationCountry = icountry and
manufacturerTable.manufacturerID =
                (select manufacturerID from foodTable where
foodtable.foodID = returnvar);

    END IF;

END $$
delimiter ;

---
* 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