Sorry, Please ignore last E-mail I sent. I rewrote it because that mail had a lot of mistake.
My environment and nature of the tests are as follow. I use Oracle 8.1.6 database server and client in the test environment. I changed only config.xml to use Oracle as following . -------------------------------------------------- <spoolRepository> <repository destinationURL="db://maildb/spool/spool" type="SPOOL"/> </spoolRepository> <data-source name="maildb" class="org.apache.james.util.dbcp.JdbcDataSource"> <driver>oracle.jdbc.OracleDriver</driver> <dburl>jdbc:oracle:thin:@hoge.ne.jp:1521:ins2</dburl> <user>hoge</user> <password>hoge</password> <max>20</max> </data-source> -------------------------------------------------- I've done test as following. No error occur when JAMES-2.1.3 received mail. But after I upgraded JAMES-2.1.3 to JAMES-2.2.0, error that is mentioned below occur. When JAMES-2.2.0 received mail appended image file, the mail is not inserted into SPOOL table and returned to sender. But JAMES could receive mail that has no image file. Please advice me. Danny Angus wrote: >This looks like a problem with your database connection, > >"java.sql.SQLException: Io exception: Broken pipe" > >Without knowing more about your set-up and the nature of the tests you were >running I couldn't say what the cause might be. > >If you were running a soak or load test it may be caused by resource >leakage, or the result of exceeding a hard limit. > >d. > > > > >|---------+----------------------------> >| | 向井 善則 | >| | <[EMAIL PROTECTED]| >| | i.ne.jp> | >| | | >| | 24/11/2005 05:48 | >| | AM | >| | Please respond to| >| | "James Users | >| | List" | >|---------+----------------------------> > > >-------------------------------------------------------------------------------------------------------------------------------| > | > | > | To: James Users List <[email protected]> > | > | cc: > | > | Subject: smtpserver ERROR > | > > >-------------------------------------------------------------------------------------------------------------------------------| > > > > >Hi, > >I ask mailing-list user same question again because mistake was found in >yesterday's E-mail. > >I am testing JAMES v2.2.0 and get errors. >After I sent mail to JAMES, I found ERROR message >in mailstore-2005-11-23.log and smtpserver-2005-11-23.log. > >I can't understand why these errors occurred. >Please teach the method of settlement. > >This is error log >smtpserver-2005-11-23.log------------------------------------------------------------------ > >23/11/05 11:17:18 ERROR smtpserver: Unknown error occurred while >processing DATA. >javax.mail.MessagingException: Exception spooling message: Exception >caught while storing mail Container: java.sql.SQLEx >ception: Io exception: Broken pipe; >nested exception is: >class javax.mail.MessagingException: Exception caught while storing mail >Container: java.sql.SQLException: Io ex >ception: Broken pipe >at org.apache.james.James.sendMail(James.java:467) >at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >at >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > >at >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >at java.lang.reflect.Method.invoke(Method.java:324) >at >org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:92 > >) >at $Proxy9.sendMail(Unknown Source) >at >org.apache.james.smtpserver.SMTPHandler.processMail(SMTPHandler.java:1450) >at org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:1287) >at >org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java:589) >at >org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.java:358) > >at >org.apache.james.util.connection.ServerConnection$ClientConnectionRunner.run(ServerConnection.java:417) > >at >org.apache.james.util.thread.ExecutableRunnable.execute(ExecutableRunnable.java:55) > >at org.apache.james.util.thread.WorkerThread.run(WorkerThread.java:90) >------------------------------------------------------------------ > > >mailstore-2005-11-23.log >------------------------------------------------------------------ >22/11/05 22:16:19 INFO mailstore: JamesMailStore init... >22/11/05 22:16:19 INFO mailstore: Registering Repository instance of >class org.apache.james.mailrepository.AvalonMailRe >pository to handle file protocol requests for repositories of type MAIL >22/11/05 22:16:19 INFO mailstore: Registering Repository instance of >class org.apache.james.mailrepository.AvalonSpoolR >epository to handle file protocol requests for repositories of type SPOOL >22/11/05 22:16:19 INFO mailstore: Registering Repository instance of >class org.apache.james.mailrepository.JDBCMailRepo >sitory to handle db protocol requests for repositories of type MAIL >22/11/05 22:16:19 INFO mailstore: Registering Repository instance of >class org.apache.james.mailrepository.JDBCSpoolRep >ository to handle db protocol requests for repositories of type SPOOL >22/11/05 22:16:19 INFO mailstore: Registering Repository instance of >class org.apache.james.mailrepository.JDBCMailRepo >sitory to handle dbfile protocol requests for repositories of type MAIL >22/11/05 22:16:19 INFO mailstore: Registering Repository instance of >class org.apache.james.mailrepository.JDBCSpoolRep >ository to handle dbfile protocol requests for repositories of type SPOOL >22/11/05 22:16:19 INFO mailstore: Registering Repository instance of >class org.apache.james.mailrepository.MBoxMailRepo >sitory to handle mbox protocol requests for repositories of type MAIL >22/11/05 22:16:20 INFO mailstore: JdbcMailRepository 'spool, table >'spool': JDBC Mail Attributes support ready. >22/11/05 22:16:20 INFO mailstore: added repository: >db://maildb/spool/spoolSPOOL->org.apache.james.mailrepository.JDBCS >poolRepository >22/11/05 22:16:20 INFO mailstore: SpoolRepository inboundSpool opened: >-237853397 >22/11/05 22:16:20 INFO mailstore: James MailStore ...init >22/11/05 22:16:21 INFO mailstore: added repository: >file://var/mail/inboxes/MAIL->org.apache.james.mailrepository.Avalo >nMailRepository >22/11/05 22:16:21 INFO mailstore: added repository: >file://var/mail/error/MAIL->org.apache.james.mailrepository.AvalonM >ailRepository >22/11/05 22:16:21 INFO mailstore: added repository: >file://var/mail/outgoing/SPOOL->org.apache.james.mailrepository.Ava >lonSpoolRepository >22/11/05 22:16:21 INFO mailstore: added repository: >file://var/mail/spam/MAIL->org.apache.james.mailrepository.AvalonMa >ilRepository >22/11/05 22:16:21 INFO mailstore: added repository: >file://var/mail/address-error/MAIL->org.apache.james.mailrepository >.AvalonMailRepository >22/11/05 22:16:21 INFO mailstore: added repository: >file://var/mail/relay-denied/MAIL->org.apache.james.mailrepository. >AvalonMailRepository >22/11/05 22:18:34 WARN mailstore: JDBCMailRepository: Unexpected >exception while closing database statement >------------------------------------------------------------------ > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > >*************************************************************************** >The information in this e-mail is confidential and for use by the addressee(s) >only. If you are not the intended recipient (or responsible for delivery of >the message to the intended recipient) please notify us immediately on 0141 >306 2050 and delete the message from your computer. You may not copy or >forward it or use or disclose its contents to any other person. As Internet >communications are capable of data corruption Student Loans Company Limited >does not accept any responsibility for changes made to this message after it >was sent. For this reason it may be inappropriate to rely on advice or >opinions contained in an e-mail without obtaining written confirmation of it. >Neither Student Loans Company Limited or the sender accepts any liability or >responsibility for viruses as it is your responsibility to scan attachments >(if any). Opinions and views expressed in this e-mail are those of the sender >and may not reflect the opinions and views of The Student Loans Company Limi t > ed. > >This footnote also confirms that this email message has been swept for the >presence of computer viruses. > >************************************************************************** > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > -- 以上です。 宜しくお願い致します。 ******************************************* 本田技研工業株式会社 インターナビ推進室 向井 善則 Tel: 048-452-1379 (個人直通) 048-452-0232 (部門直通) mail: [EMAIL PROTECTED] ******************************************* --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
