james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander.Ro...@olympus-software.com
Subject Re: Oracle datamodel for mail repository
Date Wed, 05 Sep 2001 13:35:39 GMT

Try LONG instead of CBLOB, it works fine.
Remember Oracle restrictions: you may have only one field of type LONG in
the table and LONG can't  be used in a cluster, but this should be no
problem here.






Prashant Khandelwal <prashant@thinking-minds.com>@prashant.tm.net on
05.09.2001 19:38:48

Please respond to james-dev@jakarta.apache.org

Sent by:  prashant@prashant.tm.net


To:   james-dev@jakarta.apache.org, james-user@jakarta.apache.org,
      prashant@thinking-minds.com
cc:

Subject:  Oracle datamodel for mail repository


Hi All,

I am trying to configure james to use oracle as to store user database and
also for mail repository.

I have a problem in delivery of mail to oracle.
I have designed datamodel from sample for mysql in docs directory. .......

        CREATE TABLE Messages (
         message_name varchar2(200) NOT NULL ,
         repository_name varchar2(200) NOT NULL ,
         message_state varchar2(30) NOT NULL ,
         error_message varchar2(4000),
         sender varchar2(200) NOT NULL ,
         recipients varchar2(400) NOT NULL ,
         remote_host varchar2(100) NOT NULL ,
         remote_addr varchar2(20) NOT NULL ,
         message_body clob(4000) NOT NULL,
         last_updated date NOT NULL,
         CONSTRAINT PK_Message PRIMARY KEY (message_name,repository_name)
        );



instead of the text data type i have used oracle equivalent 'clob' but it
creates a problem.
When the mail arrives to JAMES it inserts it in to database for spooling,
the repository_name field
of the  Message table for this mail has entry 'mainspool', and then james
goes in some
infinite loop the log jamesfile.log has entries as

2001.09.05 05:08:20 115 (INFO) from JamesSystem: Mail Mail999689897383-0
pushed in spool
2001.09.05 05:08:20 147 (INFO) from Processor: ==== Begin processing mail
Mail999689897383-0 ====
2001.09.05 05:08:20 147 (INFO) from Processor: Processing
Mail999689897383-0 through root
2001.09.05 05:08:20 433 (INFO) from Processor: Processing
Mail999689897383-0 through error
2001.09.05 05:08:20 468 (INFO) from Processor: Processing
Mail999689897383-0 through error
2001.09.05 05:08:20 491 (INFO) from Processor: Processing
Mail999689897383-0 through error
2001.09.05 05:08:20 529 (INFO) from Processor: Processing
Mail999689897383-0 through error
2001.09.05 05:08:20 555 (INFO) from Processor: Processing
Mail999689897383-0 through error
2001.09.05 05:08:20 581 (INFO) from Processor: Processing
Mail999689897383-0 through error
:
:
:

And
mailet.log has entries as
2001.09.05 05:01:48 409 Channel Mailets opened
2001.09.05 05:08:20 435 (INFO) from Mailets: ToRepository: Storing mail
Mail999689897383-0 in
town://mail-error
2001.09.05 05:08:20 468 (INFO) from Mailets: ToRepository: Storing mail
Mail999689897383-0 in
town://mail-error
2001.09.05 05:08:20 492 (INFO) from Mailets: ToRepository: Storing mail
Mail999689897383-0 in
town://mail-error
2001.09.05 05:08:20 530 (INFO) from Mailets: ToRepository: Storing mail
Mail999689897383-0 in
town://mail-error
2001.09.05 05:08:20 556 (INFO) from Mailets: ToRepository: Storing mail
Mail999689897383-0 in
town://mail-error
:
:
:




If I chang the datamodel replacing 'message_body CLOB' with 'message_body
varchar2(4000)' every
thing works fine.
the mail is inserted in database, also retrived through database, BUT I
want the message_body field
to be of CLOB
type as the message may also contain BIG attachments.





Regards,

---------------------
Prashant Khandelwal
Thinking-minds
---------------------

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





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


Mime
View raw message