the new database still gives headaches: we are satisfied with the characters, but found another surprise: around midnight we get timestamps through jconnect which differ 1 hour to real time. that is at 00:15 we get the time 23:12 from day before. isql shows 00:15 today. we looked for timezone thing, found nothing strange. the weird thing is, that this time-offset shows only between 00:00 and 01:00 - after that, both isql-timestamps, jconnect-timestamps and wall clock timestamp are in sync. does this sound similar to someone?
we are still on ASA10, jonnect7 and java6.
asked 31 May '12, 11:21
There is an issue that is caused by a bug with the jConnect driver where BIGDATETIME values are incorrectly handled between midnight and 1 AM.
An updated driver can be obtained from SDK 15.5 ESD #08 or higher that resolves the issue.
answered 31 May '12, 12:38