File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes can't get delete to work Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "can Watch "can New topic
Author

can't get delete to work

heath carlough
Ranch Hand

Joined: Feb 01, 2003
Posts: 34
Dunno why everything else is running smoothly(insert/update/select)
but when I try to delete a row, it seems to fail but no exceptions are thrown.
ANy reason why this could be happening?? any thoughts at all??
I can delete at the sqlplus prompt but not thru jdbc
Amol Desai
Ranch Hand

Joined: Jan 29, 2003
Posts: 82
Hi,
The information provided by u is insufficient
for anyone to help you.You need to post the code
Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
Does the user account you're using within your program have delete rights?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

are you by chance using MSAccess? If you are, there is a known bug while inserting/deleting. Just do a trivial select to the table after you insert/delete a row and it should magically appear ( kind of like a kickstart! ).
If you are not using MSAccess, you should post the code snippet giving you the problems.
Make sure you are committing the delete as well.
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: can't get delete to work
 
Similar Threads
Removin java version 1.3.1 off my linux
How could it be possible?
deleting directory
storing/retrieving image to/from database problems
Not able to delete the posts