[jira] Closed: (JAMES-247) James Does Not Work With Oracle DB For Spool Repository

[ji...@apache.org]

Message:

   The following issue has been closed.

   Resolver: Noel J. Bergman
       Date: Mon, 7 Jun 2004 4:18 PM

Steve Short reported that he "tested #247 on Oracle 9i and DB2 8.1 with no problems experienced."  We've also had reports that it works well with MySQL and PostgreSQL.

Closing this as fixed.
---------------------------------------------------------------------
View the issue:
  http://issues.apache.org/jira/browse/JAMES-247

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: JAMES-247
    Summary: James Does Not Work With Oracle DB For Spool Repository
       Type: Bug

     Status: Closed
   Priority: Blocker
 Resolution: FIXED

    Project: James
 Components: 
             MailStore & MailRepository
   Fix Fors:
             2.2.0RC4
   Versions:
             2.2.0RC3
             2.1.3
             2.2.0RC1
             2.2.0RC2

   Assignee: Vincenzo Gianferrari Pini
   Reporter: Steve Short

    Created: Fri, 2 Apr 2004 10:51 AM
    Updated: Mon, 7 Jun 2004 4:18 PM
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 *)


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org