Updating data using execute method in jdbc

Question

What are the repercussions of using executeQuery rather than executeUpdate to update data in the database.

Thanks

user517491 · Accepted Answer · 2012-07-20 10:56:31Z

0

executeQuery() returns a ResultSet, from which you have to retrieve the int result yourself. Moreover you have to close and release the resultset yourself.

answered Jul 20, 2012 at 10:56

user517491

Sign up to request clarification or add additional context in comments.

3 Comments

Vivek Over a year ago

Which means that an extra effort would be required to get the updated rows. Also would there be a performance issue angle also involved ?

user517491 Over a year ago

@Vivek No there is no performance difference between executeQuery() and executeUpdate(). Both call underlying execute() function.

Mark Rotteveel Over a year ago

@djaqeel That is an implementation detail of a specific driver, you cannot guarantee that a driver executes them both in the same way.

Collectives™ on Stack Overflow

Updating data using execute method in jdbc

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related