It's probably either
Code:
prd.setProductID(rs.getInt("SVPRID")); or
Code:
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.