Handling Torque Date data types

["Daniel B. Ramagem" <da...@ssaihq.com>]

My application Torque schema has a column "startDate" of type "DATETIME".
The SQL and the tables get generated without a problem into a MySQL
database.  But when I try to insert a new row into the table via Peers:

Criteria crit = new Criteria();
crit.add(BabyPeer.BIRTHDATE, "2001-12-03 09:00");
Object o = BabyPeer.doInsert(crit);

I get the following error:

com.workingdogs.village.DataSetException: Bad date value - Java Timestamp
Objects cannot be earlier than 1/1/70 at
com.workingdogs.village.Value.asTimestamp(Value.java:702) at
com.workingdogs.village.Value.setPreparedStatementValue(Value.java:272) at
...

I've tried a number of variations on the above date format to no avail.  Can
anyone help?

Also, what *are* all of the allowed Torque datatypes?  The Torque
documentation doesn't define them.

Thanks,

Daniel.


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>