Thank you.

I think you should raise a bug in jira..
http://issues.apache.org/jira/secure/Dashboard.jspa

please also upload an email that will reproduce the problem.

We may not be able to get an oracle 8 environment to reproduce this with,
but I think we did change the database connection pool between those two
versions, and I might be able to reproduce it against Oracle 9 or 10.

d.

---
Danny Angus
Lead Technical Consultant
ICT Products Development
4W
3257



|---------+---------------------------->
|         |           向井 善則       |
|         |           <[EMAIL PROTECTED]|
|         |           i.ne.jp>         |
|         |                            |
|         |           25/11/2005 05:51 |
|         |           AM               |
|         |           Please respond to|
|         |           "James Users     |
|         |           List"            |
|---------+---------------------------->
  
>-------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                  |
  |       To:       James Users List <[email protected]>             
                                                  |
  |       cc:                                                                   
                                                  |
  |       Subject:  Re: smtpserver ERROR                                        
                                                  |
  
>-------------------------------------------------------------------------------------------------------------------------------|




Thank you for reply.

I'm using software version
and I was doing set-up a method as following.

version-------------------
Database is oracle 8.1.6
JDBC is 8.1.6
--------------------------

set-up--------------------
Table object of Database is defult.
I changed config.xml as following.


<spoolRepository>
<repository destinationURL="db://maildb/spool/spool" type="SPOOL"/>
</spoolRepository>


AND


<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'm doing test that is as following.

Error did not occur when JAMES-2.1.3 received E-mail,
but Error occurred when I upgraded JAMES-2.1.3 to JAMES-2.2.0.

Then JAMES received test mail appended image file,Error always occurred.
E-mail did not insert in SPOOL table.
But JAMES could receive E-mail that without appending 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]




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

Reply via email to