db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stephen Felts (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4748) StringIndexOutOfBoundsException on syntax error (invalid COMMIT)
Date Mon, 19 Jul 2010 23:13:50 GMT
StringIndexOutOfBoundsException on syntax error (invalid COMMIT)
----------------------------------------------------------------

                 Key: DERBY-4748
                 URL: https://issues.apache.org/jira/browse/DERBY-4748
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.6.1.0
         Environment: Windows XP
            Reporter: Stephen Felts


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.


Mime
View raw message