You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bernd Ruehlicke (JIRA)" <de...@db.apache.org> on 2005/02/23 21:53:48 UTC
[jira] Created: (DERBY-152) ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
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
[jira] Updated: (DERBY-152) Implement COMMIT SQL Statement
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-152:
---------------------------------
Summary: Implement COMMIT SQL Statement (was: ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.)
Changing title to better reflect request.
> Implement COMMIT SQL Statement
> ------------------------------
>
> Key: DERBY-152
> URL: https://issues.apache.org/jira/browse/DERBY-152
> Project: Derby
> Issue Type: Wish
> Components: SQL
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-152) ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-152?page=comments#action_59674 ]
Kathey Marsden commented on DERBY-152:
--------------------------------------
"COMMIT" is not an SQL Statement. It is just ij language to call Connection.commit(). So, I don't think this is a bug.
> 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
[jira] Updated: (DERBY-152) ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-152?page=all ]
Mike Matrigali updated DERBY-152:
---------------------------------
Component: SQL
Description:
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 ?");
};
was:
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 ?");
};
Environment:
> 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: Wish
> Components: SQL
> 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
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-152) ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-152?page=history ]
Daniel John Debrunner updated DERBY-152:
----------------------------------------
type: Wish (was: Bug)
> 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: Wish
> 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
[jira] Commented: (DERBY-152) ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
Posted by "Jack Klebanoff (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Commented: (DERBY-152) ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
Posted by "Bernd Ruehlicke (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-152?page=comments#action_59677 ]
Bernd Ruehlicke commented on DERBY-152:
---------------------------------------
I know.
But unfortunately it works on Oracle, and if we want more people using Derby, migrating some of their smaller Oracle stuff .. we need to be more "flexable".
- OK, I agree - it's not a BUG - lets reclassify it to a "wish"
> 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