Thank you Eric. I'm sure the database is OK, and the connection is fine too. My application's functions except receive emails from James works fine, No Connection Error I've got, such as select, update, delete and so on. Additionally, only me use the server when testing, so the connection pool is not busy. The STAT command not always failed, but occasionally. If a user just have a little new mails(say less than 10), receive never got an error. All my data including message body(usually have some attaches) stored into database, does that matter?
Yours sincerely, Joshua. On Fri, Nov 23, 2012 at 11:07 PM, Eric Charles <e...@apache.org> wrote: > Hi, > > From "ORA-12519, TNS:no appropriate service handler found", it seems like > an issue on the Oracle database, not on the James server. > > Can double check with a SQL client that the James database schema responds > fine (select some tables...) when the problem occurs? > > Thx, Eric > > > On 23/11/2012 14:25, Joshua Wang wrote: > >> Sorry about that. I'm using Apache James 2.3.2 as my mail server with all >> data stored into database(Oracle). All seems good until I got some >> complains that some users cannot receive mails. I checked it out and found >> that it is the STAT command failed(both in my client application and the >> telnet): >> -- >> c:\>telnet hlrdwd.com 110 >> +OK csmis POP3 server <JAMES POP3 Server 2.3.2> ready >> user chaixufa >> +OK >> pass 123456 >> +OK Welcome chaixufa >> stat >> -ERR >> stat >> -ERR >> stat >> +OK 164 404317 >> top 1 0 >> +OK Message follows >> >> James' logs got exceptions that should not happen. Because I'm quite sure >> there's no problem about james' config, data-source, database, >> connections, >> etc. >> -- >> 21/11/12 14:39:16 ERROR pop3server: Unable to STAT mail box >> javax.mail.MessagingException: Exception while retrieving mail: Listener >> refused the connection with the following error: >> ORA-12519, TNS:no appropriate service handler found >> The Connection descriptor used by the client was: >> 192.168.250.23:1521:csmis >> at >> org.apache.james.**mailrepository.**JDBCMailRepository.retrieve(** >> JDBCMailRepository.java:918) >> at org.apache.james.pop3server.**POP3Handler.stat(POP3Handler.**java:399) >> at org.apache.james.pop3server.**POP3Handler.doPASS(** >> POP3Handler.java:547) >> at >> org.apache.james.pop3server.**POP3Handler.parseCommand(** >> POP3Handler.java:479) >> at >> org.apache.james.pop3server.**POP3Handler.handleConnection(** >> POP3Handler.java:277) >> at >> org.apache.james.util.**connection.ServerConnection$** >> ClientConnectionRunner.run(**ServerConnection.java:432) >> at >> org.apache.excalibur.thread.**impl.ExecutableRunnable.** >> execute(ExecutableRunnable.**java:55) >> at org.apache.excalibur.thread.**impl.WorkerThread.run(** >> WorkerThread.java:116) >> 21/11/12 14:39:16 INFO pop3server: Connection for chaixufa from 127.0.0.1 >> (127.0.0.1) closed. >> >> All applications running on the same server and there's only me using it >> when testing it. The error occurs usually when there are a lot of mails in >> INBOX(more than 40). I can't find the reason, all should be good. >> Thank you! >> Joshua >> >> > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > server-user-unsubscribe@james.**apache.org<server-user-unsubscr...@james.apache.org> > For additional commands, e-mail: > server-user-help@james.apache.**org<server-user-h...@james.apache.org> > >
