Hi Eric,

I have marked the mail to be deleted through the JAVA API. Something like this 
message.setFlag(Flags.Flag.DELETED, true);

When I accessed the derby database, and checked the JAMES_MAIL table, I can see 
that there are lots of mails which are flagged as DELETED but never removed 
from the database.
 select count(*) from JAMES_MAIL where MAIL_IS_DELETED=0; returns me around 
1500.

What I really want is I dont want to store the mails in the derby database. Is 
there any way to do this? My mailet looks like this, is there any configuration 
that I can do so that the no mails are store in my Derby database?

 <mailet match="All" class="RemoteDelivery">
        <mail.smtp.localhost>beta.casengo.com</mail.smtp.localhost>
        <outgoingQueue>outgoing</outgoingQueue>
        ......
 </mailet>

Thanks
Naveen


________________________________________
From: Eric Charles [e...@apache.org]
Sent: Friday, January 04, 2013 5:18 PM
To: James Users List
Subject: Re: Apache James -Question

Hi,

What do you mean by marking the mail as deleted?
Are you accessing via POP, IMAP or directy JAVA API?

Also, Read https://kb.wisc.edu/cae/page.php?id=16718 for background on
"deleted". It all depends on the client you use.

Thx,

Eric


On 04/01/2013 16:40, Naveen Gopi / Livecom wrote:
> Hi ,
>
> Unfortunately we are having a small problem. We are using Apache Derby with 
> James and we can see that the database is growing really fast eating up lot 
> of disk space and making James a lot slower.
>
> The growing files are inside apache-james/var/store/derby/seg0. We have made 
> sure that after fetching we are marking the email as deleted. But we still 
> dont understand why the database is growing
>
> It will be great will anyone can throw some lights on this problem. Your help 
> will be highly appreciated.
>
> Thanks
> Naveen
>

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org

Reply via email to