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 pchellarajan <pc...@ivesia.com> on 2002/09/13 16:53:34 UTC

Re: Data size bigger than max size for this type - Fixed

Thanks to  Dan and Peter for their responses, I found the bug and fixed it.
It is because of the setBytes method used in JDBCMailRepository, I replaced
the method setBytes as setBinaryStream as follows,

                    InputStream ins = new
ByteArrayInputStream(headerOut.toByteArray());
                    //Store the headers in the database
                    //updateMessage.setBytes(1, headerOut.toByteArray());
                    updateMessage.setBinaryStream(1, ins, headerOut.size());

--Prince

----- Original Message -----
From: "Danny Angus" <da...@apache.org>
To: "James Users List" <ja...@jakarta.apache.org>
Sent: Thursday, September 12, 2002 3:25 PM
Subject: RE: Data size bigger than max size for this type


> pity we don't know what field it is..
> d.
>
> > -----Original Message-----
> > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > Sent: 12 September 2002 19:58
> > To: James Users List
> > Subject: Re: Data size bigger than max size for this type
> >
> >
> > Thanks Dan for the response. I don't see there is any issues with
message
> > body, because if you closely observe this exception "
> > java.sql.SQLException:
> > Data size bigger than max size for this type: 4023", which means around
4
> > KB, which is the maximum size of a VARCHAR data type. Please help
> >
> > Thanks
> > Prince
> > ----- Original Message -----
> > From: "Danny Angus" <da...@apache.org>
> > To: "James Users List" <ja...@jakarta.apache.org>
> > Sent: Thursday, September 12, 2002 1:21 PM
> > Subject: RE: Data size bigger than max size for this type
> >
> >
> > > I seem to remember a thread about oracle field types, it was concerned
> > with
> > > using CLOB fro message bodies, I don't remember what the outcme was
> > > d.
> > >
> > > > -----Original Message-----
> > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > Sent: 12 September 2002 17:16
> > > > To: James Users List
> > > > Subject: Re: Data size bigger than max size for this type
> > > >
> > > >
> > > > Thanks Pete for the response,
> > > >
> > > > 1) Invalid email address means, email address that doesn't exist.
> > > > 2) I'm using James Version 2.1a1-2002-08-18
> > > > 3) Error messgae inn mailet log file,
> > > > 12/09/02 10:06:54 INFO  James.Mailet: RemoteDelivery: Temporary
> > exception
> > > > delivering mail (Mail1031785876842-35-to-localhost:
> > > > javax.mail.MessagingException: 451 Error processing message:
Exception
> > > > spooling message: Exception caught while storing mail Container:
> > > > java.sql.SQLException: Data size bigger than max size for this type:
> > 4042;
> > > >
> > > >  at
> > com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879)
> > > >  at
com.sun.mail.smtp.SMTPTransport.finishData(SMTPTransport.java:820)
> > > >  at
> > com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:322)
> > > >  at
> > > > org.apache.james.transport.mailets.RemoteDelivery.deliver(RemoteDe
> > > > livery.jav
> > > > a:213)
> > > >  at
> > > > org.apache.james.transport.mailets.RemoteDelivery.run(RemoteDelive
> > > > ry.java:52
> > > > 4)
> > > >  at java.lang.Thread.run(Thread.java:536)
> > > > --Prince
> > > > ----- Original Message -----
> > > > From: "Peter M. Goldstein" <pe...@yahoo.com>
> > > > To: "'James Users List'" <ja...@jakarta.apache.org>
> > > > Sent: Thursday, September 12, 2002 12:03 PM
> > > > Subject: RE: Data size bigger than max size for this type
> > > >
> > > >
> > > > >
> > > > > Prince,
> > > > >
> > > > > If you want help with this issue you're clearly going to have to
> > provide
> > > > > more details.  May I suggest:
> > > > >
> > > > > i) Clarification of what you mean by 'invalid' email addresses.
> > > > > Syntactically invalid or simply non-existent addresses
> > > > >
> > > > > ii) A James version #
> > > > >
> > > > > iii) Relevant log snippets
> > > > >
> > > > > --Peter
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > Sent: Thursday, September 12, 2002 9:03 AM
> > > > > > To: james-user@jakarta.apache.org
> > > > > > Subject: Data size bigger than max size for this type
> > > > > >
> > > > > > Hi,
> > > > > > I'm getting the following error messages whenever I'm
> > trying to test
> > > > > with
> > > > > > some invalid email address I'm getting the following
> > error message.
> > I
> > > > > have
> > > > > > connected to oracle and everything works fine, but
> > whenever my list
> > > > > has
> > > > > > some invalid email address it fails. Please help.
> > > > > >
> > > > > > Thanks
> > > > > > Prince
> > > > > >
> > > > > > java.sql.SQLException: Data size bigger than max size for
> > this type:
> > > > > 4023
> > > > > >         at
> > > > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > >         at
> > > > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > >         at
oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > >         at
> > > > > >
> > oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > a:1761)
> > > > > >         at
> > > > > >
> > oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > ement.java:855)
> > > > > >         at
> > > > > >
> > oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > tement.java:1812)
> > > > > >         at
> > > > > >
> > org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > sitory.java:542)
> > > > > >         at
> > > > > >
> > org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > pository.java:190)
> > > > > >         at org.apache.james.James.sendMail(James.java:308)
> > > > > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > Method)
> > > > > >         at
> > > > > >
> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > java:39)
> > > > > >         at
> > > > > >
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > sorImpl.java:25)
> > > > > >         at java.lang.reflect.Method.invoke(Method.java:324)
> > > > > >         at
> > > > > >
> > org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > >         at
> > > > > >
> > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > >         at
> > > > > >
> > org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > :349)
> > > > > >         at
> > > > > >
> > org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > java:218)
> > > > > >         at
> > > > > >
> > org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > Connection.java:169)
> > > > > >         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)
> > > > > > java.sql.SQLException: Data size bigger than max size for
> > this type:
> > > > > 4042
> > > > > >         at
> > > > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > >         at
> > > > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > >         at
oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > >         at
> > > > > >
> > oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > a:1761)
> > > > > >         at
> > > > > >
> > oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > ement.java:855)
> > > > > >         at
> > > > > >
> > oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > tement.java:1812)
> > > > > >         at
> > > > > >
> > org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > sitory.java:542)
> > > > > >         at
> > > > > >
> > org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > pository.java:190)
> > > > > >         at org.apache.james.James.sendMail(James.java:308)
> > > > > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > Method)
> > > > > >         at
> > > > > >
> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > java:39)
> > > > > >         at
> > > > > >
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > sorImpl.java:25)
> > > > > >         at java.lang.reflect.Method.invoke(Method.java:324)
> > > > > >         at
> > > > > >
> > org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > >         at
> > > > > >
> > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > >         at
> > > > > >
> > org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > :349)
> > > > > >         at
> > > > > >
> > org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > java:218)
> > > > > >         at
> > > > > >
> > org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > Connection.java:169)
> > > > > >         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)
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: Data size bigger than max size for this type - Fixed

Posted by pchellarajan <pc...@ivesia.com>.
Do it Peter, if you need any help regarding this, please feel free to ask

Prince
----- Original Message -----
From: "Peter M. Goldstein" <pe...@yahoo.com>
To: "'James Users List'" <ja...@jakarta.apache.org>
Sent: Friday, September 13, 2002 11:46 AM
Subject: RE: Data size bigger than max size for this type - Fixed


>
> Prince,
>
> Ok.  So this is a restriction of the Oracle JDBC driver implementation.
> So noted.  I'll file a bug and submit a patch.
>
> --Peter
>
> > -----Original Message-----
> > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > Sent: Friday, September 13, 2002 8:48 AM
> > To: James Users List; farsight@alum.mit.edu
> > Subject: Re: Data size bigger than max size for this type - Fixed
> >
> > Peter,
> > I was breaking my head to find this out and thanks to O'reilly Safari
> for
> > giving me the hint to proceed. Seems that there is a limitation on the
> > size
> > that you can update using setBytes, the following URL provides more
> info
> > about this
> > http://safari.oreilly.com/main.asp?bookname=jorajdbc&snode=88
> >
> > Thanks
> > Prince
> > ----- Original Message -----
> > From: "Peter M. Goldstein" <pe...@yahoo.com>
> > To: "'James Users List'" <ja...@jakarta.apache.org>
> > Sent: Friday, September 13, 2002 11:23 AM
> > Subject: RE: Data size bigger than max size for this type - Fixed
> >
> >
> > >
> > > Prince,
> > >
> > > Ok.  Do you know why the original code is causing a problem?  I
> don't
> > > know where the length limit on setBytes is coming from.  Is it an
> > > artifact of the JDBC driver you're using?
> > >
> > > --Peter
> > >
> > > > -----Original Message-----
> > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > Sent: Friday, September 13, 2002 7:54 AM
> > > > To: James Users List
> > > > Subject: Re: Data size bigger than max size for this type - Fixed
> > > >
> > > > Thanks to  Dan and Peter for their responses, I found the bug and
> > > fixed
> > > > it.
> > > > It is because of the setBytes method used in JDBCMailRepository, I
> > > > replaced
> > > > the method setBytes as setBinaryStream as follows,
> > > >
> > > >                     InputStream ins = new
> > > > ByteArrayInputStream(headerOut.toByteArray());
> > > >                     //Store the headers in the database
> > > >                     //updateMessage.setBytes(1,
> > > headerOut.toByteArray());
> > > >                     updateMessage.setBinaryStream(1, ins,
> > > > headerOut.size());
> > > >
> > > > --Prince
> > > >
> > > > ----- Original Message -----
> > > > From: "Danny Angus" <da...@apache.org>
> > > > To: "James Users List" <ja...@jakarta.apache.org>
> > > > Sent: Thursday, September 12, 2002 3:25 PM
> > > > Subject: RE: Data size bigger than max size for this type
> > > >
> > > >
> > > > > pity we don't know what field it is..
> > > > > d.
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > Sent: 12 September 2002 19:58
> > > > > > To: James Users List
> > > > > > Subject: Re: Data size bigger than max size for this type
> > > > > >
> > > > > >
> > > > > > Thanks Dan for the response. I don't see there is any issues
> with
> > > > message
> > > > > > body, because if you closely observe this exception "
> > > > > > java.sql.SQLException:
> > > > > > Data size bigger than max size for this type: 4023", which
> means
> > > > around
> > > > 4
> > > > > > KB, which is the maximum size of a VARCHAR data type. Please
> help
> > > > > >
> > > > > > Thanks
> > > > > > Prince
> > > > > > ----- Original Message -----
> > > > > > From: "Danny Angus" <da...@apache.org>
> > > > > > To: "James Users List" <ja...@jakarta.apache.org>
> > > > > > Sent: Thursday, September 12, 2002 1:21 PM
> > > > > > Subject: RE: Data size bigger than max size for this type
> > > > > >
> > > > > >
> > > > > > > I seem to remember a thread about oracle field types, it was
> > > > concerned
> > > > > > with
> > > > > > > using CLOB fro message bodies, I don't remember what the
> outcme
> > > was
> > > > > > > d.
> > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > > > Sent: 12 September 2002 17:16
> > > > > > > > To: James Users List
> > > > > > > > Subject: Re: Data size bigger than max size for this type
> > > > > > > >
> > > > > > > >
> > > > > > > > Thanks Pete for the response,
> > > > > > > >
> > > > > > > > 1) Invalid email address means, email address that doesn't
> > > exist.
> > > > > > > > 2) I'm using James Version 2.1a1-2002-08-18
> > > > > > > > 3) Error messgae inn mailet log file,
> > > > > > > > 12/09/02 10:06:54 INFO  James.Mailet: RemoteDelivery:
> > > Temporary
> > > > > > exception
> > > > > > > > delivering mail (Mail1031785876842-35-to-localhost:
> > > > > > > > javax.mail.MessagingException: 451 Error processing
> message:
> > > > Exception
> > > > > > > > spooling message: Exception caught while storing mail
> > > Container:
> > > > > > > > java.sql.SQLException: Data size bigger than max size for
> this
> > > > type:
> > > > > > 4042;
> > > > > > > >
> > > > > > > >  at
> > > > > >
> > > com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879)
> > > > > > > >  at
> > > > com.sun.mail.smtp.SMTPTransport.finishData(SMTPTransport.java:820)
> > > > > > > >  at
> > > > > >
> > > com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:322)
> > > > > > > >  at
> > > > > > > >
> > > org.apache.james.transport.mailets.RemoteDelivery.deliver(RemoteDe
> > > > > > > > livery.jav
> > > > > > > > a:213)
> > > > > > > >  at
> > > > > > > >
> > > org.apache.james.transport.mailets.RemoteDelivery.run(RemoteDelive
> > > > > > > > ry.java:52
> > > > > > > > 4)
> > > > > > > >  at java.lang.Thread.run(Thread.java:536)
> > > > > > > > --Prince
> > > > > > > > ----- Original Message -----
> > > > > > > > From: "Peter M. Goldstein" <pe...@yahoo.com>
> > > > > > > > To: "'James Users List'" <ja...@jakarta.apache.org>
> > > > > > > > Sent: Thursday, September 12, 2002 12:03 PM
> > > > > > > > Subject: RE: Data size bigger than max size for this type
> > > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > Prince,
> > > > > > > > >
> > > > > > > > > If you want help with this issue you're clearly going to
> > > have to
> > > > > > provide
> > > > > > > > > more details.  May I suggest:
> > > > > > > > >
> > > > > > > > > i) Clarification of what you mean by 'invalid' email
> > > addresses.
> > > > > > > > > Syntactically invalid or simply non-existent addresses
> > > > > > > > >
> > > > > > > > > ii) A James version #
> > > > > > > > >
> > > > > > > > > iii) Relevant log snippets
> > > > > > > > >
> > > > > > > > > --Peter
> > > > > > > > >
> > > > > > > > > > -----Original Message-----
> > > > > > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > > > > > Sent: Thursday, September 12, 2002 9:03 AM
> > > > > > > > > > To: james-user@jakarta.apache.org
> > > > > > > > > > Subject: Data size bigger than max size for this type
> > > > > > > > > >
> > > > > > > > > > Hi,
> > > > > > > > > > I'm getting the following error messages whenever I'm
> > > > > > trying to test
> > > > > > > > > with
> > > > > > > > > > some invalid email address I'm getting the following
> > > > > > error message.
> > > > > > I
> > > > > > > > > have
> > > > > > > > > > connected to oracle and everything works fine, but
> > > > > > whenever my list
> > > > > > > > > has
> > > > > > > > > > some invalid email address it fails. Please help.
> > > > > > > > > >
> > > > > > > > > > Thanks
> > > > > > > > > > Prince
> > > > > > > > > >
> > > > > > > > > > java.sql.SQLException: Data size bigger than max size
> for
> > > > > > this type:
> > > > > > > > > 4023
> > > > > > > > > >         at
> > > > > > > > > >
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > > > > >         at
> > > > oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > > > > a:1761)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > > > > ement.java:855)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > > > > tement.java:1812)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > > > > sitory.java:542)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > > > > pository.java:190)
> > > > > > > > > >         at
> org.apache.james.James.sendMail(James.java:308)
> > > > > > > > > >         at
> > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > Method)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > > > > java:39)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > > > > sorImpl.java:25)
> > > > > > > > > >         at
> > > java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > > > > :349)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > > > > java:218)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > > > > Connection.java:169)
> > > > > > > > > >         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)
> > > > > > > > > > java.sql.SQLException: Data size bigger than max size
> for
> > > > > > this type:
> > > > > > > > > 4042
> > > > > > > > > >         at
> > > > > > > > > >
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > > > > >         at
> > > > oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > > > > a:1761)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > > > > ement.java:855)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > > > > tement.java:1812)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > > > > sitory.java:542)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > > > > pository.java:190)
> > > > > > > > > >         at
> org.apache.james.James.sendMail(James.java:308)
> > > > > > > > > >         at
> > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > Method)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > > > > java:39)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > > > > sorImpl.java:25)
> > > > > > > > > >         at
> > > java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > > > > :349)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > > > > java:218)
> > > > > > > > > >         at
> > > > > > > > > >
> > > > > >
> > >
> org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > > > > Connection.java:169)
> > > > > > > > > >         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)
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > <ma...@jakarta.apache.org>
> > > > > > > > > For additional commands, e-mail:
> > > > > > > > <ma...@jakarta.apache.org>
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > To unsubscribe, e-mail:
> > > > > > > > <ma...@jakarta.apache.org>
> > > > > > > > For additional commands, e-mail:
> > > > > > > > <ma...@jakarta.apache.org>
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > To unsubscribe, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > > > For additional commands, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > To unsubscribe, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:   <mailto:james-user-
> > > > unsubscribe@jakarta.apache.org>
> > > > For additional commands, e-mail: <mailto:james-user-
> > > > help@jakarta.apache.org>
> > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:   <mailto:james-user-
> > unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail: <mailto:james-user-
> > help@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Data size bigger than max size for this type - Fixed

Posted by "Peter M. Goldstein" <pe...@yahoo.com>.
Prince,

Ok.  So this is a restriction of the Oracle JDBC driver implementation.
So noted.  I'll file a bug and submit a patch.

--Peter

> -----Original Message-----
> From: pchellarajan [mailto:pchellarajan@ivesia.com]
> Sent: Friday, September 13, 2002 8:48 AM
> To: James Users List; farsight@alum.mit.edu
> Subject: Re: Data size bigger than max size for this type - Fixed
> 
> Peter,
> I was breaking my head to find this out and thanks to O'reilly Safari
for
> giving me the hint to proceed. Seems that there is a limitation on the
> size
> that you can update using setBytes, the following URL provides more
info
> about this
> http://safari.oreilly.com/main.asp?bookname=jorajdbc&snode=88
> 
> Thanks
> Prince
> ----- Original Message -----
> From: "Peter M. Goldstein" <pe...@yahoo.com>
> To: "'James Users List'" <ja...@jakarta.apache.org>
> Sent: Friday, September 13, 2002 11:23 AM
> Subject: RE: Data size bigger than max size for this type - Fixed
> 
> 
> >
> > Prince,
> >
> > Ok.  Do you know why the original code is causing a problem?  I
don't
> > know where the length limit on setBytes is coming from.  Is it an
> > artifact of the JDBC driver you're using?
> >
> > --Peter
> >
> > > -----Original Message-----
> > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > Sent: Friday, September 13, 2002 7:54 AM
> > > To: James Users List
> > > Subject: Re: Data size bigger than max size for this type - Fixed
> > >
> > > Thanks to  Dan and Peter for their responses, I found the bug and
> > fixed
> > > it.
> > > It is because of the setBytes method used in JDBCMailRepository, I
> > > replaced
> > > the method setBytes as setBinaryStream as follows,
> > >
> > >                     InputStream ins = new
> > > ByteArrayInputStream(headerOut.toByteArray());
> > >                     //Store the headers in the database
> > >                     //updateMessage.setBytes(1,
> > headerOut.toByteArray());
> > >                     updateMessage.setBinaryStream(1, ins,
> > > headerOut.size());
> > >
> > > --Prince
> > >
> > > ----- Original Message -----
> > > From: "Danny Angus" <da...@apache.org>
> > > To: "James Users List" <ja...@jakarta.apache.org>
> > > Sent: Thursday, September 12, 2002 3:25 PM
> > > Subject: RE: Data size bigger than max size for this type
> > >
> > >
> > > > pity we don't know what field it is..
> > > > d.
> > > >
> > > > > -----Original Message-----
> > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > Sent: 12 September 2002 19:58
> > > > > To: James Users List
> > > > > Subject: Re: Data size bigger than max size for this type
> > > > >
> > > > >
> > > > > Thanks Dan for the response. I don't see there is any issues
with
> > > message
> > > > > body, because if you closely observe this exception "
> > > > > java.sql.SQLException:
> > > > > Data size bigger than max size for this type: 4023", which
means
> > > around
> > > 4
> > > > > KB, which is the maximum size of a VARCHAR data type. Please
help
> > > > >
> > > > > Thanks
> > > > > Prince
> > > > > ----- Original Message -----
> > > > > From: "Danny Angus" <da...@apache.org>
> > > > > To: "James Users List" <ja...@jakarta.apache.org>
> > > > > Sent: Thursday, September 12, 2002 1:21 PM
> > > > > Subject: RE: Data size bigger than max size for this type
> > > > >
> > > > >
> > > > > > I seem to remember a thread about oracle field types, it was
> > > concerned
> > > > > with
> > > > > > using CLOB fro message bodies, I don't remember what the
outcme
> > was
> > > > > > d.
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > > Sent: 12 September 2002 17:16
> > > > > > > To: James Users List
> > > > > > > Subject: Re: Data size bigger than max size for this type
> > > > > > >
> > > > > > >
> > > > > > > Thanks Pete for the response,
> > > > > > >
> > > > > > > 1) Invalid email address means, email address that doesn't
> > exist.
> > > > > > > 2) I'm using James Version 2.1a1-2002-08-18
> > > > > > > 3) Error messgae inn mailet log file,
> > > > > > > 12/09/02 10:06:54 INFO  James.Mailet: RemoteDelivery:
> > Temporary
> > > > > exception
> > > > > > > delivering mail (Mail1031785876842-35-to-localhost:
> > > > > > > javax.mail.MessagingException: 451 Error processing
message:
> > > Exception
> > > > > > > spooling message: Exception caught while storing mail
> > Container:
> > > > > > > java.sql.SQLException: Data size bigger than max size for
this
> > > type:
> > > > > 4042;
> > > > > > >
> > > > > > >  at
> > > > >
> > com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879)
> > > > > > >  at
> > > com.sun.mail.smtp.SMTPTransport.finishData(SMTPTransport.java:820)
> > > > > > >  at
> > > > >
> > com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:322)
> > > > > > >  at
> > > > > > >
> > org.apache.james.transport.mailets.RemoteDelivery.deliver(RemoteDe
> > > > > > > livery.jav
> > > > > > > a:213)
> > > > > > >  at
> > > > > > >
> > org.apache.james.transport.mailets.RemoteDelivery.run(RemoteDelive
> > > > > > > ry.java:52
> > > > > > > 4)
> > > > > > >  at java.lang.Thread.run(Thread.java:536)
> > > > > > > --Prince
> > > > > > > ----- Original Message -----
> > > > > > > From: "Peter M. Goldstein" <pe...@yahoo.com>
> > > > > > > To: "'James Users List'" <ja...@jakarta.apache.org>
> > > > > > > Sent: Thursday, September 12, 2002 12:03 PM
> > > > > > > Subject: RE: Data size bigger than max size for this type
> > > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > Prince,
> > > > > > > >
> > > > > > > > If you want help with this issue you're clearly going to
> > have to
> > > > > provide
> > > > > > > > more details.  May I suggest:
> > > > > > > >
> > > > > > > > i) Clarification of what you mean by 'invalid' email
> > addresses.
> > > > > > > > Syntactically invalid or simply non-existent addresses
> > > > > > > >
> > > > > > > > ii) A James version #
> > > > > > > >
> > > > > > > > iii) Relevant log snippets
> > > > > > > >
> > > > > > > > --Peter
> > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > > > > Sent: Thursday, September 12, 2002 9:03 AM
> > > > > > > > > To: james-user@jakarta.apache.org
> > > > > > > > > Subject: Data size bigger than max size for this type
> > > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > > I'm getting the following error messages whenever I'm
> > > > > trying to test
> > > > > > > > with
> > > > > > > > > some invalid email address I'm getting the following
> > > > > error message.
> > > > > I
> > > > > > > > have
> > > > > > > > > connected to oracle and everything works fine, but
> > > > > whenever my list
> > > > > > > > has
> > > > > > > > > some invalid email address it fails. Please help.
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > > Prince
> > > > > > > > >
> > > > > > > > > java.sql.SQLException: Data size bigger than max size
for
> > > > > this type:
> > > > > > > > 4023
> > > > > > > > >         at
> > > > > > > > >
> > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > > > >         at
> > > > > > > > >
> > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > > > >         at
> > > oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > > > a:1761)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > > > ement.java:855)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > > > tement.java:1812)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > > > sitory.java:542)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > > > pository.java:190)
> > > > > > > > >         at
org.apache.james.James.sendMail(James.java:308)
> > > > > > > > >         at
> > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > Method)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > > > java:39)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > > > sorImpl.java:25)
> > > > > > > > >         at
> > java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > > > :349)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > > > java:218)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > > > Connection.java:169)
> > > > > > > > >         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)
> > > > > > > > > java.sql.SQLException: Data size bigger than max size
for
> > > > > this type:
> > > > > > > > 4042
> > > > > > > > >         at
> > > > > > > > >
> > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > > > >         at
> > > > > > > > >
> > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > > > >         at
> > > oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > > > a:1761)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > > > ement.java:855)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > > > tement.java:1812)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > > > sitory.java:542)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > > > pository.java:190)
> > > > > > > > >         at
org.apache.james.James.sendMail(James.java:308)
> > > > > > > > >         at
> > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > Method)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > > > java:39)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > > > sorImpl.java:25)
> > > > > > > > >         at
> > java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > > > :349)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > > > java:218)
> > > > > > > > >         at
> > > > > > > > >
> > > > >
> >
org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > > > Connection.java:169)
> > > > > > > > >         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)
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > To unsubscribe, e-mail:
> > > > > > > <ma...@jakarta.apache.org>
> > > > > > > > For additional commands, e-mail:
> > > > > > > <ma...@jakarta.apache.org>
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > To unsubscribe, e-mail:
> > > > > > > <ma...@jakarta.apache.org>
> > > > > > > For additional commands, e-mail:
> > > > > > > <ma...@jakarta.apache.org>
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > To unsubscribe, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > > For additional commands, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:   <mailto:james-user-
> > > unsubscribe@jakarta.apache.org>
> > > For additional commands, e-mail: <mailto:james-user-
> > > help@jakarta.apache.org>
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:james-user-
> unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <mailto:james-user-
> help@jakarta.apache.org>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: Data size bigger than max size for this type - Fixed

Posted by pchellarajan <pc...@ivesia.com>.
Peter,
I was breaking my head to find this out and thanks to O'reilly Safari for
giving me the hint to proceed. Seems that there is a limitation on the size
that you can update using setBytes, the following URL provides more info
about this
http://safari.oreilly.com/main.asp?bookname=jorajdbc&snode=88

Thanks
Prince
----- Original Message -----
From: "Peter M. Goldstein" <pe...@yahoo.com>
To: "'James Users List'" <ja...@jakarta.apache.org>
Sent: Friday, September 13, 2002 11:23 AM
Subject: RE: Data size bigger than max size for this type - Fixed


>
> Prince,
>
> Ok.  Do you know why the original code is causing a problem?  I don't
> know where the length limit on setBytes is coming from.  Is it an
> artifact of the JDBC driver you're using?
>
> --Peter
>
> > -----Original Message-----
> > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > Sent: Friday, September 13, 2002 7:54 AM
> > To: James Users List
> > Subject: Re: Data size bigger than max size for this type - Fixed
> >
> > Thanks to  Dan and Peter for their responses, I found the bug and
> fixed
> > it.
> > It is because of the setBytes method used in JDBCMailRepository, I
> > replaced
> > the method setBytes as setBinaryStream as follows,
> >
> >                     InputStream ins = new
> > ByteArrayInputStream(headerOut.toByteArray());
> >                     //Store the headers in the database
> >                     //updateMessage.setBytes(1,
> headerOut.toByteArray());
> >                     updateMessage.setBinaryStream(1, ins,
> > headerOut.size());
> >
> > --Prince
> >
> > ----- Original Message -----
> > From: "Danny Angus" <da...@apache.org>
> > To: "James Users List" <ja...@jakarta.apache.org>
> > Sent: Thursday, September 12, 2002 3:25 PM
> > Subject: RE: Data size bigger than max size for this type
> >
> >
> > > pity we don't know what field it is..
> > > d.
> > >
> > > > -----Original Message-----
> > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > Sent: 12 September 2002 19:58
> > > > To: James Users List
> > > > Subject: Re: Data size bigger than max size for this type
> > > >
> > > >
> > > > Thanks Dan for the response. I don't see there is any issues with
> > message
> > > > body, because if you closely observe this exception "
> > > > java.sql.SQLException:
> > > > Data size bigger than max size for this type: 4023", which means
> > around
> > 4
> > > > KB, which is the maximum size of a VARCHAR data type. Please help
> > > >
> > > > Thanks
> > > > Prince
> > > > ----- Original Message -----
> > > > From: "Danny Angus" <da...@apache.org>
> > > > To: "James Users List" <ja...@jakarta.apache.org>
> > > > Sent: Thursday, September 12, 2002 1:21 PM
> > > > Subject: RE: Data size bigger than max size for this type
> > > >
> > > >
> > > > > I seem to remember a thread about oracle field types, it was
> > concerned
> > > > with
> > > > > using CLOB fro message bodies, I don't remember what the outcme
> was
> > > > > d.
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > Sent: 12 September 2002 17:16
> > > > > > To: James Users List
> > > > > > Subject: Re: Data size bigger than max size for this type
> > > > > >
> > > > > >
> > > > > > Thanks Pete for the response,
> > > > > >
> > > > > > 1) Invalid email address means, email address that doesn't
> exist.
> > > > > > 2) I'm using James Version 2.1a1-2002-08-18
> > > > > > 3) Error messgae inn mailet log file,
> > > > > > 12/09/02 10:06:54 INFO  James.Mailet: RemoteDelivery:
> Temporary
> > > > exception
> > > > > > delivering mail (Mail1031785876842-35-to-localhost:
> > > > > > javax.mail.MessagingException: 451 Error processing message:
> > Exception
> > > > > > spooling message: Exception caught while storing mail
> Container:
> > > > > > java.sql.SQLException: Data size bigger than max size for this
> > type:
> > > > 4042;
> > > > > >
> > > > > >  at
> > > >
> com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879)
> > > > > >  at
> > com.sun.mail.smtp.SMTPTransport.finishData(SMTPTransport.java:820)
> > > > > >  at
> > > >
> com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:322)
> > > > > >  at
> > > > > >
> org.apache.james.transport.mailets.RemoteDelivery.deliver(RemoteDe
> > > > > > livery.jav
> > > > > > a:213)
> > > > > >  at
> > > > > >
> org.apache.james.transport.mailets.RemoteDelivery.run(RemoteDelive
> > > > > > ry.java:52
> > > > > > 4)
> > > > > >  at java.lang.Thread.run(Thread.java:536)
> > > > > > --Prince
> > > > > > ----- Original Message -----
> > > > > > From: "Peter M. Goldstein" <pe...@yahoo.com>
> > > > > > To: "'James Users List'" <ja...@jakarta.apache.org>
> > > > > > Sent: Thursday, September 12, 2002 12:03 PM
> > > > > > Subject: RE: Data size bigger than max size for this type
> > > > > >
> > > > > >
> > > > > > >
> > > > > > > Prince,
> > > > > > >
> > > > > > > If you want help with this issue you're clearly going to
> have to
> > > > provide
> > > > > > > more details.  May I suggest:
> > > > > > >
> > > > > > > i) Clarification of what you mean by 'invalid' email
> addresses.
> > > > > > > Syntactically invalid or simply non-existent addresses
> > > > > > >
> > > > > > > ii) A James version #
> > > > > > >
> > > > > > > iii) Relevant log snippets
> > > > > > >
> > > > > > > --Peter
> > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > > > Sent: Thursday, September 12, 2002 9:03 AM
> > > > > > > > To: james-user@jakarta.apache.org
> > > > > > > > Subject: Data size bigger than max size for this type
> > > > > > > >
> > > > > > > > Hi,
> > > > > > > > I'm getting the following error messages whenever I'm
> > > > trying to test
> > > > > > > with
> > > > > > > > some invalid email address I'm getting the following
> > > > error message.
> > > > I
> > > > > > > have
> > > > > > > > connected to oracle and everything works fine, but
> > > > whenever my list
> > > > > > > has
> > > > > > > > some invalid email address it fails. Please help.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > > Prince
> > > > > > > >
> > > > > > > > java.sql.SQLException: Data size bigger than max size for
> > > > this type:
> > > > > > > 4023
> > > > > > > >         at
> > > > > > > >
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > > >         at
> > > > > > > >
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > > >         at
> > oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > > >         at
> > > > > > > >
> > > >
> oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > > a:1761)
> > > > > > > >         at
> > > > > > > >
> > > >
> oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > > ement.java:855)
> > > > > > > >         at
> > > > > > > >
> > > >
> oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > > tement.java:1812)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > > sitory.java:542)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > > pository.java:190)
> > > > > > > >         at org.apache.james.James.sendMail(James.java:308)
> > > > > > > >         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > Method)
> > > > > > > >         at
> > > > > > > >
> > > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > > java:39)
> > > > > > > >         at
> > > > > > > >
> > > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > > sorImpl.java:25)
> > > > > > > >         at
> java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > > :349)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > > java:218)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > > Connection.java:169)
> > > > > > > >         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)
> > > > > > > > java.sql.SQLException: Data size bigger than max size for
> > > > this type:
> > > > > > > 4042
> > > > > > > >         at
> > > > > > > >
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > > >         at
> > > > > > > >
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > > >         at
> > oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > > >         at
> > > > > > > >
> > > >
> oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > > a:1761)
> > > > > > > >         at
> > > > > > > >
> > > >
> oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > > ement.java:855)
> > > > > > > >         at
> > > > > > > >
> > > >
> oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > > tement.java:1812)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > > sitory.java:542)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > > pository.java:190)
> > > > > > > >         at org.apache.james.James.sendMail(James.java:308)
> > > > > > > >         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > Method)
> > > > > > > >         at
> > > > > > > >
> > > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > > java:39)
> > > > > > > >         at
> > > > > > > >
> > > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > > sorImpl.java:25)
> > > > > > > >         at
> java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > > :349)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > > java:218)
> > > > > > > >         at
> > > > > > > >
> > > >
> org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > > Connection.java:169)
> > > > > > > >         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)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > To unsubscribe, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > > > For additional commands, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > To unsubscribe, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > > For additional commands, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:   <mailto:james-user-
> > unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail: <mailto:james-user-
> > help@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Data size bigger than max size for this type - Fixed

Posted by "Peter M. Goldstein" <pe...@yahoo.com>.
Prince,

Ok.  Do you know why the original code is causing a problem?  I don't
know where the length limit on setBytes is coming from.  Is it an
artifact of the JDBC driver you're using?

--Peter

> -----Original Message-----
> From: pchellarajan [mailto:pchellarajan@ivesia.com]
> Sent: Friday, September 13, 2002 7:54 AM
> To: James Users List
> Subject: Re: Data size bigger than max size for this type - Fixed
> 
> Thanks to  Dan and Peter for their responses, I found the bug and
fixed
> it.
> It is because of the setBytes method used in JDBCMailRepository, I
> replaced
> the method setBytes as setBinaryStream as follows,
> 
>                     InputStream ins = new
> ByteArrayInputStream(headerOut.toByteArray());
>                     //Store the headers in the database
>                     //updateMessage.setBytes(1,
headerOut.toByteArray());
>                     updateMessage.setBinaryStream(1, ins,
> headerOut.size());
> 
> --Prince
> 
> ----- Original Message -----
> From: "Danny Angus" <da...@apache.org>
> To: "James Users List" <ja...@jakarta.apache.org>
> Sent: Thursday, September 12, 2002 3:25 PM
> Subject: RE: Data size bigger than max size for this type
> 
> 
> > pity we don't know what field it is..
> > d.
> >
> > > -----Original Message-----
> > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > Sent: 12 September 2002 19:58
> > > To: James Users List
> > > Subject: Re: Data size bigger than max size for this type
> > >
> > >
> > > Thanks Dan for the response. I don't see there is any issues with
> message
> > > body, because if you closely observe this exception "
> > > java.sql.SQLException:
> > > Data size bigger than max size for this type: 4023", which means
> around
> 4
> > > KB, which is the maximum size of a VARCHAR data type. Please help
> > >
> > > Thanks
> > > Prince
> > > ----- Original Message -----
> > > From: "Danny Angus" <da...@apache.org>
> > > To: "James Users List" <ja...@jakarta.apache.org>
> > > Sent: Thursday, September 12, 2002 1:21 PM
> > > Subject: RE: Data size bigger than max size for this type
> > >
> > >
> > > > I seem to remember a thread about oracle field types, it was
> concerned
> > > with
> > > > using CLOB fro message bodies, I don't remember what the outcme
was
> > > > d.
> > > >
> > > > > -----Original Message-----
> > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > Sent: 12 September 2002 17:16
> > > > > To: James Users List
> > > > > Subject: Re: Data size bigger than max size for this type
> > > > >
> > > > >
> > > > > Thanks Pete for the response,
> > > > >
> > > > > 1) Invalid email address means, email address that doesn't
exist.
> > > > > 2) I'm using James Version 2.1a1-2002-08-18
> > > > > 3) Error messgae inn mailet log file,
> > > > > 12/09/02 10:06:54 INFO  James.Mailet: RemoteDelivery:
Temporary
> > > exception
> > > > > delivering mail (Mail1031785876842-35-to-localhost:
> > > > > javax.mail.MessagingException: 451 Error processing message:
> Exception
> > > > > spooling message: Exception caught while storing mail
Container:
> > > > > java.sql.SQLException: Data size bigger than max size for this
> type:
> > > 4042;
> > > > >
> > > > >  at
> > >
com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879)
> > > > >  at
> com.sun.mail.smtp.SMTPTransport.finishData(SMTPTransport.java:820)
> > > > >  at
> > >
com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:322)
> > > > >  at
> > > > >
org.apache.james.transport.mailets.RemoteDelivery.deliver(RemoteDe
> > > > > livery.jav
> > > > > a:213)
> > > > >  at
> > > > >
org.apache.james.transport.mailets.RemoteDelivery.run(RemoteDelive
> > > > > ry.java:52
> > > > > 4)
> > > > >  at java.lang.Thread.run(Thread.java:536)
> > > > > --Prince
> > > > > ----- Original Message -----
> > > > > From: "Peter M. Goldstein" <pe...@yahoo.com>
> > > > > To: "'James Users List'" <ja...@jakarta.apache.org>
> > > > > Sent: Thursday, September 12, 2002 12:03 PM
> > > > > Subject: RE: Data size bigger than max size for this type
> > > > >
> > > > >
> > > > > >
> > > > > > Prince,
> > > > > >
> > > > > > If you want help with this issue you're clearly going to
have to
> > > provide
> > > > > > more details.  May I suggest:
> > > > > >
> > > > > > i) Clarification of what you mean by 'invalid' email
addresses.
> > > > > > Syntactically invalid or simply non-existent addresses
> > > > > >
> > > > > > ii) A James version #
> > > > > >
> > > > > > iii) Relevant log snippets
> > > > > >
> > > > > > --Peter
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: pchellarajan [mailto:pchellarajan@ivesia.com]
> > > > > > > Sent: Thursday, September 12, 2002 9:03 AM
> > > > > > > To: james-user@jakarta.apache.org
> > > > > > > Subject: Data size bigger than max size for this type
> > > > > > >
> > > > > > > Hi,
> > > > > > > I'm getting the following error messages whenever I'm
> > > trying to test
> > > > > > with
> > > > > > > some invalid email address I'm getting the following
> > > error message.
> > > I
> > > > > > have
> > > > > > > connected to oracle and everything works fine, but
> > > whenever my list
> > > > > > has
> > > > > > > some invalid email address it fails. Please help.
> > > > > > >
> > > > > > > Thanks
> > > > > > > Prince
> > > > > > >
> > > > > > > java.sql.SQLException: Data size bigger than max size for
> > > this type:
> > > > > > 4023
> > > > > > >         at
> > > > > > >
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > >         at
> > > > > > >
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > >         at
> oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > >         at
> > > > > > >
> > >
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > a:1761)
> > > > > > >         at
> > > > > > >
> > >
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > ement.java:855)
> > > > > > >         at
> > > > > > >
> > >
oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > tement.java:1812)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > sitory.java:542)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > pository.java:190)
> > > > > > >         at org.apache.james.James.sendMail(James.java:308)
> > > > > > >         at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > Method)
> > > > > > >         at
> > > > > > >
> > >
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > java:39)
> > > > > > >         at
> > > > > > >
> > >
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > sorImpl.java:25)
> > > > > > >         at
java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > >         at
> > > > > > >
> > >
org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > :349)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > java:218)
> > > > > > >         at
> > > > > > >
> > >
org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > Connection.java:169)
> > > > > > >         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)
> > > > > > > java.sql.SQLException: Data size bigger than max size for
> > > this type:
> > > > > > 4042
> > > > > > >         at
> > > > > > >
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
> > > > > > >         at
> > > > > > >
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
> > > > > > >         at
> oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:99)
> > > > > > >         at
> > > > > > >
> > >
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
> > > > > > > a:1761)
> > > > > > >         at
> > > > > > >
> > >
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
> > > > > > > ement.java:855)
> > > > > > >         at
> > > > > > >
> > >
oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedSta
> > > > > > > tement.java:1812)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
> > > > > > > sitory.java:542)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
> > > > > > > pository.java:190)
> > > > > > >         at org.apache.james.James.sendMail(James.java:308)
> > > > > > >         at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > Method)
> > > > > > >         at
> > > > > > >
> > >
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > > > > > > java:39)
> > > > > > >         at
> > > > > > >
> > >
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > > > > > > sorImpl.java:25)
> > > > > > >         at
java.lang.reflect.Method.invoke(Method.java:324)
> > > > > > >         at
> > > > > > >
> > >
org.apache.avalon.phoenix.components.application.BlockInvocationHandl
> > > > > > > er.invoke(BlockInvocationHandler.java:92)
> > > > > > >         at $Proxy9.sendMail(Unknown Source)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:994)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
> > > > > > > :349)
> > > > > > >         at
> > > > > > >
> > >
org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
> > > > > > > java:218)
> > > > > > >         at
> > > > > > >
> > >
org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
> > > > > > > Connection.java:169)
> > > > > > >         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)
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > To unsubscribe, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > > For additional commands, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:james-user-
> unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <mailto:james-user-
> help@jakarta.apache.org>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>