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