Re: SQL TIMESTAMP and Torque java.util.Date mapping.
Thomas Vandahl <[email protected]>
| Newsgroups | gmane.comp.jakarta.turbine.torque.user |
|---|---|
| Message-ID | <[email protected]> |
Shinkan wrote: > Maybe that is because my schema doesn't NULL the value correctly ? Here is > the column definition : > <column name="expires" > type="TIMESTAMP" > required="false" /> > And the generated SQL: > expiration TIMESTAMP, That looks ok to me. Based on this definition >> criteria.add(TestPeer.EXPIRES, (Object) null, Criteria.ISNULL) seems to be the right way to check for a null value. Unless Derby is doing something strange with TIMESTAMP columns by itself - like, for example, MySQL which would insert the current timestamp in such a column. What does Derbys documentation say about TIMESTAMP columns? Bye, Thomas.