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 > >
