java - More than one "one to many" association using Detached Criteria (XML Based Hibernate Configuration) -


i trying join 3 tables using detached criteria class of hibernate.

i have 3 tables student,student_correspond,student_courses

primary keys of tables 

**table names**            **primary keys**  student                     inqry_id  student_correspond          student_crsp_id  student_courses             course_cd

select *from db01.student inner join db01.student_correspond on db01.student.inqry_id =db01.student_correspond.inqry_id inner join db01.student_courses on db01.student_courses.course_cd=db01.student.course_cd

actual db results above query 250 in database.

i want achieve above query using detached criteria.

in studentdo.hbm.xml,i have added following code when ran application it's not displaying results.i.e

the results count zero.

studentdo.hbm.xml

<set name="studentids" lazy="true" inverse="true" cascade="none" sort="unsorted" batch-size="10"> <key><column name="inqry_id" /></key> <one-to-many class="com.test.studentcorrespondencedo"/> </set>  <set name="coursecodes" lazy="true" inverse="true" cascade="none" sort="unsorted" batch-size="10"> <key><column name="course_cd"/></key> <one-to-many class="com.test.studentcoursesdo"/> </set>

i have added respected setter , getter methods in studentdo.java file.

my application main file looks follows

detachedcriteria detachedcriteria =detachedcriteria.forclass(studentdo.class); detachedcriteria.createcriteria("studentids","stuids",criteria.inner_join);  detachedcriteria.createcriteria("coursecodes","coursecds",criteria.inner_join); list l = gethibernatetemplate().findbycriteria(detachedcriteria); system.out.println(l.size());

the result zero.

but when have coded (only 2 tables joining )  ----------------------------------------------------------------------  select *from  db01.student  inner join db01.student_correspond on db01.student.inqry_id =db01.student_correspond.inqry_id

actual db results count 10.

i want achieve above query using detached criteria.

studentdo.hbm.xml 

<set name="studentids" lazy="true" inverse="true" cascade="none"    sort="unsorted" batch-size="10"> <key><column name="inqry_id" /></key> <one-to-many class="com.test.studentcorrespondencedo"/> </set>

i have added respected setter , getter methods in studentdo.java file. when ran application it's displaying correct results. 10

my application main file looks follows 2 tables

detachedcriteria detachedcriteria =detachedcriteria.forclass(studentdo.class); detachedcriteria.createcriteria("studentids","stuids",criteria.inner_join);  list l = gethibernatetemplate().findbycriteria(detachedcriteria); system.out.println(l.size());

as,i mentioned joins of 2 tables working fine.but 3 tables joining not working. please 1 provide solution problem.it great helpful side.

thanks lot.


-

Comments

Post a Comment

Popular posts from this blog

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

Image
i having issues populating data in subreport in title band of main report. data populated correctly in subreport in detail band of main report. trying find wrong in json query. appreciated. json sample data source (expenses.json) { "expenses": { "date": "8 sep 2016", "accounts": [ { "title": "xyz corp (111)", "accountname": "xyz corp", "accountnumber": "111", "transactions": [ { "date": "21 jun 2016", "name": "gas", "price": "17.50" }, { "date": "12 may 2016", "name": "shopping", "price": "111.99" }, { "date": "30 apr 2016", "name"
Read more

mapreduce - Resource manager does not transit to active state from standby -

one spark job running more 23 days , caused resource manager crash. after restarting resource manager istance (there 2 of them in our cluster) both of them stayed in standby state. and getting error: error org.apache.hadoop.yarn.server.resourcemanager.resourcemanager failed load/recover state org.apache.hadoop.yarn.exceptions.yarnexception: application id application_1470300000724_40101 present! cannot add duplicate! we not kill 'application_1470300000724_40101' yarn resource manager not working. killed instances unix level on nodes dint work. have tried rebooting nodes , still same. somewhere 1 entry of job still there , preventing resource manager elected active. using cloudera 5.3.0 , can see issue has been addressed , resolved in cloudera 5.3.3. @ moment need workaround past now. to resolve issue can format rmstatestore executing below command: yarn resourcemanager -format-state-store but careful clear application history executed befor
Read more

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri
Read more