Hi everyone. I have a DB2 table that has a Timestamp column as primary key. My OJB code was just right with the OJB 1.0.0 version. I've tried to upgrade the OJB to the 1.0.1 version. For some reason (I suspect caching), my select query doesn't work anymore. Here is some data:
Here is the DB2 table. See that in 2 differents seconds, we have 6 events: 4 in the first second and 2 in the second. EVENT_TMST (Primary Key) USERID EVENT_MSG -------------------------- ---------- ---------------------------------------------- 2004-11-05 11:08:21.603950 JECROTEA Message #1 2004-11-05 11:08:21.760608 SLALIBER Message #2 2004-11-05 11:08:21.798037 TITI Message #3 2004-11-05 11:08:21.829017 TOTO Message #4 2004-11-05 11:08:22.080724 TYTY Message #5 2004-11-05 11:08:22.180625 TUTU Message #5 If I use my OJB version 1.0.1 query , I obtain this result : EVENT_TMST (Primary Key) USERID EVENT_MSG -------------------------- ---------- ---------------------------------------------- 2004-11-05 11:08:21.603950 JECROTEA Message #1 2004-11-05 11:08:21.603950 JECROTEA Message #1 2004-11-05 11:08:21.603950 JECROTEA Message #1 2004-11-05 11:08:21.603950 JECROTEA Message #1 2004-11-05 11:08:22.080724 TYTY Message #5 2004-11-05 11:08:22.080724 TYTY Message #5 I red this in the changes.txt file from version 1.0.1: CHANGES: - Performance improvement in RsIterator, first only map PK values from the result set and check against the cache. If no match map all field values from result set to internal Map class (old version always maps all values from the result set to the internal Map class). So I tried to add "another" primary key in my repository.xml file and it worked. So I guess something is truncated in the caching hashmap. Any though on this? ----------------------------------------------------------------------------- Jean-Francois Croteau IBM Canada Ltée (Bromont) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]