How to write HQL select query on map elements:
HBM File:
<class name="TimerData" table="timer_data" lazy="false">
<id name="userId" type="string"/>
...........
<map name="lastExecTimeMap" lazy="false">
<key column="userId"/>
<map-key column="handleType" type="string"/>
<element column="lastExecTime" type="timestamp"/>
<!-- <element column="handle" length="1024000"/>-->
</map>
...........
</class>
I want to get value of lastExecTime for given value of userId and handleType.
Here's the HQL query:
"select letMap
from TimerData d inner join d.lastExecTimeMap as letMap
where d.userId = ? and index(letMap)=?"
This will return lastExecTime of type Timestamp... value of 'lastExecTimeMap' for given key 'handleType'
Nice tips. Very innovative... Your post shows all your effort and great experience towards your work Your Information is Great if mastered very well.
ReplyDeletepython Online training in chennai
python training institute in marathahalli
python training institute in btm
Python training course in Chennai
Nice Post! Thank you for sharing very good post, it was so Nice to read and useful to improve my knowledge as updated one, keep blogging.
ReplyDeleteIt’s great to come across a blog every once in a while that isn’t
aws training in chennai | aws training in annanagar | aws training in omr | aws training in porur | aws training in tambaram | aws training in velachery
Easy coding.Thank you for your effort.Keep blogging. Java training in Chennai | Certification | Online Course Training | Java training in Bangalore | Certification | Online Course Training | Java training in Hyderabad | Certification | Online Course Training | Java training in Coimbatore | Certification | Online Course Training | Java training in Online | Certification | Online Course Training
ReplyDeleteDamien Grant
ReplyDeleteDamien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
I hope you keep blogging and sharing your design idea. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject. Nice post. It is really interesting.
ReplyDeleteAws Training in Chennai
Aws Training in Velachery
Aws Training in Tambaram
Aws Training in Porur
Aws Training in Omr
Aws Training in Annanagar
I really liked your blog article.Really thank you! Really Cool.
ReplyDeleteMuleSoft training
python training
Angular js training
selenium trainings
sql server dba training