Hi Aziz,
if you use:
<field name="creationTime" type="java.util.Date">
<sql name="ctime" type="timestamp" />
</field>
in mapping.xml and create the ctime column with type DATETIME then it
works without patching castor.
Regards
Ralf
Aziz Hammadi schrieb:
Hi all!
I am just wondering while the mysql type DATETIME has not yet been
implemented. The MySQL Connector/J supports allready this type by
using java.sql.Timestamp to model it. I tried to hack the castor code
(SQLTypes.java) to map datetime to java.sql.Timestamp.class. I added
the following entry
new TypeInfo( java.sql.Types.TIMESTAMP, "datetime", =3D20
java.sql.Timestamp.class),
to the =5FtypeInfos array.
Well this little change produced the value "1989-01-24 00:00:00" in my
table. I guess it needs more modifications to handle the 00:00:00
part. What do you think=3F is this a correct concept=3F
reference:
http://www.issociate.de/board/post/18070/JConnector=5F3.0=5Fand=5FDAT=
ETIME.html
Cheers
Aziz
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
--
Syscon Ingenieurb�ro f�r
Me�- und Datentechnik GmbH
Ralf Joachim
Raiffeisenstra�e 11
D-72127 Kusterdingen
Germany
Tel. +49 7071 3690 52
Mobil: +49 173 9630135
Fax +49 7071 3690 98
Email: [EMAIL PROTECTED]
Web: www.syscon-world.de
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
