Hi Andy,
we use the following mapping
<field name="updatedAt" type="date">
<sql name="UMU_UPD" type="char[yyyy/MM/dd HH:mm:ss.SSS]" />
</field>
but you will see another problem coming up with this mapping.
There had been bug 1045 in castor that still appear in 0.9.4.3 but according to
bugzilla should be solved in CVS. In 0.9.4.3 and previeous versions of castor
the space in the format string caused the problem.
You have 3 possibilities to solve this problem:
- use CVS version (not tested by myself)
- use another format string (e.g. yyyy/MM/dd-HH:mm:ss.SSS)
- get my patch for 0.9.4.2 or 3 attached to bug 1045 from bugzilla
Regards
Ralf
----- Original Message -----
From: "Andy Hebeisen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 7:16 PM
Subject: Re: [castor-dev] RollbackException with JBOSS
> Hi Ralf
>
> Thanks for your answer.
> You wrote:
> > We did some test about mapping java datatypes to a oracle database and also
> > recogized strange things at date and timestamp.
> >
> > - it seams that timestamp datatype is not available before oracle 9.0
> > we could not find any information in 8.0 manuals
> So switching to 9i will solve this?
>
> > - java.util.Date and also oracle date datatype handles millisecond values but
> > the jdbc datatype java.sql.Date has only day resolution. According to the
> > resolution java.sql.Date values of java.util.Date are truncated to day and
> > will cause a ObjectModifiedException.
> damn.. why didn't I realized this before ;-)
>
> > - we did not do tests with Time as we wanted to store all in one DB column.
> mee too.
>
> > As we could not find any solution with oracle date datatype we desided to
> > use castors parameterized converter and store dates as varchar.
> Cool... can you mail this setting to the list?
> Just in case somebody else (or me) wants to stay on 8i.
>
> Maybe, it will help Koen too with his SQL-Server (the guy who startet
> this thread).
>
> Thanks again and bye...
> Andy
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
