Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-18029

REST schema doesn't work on ORACLE

    XMLWordPrintable

    Details

      Description

      Hi

      When loading the .dba file on oracle you get:

      CREATE TABLE ezprest_authcode (
        client_id VARCHAR2(200) NOT NULL,
        expirytime bigINTEGER(20) DEFAULT '0' NOT NULL,
        id VARCHAR2(200) NOT NULL,
        scope VARCHAR2(200),
        user_id VARCHAR2(200) NOT NULL,
        PRIMARY KEY ( id )
      )
      

      Removing the table from .dba file and you get:

      Failed inserting the SQL:
      CREATE TABLE ezprest_token (
        client_id VARCHAR2(200) NOT NULL,
        expirytime bigINTEGER(20) DEFAULT '0' NOT NULL,
        id VARCHAR2(200) NOT NULL,
        refresh_token VARCHAR2(200) NOT NULL,
        scope VARCHAR2(200),
        user_id VARCHAR2(200) NOT NULL,
        PRIMARY KEY ( id )
      )
      

      I believe it is the bigINTEGER which causes the problems ?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              gg Gaetano Giunta
              Reporter:
              vl Vidar Langseid
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: