Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-58608

rebuild-hypersonic failure: java.sql.SQLSyntaxErrorException: unexpected token: [ required: )

    Details

    • Branch Version/s:
      6.2.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      3
    • Databases:
      HSQLDB 2

      Description

      I noticed this during the build process when I ran ant all.

      Steps to reproduce:

      1. Run "ant rebuild-hypersonic" from portal-source/sql

      Expected result:
      No errors.

      Actual result:

      rebuild-hypersonic:
         [delete] Deleting: L:\public\master-portal\sql\lportal.properties
         [delete] Deleting: L:\public\master-portal\sql\lportal.script
           [java] JVM args ignored when same JVM is used.
           [java] Loading file:/L:/public/master-portal/portal-impl/classes/system.properties
           [java] 10:59:01,941 INFO  [ENGINE:866] Checkpoint start
           [java] 10:59:01,949 INFO  [ENGINE:866] checkpointClose start
           [java] 10:59:01,951 INFO  [ENGINE:866] checkpointClose synched
           [java] 10:59:01,959 INFO  [ENGINE:866] checkpointClose script done
           [java] 10:59:01,980 INFO  [ENGINE:866] checkpointClose end
           [java] 10:59:01,984 INFO  [ENGINE:866] Checkpoint end - txts: 1
           [java] create index IX_8FCB620E on Address (uuid_[$COLUMN_LENGTH:75$], companyId);
           [java] 10:59:02,304 INFO  [ENGINE:866] Database closed
           [java] java.sql.SQLSyntaxErrorException: unexpected token: [ required: )
           [java]     at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:194)
           [java]     at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
           [java]     at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
           [java]     at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
           [java]     at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
           [java]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
           [java]     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
           [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [java]     at java.lang.reflect.Method.invoke(Method.java:606)
           [java]     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
           [java]     at org.apache.tools.ant.Task.perform(Task.java:348)
           [java]     at org.apache.tools.ant.Target.execute(Target.java:435)
           [java]     at org.apache.tools.ant.Target.performTasks(Target.java:456)
           [java]     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
           [java]     at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
           [java]     at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
           [java]     at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
           [java]     at org.apache.tools.ant.Main.runBuild(Main.java:851)
           [java]     at org.apache.tools.ant.Main.startAnt(Main.java:235)
           [java]     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
           [java]     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
           [java] Caused by: java.sql.SQLSyntaxErrorException: unexpected token: [ required: )
           [java]     at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:376)
           [java]     at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:247)
           [java]     at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3888)
           [java]     at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:641)
           [java]     at com.liferay.portal.tools.DBLoader.loadHypersonic(DBLoader.java:70)
           [java]     at com.liferay.portal.tools.DBLoader._loadHypersonic(DBLoader.java:218)
           [java]     at com.liferay.portal.tools.DBLoader.<init>(DBLoader.java:113)
           [java]     at com.liferay.portal.tools.DBLoader.main(DBLoader.java:92)
           [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
           [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [java]     at java.lang.reflect.Method.invoke(Method.java:606)
           [java]     at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
           [java]     at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
           [java]     ... 20 more
           [java] Caused by: org.hsqldb.HsqlException: unexpected token: [ required: )
           [java]     at org.hsqldb.error.Error.parseError(Error.java:156)
           [java]     at org.hsqldb.ParserBase.unexpectedTokenRequire(ParserBase.java:788)
           [java]     at org.hsqldb.ParserBase.readThis(ParserBase.java:442)
           [java]     at org.hsqldb.ParserDQL.readColumnNames(ParserDQL.java:759)
           [java]     at org.hsqldb.ParserDQL.readColumnNames(ParserDQL.java:749)
           [java]     at org.hsqldb.ParserDQL.readColumnList(ParserDQL.java:704)
           [java]     at org.hsqldb.ParserDDL.compileCreateIndex(ParserDDL.java:1339)
           [java]     at org.hsqldb.ParserDDL.compileCreate(ParserDDL.java:225)
           [java]     at org.hsqldb.ParserCommand.compilePart(ParserCommand.java:236)
           [java]     at org.hsqldb.ParserCommand.compileStatement(ParserCommand.java:64)
           [java]     at org.hsqldb.Session.compileStatement(Session.java:933)
           [java]     at org.hsqldb.StatementManager.compile(StatementManager.java:375)
           [java]     at org.hsqldb.Session.execute(Session.java:1037)
           [java]     at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3885)
           [java]     ... 31 more
           [java] Java Result: -1
      
      BUILD SUCCESSFUL
      Total time: 3 seconds

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              hong.zhao Hong Zhao (Inactive)
              Reporter:
              brian.chiu Brian Chiu (Inactive)
              Participants of an Issue:
              Recent user:
              Tibor Lipusz
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 40 weeks, 2 days ago

                  Packages

                  Version Package
                  6.2.X EE
                  7.0.0 Alpha 1