Task #1352
IB_CUST_PROFILE Database
| Status: | Work Completed-End life cycle | Start date: | December 13, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Wong Bernard | % Done: | 100% | |
| Category: | Report | Spent time: | - | |
| Target version: | - |
Description
Hi Bernard,
updated_date column on IB_CUST_PROFILE Database is not updated, please help me to check on this,
Thanks,
History
#1
Updated by Wong Bernard almost 13 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 50
In progress. Added coded to update the Update Date and Update By values, but the Update Date is not being updated.
#2
Updated by Wong Bernard almost 13 years ago
In progress. Values fetched from JDBC/Hibernate does not match with database actual data:
setLastLoginDate: 2011-12-12 16:02:13.702
setUpdatedDate: 2011-12-02 15:27:20.74
IBLoginPasswordServices Last Login Date: 2011-12-12 16:02:13.702
IBLoginPasswordServices Updated Date: 2011-12-02 15:27:20.74
setLastLoginDate: Wed Dec 14 16:07:48 SGT 2011
updateDatabase Last Login Date: Wed Dec 14 16:07:48 SGT 2011
updateDatabase Updated Date: 2011-12-02 15:27:20.74
Wed Dec 14 16:07:48 SGT 2011
2011-12-02 15:27:20.74
setLastLoginDate: 2011-12-12 16:07:48.964
setUpdatedDate: 2011-11-30 15:27:20.74
IBLoginPasswordServices Last Login Date: 2011-12-12 16:07:48.964
IBLoginPasswordServices Updated Date: 2011-11-30 15:27:20.74
setLastLoginDate: Wed Dec 14 16:13:28 SGT 2011
updateDatabase Last Login Date: Wed Dec 14 16:13:28 SGT 2011
updateDatabase Updated Date: 2011-11-30 15:27:20.74
Wed Dec 14 16:13:28 SGT 2011
2011-11-30 15:27:20.74
setLastLoginDate: 2011-12-12 16:13:28.728
setUpdatedDate: 2011-11-28 15:27:20.74
IBLoginPasswordServices Last Login Date: 2011-12-12 16:13:28.728
IBLoginPasswordServices Updated Date: 2011-11-28 15:27:20.74
setLastLoginDate: Wed Dec 14 16:26:33 SGT 2011
setUpdatedDate: 2011-11-28 15:27:20.74
updateDatabase Last Login Date: Wed Dec 14 16:26:33 SGT 2011
updateDatabase Updated Date: 2011-11-28 15:27:20.74
Wed Dec 14 16:26:33 SGT 2011
2011-11-28 15:27:20.74
The values in bold are the data saved into database, Last Login Date and Updated Date respectively.
The values in bold and italic are data that was returned from database during Login.
There is an inconsistency when RIB is fetching these date values and because of this, also updates the two column wrongly.
#3
Updated by Wong Bernard almost 13 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
- % Done changed from 50 to 100
Fixed. Caused by IB_CUST_PROFILE using datetime2 instead of datetime data type.
#4
Updated by Wong Bernard almost 13 years ago
- File IB_CUST_PROFILE.sql added