James Server
  1. James Server
  2. JAMES-247

James Does Not Work With Oracle DB For Spool Repository

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.1.3, 2.2.0
    • Fix Version/s: 2.2.0
    • Labels:
      None
    • Environment:
      Windows XP, Oracle 9i

      Description

      Oracle does not allow two columns of type 'long' in the same table. The sqlResources.xml file defines message_body and message_attributes as type 'long raw' so James fails during the initialization phase because it cannot create the spool table.

      (* I have tried simply substituting blobs but that does not work - the message content is lost passing through James *)

        Activity

        Steve Short created issue -
        Noel J. Bergman made changes -
        Field Original Value New Value
        Resolution Fixed [ 1 ]
        Fix Version/s 2.2.0a19 [ 10689 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Vincenzo Gianferrari Pini made changes -
        Status Resolved [ 5 ] Reopened [ 4 ]
        Resolution Fixed [ 1 ]
        Vincenzo Gianferrari Pini made changes -
        Affects Version/s 2.2.0RC3 [ 10704 ]
        Priority Minor [ 4 ] Blocker [ 1 ]
        Affects Version/s 2.2.0RC1 [ 10689 ]
        Noel J. Bergman made changes -
        Affects Version/s 2.1.3 [ 10599 ]
        Fix Version/s 2.2.0RC4 [ 10720 ]
        Affects Version/s 2.2.0RC1 [ 10689 ]
        Affects Version/s 2.2.0RC2 [ 10700 ]
        Fix Version/s 2.2.0RC1 [ 10689 ]
        Vincenzo Gianferrari Pini made changes -
        Assignee Vincenzo Gianferrari Pini [ vincenzo ]
        Vincenzo Gianferrari Pini made changes -
        Status Reopened [ 4 ] In Progress [ 3 ]
        Noel J. Bergman made changes -
        Resolution Fixed [ 1 ]
        Status In Progress [ 3 ] Closed [ 6 ]
        Mark Thomas made changes -
        Workflow jira [ 27813 ] Default workflow, editable Closed status [ 12565984 ]
        Mark Thomas made changes -
        Workflow Default workflow, editable Closed status [ 12565984 ] jira [ 12581383 ]

          People

          • Assignee:
            Vincenzo Gianferrari Pini
            Reporter:
            Steve Short
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development