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 update statement seems not working 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 "update statement seems not working" Watch "update statement seems not working" New topic

update statement seems not working

Mohamed Manas

Joined: Jun 02, 2008
Posts: 24
hi,im trying to connect to a access a MS Access database from which the knowledge i gained from Sun Java's tutorials.
Although the select code works it seems that the following update statement doesn't work.
The statement updates the data in the recordset but not in the database itself.

It is better to make mistakes now and on purpose than later and accidentally...
Mohamed Manas

Joined: Jun 02, 2008
Posts: 24
the code:

String database="jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";
String filename="COFFEEBREAK.mdb";
String url=database+filename;

Connection conn=DriverManager.getConnection(url);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet rs=stmt.executeQuery("SELECT COF_NAME FROM COFFEES WHERE PRICE=7.99");;
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

I would avoid using updateString/updateRow at all, not all databases support it. Instead, I'd recommend you write an update statement and execute it as a separate query.

[OCA 8 Book] [Blog]
Mohamed Manas

Joined: Jun 02, 2008
Posts: 24
Thank you for your review.
Anyway I found out that I hadn't included the close() method for the connection after updating the resultset.
Since I am a newbie I will make sure I will not make this kind of silly mistakes anymore.
I agree. Here's the link:
subject: update statement seems not working
jQuery in Action, 3rd edition