Return-Path: 
 <derby-dev-return-80303-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 83052 invoked from network); 30 Jul 2010 08:58:44 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 30 Jul 2010 08:58:44 -0000
Received: (qmail 89573 invoked by uid 500); 30 Jul 2010 08:58:44 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 89176 invoked by uid 500); 30 Jul 2010 08:58:42 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 89165 invoked by uid 99); 30 Jul 2010 08:58:41 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Jul 2010 08:58:41 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Jul 2010 08:58:38 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o6U8wFZF024932
	for <derby-dev@db.apache.org>; Fri, 30 Jul 2010 08:58:16 GMT
Message-ID: <17316986.84531280480295924.JavaMail.jira@thor>
Date: Fri, 30 Jul 2010 04:58:15 -0400 (EDT)
From: "Kristian Waagan (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Resolved: (DERBY-4748) StringIndexOutOfBoundsException on
 syntax error (invalid COMMIT)
In-Reply-To: <32976732.465361279581230715.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/DERBY-4748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristian Waagan resolved DERBY-4748.
------------------------------------

    Issue & fix info:   (was: [Patch Available])
       Fix Version/s: 10.7.0.0
          Resolution: Fixed

Committed patch 1b to trunk with revision 980684.
Will backport before closing.

> StringIndexOutOfBoundsException on syntax error (invalid COMMIT)
> ----------------------------------------------------------------
>
>                 Key: DERBY-4748
>                 URL: https://issues.apache.org/jira/browse/DERBY-4748
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client, SQL
>    Affects Versions: 10.4.2.1, 10.5.3.1, 10.6.1.0, 10.7.0.0
>         Environment: Windows XP
>            Reporter: Stephen Felts
>            Assignee: Kristian Waagan
>             Fix For: 10.7.0.0
>
>         Attachments: derby-4748-1a-sioobe.diff, derby-4748-1b-sioobe.diff
>
>
> Start the network server on port 1527 on localhost.
> Run ant on the following:
> <project default="all"> 
>   <property environment="env" /> 
>   <path id="derby.classpath.id"> 
>     <fileset dir="${env.DERBY_LIB"> 
>       <include name="derbynet.jar" /> 
>       <include name="derbyclient.jar" /> 
>     </fileset> 
>   </path> 
>   <target name="all"> 
>     <sql driver="org.apache.derby.jdbc.ClientDriver" 
>          
> url="jdbc:derby://localhost:1527/derbyDB;create=true;user=derbyuser;passsword=derbypwd" 
>          userid="derbyuser" 
>          password="derbypwd" 
>          classpathref="derby.classpath.id" 
>          onerror="continue">
> create table mytable1 (mycol varchar(255)); 
> commit; 
>     </sql> 
>   </target> 
> </project> 
> On 10.5.3, I get
>       [sql] Executing commands 
>       [sql] Failed to execute:  commit 
>       [sql] java.sql.SQLSyntaxErrorException: Syntax error: Encountered 
> "commit" 
>  at line 1, column 1. 
>       [sql] 1 of 2 SQL statements executed successfully 
> but on 10.6.1, I get
>      [sql] Executing commands 
> BUILD FAILED 
> java.lang.StringIndexOutOfBoundsException: String index out of range: 6 
>         at java.lang.String.charAt(String.java:686) 
>         at org.apache.derby.client.am.Statement.isolateAnyInitialIdentifier(Unknown Source) 
>         at org.apache.derby.client.am.Statement.getStatementToken(Unknown Source) 
>         at org.apache.derby.client.am.Statement.parseSqlAndSetSqlModes(Unknown Source) 
> ....

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.