it looks like you are passing in a javax.mail.internet.InternetAddress
and you don't have a custom type handler to deal with it.
Brandon
On 6/3/05, sma3har <[EMAIL PROTECTED]> wrote:
> This is DDL to create my table.
>
> create table load_allemails (
> id bigint AUTO_INCREMENT NOT NULL UNIQUE PRIMARY KEY,
> club_id int null,
> subject varchar(120) null,
> from_email varchar(120) null,
> to_name varchar(200) null,
> xaccountkey varchar(200) null,
> x_uidl int null,
> x_mozilla_status int null,
> return_path varchar(60) null,
> received varchar(60) null,
> domain_key varchar(60) null,
> messageid varchar(200) null,
> reply_to varchar(200) null,
> in_reply_to varchar(200) null,
> mime_version varchar(200) null,
> content_type varchar(200) null,
> content_disposition varchar(200) null,
> refernces varchar(200) null,
> content_transfer_encoding varchar(200) null,
> x_mime_autocoverted varchar(200) null,
> content text,
> date_published datetime null)
>
> I am inserting the values into Hashmap using the below code :
>
> messageDetails = new HashMap();
>
> messageDetails.put("subject" ,
> checkNull(message[i].getSubject()));
> messageDetails.put("fromemail",
> checkNull(message[i].getFrom()));
> messageDetails.put("toname",
> checkNull(message[i].getHeader("To")));
> messageDetails.put("xaccountkey",
> checkNull(message[i].getHeader("X-Account-Key")));
> messageDetails.put("xuidl",
> checkNull(message[i].getHeader("X-UIDL")));
> messageDetails.put("xmozillastatus",
> checkNull(message[i].getHeader("X-Mozilla-Status")));
> messageDetails.put("returnpath",
> checkNull(message[i].getHeader("Return-Path")));
> messageDetails.put("received",
> checkNull(message[i].getHeader("Received")));
> messageDetails.put("domainkeysignature",
> checkNull(message[i].getHeader("DomainKey-Signature")));
> messageDetails.put("messageId",
> checkNull(message[i].getHeader("Message-ID")));
> messageDetails.put("replyto",
> checkNull(message[i].getHeader("Reply-To")));
> messageDetails.put("inreplyto",
> checkNull(message[i].getHeader("In-Reply-To")));
> messageDetails.put("mimeversion",
> checkNull(message[i].getHeader("MIME-Version")));
> messageDetails.put("contentype",
> checkNull(message[i].getContentType()));
> messageDetails.put("contentdisposition",
> checkNull(message[i].getHeader("Content-Disposition")));
> messageDetails.put("references" ,
> checkNull(message[i].getHeader("References")));
> messageDetails.put("contenttranferencoding",
> checkNull(message[i].getHeader("Content-Tranfer-Encoding")));
> messageDetails.put("xmimeautoconverted",
> checkNull(message[i].getHeader("X-MIME-Autoconverted")));
> messageDetails.put("content",
> checkNull(message[i].getContent()));
>
> messageDetails.put("todaydate",checkNull(message[i].getHeader("Date")));
>
> list.add(messageDetails);
>
> My sqlmap statements look like this :
>
> INSERT LOW_PRIORITY
> INTO load_allemails (
> subject, from_email, to_name, xaccountkey,
> x_uidl,
> x_mozilla_status, return_path,
> received, domain_key, messageid, reply_to,
> in_reply_to,
> mime_version, content_type, content_disposition,
> refernces, content_transfer_encoding,
> x_mime_autocoverted,
> content, date_published)
> VALUES (
> #subject:VARCHAR:NO_ENTRY#,
> #fromemail:VARCHAR:NO_ENTRY#,
> #to:VARCHAR:NO_ENTRY#,
> #xaccountkey:VARCHAR:NO_ENTRY#,
> #xuidl:INTEGER:NO_ENTRY#,
> #xmozillastatus:INTEGER:NO_ENTRY#,
> #returnpath:VARCHAR:NO_ENTRY#,
> #received:VARCHAR:NO_ENTRY#,
> #domainkeysignature:VARCHAR:NO_ENTRY#,
> #messageId:VARCHAR:NO_ENTRY#,
> #replyto:VARCHAR:NO_ENTRY#,
> #inreplyto:VARCHAR:NO_ENTRY#,
> #mimeversion:VARCHAR:NO_ENTRY#,
> #contenttype:VARCHAR:NO_ENTRY#,
> #contentdisposition:VARCHAR:NO_ENTRY#,
> #references:VARCHAR:NO_ENTRY#,
> #contenttranferencoding:VARCHAR:NO_ENTRY#,
> #xmimeautoconverted:VARCHAR:NO_ENTRY#,
> #content:TEXT:NO_ENTRY#,
> #date:DATETIME:NO_ENTRY#)
>
> I keep getting this error :
>
> mimeversion=[Ljava.lang.String;@1016632,
> messageId=[Ljava.lang.String;@dc6a77, xuidl=, contentype=text/plain;
> charset=ISO-8859-1, references=[Ljava.lang.String;@d1e89e,
> replyto=[Ljava.lang.String;@ff057f,
> inreplyto=[Ljava.lang.String;@c1f10e,
> xmimeautoconverted=[Ljava.lang.String;@b8deef, _MODE=_Insert,
> domainkeysignature=[Ljava.lang.String;@1342ba4,
> contentdisposition=[Ljava.lang.String;@1d332b, subject=Re: (no subject),
> fromemail=[Ljavax.mail.internet.InternetAddress;@10a6ae2,
> returnpath=[Ljava.lang.String;@ef2c60, contenttranferencoding=}
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/basyc/mail/dao/MailImportSql.xml.
> --- The error occurred while applying a parameter map.
> --- Check the MailImportSql.loadMail-InlineParameterMap.
> --- Cause: java.lang.NullPointerException
> Caused by: java.lang.NullPointerException
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:90)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:85)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:57)
> at
> com.sandra.servicer.dao.SqlMapHelper.doInsert(SqlMapHelper.java:198)
> at com.sandra.servicer.dao.SqlMapHelper.execute(SqlMapHelper.java:114)
> at
> com.basyc.mail.dao.MailArticleSave.saveMail(MailArticleSave.java:30)
> at com.basyc.mail.EmailLoad.saveMail(EmailLoad.java:60)
> at com.basyc.mail.EmailLoad.execute(EmailLoad.java:42)
> at com.basyc.mail.EmailLoad.main(EmailLoad.java:33)
> Caused by: java.lang.NullPointerException
> at
> com.ibatis.sqlmap.engine.type.UnknownTypeHandler.setParameter(UnknownTypeHandler.java:42)
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter(BasicParameterMap.java:165)
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters(BasicParameterMap.java:125)
> at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:196)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:74)
> ... 9 more
>
> Caused by:
> java.lang.NullPointerException
> at
> com.ibatis.sqlmap.engine.type.UnknownTypeHandler.setParameter(UnknownTypeHandler.java:42)
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter(BasicParameterMap.java:165)
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters(BasicParameterMap.java:125)
> at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:196)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:74)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:85)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:57)
> at
> com.sandra.servicer.dao.SqlMapHelper.doInsert(SqlMapHelper.java:198)
> at com.sandra.servicer.dao.SqlMapHelper.execute(SqlMapHelper.java:114)
> at
> com.basyc.mail.dao.MailArticleSave.saveMail(MailArticleSave.java:30)
> at com.basyc.mail.EmailLoad.saveMail(EmailLoad.java:60)
> at com.basyc.mail.EmailLoad.execute(EmailLoad.java:42)
> at com.basyc.mail.EmailLoad.main(EmailLoad.java:33)
>
> Caused by:
> java.lang.NullPointerException
> at
> com.ibatis.sqlmap.engine.type.UnknownTypeHandler.setParameter(UnknownTypeHandler.java:42)
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter(BasicParameterMap.java:165)
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters(BasicParameterMap.java:125)
> at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:196)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:74)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:85)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:57)
> at
> com.sandra.servicer.dao.SqlMapHelper.doInsert(SqlMapHelper.java:198)
> at com.sandra.servicer.dao.SqlMapHelper.execute(SqlMapHelper.java:114)
> at
> com.basyc.mail.dao.MailArticleSave.saveMail(MailArticleSave.java:30)
> at com.basyc.mail.EmailLoad.saveMail(EmailLoad.java:60)
> at com.basyc.mail.EmailLoad.execute(EmailLoad.java:42)
> at com.basyc.mail.EmailLoad.main(EmailLoad.java:33)
>
>
> I can see the map values coming. Can someone please help where i am
> going wrong.
>
> Appreciate it,
>
>
