Uploaded image for project: 'Railo'
  1. Railo
  2. RAILO-269

Update H2 database driver - statements like CREATE INDEX will fail with old version

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.1
    • Fix Version/s: None
    • Labels:
    • Affects:
      Compatibility/Configuration
    • Patch Instructions:
      Download the latest driver from http://www.h2database.com/, replace h2.jar and restart railo - fixed!
    • Estimated Difficulty:
      Low

      Description

      The driver provided with railo by default seems to be rather old (0.9 (2006-06-16 / Beta)), current version is 1.1

      With the current driver statements like CREATE INDEX IF NOT EXISTS idx_test ON table1 (field1,field2) will fail with the error message:

      Message Syntax error in SQL statement
      CREATE INDEX IF NOT[*] EXISTS IDX_TEST ON TABLE1 (FIELD1,FIELD2);
      ; expected ON [42001-12]
      DatabaseName H2
      DatabaseVersion 0.9 (2006-06-16 / Beta)
      DriverName H2 JDBC Driver
      DriverVersion 0.9 (2006-06-16 / Beta)

      The problem is the [*] added to the statement by the driver, this does not happen with the version 1.1

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                micstriit Michael Offner
                Reporter:
                funkymusic Hansjoerg Posch
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated: