insert and preparedStatement

[miguel lisboa]

i'm using this code:

public void cria(Object o) throws EntidadeException {

Epoca epoca = (Epoca)o;

int anoCivil = epoca.getAnoCivil();

try {

PreparedStatement prepare = null;

String sql = "insert into epoca (anoCivil) values (?)";

prepare = acesso.prepare(sql);

prepare.setInt(1, epoca.getAnoCivil());

prepare.executeQuery();

}    

but i get an error:

java.sql.SQLException: Can not issue data manipulation statements with executeQuery().

is it not possible to use my insert sql with '?' and preparedstatements?

TiA

[Paul Clapham]

Of course it is possible. But (as the error message says) you cannot use the executeQuery() method to do that. You should use the executeUpdate() method instead.

[miguel lisboa]

executeUpdate() is the one ;)
thanks, Paul