File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Retrieve return message Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Retrieve return message" Watch "Retrieve return message" New topic

Retrieve return message

Jane Somerfield
Ranch Hand

Joined: Jul 20, 2002
Posts: 193
I'm doing following simple SQL using JDBC. I need to retrieve the
return message "2 rows deleted". Could anyone tell me which
JDBC API I can use? Thanks.

SQL> delete from family_member where first_name='ann';

2 rows deleted.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33098

If you call it using executeUpdate(), the method returns an integer (in your case 2.) Your code knows that it is performing a delete and can form an appropriate message.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Retrieve return message
It's not a secret anymore!