You could use DBFile which stores the body of a mail message in the file
system, while headers are stored in the database, see
http://james.apache.org/server/2.3.0/repositories.html
It should help.
Thx, Eric
On 29/11/2012 02:23, Joshua Wang wrote:
Use Oracle Database 11g Release 2 (11.2.0.3) JDBC Drivers ojdbc6.jar seems
better. But still have this problem.
The environments:
1. laboratory: win server 2003 r2 standard edition service pack2, jdk
1.6.0_07, oracle 11g enterprise edition 11.1.0.6.0
2. Customor: win server 2003 enterprise edition service pack2, jdk
1.6.0_21, oracle 11g enterprise edition 11.1.0.7.0
Will it be good if all mails store as files even a large amount?
Joshua
On Wed, Nov 28, 2012 at 5:58 PM, Eric Charles <e...@apache.org> wrote:
Ok, so it seems it is an issue when James has to get large amount of
data from Oracle.
The failing code can be read on [1], the suspect being somewhere in [2]
when the resultset is read.
Do you use the latest oracle jdbc driver (will probably not fix it, but
who knows?)
Thx, Eric
[1]
http://svn.apache.org/viewvc/james/server/tags/2_3_2/src/java/org/apache/james/mailrepository/JDBCMailRepository.java?view=markup
[2]
885 MailImpl mc = new MailImpl();
886 mc.setAttributesRaw (attributes);
887 mc.setName(key);
888 mc.setState(rsMessage.getString(1));
889 mc.setErrorMessage(rsMessage.getString(2));
890 String sender = rsMessage.getString(3);
891 if (sender == null) {
892 mc.setSender(null);
893 } else {
894 mc.setSender(new MailAddress(sender));
895 }
896 StringTokenizer st = new StringTokenizer(rsMessage.getString(4),
"\r\n", false);
897 Set recipients = new HashSet();
898 while (st.hasMoreTokens()) {
899 recipients.add(new MailAddress(st.nextToken()));
900 }
901 mc.setRecipients(recipients);
902 mc.setRemoteHost(rsMessage.getString(5));
903 mc.setRemoteAddr(rsMessage.getString(6));
904 mc.setLastUpdated(rsMessage.getTimestamp(7));
905
On 28/11/2012 08:52, Joshua Wang wrote:
Yeah. I've got this error occasionally in thunderbird, telnet and my
application. Here's what I got from thunderbird:
"STAT ???????????????????????? hlrdwd.com ???-ERR".
(English meaning: Stat command unsuccessfully. Can't get message number
and
size. Mail server hlrdwd.com response: -ERR)
The error occurs usually when there are a lot of new mails of the user.
By
the way, the whole size of mails is about 5G.
Joshua
On Wed, Nov 28, 2012 at 2:48 PM, Eric Charles <e...@apache.org> wrote:
Do you also see this error when connecting via a mail client
(thunderbird...) or only connecting via telnet?
Thx, Eric
---------------------------------------------------------------------
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
