Re: No Patch necessary for making James working with SAPDB

[Serge Knystautas <se...@lokitech.com>]

Thanks for the create statement.  I'll add it to CVS.

Glad it's stable... I knew for sure it was a lot faster.  I patched for a
file-deletion problems and was waiting to hear any problems.  Since it's
been quiet for a week or two, I'm assuming my patch is working well enough.
That was the last of the show stoppers.  I'll release an alpha this week (I
swear!)

Serge Knystautas
Loki Technologies - Unstoppable Websites
http://www.lokitech.com/
----- Original Message -----
From: "Samuel Franklyn" <pt...@indosat.net.id>
To: <ja...@jakarta.apache.org>
Sent: Monday, October 22, 2001 9:16 AM
Subject: No Patch necessary for making James working with SAPDB


> Last time I send  mail to this list informing that
> I need to patch James to make it work with SAPDB.
> Well after learning more about SAPDB I am able to
> make James store mail in SAPDB without patching
> James.
>
> I am wrong in writing create table statement for SAPDB.
> The right statement is :
>
>         CREATE TABLE ${table} (
>          message_name varchar (200) NOT NULL,
>          repository_name varchar (200) NOT NULL,
>          message_state varchar (30) NOT NULL ,
>          error_message varchar (200) NULL ,
>          sender varchar (200) NULL ,
>          recipients long NOT NULL ,
>          remote_host varchar (100) NOT NULL ,
>          remote_addr varchar (20) NOT NULL ,
>
>          message_body long byte NOT NULL ,
>
>          last_updated date NOT NULL,
>          PRIMARY KEY (message_name, repository_name)
>         )
>
> If you specify a long column without byte the long column
> reject setBytes and getBytes with byte long column get
> along fine with James.
>
> By the way James CVS code is more stable and faster than
> James version you can download from the web site.
> I think it will be wise to release a new version of James from
> the CVS code.
>
>
> ---------------------------------------------------------------------
> 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