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

REST doesn't work on oracle

    XMLWordPrintable

Details

    Description

      Hi

      When accessing "/oauthadmin/list" you get this error:

      An unexpected error has occurred. Please contact the webmaster.
      A query failed internally in Persistent Object: SQLSTATE[HY000]: General error: 942 OCIStmtExecute: ORA-00942: tabellen eller utsnittet finnes ikke (/usr/src/php-5.2.17/ext/pdo_oci/oci_statement.c:146) Query: 'SELECT "ezprest_clients"."id", "ezprest_clients"."name", "ezprest_clients"."description", "ezprest_clients"."client_id", "ezprest_clients"."client_secret", "ezprest_clients"."endpoint_uri", "ezprest_clients"."owner_id", "ezprest_clients"."created", "ezprest_clients"."updated", "ezprest_clients"."version" FROM "ezprest_clients" WHERE "ezprest_clients"."version" = 0 ORDER BY "ezprest_clients"."name"' in /data1/www/apache2php52/ezporacle/.run/lib/ezc/PersistentObject/src/persistent_session.php on line 799
      

      With the following patch, it helps but you then get problem with a sequence

      --- lib/ezc/Database/src/handlers/oracle.php.old        2010-01-08 16:27:00.000000000 +0100
      +++ lib/ezc/Database/src/handlers/oracle.php    2011-03-28 14:33:28.000000000 +0200
      @@ -151,5 +151,11 @@
               $str = str_replace( "'", "''", $str );
               return "'$str'";
           }
      +
      +    protected $identifierQuoteChars = array(
      +        "start" => '',
      +        "end"   => '',
      +    );
      +
       }
       ?>
      

      The error is then:

      An unexpected error has occurred. Please contact the webmaster.
      A query failed internally in Persistent Object: SQLSTATE[HY000]: General error: 2289 OCIStmtExecute: ORA-02289: sekvensen finnes ikke (/usr/src/php-5.2.17/ext/pdo_oci/oci_statement.c:146) Query: 'INSERT INTO ezprest_clients ( name, description, client_id, client_secret, endpoint_uri, owner_id, created, updated, version, id ) VALUES ( :ezcValue1, :ezcValue2, :ezcValue3, :ezcValue4, :ezcValue5, :ezcValue6, :ezcValue7, :ezcValue8, :ezcValue9, ezprest_clients_s.nextval )' in /data1/www/apache2php52/ezporacle/.run/lib/ezc/PersistentObject/src/persistent_session.php on line 799
      

      Attachments

        Activity

          People

            unknown unknown
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: