I have turned on "show_sql" to try to understand what is going on.
==============================================
Hibernate: select prospect0_.PRP_PROSPECT_ID as PRP_PROS1_, prospect0_.PRP_COMPANY_NAME as PRP_COMP2_, prospect0_.PRP_CORP_ADDRESS_1 as PRP_CORP3_, prospect0_.PRP_CORP_ADDRESS_2 as PRP_CORP4_, prospect0_.PRP_CORP_CITY as PRP_CORP5_, prospect0_.PRP_CORP_STATE as PRP_CORP6_, prospect0_.PRP_CORP_ZIP as PRP_CORP7_, prospect0_.PRP_CORP_PHONE as PRP_CORP8_, prospect0_.PRP_CONTRACT_CNT as PRP_CONT9_, prospect0_.CNT_CONTACT_ID as CNT_CON10_ from MIS2.MIS_PROSPECTS prospect0_ left outer join MIS2.MIS_CONTACTS contact1_ on prospect0_.CNT_CONTACT_ID=contact1_.CNT_CONTACT_ID where (prospect0_.PRP_CORP_CITY like ? )
Hibernate: select contact0_.CNT_CONTACT_ID as CNT_CONT1_1_, contact0_.CNT_FIRST_NAME as CNT_FIRS2_1_, contact0_.CNT_LAST_NAME as CNT_LAST3_1_, contact0_.CTR_CONTACT_TYPE as CTR_CONT4_1_, contacttyp1_.CTR_CONTACT_TYPE as CTR_CONT1_0_, contacttyp1_.CTR_DESCRIPTION as CTR_DESC2_0_ from MIS2.MIS_CONTACTS contact0_ left outer join MIS2.MIS_CONTACT_TYPE_REF contacttyp1_ on contact0_.CTR_CONTACT_TYPE=contacttyp1_.CTR_CONTACT_TYPE where contact0_.CNT_CONTACT_ID=?
Hibernate: select contact0_.CNT_CONTACT_ID as CNT_CONT1_1_, contact0_.CNT_FIRST_NAME as CNT_FIRS2_1_, contact0_.CNT_LAST_NAME as CNT_LAST3_1_, contact0_.CTR_CONTACT_TYPE as CTR_CONT4_1_, contacttyp1_.CTR_CONTACT_TYPE as CTR_CONT1_0_, contacttyp1_.CTR_DESCRIPTION as CTR_DESC2_0_ from MIS2.MIS_CONTACTS contact0_ left outer join MIS2.MIS_CONTACT_TYPE_REF contacttyp1_ on contact0_.CTR_CONTACT_TYPE=contacttyp1_.CTR_CONTACT_TYPE where contact0_.CNT_CONTACT_ID=?
============================
Any and all help is appreciated, sganzman
|