Re: Dates inserted into Oracle do not have Minutes / Seconds?

From: Mike Kienenberger (mkienen..mail.com)
Date: Mon Nov 28 2005 - 14:45:54 EST

  • Next message: Andrus Adamchik: "Re: Dates inserted into Oracle do not have Minutes / Seconds?"

    This might be relevent.

    Some of the problem is simply due to incompatible Oracle releases.

    http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-201

    On 11/28/05, Ingo Feulner <ing..eulner-tech.com> wrote:
    > Hi,
    >
    > meanwhile I "solved" this issue. Problem is, that the DBAttribute
    > mapping of a DATE Column maps to to DATE in the model, and not to
    > TIMESTAMP.
    > There is a class org.objectstyle.cayenne.access.types.UtilDateType
    > which checks the DBAttribute and converts a java.util.Date then to
    > the appropriate jdbc class.
    > But Oracle allows by default to save date + time in a DATE type, so I
    > would consider this as a bug.
    >
    > What do you think?
    >
    > Regards, Ingo.
    >
    >
    > Am 24.11.2005 um 19:55 schrieb Ingo Feulner:
    >
    > > Hi,
    > >
    > > all our inserted dates into an Oracle (10gR2) database are missing the
    > > minutes and seconds.
    > > The mapping is DB Type DATE to java.util.Date
    > > Is there a known issue (JDBC driver, NLS_LANG settings, whatever)
    > > (Haven't found one...).
    > >
    > > We're using Cayenne 1.1.3.
    > >
    > > Thanks for any help, Ingo.
    > >
    > >
    >
    >

    This archive was generated by hypermail 2.0.0 : Mon Nov 28 2005 - 14:45:56 EST