Hi ,
I have Query as follows ,
select * from AUDIT_LOG where DOC_ID in (select doc_id
from INFORMATION where DOC_ID =261)
I would like to implement in the createcriteria.
Can any one suggest me how to implement?
Actually I am facing problem of association .
I have 1 more tabel in addation to the above.
this is the main table called Master_DOC and DOC_ID is the primary key .this column refered by both the tables ..
Also above tables have assoction with the Master_DOC .
At the time of fetching data both the table should check whether entry for Doc_id present in the MST_DOC.
so whatever DOC_ID's exists I should get the details from the AUDIT_LOG.
What problem I am facing is that classCast exception or wrong records are populated..
since INFORMATION table has SERIAL primary key. and I have made assoction with this table in the Audit_LOG and refering to DOC_Id but
hiberte is always firing query as Audit_LOG.doc_ID = Information.SERIAL.
Please help me ................................
Thanks in advance.
|