Re: SQL TIMESTAMP and Torque java.util.Date mapping.

Shinkan <[email protected]>
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <[email protected]>
Really thanks for your support.

Derby doc doesn't say much about this, but it seems that I have to specify
default="CURRENT_TIMESTAMP" to make them filled.
In fact the behavior is good, by not adding "default" clause, and adding
required = "false", I expect my DB to init it to NULL or equivalent.

Then, don't worry as I just discovered problem didn't come from Derby or
Torche, but from me using Java :D
I store UNIX timestamps in XML files (they are in SECONDS), then I try to
build java.util.Date with Long parse of these timestamp ... BUT, Java
expects milliseconds ...
As I stored my results in DB, all my data dates were buggy.


-- 
Pierre.
Some people, when confronted with a problem, think "I know, I'll use XML".
Now they have two problems. -- Jamie Zawinski / James Robertson
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.