[JAMES-247] James Does Not Work With Oracle DB For Spool Repository

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.1.3, 2.2.0
• Fix Version/s: 2.2.0
• Component/s: MailStore & MailRepository
• Environment: Windows XP, Oracle 9i
• Assignee: Vincenzo Gianferrari Pini
• Reporter: Steve Short
• Created: 02/Apr/04 18:51
• Updated: 07/Jun/04 23:18
• Resolved: 07/Jun/04 23:18

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 *)