Prepared Statement & Microsoft ACCESS JDBC:ODBC
Hello everybody,
I'm trying to figure out why Java returns me this error ion various situation:
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]COUNT field incorrect.
As you can see I'm trying to use a Prepared stetement with jdbc:odbc(is possible, isn't it?)
The problem is that in every way I try to use the prepared Statement it returns me this error.
If i fill up fields with a big SQL query everything it's ok.
askSQL =conn.prepareStatement("INSERT INTO pippo(Campo1,Campo2,Campo3) VALUES (?,?,?) ");
Iterator Idati_articolo = lista_articoli.iterator();
if (Idati_articolo.hasNext()){
while (Idati_articolo.hasNext()){
ArticoloBean myBean2 = (ArticoloBean)Idati_articolo.next();
askSQL.setString (1,"pippoa");
askSQL.setString(2,"plutoa");
askSQL.setString(3,"giannia");
}
}
askSQL.executeUpdate();
