ClassCastException

[Jennifer Sohl]

Aaaaagh! I don't know if it's just because it's 5:00 on a Friday, or if I really have a problem, but I just can't seem to figure this out. I keep getting the ClassCastException: sun.jdbc.odbc.JdbcOdbcPreparedStatement cannot be cast to MVProductList whenever the following line of code runs:

ArrayList assyList = getProductList();
int indexOfAssy = ((MVProductList)assyList.get(0)).getProdIndex();    

Here's the code for the method that gets called to return the ArrayList as well as the class I created that I'm trying to cast the object to:

private ArrayList getProductList() {
AccessDBConnection.connectToDatabase(getSelectedFile().getPath() + "/OverdrivePro.mdb");
ArrayList prodList = new ArrayList();
try {
PreparedStatement pl = AccessDBConnection.getCon().prepareStatement("Select ProductsIndex,ItemNumber,Description,Qty from Products");
ResultSet rs = pl.executeQuery();
while(rs.next()) {
String matl = rs.getString(3).trim();
if(matl.equals(assyNo)) {
MVProductList plist = new MVProductList();
plist.setProdIndex(rs.getInt(1));
plist.setItemNumber(rs.getDouble(2));
plist.setProdDesc(matl);
plist.setProdQty(rs.getInt(4));
prodList.add(pl);
}
}
if(rs != null) rs.close();
if(pl != null) pl.close();
AccessDBConnection.closeConnection();
}
catch(SQLException sqle){
GUIUtil.showError(sqle,sqle.toString(),"MicrovellumImport getProductList()",MicrovellumImport.this);
dialogCancelled = true;
}
return prodList;
}    
 
public class MVProductList {
private String prodDesc;
private int prodQty;
private int prodIndex;
private double itemNumber;

double getItemNumber() {
return itemNumber;
}
void setItemNumber(double itemNumber) {
this.itemNumber = itemNumber;
}
void setProdIndex(int prodIndex) {
this.prodIndex = prodIndex;
}

int getProdIndex() {
return prodIndex;
}

void setProdDesc(String prodDesc) {
this.prodDesc = prodDesc;
}
String getProdDesc() {
return prodDesc;
}

void setProdQty(int prodQty) {
this.prodQty = prodQty;
}
int getProdQty() {
return prodQty;
}
}

What in the heck have I done wrong? Thanks for any help anyone can give me!
Let me know if any further information is needed.


[ February 22, 2008: Message edited by: Jennifer Sohl ]

[ February 22, 2008: Message edited by: Jennifer Sohl ]

[ February 22, 2008: Message edited by: Jennifer Sohl ]
[ February 22, 2008: Message edited by: Jennifer Sohl ]

[Roger Chung-Wee]

Your ArrayList contains a bunch of PreparedStatement objects, this is why the cast to MVProductList fails. You should be doing this instead.

prodList.add(plist);

[Jennifer Sohl]

Oooooo boy..... I'm so sorry! I see what I did wrong now! I'm using the excuse that it was 5:00 on a Friday and I wasn't in my right mind!
Thanks for straightening me out!