preparestatment

[anvi kon]

Hi,

I am doing like below.

preparedStatement = conn.prepareStatement(sql);
del =preparedStatement.executeUpdate("DELETE FROM EMPLOYEE");

System.out.println("delcnt" +del);

It is not working. I am not getting the del cnt. It is throwing an exception.


Can anyone tell me what is wrong in the above code?

Thanks

[Jan Cumps]

anvi kon wrote:Hi,... It is throwing an exception...

What does that exception say?

[anvi kon]

Hi,

Exception says: you cannot rollback with autocommit set.


My question , Is the below code returns the int or not?

del =preparedStatement.executeUpdate("DELETE FROM EMPLOYEE");   

Thanks

[Jeanne Boyarsky]

It returns the int on success.

[YogeshS Pandit]

Yes, it returns int for INSERT,UPDATE,DELETE statements and 0 for DDL statements. Check out this link..

[lokesh pattajoshi]

Once Check you have delete permission or not..

[Nicola Garofalo]

There's something confused in your instruction.

You get the PreparedStatement from the connection with the method

conn.prepareStatement(sql);

and you pass to this method the sql query String

Then you invoke the super interface (Statement) version of executeUpdate with another sql query.

If the query is

DELETE FROM EMPLOYEE

then don't even use a PreparedStatement, but just a Statement

Statement stmt = conn.createStatement();
int result = stmt.executeUpdate("DELETE FROM EMPLOYEE");

[Jeanne Boyarsky]

Nicola Garofalo wrote:There's something confused in your instruction.

You get the PreparedStatement from the connection with the method

conn.prepareStatement(sql);

and you pass to this method the sql query String

Then you invoke the super interface (Statement) version of executeUpdate with another sql query

Good catch!