Re: Problems with Date in Cayenne 2.0.4

From: Alessio Giovanni Baroni (alessiogiovanni.baron..mail.com)
Date: Wed Jan 28 2009 - 10:05:28 EST

  • Next message: Michael Gentry: "Re: Problems with Date in Cayenne 2.0.4"

    A simple example?

    Thanks.

    2009/1/28 Andrus Adamchik <andru..bjectstyle.org>

    > 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 - 10:05:56 EST