0

I am new in json. I am using a mysql query in which a datetime field is there.I want to convert the query result in json.but for datetime field I cast the field to only date.query executed properly and give the proper output.but when i am trying to convert this result into json its giving error releated to date time field. class to convert in json is. 

package com.helical.efw.json;

import java.util.List;
import java.util.Map;
import net.sf.json.JSONObject;

public class ConvertJson {
    public String CommonJson(Map<String,? extends List<?>> commonList)
    {
        String jsonString;
        System.out.println("in json locationId List=======jjjj==========");
        JSONObject json = new JSONObject();
        json.accumulateAll(commonList);
        jsonString=json.toString();
        System.out.println(json.toString());
        return jsonString;
    }
}

Method to fire query:

public List<Map<String,Object>> getLastSevenDaysStageExecutionDetail()
{
    System.out.println("I am in getLastStageExecutionDetail=========");
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();
    Query query;
    List<Map<String,Object>> aliasToValueMapList=null;

    try{
        String d1="2013-12-30";
        String d2="2013-12-31";
        query =session.createSQLQuery("SELECT cast(moment as date) as dated, timestampdiff(second,moment, end_time) as t FROM efw_db.efw_job_time where moment between '"+d1+"' and '"+d2+"' group by cast(moment as date);");
        query.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);
        aliasToValueMapList=query.list();
        System.out.println(aliasToValueMapList.toString());
    }catch(Exception e) {
        e.printStackTrace();
    }
    return aliasToValueMapList;
} 

     Error is:

HTTP Status 500 - java.lang.reflect.InvocationTargetException

type Exception report

message java.lang.reflect.InvocationTargetException

description The server encountered an internal error that prevented it from  fulfilling   this request.

exception

    net.sf.json.JSONException: java.lang.reflect.InvocationTargetException
    net.sf.json.JSONObject.defaultBeanProcessing(JSONObject.java:818)
    net.sf.json.JSONObject._fromBean(JSONObject.java:699)
    net.sf.json.JSONObject.fromObject(JSONObject.java:172)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:274)
    net.sf.json.JSONObject._processValue(JSONObject.java:2655)
    net.sf.json.JSONObject.processValue(JSONObject.java:2721)
    net.sf.json.JSONObject.setInternal(JSONObject.java:2736)
    net.sf.json.JSONObject.setValue(JSONObject.java:1424)
    net.sf.json.JSONObject._fromMap(JSONObject.java:1168)
    net.sf.json.JSONObject.fromObject(JSONObject.java:163)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:274)
    net.sf.json.JSONArray._processValue(JSONArray.java:2513)
    net.sf.json.JSONArray.processValue(JSONArray.java:2538)
    net.sf.json.JSONArray.addValue(JSONArray.java:2525)
    net.sf.json.JSONArray._fromCollection(JSONArray.java:1056)
    net.sf.json.JSONArray.fromObject(JSONArray.java:123)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:240)
    net.sf.json.JSONObject._processValue(JSONObject.java:2655)
    net.sf.json.JSONObject.processValue(JSONObject.java:2721)
    net.sf.json.JSONObject.setInternal(JSONObject.java:2736)
    net.sf.json.JSONObject._accumulate(JSONObject.java:2635)
    net.sf.json.JSONObject.accumulate(JSONObject.java:1560)
    net.sf.json.JSONObject.accumulateAll(JSONObject.java:1582)
    net.sf.json.JSONObject.accumulateAll(JSONObject.java:1564)
    com.helical.efw.view.StageExecution.LastSevenDaysStageWiseExecution(StageExecution.java:70)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
    org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)

root cause

java.lang.reflect.InvocationTargetException
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773)
    org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1132)
    org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:686)
    org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:715)
    org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:290)
    net.sf.json.JSONObject.defaultBeanProcessing(JSONObject.java:749)
    net.sf.json.JSONObject._fromBean(JSONObject.java:699)
    net.sf.json.JSONObject.fromObject(JSONObject.java:172)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:274)
    net.sf.json.JSONObject._processValue(JSONObject.java:2655)
    net.sf.json.JSONObject.processValue(JSONObject.java:2721)
    net.sf.json.JSONObject.setInternal(JSONObject.java:2736)
    net.sf.json.JSONObject.setValue(JSONObject.java:1424)
    net.sf.json.JSONObject._fromMap(JSONObject.java:1168)
    net.sf.json.JSONObject.fromObject(JSONObject.java:163)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:274)
    net.sf.json.JSONArray._processValue(JSONArray.java:2513)
    net.sf.json.JSONArray.processValue(JSONArray.java:2538)
    net.sf.json.JSONArray.addValue(JSONArray.java:2525)
    net.sf.json.JSONArray._fromCollection(JSONArray.java:1056)
    net.sf.json.JSONArray.fromObject(JSONArray.java:123)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:240)
    net.sf.json.JSONObject._processValue(JSONObject.java:2655)
    net.sf.json.JSONObject.processValue(JSONObject.java:2721)
    net.sf.json.JSONObject.setInternal(JSONObject.java:2736)
    net.sf.json.JSONObject._accumulate(JSONObject.java:2635)
    net.sf.json.JSONObject.accumulate(JSONObject.java:1560)
    net.sf.json.JSONObject.accumulateAll(JSONObject.java:1582)
    net.sf.json.JSONObject.accumulateAll(JSONObject.java:1564)
    com.helical.efw.view.StageExecution.LastSevenDaysStageWiseExecution(StageExecution.java:70)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
    org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)

root cause

java.lang.IllegalArgumentException
    java.sql.Date.getHours(Date.java:177)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773)
    org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1132)
    org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:686)
    org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:715)
    org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:290)
    net.sf.json.JSONObject.defaultBeanProcessing(JSONObject.java:749)
    net.sf.json.JSONObject._fromBean(JSONObject.java:699)
    net.sf.json.JSONObject.fromObject(JSONObject.java:172)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:274)
    net.sf.json.JSONObject._processValue(JSONObject.java:2655)
    net.sf.json.JSONObject.processValue(JSONObject.java:2721)
    net.sf.json.JSONObject.setInternal(JSONObject.java:2736)
    net.sf.json.JSONObject.setValue(JSONObject.java:1424)
    net.sf.json.JSONObject._fromMap(JSONObject.java:1168)
    net.sf.json.JSONObject.fromObject(JSONObject.java:163)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:274)
    net.sf.json.JSONArray._processValue(JSONArray.java:2513)
    net.sf.json.JSONArray.processValue(JSONArray.java:2538)
    net.sf.json.JSONArray.addValue(JSONArray.java:2525)
    net.sf.json.JSONArray._fromCollection(JSONArray.java:1056)
    net.sf.json.JSONArray.fromObject(JSONArray.java:123)
    net.sf.json.AbstractJSON._processValue(AbstractJSON.java:240)
    net.sf.json.JSONObject._processValue(JSONObject.java:2655)
    net.sf.json.JSONObject.processValue(JSONObject.java:2721)
    net.sf.json.JSONObject.setInternal(JSONObject.java:2736)
    net.sf.json.JSONObject._accumulate(JSONObject.java:2635)
    net.sf.json.JSONObject.accumulate(JSONObject.java:1560)
    net.sf.json.JSONObject.accumulateAll(JSONObject.java:1582)
    net.sf.json.JSONObject.accumulateAll(JSONObject.java:1564)
    com.helical.efw.view.StageExecution.LastSevenDaysStageWiseExecution(StageExecution.java:70)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
     com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
    org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.37 lo

Please reply me

user3090158
  • 135
  • 1
  • 3
  • 14
  • Thanks greyfairer for reply,It's givin the error :"java.lang.reflect.InvocationTargetException type Exception report" for more detail I have attached full error log above – user3090158 Jan 20 '14 at 12:07
  • I m not sure, but probably you have to format `DateTime` object individually. Check related links [link](http://stackoverflow.com/questions/10442732/convert-datetime-object-java-to-json-string) – Alex Jan 20 '14 at 12:21
  • thanks alex, when I am sending full time stamp is giving the result :{"children":[{"moment":{"date":30,"day":1,"hours":14,"minutes":2,"month":11,"nanos":0,"seconds":21,"time":1388392341000,"timezoneOffset":-330,"year":113},"t":38}]} but i don't need such type of date format I neeed only YYYY-MM-DD formate of date – user3090158 Jan 20 '14 at 12:34

3 Answers3

6

You can always provide your own JsonValueProcessor to implement the encoding desired. I decided to encode dates as milliseconds that have passed since January 1, 1970, 00:00:00 GMT, using the getTime() method.

Here it is some sample code:

JsonConfig config = new JsonConfig();
config.registerJsonValueProcessor(java.util.Date.class, new JsonValueProcessor() {

    @Override
    public Object processArrayValue(Object value, JsonConfig jsonConfig) {
        Date[] dates = (Date[])value;
        Long[] result = new Long[dates.length];
        for (int index = 0; index < dates.length; index++) {
            result[index] = dates[index].getTime();
        }
        return result;
    }

    @Override
    public Object processObjectValue(String key, Object value, JsonConfig jsonConfig) {
        Date date = (Date)value;
        return date.getTime();
    }

});

You can then create a JSONObject as follows:

Map<String, Object> data = new HashMap<String, Object>();
data.put("myDate", new Date());
JSONObject jsonObject = (JSONObject) JSONSerializer.toJSON( data, config );
mxb
  • 3,300
  • 4
  • 20
  • 25
2

In JSON-Lib, there's a JsDateJsonBeanProcessor, but that one converts to 

{
"minutes": 13,
"seconds": 14,
"hours": 12,
"month": 5,
"year": 2007,
"day": 17,
"milliseconds": 150
}

Jackson JSON Processor is more flexible, it writes dates as milliseconds by default, but you can configure it to use ISO-8601 formatting, too, see http://wiki.fasterxml.com/JacksonFAQDateHandling

GeertPt
  • 16,398
  • 2
  • 37
  • 61
1

This answer is for Gson a Google Json library for java.

First create a type converter class as it's shown here

https://sites.google.com/site/gson/gson-type-adapters-for-common-classes-1

Supposing you are using joda time and your type converter class is named DateTimeTypeConverter, then create Gson object like this

 GsonBuilder builder = new GsonBuilder();
 builder.registerTypeAdapter(DateTime.class, new DateTimeTypeConverter());
 Gson gson = builder.create();

I've it working that way.

Hernán Eche
  • 6,529
  • 12
  • 51
  • 76