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