aspose file tools*
The moose likes JDBC and the fly likes No errors but no update on table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "No errors but no update on table" Watch "No errors but no update on table" New topic

No errors but no update on table

Rob Lynn

Joined: Jun 27, 2005
Posts: 28
I have the following code:

When I step through the code it seems to be fine - no exceptions thrown, etc. However, the change does not appear in the database. I have the correct database name in server.xml. Why would this be failing? BTW, I am trying this because when I tried Spring's jdbc, the table would be corrupted each time, and I had to delete the table and start over.
[ August 18, 2005: Message edited by: Bear Bibeault ]
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 31073

Can you insert a println or check in the debugger that the commit is getting executed?

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Roger Chung-Wee
Ranch Hand

Joined: Sep 29, 2002
Posts: 1683
Are you certain that the row to be updated exists in the DB?

Also, I'd prefer to do this, it's much more obvious what you are trying to do:

SCJP 1.4, SCWCD 1.3, SCBCD 1.3
I agree. Here's the link:
subject: No errors but no update on table