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