Hi all,

I have problems sending and thus receiving mail attachment messages within 
James. I have placed some rigorous debug messages throughout the whole of 
James project and got the following results:


Whenever I attempt to send a multipart mail message with some binary 
attachment files and send it to a local recipient (or non-local), it throws 
some strange exception:


java.sql.SQLException: Io exception: Connection reset by peer: socket write 
erro
r
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
        at 
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:1460)
        at 
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1371)
        at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1900)
        at 
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:363)
        at 
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
ement.java:407)
        at 
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
sitory.java:479)
        at org.apache.james.James.sendMail(James.java:265)
        at java.lang.reflect.Method.invoke(Native Method)
        at 
org.apache.avalon.phoenix.components.application.BlockInvocationHandl
er.invoke(BlockInvocationHandler.java:88)
        at $Proxy9.sendMail(Unknown Source)
        at 
org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:609)
        at 
org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
:255)
        at 
org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
java:164)
        at 
org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
Connection.java:163)
        at 
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
        at 
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)


When I then attemp to login into James POP server as the recipient expecting 
to read the attachment mail message, I'm unable to login at all, which is 
very odd, it also threw some spurious exceptions:


(SQLException) AbstractJdbcUsersRepository.getUserByName): Io exception: 
Connect
ion reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write 
erro
r
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
        at 
oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417)
        at 
oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)
        at 
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedState
ment.java:182)
        at 
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedState
ment.java:165)
        at 
oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleCon
nection.java:608)
        at 
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection
.java:489)
        at 
org.apache.james.util.mordred.PoolConnEntry.prepareStatement(PoolConn
Entry.java:199)
        at 
org.apache.james.userrepository.AbstractJdbcUsersRepository.getUserBy
Name(AbstractJdbcUsersRepository.java:407)
        at 
org.apache.james.userrepository.AbstractUsersRepository.test(Abstract
UsersRepository.java:252)
        at 
org.apache.james.pop3server.POP3Handler.doPASS(POP3Handler.java:336)
        at 
org.apache.james.pop3server.POP3Handler.parseCommand(POP3Handler.java
:290)
        at 
org.apache.james.pop3server.POP3Handler.handleConnection(POP3Handler.
java:225)
        at 
org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
Connection.java:163)
        at 
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
        at 
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
(2nd Exception) POP3Handler.handleConnection(): Error accessing database

Then after every 10 seconds the JamesSpoolManager reattempts to send the 
mail message, and I got the following exceptions:

(SQLException) JDBCSpoolRepository.loadPendingMessages(): Io exception: 
Connecti
on reset by peer: socket write error
(1st Exception) JDBCSpoolRepository.loadPendingMessages(): null
(2nd Exception) JDBCSpoolRepository.loadPendingMessages(): null


I would be most grateful if you could shed a light into this peculiar 
James's behaviour.

Thanks in advance.

Sam.


_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to