Message:

   The following issue has been resolved as FIXED.

   Resolver: Noel J. Bergman
       Date: Tue, 13 Apr 2004 11:09 PM

Patch contributed by Steve Short adds support for Oracle by changing to use Blob 
column and Blob JDBC type.  Also add support for db2.
---------------------------------------------------------------------
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: Resolved
   Priority: Minor
 Resolution: FIXED

    Project: James
 Components: 
             MailStore & MailRepository
   Fix Fors:
             2.2.0a19
   Versions:
             2.2.0a18

   Assignee: 
   Reporter: Steve Short

    Created: Fri, 2 Apr 2004 10:51 AM
    Updated: Tue, 13 Apr 2004 11:09 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to