NumberFormatException: multiple points

[sde]

i've been working on this for the past 2 hours and can't seem to figure out where this exception is coming from. it is very intermitant.

i am calling the same method with the same customerID and it only throws an exception sometimes.

getProducts() java.lang.NumberFormatException: multiple points

  private static SimpleDateFormat formatDateOut = new SimpleDateFormat("yyyy-MM-dd");

...
public static ArrayList getProducts(String customerID){
    
    ArrayList al = new ArrayList();
    String sql = "SELECT SVPRID,SVMODN,SVSERL,SVPCHD,SVPSTR,SVPCTY,SVPSTA FROM MRKCPRD WHERE SVCUSN='" + customerID + "' AND SVSTAT='1'";

    try{
      
      Connection con = Pool.getConnection();
      
      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery(sql);
      
      while(rs.next()){
        
        Product prd = new Product();
        prd.setProductID(rs.getInt("SVPRID"));
        prd.setModelID(rs.getString("SVMODN"));
        prd.setSerial(rs.getString("SVSERL"));
        prd.setDatePurchased((Date)formatDateOut.parse(rs.getString("SVPCHD")));
        prd.setStorePurchased(rs.getString("SVPSTR"));
        prd.setCityPurchased(rs.getString("SVPCTY"));
        prd.setStatePurchased(rs.getString("SVPSTA"));
        
        al.add(prd);
      }
      
      con.close();
      
    }catch(Exception e){
      System.out.println("getProducts() " + e.toString());
    }
    
    return al; 
  }

is there anything obviously wrong that might be throwing this exception?

[Belisarius]

It's probably either

prd.setProductID(rs.getInt("SVPRID"));

or

prd.setDatePurchased((Date)formatDateOut.parse(rs.getString("SVPCHD")));

and I'm leaning towards the former. You probably have some bogus data in your DB, or the number is too big for an int.

What you could do is put println() after every set method to track down exactly what line it's occuring on.

[sde]

it happens in setting the products, but i have hard coded good data in there and it does the same thing.

prd.setProductID(1);
prd.setModelID("");        prd.setSerial("");
prd.setDatePurchased((Date)formatDateOut.parse("2004-01-01"));    prd.setStorePurchased("");
prd.setCityPurchased("");
prd.setStatePurchased("");

i'm thinking it is the formatDateOut, but i can't figure out why it throws an exception intermitantly even hard coded. =/ i use that same format Date method in other places in this project and it works just fine. if i comment out all those lines where i am setting the product, it is consistant and does not throw exceptions.

i'll be spending more time tomorrow on this little section of code. i'll post when i figure it out.

[sde]

well after setting up a main class calling that method, it did not generate errors .. so i just re-wrote the jsp that was calling that method and now it works fine.

seems like for some reason it was executing that code twice everytime.