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" <[EMAIL PROTECTED]> To: "James Users List" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > > 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" <[EMAIL PROTECTED]> > > To: "'James Users List'" <[EMAIL PROTECTED]> > > 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:[EMAIL PROTECTED]] > > > > Sent: Thursday, September 12, 2002 9:03 AM > > > > To: [EMAIL PROTECTED] > > > > 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: > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
