Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4748

StringIndexOutOfBoundsException on syntax error (invalid COMMIT)

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Normal
    • Regression

    Description

      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)
      ....

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            kristwaa Kristian Waagan
            sdfelts Stephen Felts
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment