Thanks for the response Jim, I forgot to mention that I had used the Temporal annotation at one point and that it did not work in that case either.
To be sure, I readded and tested again with the same result. As a side note, I am usinf the java.sql.Date instead of java.util! Lastly, the timezone can't be the problem as both the client I am on, and the server are on the same zone and synch'd. Further, I write out timestamps to the server to log creation and modification and these are correct, although truncated :( and afaik, postgres does not store that for a date type anyway ... Cheers! > -----Ursprüngliche Nachricht----- > Von: Jim O'Rourke [mailto:[email protected]] > Gesendet: Mittwoch, 29. Juni 2011 16:59 > An: [email protected] > Betreff: Re: Problem retrieving a row from the db with a > composite key with a date as a part of the key > > Could it be a timezone difference between the jvm and > Postgres server? > > Might also be that your persistent property needs to be annotated with > @Temporal(javax.persistence.DATE) to match the sql column > declaration. > > > > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/Problem-retrieving-a-row-f > rom-the-db-with-a-composite-key-with-a-date-as-a-part-of-the-k > ey-tp6528286p6529300.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. >
