Re: Problems with Date in Cayenne 2.0.4

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jan 28 2009 - 09:58:35 EST

  • Next message: Alessio Giovanni Baroni: "Re: Problems with Date in Cayenne 2.0.4"

    I guess that's how Oracle driver returns the metadata for the DATE
    column in the ResultSet. The workaround is to use #result() directive
    in the SQL:

        http://cayenne.apache.org/doc20/scripting-sqltemplate.html

    Hope this helps,

    Andrus

    On Jan 28, 2009, at 4:48 PM, Alessio Giovanni Baroni wrote:

    > Hi to all,
    > I have the following code:
    >
    > .............
    > query = new SQLTemplate("SELECT FOO FROM BAR");
    > results = ctxt.performQuery(Bar.class, query);
    > for(int i = 0; i < results.size() - 1; ++i)
    > {
    > Bar f = (Bar)results.get(i);
    > ...... (f.getFoo());
    > ....................
    > }
    >
    > In the Oracle DB the field FOO is a DATE and I map it to
    > java.util.Date.
    > When I do .getFoo(), the date that I have is without the
    > hours/minutes/seconds.
    > Why? How do I resolve it?
    >
    > Thanks.

    This archive was generated by hypermail 2.0.0 : Wed Jan 28 2009 - 09:59:07 EST