The hibernate.max_fetch_depth is not currently available as a property in the cfg.xml...I'll add it.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Sirius Sent: Friday, March 04, 2005 7:31 AM To: Carlos Cuenca; andromda-user@lists.sourceforge.net Subject: Re: [Andromda-user] how to specify max_fetch_depth for hibernate Hi Carlos, I followed your advice, but now that proxies are enabled I get a very strange NoClassDefFoundError, without a stack trace: BUILD FAILED File...... C:\Documents and Settings\Candide\.maven\cache\maven-test-plugin-1.6. 2\plugin.jelly Element... junit Line...... 133 Column.... 41 java.lang.NoClassDefFoundError Total time: 7 seconds Finished at: Fri Mar 04 15:26:43 GMT+01:00 2005 Besides, that doesn't explain the fact that one-2-one relations become many-to-one... bernard --- Carlos Cuenca <[EMAIL PROTECTED]> wrote: > Hi Bernard, > > to get rid of all those outer joins when creating a > simple query, just > turn on the hibernate proxies. Namespace property > "hibernateProxy=true" > > Carlos > > > Bernard Sirius wrote: > > >Hi! > > > >Again, I have this problem with hibernate: a simple > >query generates an incredible amount of SQL. I was > >thinking that specifying outer-join="false" would > >solve this, but it doesn't as you probably guess. > > > >I can't figure out how to tell hibernate NOT to > >eagerly load relations. It seems to be completely > >ignorant of the "lazy=true" attribute. > > > >Now that I've set outer-join="auto", which is > >AndroMDA's default, I have hibernate complain that > >"MySQL can only use 31 tables in a join", which is > >documented in their faq > >(http://hibernate.bluemars.net/117.html#A29). > > > >So, as a last resort, as is stated there, I'd like > to > >try setting max_fetch_depth to 1 or 2, only I don't > >know how to let AndroMDA specify that. > > > >Of course please let me know if you have other > >suggestions > > > >bernard > > > >PS: the hibernate query: > > > > String query = "SELECT person FROM > >fractals.psychos.core.ontology.entity.PersonImpl " > + > > "person LEFT JOIN > person.properties > >as property WHERE " + > > "property.predicate=:pred"; > > > >the generated SQL: > > > >Hibernate: select userimpl0_.ID as ID, > >userimpl0_.USERNAME as USERNAME, userimpl > >0_.PASSWORD as PASSWORD, userimpl0_.TIMESTAMP as > >TIMESTAMP, userimpl0_.PERSON_FK > > as PERSON_FK, userimpl0_.THUMBNAIL_FK as > THUMBNAI6_, > >userimpl0_.ROLODEX_FK as R > >OLODEX_FK, userimpl0_.CALENDAR_FK as CALENDAR8_ > from > >USER userimpl0_ left outer > >join PERSON personimpl1_ on > >userimpl0_.PERSON_FK=personimpl1_.ID left outer > join > > PROPERTY properties2_ on > >personimpl1_.ID=properties2_.RESOURCE_FK left outer > jo > >in ABSTRACT_OBJECT properties2__1_ on > >properties2_.ID=properties2__1_.ID left ou > >ter join RESOURCE properties2__2_ on > >properties2_.ID=properties2__2_.ID where (p > >roperties2_.PREDICATE=? ) > >Hibernate: select personimpl0_.ID as ID10_, > >personimpl0_.FIRSTNAME as FIRSTNAME1 > >3_10_, personimpl0_.LASTNAME as LASTNAME13_10_, > >personimpl0_.BIRTHDATE as BIRTHD > >ATE13_10_, personimpl0_.MIDDLE_NAME as > >MIDDLE_N5_13_10_, personimpl0_.EMAIL as E > >MAIL13_10_, personimpl0_.PHONE as PHONE13_10_, > >personimpl0_.MOBILE as MOBILE13_1 > >0_, personimpl0_.WORK_PHONE as WORK_PHONE13_10_, > >personimpl0_.PERSONAL_EMAIL as > >PERSONA10_13_10_, personimpl0_.ICQ_NUMBER as > >ICQ_NUMBER13_10_, personimpl0_.MSN_ > >ID as MSN_ID13_10_, personimpl0_.SKYPE_ID as > >SKYPE_ID13_10_, personimpl0_.SKYPE_ > >NUMBER as SKYPE_N14_13_10_, personimpl0_.FAX as > >FAX13_10_, personimpl0__2_.TIMES > >TAMP as TIMESTAMP0_10_, personimpl0__2_.CORE_M_D_FK > as > >CORE_M_D3_0_10_, userimpl > >1_.ID as ID0_, userimpl1_.USERNAME as USERNAME0_, > >userimpl1_.PASSWORD as PASSWOR > >D0_, userimpl1_.TIMESTAMP as TIMESTAMP0_, > >userimpl1_.PERSON_FK as PERSON_FK0_, u > >serimpl1_.THUMBNAIL_FK as THUMBNAI6_0_, > >userimpl1_.ROLODEX_FK as ROLODEX_FK0_, u > >serimpl1_.CALENDAR_FK as CALENDAR8_0_, > imageimpl2_.ID > >as ID1_, imageimpl2__1_.ME > >DIA_PATH as MEDIA_PATH2_1_, > >imageimpl2__1_.ORIGINAL_MEDIA_PATH as > ORIGINAL3_2_1_ > >, imageimpl2__1_.MEDIA_U_R_L as MEDIA_U_4_2_1_, > >imageimpl2__1_.IS_REMOTE as IS_R > >EMOTE2_1_, imageimpl2__3_.TIMESTAMP as > TIMESTAMP0_1_, > >imageimpl2__3_.CORE_M_D_FK > > as CORE_M_D3_0_1_, rolodeximp3_.ID as ID2_, > >rolodeximp3_.TIMESTAMP as TIMESTAMP > >2_, calendarim4_.ID as ID3_, calendarim4_.TIMESTAMP > as > >TIMESTAMP3_, coremetada5_ > >.ID as ID4_, coremetada5_.TYPE as TYPE4_, > >coremetada5_.LANGUAGE as LANGUAGE4_, c > >oremetada5_.DATE_FK as DATE_FK4_, > >coremetada5_.TEMPORAL_COVERAGE_FK as TEMPORAL5 > >_4_, coremetada5_.IDENTIFIER_FK as IDENTIFI6_4_, > >coremetada5_.PUBLISHER_FK as PU > >BLISHE7_4_, coremetada5_.OBJECT_FK as OBJECT_FK4_, > >coremetada5_.CREATOR_FK as CR > >EATOR_FK4_, datetermim6_.ID as ID5_, > >datetermim6_.AVAILABLE_FK as AVAILABL2_5_, > >datetermim6_.DATE_CREATED_FK as DATE_CRE3_5_, > >datetermim6_.DATE_ACCEPTED_FK as D > >ATE_ACC4_5_, datetermim6_.DATE_COPYRIGHTED_FK as > >DATE_COP5_5_, datetermim6_.DATE > >_SUBMITTED_FK as DATE_SUB6_5_, > datetermim6_.VALID_FK > >as VALID_FK5_, datetermim6_ > >.DATE_MODIFIED_FK as DATE_MOD8_5_, > >datetermim6_.DATE_ISSUED_FK as DATE_ISS9_5_, > >abstractte7_.ID as ID6_, case when > abstractte7__1_.ID > >is not null then 1 when ab > >stractte7__2_.ID is not null then 2 when > >abstractte7_.ID is not null then 0 end > >as clazz_6_, abstractte7__1_.START_TIME as > >START_TIME45_6_, abstractte7__1_.END_ > >TIME as END_TIME45_6_, abstractte7__2_.TIME as > >TIME46_6_, resourceim8_.ID as ID7 > >_, case when resourceim8__3_.ID is not null then 1 > >when resourceim8__4_.ID is no > >t null then 2 when resourceim8__5_.ID is not null > then > >3 when resourceim8__6_.ID > > is not null then 4 when resourceim8__7_.ID is not > >null then 5 when resourceim8_ > >_8_.ID is not null then 6 when resourceim8__11_.ID > is > >not null then 7 when resou > >rceim8__12_.ID is not null then 8 when > >resourceim8__15_.ID is not null then 9 wh > >en resourceim8__2_.ID is not null then 10 when > >resourceim8__9_.ID is not null th > >en 11 when resourceim8__10_.ID is not null then 12 > >when resourceim8__13_.ID is n > >ot null then 13 when resourceim8__14_.ID is not > null > >then 14 when resourceim8__1 > >6_.ID is not null then 15 when resourceim8__17_.ID > is > >not null then 16 when reso > >urceim8__18_.ID is not null then 17 when > >resourceim8__19_.ID is not null then 18 > > when resourceim8__20_.ID is not null then 19 when > >resourceim8__21_.ID is not nu > >ll then 20 when resourceim8__1_.ID is not null then > 21 > >when resourceim8__22_.ID > >is not null then 22 when resourceim8__23_.ID is not > >null then 23 when resourceim > >8_.ID is not null then 0 end as clazz_7_, > >resourceim8_.TIMESTAMP as TIMESTAMP0_7 > >_, resourceim8_.CORE_M_D_FK as CORE_M_D3_0_7_, > >resourceim8__2_.MEDIA_PATH as MED > >IA_PATH2_7_, resourceim8__2_.ORIGINAL_MEDIA_PATH as > >ORIGINAL3_2_7_, resourceim8_ > >_2_.MEDIA_U_R_L as MEDIA_U_4_2_7_, > >resourceim8__2_.IS_REMOTE as IS_REMOTE2_7_, r > >esourceim8__3_.TEXT as TEXT3_7_, > >resourceim8__9_.STRING_VALUE as STRING_V2_9_7_, > > resourceim8__9_.BOOLEAN_VALUE as BOOLEAN_3_9_7_, > >resourceim8__9_.FLOAT_VALUE as > > FLOAT_VA4_9_7_, resourceim8__9_.INT_VALUE as > >INT_VALUE9_7_, resourceim8__9_.DAT > >E_VALUE as DATE_VALUE9_7_, > resourceim8__9_.VALUE_TYPE > >as VALUE_TYPE9_7_, resourc > >eim8__9_.PREDICATE as PREDICATE9_7_, > >resourceim8__10_.PLACE_FK as PLACE_FK10_7_, > > resourceim8__10_.TIME_INFO_FK as TIME_INF3_10_7_, > >resourceim8__13_.FIRSTNAME as > > FIRSTNAME13_7_, resourceim8__13_.LASTNAME as > >LASTNAME13_7_, resourceim8__13_.BI > >RTHDATE as BIRTHDATE13_7_, > >resourceim8__13_.MIDDLE_NAME as MIDDLE_N5_13_7_, > reso > >urceim8__13_.EMAIL as EMAIL13_7_, > >resourceim8__13_.PHONE as PHONE13_7_, resource > >im8__13_.MOBILE as MOBILE13_7_, > === message truncated === __________________________________ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/ ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user
