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

        Activity

          People

            72f8acac-185f-4a54-9470-a7473f50daab@accounts.ibexa.co Gaetano Giunta
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: