Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-2350

XMLUI Submissions link throws SQL error when using Oracle as a DB

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 5.0
    • Fix Version/s: 5.0
    • Component/s: XMLUI
    • Labels:
      None
    • Environment:
      Oracle DB, RHEL/CentOS 6, Java 7, Tomcat 7
    • Attachments:
      0
    • Comments:
      5
    • Documentation Status:
      Not Required

      Description

      After logging in, when an admin selects the "submissions" link from the navigation menu, the following error is thrown:

      ORA-00933: SQL command not properly ended

      I'll include the full stack trace in comments below, to keep this description short. But the stack trace points to this portion of the code:

      ‚Äčorg.dspace.content.Item.findBySubmitterDateSorted(Item.java:305)
      https://github.com/DSpace/DSpace/blob/d507fc4d1d4d3a73ea78263a77fc44a7a70ea283/dspace-api/src/main/java/org/dspace/content/Item.java#L305

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              peterdietz Peter Dietz
              Reporter:
              hardyoyo Hardy Pottinger
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: