You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Samuel Sadek <sa...@hotmail.com> on 2002/02/26 13:00:01 UTC
Mail Attachment problem (Continued...)
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 worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Mail Attachment problem (Continued...)
Posted by Darrell DeBoer <li...@bigdaz.com>.
Hi Samuel,
>From the stack-trace provided, it's pretty clear that the Oracle driver is
spitting in the OraclePreparedStatement.execute() call. Maybe the Oracle logs
can provide you with more information about what's going wrong.
Something that can be immensely useful is to enable logging inside the JDBC
driver itself. This let's the JDBC driver tell you what's going on. It's
something like:
DriverManager.setLogStream( System.out );
(have a look at the API docs for java.sql.DriverManager)
Hope this helps
ciao
Daz
On Tue, 26 Feb 2002 22:00, you wrote:
> 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 worlds largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>