• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

can't get delete to work

 
heath carlough
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
The information provided by u is insufficient
for anyone to help you.You need to post the code
 
Tina Coleman
Ranch Hand
Posts: 150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does the user account you're using within your program have delete rights?
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic