[jira] Commented: (DERBY-152) ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.

     [ 
http://issues.apache.org/jira/browse/DERBY-152?page=comments#action_59681 ]
     
Jack Klebanoff commented on DERBY-152:
--------------------------------------

I think that "commit" is an SQL statement. I found "<commit statement> ::= 
COMMIT [ WORK ] [ AND [ NO ] CHAIN ]" in the SQL 2003 spec. 

> ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
> --------------------------------------------------------------------
>
>          Key: DERBY-152
>          URL: http://issues.apache.org/jira/browse/DERBY-152
>      Project: Derby
>         Type: Bug
>     Reporter: Bernd Ruehlicke
>     Priority: Minor

>
> The following totally valid (but of course a little insane - since you could 
> use _connection.commit() ) throws the ERROR 42X01 - which it should not do.
>           Statement s = _connection.createStatement();
>           try
>           {
>               s.execute("commit");
>           }
>           catch(Exception e)
>           {
>               e.printStackTrace();
>               System.out.println("WOW - what happened here  ?");       
>           };

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira