Andrus Adamchik <andru..bjectstyle.org> wrote:
> That's strange ... The original mapping was incorrect. Out of 3
> time-related JDBC types (DATE, TIME, TIMESTAMP), only TIMESTAMP provides
> both date and time portions. So that fix still applies.
>
> Not sure what else can be wrong :-/ Are you sure that old *.map.xml copy
> is not sitting somewhere in CLASSPATH?
Also, what version of Oracle are you using?
Oracle 9 and 10 might need a different extended type mapping.
Index: types.xml
===================================================================
RCS file:
/cvsroot/cayenne/cayenne/src/cayenne/java/org/objectstyle/cayenne/dba/oracle/types.xml,v
retrieving revision 1.3
diff -u -r1.3 types.xml
--- types.xml 29 Oct 2003 16:58:07 -0000 1.3
+++ types.xml 24 Feb 2005 15:45:26 -0000
..-64,7 +64,7 @@
<db-type name="DATE"/>
</jdbc-type>
<jdbc-type name="TIMESTAMP">
- <db-type name="DATE"/>
+ <db-type name="TIMESTAMP"/>
</jdbc-type>
<jdbc-type name="TINYINT">
<db-type name="SMALLINT"/>
> > Hi,
> >
> > No, it does not work :-(. Any idea how to find the problem ?
> >
> > Thanks and best regards
> > René
> >
> >> -----Ursprüngliche Nachricht-----
> >> Von: Andrus Adamchik [mailto:andru..bjectstyle.org]
> >> Gesendet: Donnerstag, 24. Februar 2005 15:17
> >> An: René Kulschewski
> >> Betreff: Re: Problem with Date/Time-part
> >>
> >> René,
> >>
> >> Just change DATE to TIMESTAMP for DbEntity - this should fix
> >> it. Hope this helps.
> >>
> >> Andrus
> >>
> >>
> >> > Hello,
> >> >
> >> > I have a table in Oracle with column of type "Date". In
> >> this column is
> >> > a value with Date+Time (checked that with SQLplus).
> >> > In Cayenne-modeler this column is DATE (DbEntity) and
> >> java.util.Date
> >> > (ObjEntity). But when i fetch this value with Cayenne and
> >> assign it to
> >> > another variable i get only the "Date"-part, time is "00:00:00".
> >> >
> >> > Do you have any idea what's wrong ?
This archive was generated by hypermail 2.0.0 : Thu Feb 24 2005 - 10:46:56 EST