Hi Werner
well I am using the last casotr version and I get this error :
org.exolab.castor.jdo.DatabaseNotFoundException: Nested error:
org.exolab.castor.mapping.MappingException: The SQL type datetime is
not supported in this release:
here is my mapping configuration:
<field name="fileDate" type="java.util.Date">
<sql name="file_date" type="datetime"/>
</field>
On 6/14/05, Werner Guttmann <[EMAIL PROTECTED]> wrote:
> Aziz,
>
> first off, what makes you think that the mySQL datetime type is not supported
> ? Second, many of the mySQL types suffer from the fact that they don't
> support fractions of a second (i.e. by simply dropping the fraction value),
> and hence cannot be used to persist java.sql.Timestamp values. One could of
> course use LONGs to persist time stamps.
>
> Werner
>
> wg> -----Original Message-----
> wg> From: Aziz Hammadi [mailto:[EMAIL PROTECTED]
> wg> Sent: Tuesday, June 14, 2005 1:20 PM
> wg> To: [email protected]
> wg> Subject: [castor-user] [JDO] support for the mysql type datetime
> wg>
> wg>
> wg> Hi all!
> wg> I am just wondering while the mysql type DATETIME has not yet been
> wg> implemented. The MySQL Connector/J supports allready this type by
> wg> using java.sql.Timestamp to model it. I tried to hack the
> wg> castor code
> wg> (SQLTypes.java) to map datetime to java.sql.Timestamp.class. I added
> wg> the following entry
> wg> new TypeInfo( java.sql.Types.TIMESTAMP, "datetime", =3D20
> wg> java.sql.Timestamp.class),
> wg> to the =5FtypeInfos array.
> wg>
> wg> Well this little change produced the value "1989-01-24
> wg> 00:00:00" in my
> wg> table. I guess it needs more modifications to handle the 00:00:00
> wg> part. What do you think=3F is this a correct concept=3F
> wg>
> wg> reference:
> wg> http://www.issociate.de/board/post/18070/JConnector=5F3.0=5F
> wg> and=5FDAT=
> wg> ETIME.html
> wg>
> wg>
> wg> Cheers
> wg> Aziz
> wg>
> wg> -------------------------------------------------
> wg> If you wish to unsubscribe from this list, please
> wg> send an empty message to the following address:
> wg>
> wg> [EMAIL PROTECTED]
> wg> -------------------------------------------------
> wg>
> wg>
>
--
Aziz Hammadi Lamrani
email: [EMAIL PROTECTED]
url: http://user.et-cip.rub.de/hammadi/
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
