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,
