Uploaded image for project: 'Apache Roller'
  1. Apache Roller
  2. ROL-1855

Automatic table creation fails on HSQLDB

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.0
    • Fix Version/s: 5.0
    • Labels:
      None
    • Environment:
      Ubuntu 8.04 LTS, Sun JDK 1.6, Tomcat 6.0.20, HSQLDB 2.0 RC8
    • Browser Version:
      Chrome 3.0
    • Database:
      HSQLDB 2.0 RC8
    • JDK Version:
      1.6
    • Level of effort:
      0.25
    • O/S Version:
      Ubuntu 8.04 LTS

      Description

      When Tomcat and Roller is set up with HSQLDB, I get a complaint when Roller tries to create its tables.
      The exact message is "Unexpected token 'DEFAULT'" and comes up during the execution of the create table script for the table "webpage".

      The bug is caused by a mistake in the keyword order and can be fixed by replacing:
      action varchar(16) not null default 'custom'
      with:
      action varchar(16) default 'custom' not null

      After this change all tables are created just fine.

        Attachments

          Activity

            People

            • Assignee:
              djohnson David Johnson
              Reporter:
              juergenk Juergen Kellerer
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1h
                1h
                Remaining:
                Remaining Estimate - 1h
                1h
                Logged:
                Time Spent - Not Specified
                Not Specified