I was inspired by gmail's april fools day joke and decided to write an email auto-reply program that checks emails then replies to them.
I'm at 75% complete, including most databases working fine, checking email, just have to write the sending.
Last night this JavaDB command worked 100% fine:
LOCK TABLE OUTBOX IN EXCLUSIVE MODE; DELETE FROM MAIL WHERE ID ="+rowNumber;
It worked great. rowNumber is an integer, and it would delete the appropriate record. I used it several times.
Today, I'm working on coding some other portions of the program and polishing it. None of these have anything to do with the class that handles this. I try to walk through the program again, and I'm getting this:
Syntax error: Encountered ";" at line 1, column 36.
from the stack trace.
So I put a JOptionPane.showMessageDialog() with the sql statement in it, to check if there was more than one ; in the statement. Nope, statement works fine. It works if I copy and paste it to the sql command prompt.
It doesnt work, when the program tries to execute it though. am I missing something? If I remove the ; it throws an error for not having it there.