Andrus Adamchik wrote:
>
> On May 14, 2005, at 1:01 AM, Robert Zeigler wrote:
>
>> From looking at the modeler, it appears that only date, time, and
>> timestamp fields are supported.
>
>
> This only means that date, time, and timestamp are the choices JDBC
> provides. MySQL itself can use any of its (compatible) column types. So
> you can map your column in Cayenne as (JDBC) "TIMESTAMP", but on MySQL
> end you can use (MySQL specific) type DATETIME, which I think is the
> type you are looking for - nullable date + time.
Yup... datetime is what I'm looking for. :)
>
> The only caveat is when you use CayenneModeler for schema generation,
> you'll need to save the generated script, replace TIMESTAMP references
> (a default mapping from JDBC to MySQL types used by Cayenne) to
> DATETIME, and run it manually. Hopefully this part will become
> customizable in Cayenne 1.2.
>
Thanks for the info. That helps considerably.
Having it be customizable from the modeler would also be very nice. :)
Robert
This archive was generated by hypermail 2.0.0 : Sat May 14 2005 - 09:44:23 EDT