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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]