[json-lib-user] Date to JSON

[Petr K. <kob...@gm...>]

Hi list,

how are handled dates in json-lib? I have this code:

    JsonConfig conf = new JsonConfig();
    conf.addIgnoreFieldAnnotation("permissions");

    Session session = JflyRequestCycle.get().getDBSession();

    List<User> users = (List<User>)session.createQuery(
      "select j_user from User as j_user order by j_user.nickname"
    ).list();
    return JSONArray.fromObject(users, conf);

and this throws this exception:

    ...

Caused by: net.sf.json.JSONException:
java.lang.reflect.InvocationTargetException
        at net.sf.json.JSONObject._fromBean(JSONObject.java:987)
        at net.sf.json.JSONObject.fromObject(JSONObject.java:168)
        at net.sf.json.AbstractJSON._processValue(AbstractJSON.java:265)
        at net.sf.json.JSONObject._processValue(JSONObject.java:2808)
        at net.sf.json.JSONObject.processValue(JSONObject.java:2874)
        at net.sf.json.JSONObject.setInternal(JSONObject.java:2889)
        at net.sf.json.JSONObject.setValue(JSONObject.java:1577)
        at net.sf.json.JSONObject._fromBean(JSONObject.java:934)
        at net.sf.json.JSONObject.fromObject(JSONObject.java:168)
        at net.sf.json.AbstractJSON._processValue(AbstractJSON.java:265)
        at net.sf.json.JSONArray._processValue(JSONArray.java:2514)
        at net.sf.json.JSONArray.processValue(JSONArray.java:2539)
        at net.sf.json.JSONArray.addValue(JSONArray.java:2526)
        at net.sf.json.JSONArray._fromCollection(JSONArray.java:1057)
        at net.sf.json.JSONArray.fromObject(JSONArray.java:123)
        at com.jfly.core.services.UserService.list(UserService.java:30)
        ... 38 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:2155)
        at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1323)
        at org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:762)
        at org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:837)
        at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:426)
        at net.sf.json.JSONObject._fromBean(JSONObject.java:918)
        ... 53 more
Caused by: java.lang.IllegalArgumentException
        at java.sql.Date.getHours(Date.java:143)
        ... 63 more

I tracked it down and it's in java.sql.Date.getHours:

    public int getHours() {
	throw new java.lang.IllegalArgumentException();
    }

Is this my problem, json-lib problem or it's somewhere else?

Thanks for reply
- Petr