Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-10091

2.4 oracle conversion script uses invalid datatype

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: trunk
    • Fix Version/s: 2.4.0
    • Component/s: Content
    • Labels:
      None

      Description

      The create table statements for the citation tool are invalid on oracle 9.

      Here's one of the many errors the conversion script throws:

      Error starting at line 1,189 in command:
      CREATE TABLE CITATION_CITATION ( CITATION_ID VARCHAR (36) NOT NULL, PROPERTY_NAME VARCHAR (255), PROPERTY_VALUE LONGTEXT )
      Error at Command Line:1,189 Column:112
      Error report:
      SQL Error: ORA-00902: invalid datatype
      00902. 00000 - "invalid datatype"

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                gbhatnag Gaurav Cedric Bhatnagar (Inactive)
                Reporter:
                jholtzman Josh Holtzman (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration