This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 3702

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.

My Blog: Down Home Country Coding with Scott Selikoff
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
Similar Threads
Accessing One table with multiple Threads and Inserting Values
If Statement&Equals
Difference between execute() and excuteQuery()
pleeez help
Updatable resultsets