My Current data looks like this:
||ENTITY_INTERNAL_ID||LIT_STATIC_TYPE||ORIGIN_ENTITY_TYPE||ORIGIN_ENTITY_ID||LIT_STATIC_TYPE||TXT_SEQ_NUM||LIT_VALUE||
|JW1jmnij|01|DECONTRL|ENTER_SIZELB173|01|1|~OK|
|JW1jmnij|01|DECONTRL|CANCEL_SIZELB173|01|2|~Cancel|
|JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)"d]8|01|3|31000 Bytes|
|JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m(tirB|01|3|2 Bytes|
|JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)%3VV|01|3|32000 Bytes|
|JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)'g\A|01|3|63882 Bytes|
|JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)/bG$|01|3|64000 Bytes|
|JW1jmnij|01|DEDTELEM|COM1_MESSAGE_SIZE_SENDLB173|01|3|Message Size|
|JW1jmnij|01| | |01|5|Message Size Parameter|
This was pulled by the SQL query:
select entity_Internal_Id, lit_Static_Type, origin_Entity_Type, origin_Entity_Id, lit_Static_Type, txt_Seq_Num, lit_value from Wdd0d040 where entity_Internal_Id = 'JW1jmnij' and lit_Static_Type = '01' order by txt_Seq_Num
When running a similar query in hibernate:
from Wdd0d040 where wdd40Key.entityInternalId = 'JW1jmnij' and litStaticType = '01' order by wdd40Key.txtSeqNum
I get the following "formatted" results:
||Origin||SEQ_NUM||VALUE||
| {DECONTRL::ENTER_SIZELB173}|1|~OK|
|{DECONTRL::CANCEL_SIZELB173}|2|~Cancel|
|{DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB}|3|2 Bytes|
|{DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB}|3|2 Bytes|
|{DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB}|3|2 Bytes|
|{DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB}|3|2 Bytes|
|{DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB}|3|2 Bytes|
|{DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB}|3|2 Bytes|
|{ :: }|5|Message Size Parameter|
As you can see:
1. Missing the entry that starts with "DETELEM" value
2. All Values for lit_value column are the same "2 Bytes".
Additional information:
1. This happen After I run 2 queries on the table and the 3rd one shows cached data but invalid.
2. I tried to run a session.clear() but it does not seems to help.
3. I did add hibernate configuration not to use cache at any level.
cfg.setProperty("hibernate.cache.use_second_level_cache", "false");
cfg.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.NoCacheProvider");
|
|
