The following issue has been updated:
Updater: Vincenzo Gianferrari Pini (mailto:[EMAIL PROTECTED])
Date: Wed, 19 May 2004 4:04 AM
Comment:
New fix committed. Needed because mssql (and possibly other database products) does
not work the way we need with getBlob.
Created a new sqlResources.xml element ("dbOptions") that allows control of the
desired behaviour for each database product, specifically with the new "dbOption"s
"getBody" and "getAttributes". They drive the usage of either getBlob or getBytes, the
latter being the default.
The defaults set should be fully backwards compatible (to 2.1.x and 2.2.0ax);
only oracle and db2 are set to use getBlob, so no current installation should break,
even without modifying SqlResources.xml.
I fully (?) tested the new dbOptions mechanism and the behaviour of mssql. Other db
products should be tested now.
Changes:
assignee changed to Vincenzo Gianferrari Pini
---------------------------------------------------------------------
For a full history of the issue, see:
http://issues.apache.org/jira/browse/JAMES-247?page=history
---------------------------------------------------------------------
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: Reopened
Priority: Blocker
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: Wed, 19 May 2004 4:04 AM
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]
