ResultSet Exhausted Error

[sovan chatt]

I have the following java class which is called from a servlet ...Whenever I try to retrieve the data using getString()method I get a resultset exhausted message...But when I replaced

  p.setSring(s1);
  

with

 p.setString("700x900")   

it worked...I am totally confused...I am giving both the sevlet code and java class code here....

 //UploadServlet.java
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.regex.*;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.*;

import javax.servlet.*;
import javax.servlet.http.*;

public class UploadServlet extends HttpServlet{
	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PrintWriter out = response.getWriter();
                int nof=0;
                String s="";int cost=0;
		boolean isMultipart = ServletFileUpload.isMultipartContent(request);
		//System.out.println("request: "+request);
		if (!isMultipart) {
			System.out.println("File Not Uploaded");
		} else {
			FileItemFactory factory = new DiskFileItemFactory();
			ServletFileUpload upload = new ServletFileUpload(factory);
			List items = null;

			try {
				items = upload.parseRequest(request);
			} catch (FileUploadException e) {
				e.printStackTrace();
			}
			Iterator itr = items.iterator();
			while (itr.hasNext()) {
				FileItem item = (FileItem) itr.next();
				if (item.isFormField()){
					String name = item.getFieldName();
					
					String value = item.getString();
			
                                         if(name.equals("nof"))
	                             {
                                    
			                   nof=(Integer.parseInt(value));
                                 
                                    }
                                         if(name.equals("size")){
                        
                                            s=value;
                    
                                        }
                                       if((!s.equals(""))&&(nof!=0)){
                                        Price p=new Price(nof,s);
                                         cost=p.getPrice();

                        }

                                }
				 else {
					try {
						String itemName = item.getName();
						Random generator = new Random();
						int r = Math.abs(generator.nextInt());
      						String reg = "[.*]";
						String replacingtext = "
						Pattern pattern = Pattern.compile(reg);
						Matcher matcher = pattern.matcher(itemName);
						StringBuffer buffer = new StringBuffer();

						while (matcher.find()) {
							matcher.appendReplacement(buffer, replacingtext);
						}
						int IndexOf = itemName.indexOf(".");
						String domainName = itemName.substring(IndexOf);
					

						String finalimage ="images_"+r+domainName;
						System.out.println("Final Image==="+finalimage);
                                                String loc=new String("C:/uploadedfiles/"+finalimage);
                                  

						File savedFile = new File("C:/uploadedfiles/"+"images"+"_"+r+domainName);
						item.write(savedFile);
						

					} catch (Exception e) {
						e.printStackTrace();
					}
				}
			}
		}
	}
}
   

//Price.java
import java.sql.*;
public class Price {
  public int nof1; public String s1;
public Price(int nof,String s)
    {
        nof1=nof;
        s1=s;

        System.out.println("FILES="+nof1+"SIZE"+s1);
    }
public int getPrice()

    {
    int x=0;
    try{
    Connection con=DbCon.setCon();

    PreparedStatement p=con.prepareStatement("SELECT COST FROM PRICE WHERE PSIZE=?");
	        System.out.println("size="+s1);
                p.setString(1,s1);
	        ResultSet r=p.executeQuery();
	       while( r.next()){
	       String s=r.getString(1);
	        x=Integer.parseInt(s);
	       }
                con.close();

    return x;
    }
catch(Exception o)
            {
    System.out.println("EXCEPTION"+o);
    return 0;
            }
    }
}

    

[Bear Bibeault]

Moved to the JDBC forum.

[Sandeep Sanaboyina]

If you are saying the issue is solved, just by replacing s1 with "700x900", the issue can't be with your code.
It could either be a data issue or that s1 does not have the correct value during execution. Better check your data.

Since you are already printing s1 before execution, I can only guess that there may be an extra space in the end.

[Sandeep Sanaboyina]

Also, is the below code supposed to be inside the while loop

if((!s.equals(""))&&(nof!=0)){
Price p=new Price(nof,s);
cost=p.getPrice();

If it is in the while loop, I don't think the s1 will have proper values everytime.

[sovan chatt]

Also, is the below code supposed to be inside the while loop

     1. if((!s.equals(""))&&(nof!=0)){  
   2. Price p=new Price(nof,s);  
   3. cost=p.getPrice();   

If it is in the while loop, I don't think the s1 will have proper values everytime.

@Sandeep Sanaboyina Why do you think if s is inside while loop s1 wont get proper values...?And there is no extra space in values of s1...please reply..