I'm writing an application in Java, that connects to Derby via JDBC, this statement:
LOCK TABLE MAIL IN EXCLUSIVE MODE; DELETE FROM MAIL WHERE ID = 18
is not working for me when I try to execute it via my program, it returns "java.sql.SQLSyntaxErrorException: Syntax error: Encountered ";" at line 1, column 34.". When I run this from the command line, it works fine.
Can someone just give me a sanity check on the syntax?