headers
Martin Taal | 1 Sep 02:05

Java JPA Annotation Syntax Support

Hi,
For those on the svn version and willing to try things out.

I have added the possibility to specify jpa annotations using the java source code syntax. This 
makes it probably much easier to specify jpa annotations in the model.
To use this format the eannotation should have the source teneo.jpa (or teneo.hibernate for 
hibernate specific annotations).
As an example for (in xml schema):
   <xsd:complexType name="Printer">
  	<xsd:annotation>
		<xsd:appinfo source="teneo.jpa">
			@SecondaryTable(name="THETONER"
				pkJoinColumns={@PrimaryKeyJoinColumn(name="PRINTER_ID")})
		</xsd:appinfo>
     </xsd:annotation>
     <xsd:sequence>....</sequence>

other example:

       <xsd:element name="tonerMake" type="xsd:string">
	 	<xsd:annotation>
			<xsd:appinfo source="teneo.jpa">@Column(table="THETONER")</xsd:appinfo>
	    </xsd:annotation>
       </xsd:element>

more complex Hibernate specific example:

		<xsd:appinfo source="teneo.hibernate">
@GenericGenerator(name="hibseq", strategy = "hilo",
     parameters = {
(Continue reading)

Permalink | Reply | 0 comments |
headers
Hui Gao | 1 Sep 10:25
Picon

How can I set the property 'hibernate.jdbc.batch_size'

Hi Martin,

I use Elver connected with the HSQLDB. I want to set 
hibernate.jdbc.batch_size with  0 (otherwise I can not use saveOrUpdate()).

How can I set this property? I could not find the option with the 
.setProperty(Einviroment....) .

An another question: is there a possibility to define in the 
hibernate.hbm.xml file, for which class a database table shoud be created, 
and or another class should no table be created?

Thanks for the help.

Hui
Permalink | Reply | 1 comment |
headers
Martin Taal | 1 Sep 13:35

Re: How can I set the property 'hibernate.jdbc.batch_size'

Hi Hui,
try Environment.STATEMENT_BATCH_SIZE.

What do you mean no-table? Do you mean that it should be stored in the superclass, subclass or not 
persisted at all?

gr. Martin

Hui Gao wrote:
> Hi Martin,
> 
> I use Elver connected with the HSQLDB. I want to set 
> hibernate.jdbc.batch_size with  0 (otherwise I can not use saveOrUpdate()).
> 
> How can I set this property? I could not find the option with the 
> .setProperty(Einviroment....) .
> 
> 
> An another question: is there a possibility to define in the 
> hibernate.hbm.xml file, for which class a database table shoud be created, 
> and or another class should no table be created?
> 
> Thanks for the help.
> 
> Hui 
> 
> 
> 
> 
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Hui Gao | 1 Sep 17:13
Picon

lazy="true" in hibernate mapping

Hi Martin,

an another question today:

If I set lazy = "true" in the mappingfile, I get the NullPointException:

at 
org.hibernate.tuple.AbstractEntityTuplizer.createProxy(AbstractEntityTuplizer.java:372)

If I set the lazy ="false", in case if there are much data from a query, the 
Exception:
     ORA-01000: Maximale Anzahl offener Cursor überschritten

Reason: all the associated objects are loaded,  thounds selects are called.

How can I stop to load the assoicated objects by a query?

Thanks for your help and have a nice weekend!

Hui
Permalink | Reply | 1 comment |
headers
Douglas Bitting | 1 Sep 21:23

Persisting Ecore definitions?

OK, here’s a somewhat interesting question.  Has anyone given any thought as to how to persist Ecore definitions?  Say I want to define a system where Ecore definitions are definable at runtime, along with all their persistable attributes.  The next time the system starts up, these Ecore definitions can be read in from the database and bootstrapped into the Teneo environment.  I can setup the annotations on the Ecore.ecore definition, but it clearly is not designed with RDBMS persistence in mind as there are no surrogate keys, no versioning, etc.

 

Anyway, just a thought.

 

Thanks,

--Doug

Permalink | Reply | 1 comment |
headers
Martin Taal | 1 Sep 23:37

Re: lazy="true" in hibernate mapping

Hi Hui,
cglib proxying does not work with Elver/Teneo. So lazy="true" won't work.
This means that single-associations are always eagerly loaded. Collection relations are lazily loaded.
Most of the times this is sufficient behavior because single associations in the end do not result 
in that many objects.

Are the many selects caused by single associations or collection associations?
Or do you have some more info on the structure and queries of your case?

gr. Martin

Hui Gao wrote:
> Hi Martin,
> 
> an another question today:
> 
> If I set lazy = "true" in the mappingfile, I get the NullPointException:
> 
> at 
> org.hibernate.tuple.AbstractEntityTuplizer.createProxy(AbstractEntityTuplizer.java:372)
> 
> If I set the lazy ="false", in case if there are much data from a query, the 
> Exception:
>      ORA-01000: Maximale Anzahl offener Cursor überschritten
> 
> Reason: all the associated objects are loaded,  thounds selects are called.
> 
> How can I stop to load the assoicated objects by a query?
> 
> Thanks for your help and have a nice weekend!
> 
> Hui 
> 
> 
> 
> 
> 

--

-- 

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@... - mtaal@...
Web: www.springsite.com - www.elver.org
Permalink | Reply | 0 comments |
headers
Hui Gao | 2 Sep 11:27
Picon

lazy = "true"

Hi Martin,

thank you ver much for the soon answer.

The many selects are caused by the single association. The problem is: in a 
query,  more than 7000 objects KomKa are fetched. KomKa has a FK to Object 
Betreiber, so more than 7000 selects are created to select object Betreiber.

I attaced the part of the mapping file and the tracing

By the way: we must use old database and there is no column need by a list 
for sorting. So I use bag and not list for the collection.

Best regards,

Hui 

begin 666 Elvertrace.txt
M2&EB97)N871E($UA<'!I;F<@9FEL93H-"@T*/&-L87-S(&5N=&ET>2UN86UE
M/2)+;VU+82(@;&%Z>3TB9F%L<V4B('1A8FQE/2)+3TU?2T$B/@T*#0H\:60@
M;F%M93TB86)W06YL260B('5N<V%V960M=F%L=64](C B(&-O;'5M;CTB04)7
M7T%.3%])1"(@#0H-"G1Y<&4](FEN="(^/&=E;F5R871O<B!C;&%S<STB;F%T
M:79E(B\^/"]I9#X@#0H-"BXN+BXN+BX-"CQM86YY+71O+6]N92!N86UE/2)A
M8G="97-E:7109FQI260B(&5N=&ET>2UN86UE/2)"971R96EB97(B( T*#0IC
M87-C861E/2)P97)S:7-T+"!M97)G92P@<V%V92UU<&1A=&4L(&QO8VLL(')E
M9G)E<V <at> B('5P9&%T93TB=')U92(@;F]T+6YU;&P](F9A;'-E(CX@#0H-"CQC
M;VQU;6X@;F%M93TB04)77T)%4T5)5%]01DQ)7TE$(B\^( T*#0H\+VUA;GDM
M=&\M;VYE/@T*#0HN+BX-"@T*/&UA;GDM=&\M;VYE(&YA;64](F)E=')E:4ED
M(B!E;G1I='DM;F%M93TB0F5T<F5I8F5R(B -"@T*8V%S8V%D93TB<&5R<VES
M="P@;65R9V4L('-A=F4M=7!D871E+"!L;V-K+"!R969R97-H(B!U<&1A=&4]
M(G1R=64B(&YO="UN=6QL/2)F86QS92(^( T*#0H\8V]L=6UN(&YA;64](D)%
M5%)%25])1"(O/B -"@T*/"]M86YY+71O+6]N93X-"@T*/"]C;&%S<SX-"@T*
M#0H-"CQC;&%S<R!E;G1I='DM;F%M93TB0F5T<F5I8F5R(B!L87IY/2)F86QS
M92(@=&%B;&4](D)%5%)%24)%4B(^#0H-"CQI9"!N86UE/2)B971R96E)9"(@
M=6YS879E9"UV86QU93TB,"(@8V]L=6UN/2)"151214E?240B( T*#0IT>7!E
M/2)I;G0B/CQG96YE<F%T;W(@8VQA<W,](FYA=&EV92(O/CPO:60^#0H-"BXN
M+BX-"@T*/&)A9R!N86UE/2)K;VU+86QI<W0B(&QA>GD](G1R=64B#0H-"F-A
M<V-A9&4](G!E<G-I<W0L(&UE<F=E+"!S879E+75P9&%T92P@;&]C:R(@#0H-
M"F%C8V5S<STB;W)G+F5L=F5R+G-T;W)E+FAI8F5R;F%T92YM87!P:6YG+F5L
M:7-T+D5,:7-T4')O<&5R='E!8V-E<W-O<B(^#0H-"CQK97D <at> 8V]L=6UN/2)!
M0E=?0D5314E47U!&3$E?240B+SX-"@T*/&]N92UT;RUM86YY(&5N=&ET>2UN
M86UE/2)+;VU+82(O/B -"@T*/"]B86<^#0H-"@T*/&)A9R!N86UE/2)K;VU+
M87,B(&QA>GD](G1R=64B#0H-"F-A<V-A9&4](G!E<G-I<W0L(&UE<F=E+"!S
M879E+75P9&%T92P@;&]C:R(@#0H-"F%C8V5S<STB;W)G+F5L=F5R+G-T;W)E
M+FAI8F5R;F%T92YM87!P:6YG+F5L:7-T+D5,:7-T4')O<&5R='E!8V-E<W-O
M<B(^#0H-"CQK97D <at> 8V]L=6UN/2)"151214E?240B+SX-"@T*/&]N92UT;RUM
M86YY(&5N=&ET>2UN86UE/2)+;VU+82(O/B -"@T*/"]B86<^#0H-"CPO8VQA
M<W,^#0H-"@T*#0H-"E1R86-E.@T*#0I(:6)E<FYA=&4Z('-E;&5C="!D:7-T
M:6YC="!K;VUK83!?+D%"5U]!3DQ?240 <at> 87,@04)7,5\Q-5\L(&MO;6MA,%\N
M3D%-12!A<R!.04U%,35?+"!K;VUK83!?+D)%34522T<@87,@0D5-15)+1S$U
M7RP@:V]M:V$P7RY!14Y$7T1!5"!A<R!!14Y$-%\Q-5\L(&MO;6MA,%\N045.
M1%].551:15(@87,@045.1#5?,35?+"!K;VUK83!?+D%.4D5$12!A<R!!3E)%
M1$4Q-5\L(&MO;6MA,%\N041215-3050 <at> 87,@041215-3050Q-5\L(&MO;6MA
M,%\N4U1205-312!A<R!35%)!4U-%,35?+"!K;VUK83!?+E!,6B!A<R!03%HQ
M-5\L(&MO;6MA,%\N3U)44U]"15H <at> 87,@3U)44S$P7S$U7RP@:V]M:V$P7RY/
M4E135$5)3%]"15H <at> 87,@3U)44U1%24PQ,5\Q-5\L(&MO;6MA,%\N4$]35$9!
M0T@@87,@4$]35$9!0T <at> Q-5\L(&MO;6MA,%\N5$5,(&%S(%1%3#$U7RP@:V]M
M:V$P7RY&05@@87,@1D%8,35?+"!K;VUK83!?+D5?34%)3"!A<R!%,35?,35?
M+"!K;VUK83!?+EI54T%46DY!344 <at> 87,@6E53051:3D%-13$U7RP@:V]M:V$P
M7RY33TY?2T%?2DX <at> 87,@4T].,3=?,35?+"!K;VUK83!?+D%.4D5$15])1"!A
M<R!!3E)%1$4Q.%\Q-5\L(&MO;6MA,%\N2T%?3E(@87,@2T$Q.5\Q-5\L(&MO
M;6MA,%\N05534T527TA%4U-?2T%?2DX <at> 87,@05534T52,C!?,35?+"!K;VUK
M83!?+D%.1T5?05534T527TA%4U-?1T5-(&%S($%.1T4R,5\Q-5\L(&MO;6MA
M,%\N05533$5'1U]!3D=%7T57(&%S($%54TQ%1T<R,E\Q-5\L(&MO;6MA,%\N
M0T1?05533$5'1U]&4D%#2%0 <at> 87,@0T0R,U\Q-5\L(&MO;6MA,%\N04)77T)%
M4T5)5%]01DQ)7TE$(&%S($%"5S(T7S$U7RP@:V]M:V$P7RY#1%]"14A?3D%#
M2%]214E.(&%S($-$,C5?,35?+"!K;VUK83!?+D-$7T)%2%]63U)?4D5)3B!A
M<R!#1#(V7S$U7RP@:V]M:V$P7RY#1%]!55-,14='7T%"5U]-1R!A<R!#1#(W
M7S$U7RP@:V]M:V$P7RY"151214E?240 <at> 87,@0D544D5),CA?,35?+"!K;VUK
M83!?+D-$7T)%2%](05505%]214E.(&%S($-$,CE?,35?(&9R;VT <at> 2T]-7TM!
M(&MO;6MA,%\L($)%4D5#2%1)1U5.1T5.7U8 <at> 8F5R96-H=&EG=3%?('=H97)E
M(&MO;6MA,%\N04)77T%.3%])1#UB97)E8VAT:6=U,5\N04)77T%.3%])1"!A
M;F0@*&)E<F5C:'1I9W4Q7RY"14A/15)$15])1#T_(&]R(&)E<F5C:'1I9W4Q
M7RY"14A?0D5(3T521$5?240]/RD <at> 86YD("AB97)E8VAT:6=U,5\N0T]$12!L
M:6ME("=%2U9/7R<I(&%N9" H;G9L*&MO;6MA,%\N4T].7TM!7TI.+" P*3TP
M(&]R(&YV;"AK;VUK83!?+D-$7T%54TQ%1T=?04)77TU'+" P*3T_(&%N9"!N
M=FPH:V]M:V$P7RY!55-,14='7T%.1T5?15<L(# I/C\I(&%N9" @;F]T("AE
M>&ES=',@*'-E;&5C="!K87IU<W1A;F0R7RY!0E=?04Y,7TE$(&9R;VT <at> 2T%?
M6E535$%.1"!K87IU<W1A;F0R7R!W:&5R92!K87IU<W1A;F0R7RY!0E=?04Y,
M7TE$/6MO;6MA,%\N04)77T%.3%])1"!A;F0@:V%Z=7-T86YD,E\N0T1?2T%?
M6E535$%.1#T_*2D <at> 86YD("AK;VUK83!?+D%"5U]!3DQ?240@:6X@*'-E;&5C
M="!K;VUK83-?+D%"5U]!3DQ?240 <at> 9G)O;2!+3TU?2T$@:V]M:V$S7RP <at> 0D54
M4D5)0D52(&)E=')E:6)E<C1?('=H97)E(&)E=')E:6)E<C1?+D)%5%)%25])
M1#UK;VUK83-?+D)%5%)%25])1"!A;F0@:V]M:V$S7RY33TY?2T%?2DX]/RDI
M(&]R9&5R(&)Y(&MO;6MA,%\N3D%-12P@:V]M:V$P7RY:55-!5%I.04U%#0I(
M:6)E<FYA=&4Z('-E;&5C="!B971R96EB97(P7RY"151214E?240 <at> 87,@0D54
M4D5),5\R7S)?+"!B971R96EB97(P7RY!1%)%4U-!5"!A<R!!1%)%4U-!5#)?
M,E\L(&)E=')E:6)E<C!?+D%.4D5$12!A<R!!3E)%1$4R7S)?+"!B971R96EB
M97(P7RY%7TU!24P <at> 87,@131?,E\R7RP <at> 8F5T<F5I8F5R,%\N05)"14E44UI%
M251%3B!A<R!!4D)%25136C5?,E\R7RP <at> 8F5T<F5I8F5R,%\N1D%8(&%S($9!
M6#)?,E\L(&)E=')E:6)E<C!?+DY!344 <at> 87,@3D%-13)?,E\L(&)E=')E:6)E
M<C!?+D]25%-414E,7T)%6B!A<R!/4E135$5)3#A?,E\R7RP <at> 8F5T<F5I8F5R
M,%\N3U)44U]"15H <at> 87,@3U)44SE?,E\R7RP <at> 8F5T<F5I8F5R,%\N4$Q:(&%S
M(%!,6C)?,E\L(&)E=')E:6)E<C!?+E!/4U1&04-((&%S(%!/4U1&04-(,E\R
M7RP <at> 8F5T<F5I8F5R,%\N4U1!3D0 <at> 87,@4U1!3D0R7S)?+"!B971R96EB97(P
M7RY35%)!4U-%(&%S(%-44D%34T4R7S)?+"!B971R96EB97(P7RY414P <at> 87,@
M5$5,,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%7TE$(&%S($%.4D5$13$U7S)?
M,E\L(&-O9&5T86(Q7RY#3T1%7TE$(&%S($-/1$4Q7S1?,%\L(&-O9&5T86(Q
M7RY#3T1%(&%S($-/1$4T7S!?+"!C;V1E=&%B,5\N0T]$15]"15H <at> 87,@0T]$
M13-?-%\P7RP <at> 8V]D971A8C%?+DE.04M4259?2DX <at> 87,@24Y!2U1)5C1?-%\P
M7RP <at> 8V]D971A8C%?+D%%3D1?1$%4(&%S($%%3D0U7S1?,%\L(&-O9&5T86(Q
M7RY!14Y$7TY55%I%4B!A<R!!14Y$-E\T7S!?+"!C;V1E=&%B,5\N4U1!3D0@
M87,@4U1!3D0T7S!?+"!C;V1E=&%B,5\N4T]25$E%4D9%3$0 <at> 87,@4T]25$E%
M4D8X7S1?,%\L(&-O9&5T86(Q7RY#3T1%7U194%])1"!A<R!#3T1%.5\T7S!?
M+"!C;V1E='EP,E\N0T]$15]465!?240 <at> 87,@0T]$13%?-5\Q7RP <at> 8V]D971Y
M<#)?+D)%34522T<@87,@0D5-15)+1S5?,5\L(&-O9&5T>7 R7RY#3T1%7T)%
M6E],045.1T4 <at> 87,@0T]$13-?-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?3$%%3D=%
M(&%S($-/1$4T7S5?,5\L(&-O9&5T>7 R7RY#3T1%7U194"!A<R!#3T1%-5\U
M7S%?+"!C;V1E='EP,E\N4$9,14="05)?2DX <at> 87,@4$9,14="05(V7S5?,5\L
M(&-O9&5T>7 R7RY35$%.1"!A<R!35$%.1#5?,5\L(&-O9&5T>7 R7RY"15H@
M87,@0D5:-5\Q7R!F<F]M($)%5%)%24)%4B!B971R96EB97(P7R!L969T(&]U
M=&5R(&IO:6X <at> 0T]$15]404(@8V]D971A8C%?(&]N(&)E=')E:6)E<C!?+D%.
M4D5$15])1#UC;V1E=&%B,5\N0T]$15])1"!L969T(&]U=&5R(&IO:6X <at> 0T]$
M15]465 @8V]D971Y<#)?(&]N(&-O9&5T86(Q7RY#3T1%7U194%])1#UC;V1E
M='EP,E\N0T]$15]465!?240@=VAE<F4 <at> 8F5T<F5I8F5R,%\N0D544D5)7TE$
M/3\-"DAI8F5R;F%T93H@<V5L96-T(&)E=')E:6)E<C!?+D)%5%)%25])1"!A
M<R!"151214DQ7S)?,E\L(&)E=')E:6)E<C!?+D%$4D534T%4(&%S($%$4D53
M4T%4,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%(&%S($%.4D5$13)?,E\L(&)E
M=')E:6)E<C!?+D5?34%)3"!A<R!%-%\R7S)?+"!B971R96EB97(P7RY!4D)%
M25136D5)5$5.(&%S($%20D5)5%-:-5\R7S)?+"!B971R96EB97(P7RY&05@@
M87,@1D%8,E\R7RP <at> 8F5T<F5I8F5R,%\N3D%-12!A<R!.04U%,E\R7RP <at> 8F5T
M<F5I8F5R,%\N3U)44U1%24Q?0D5:(&%S($]25%-414E,.%\R7S)?+"!B971R
M96EB97(P7RY/4E137T)%6B!A<R!/4E13.5\R7S)?+"!B971R96EB97(P7RY0
M3%H <at> 87,@4$Q:,E\R7RP <at> 8F5T<F5I8F5R,%\N4$]35$9!0T@@87,@4$]35$9!
M0T <at> R7S)?+"!B971R96EB97(P7RY35$%.1"!A<R!35$%.1#)?,E\L(&)E=')E
M:6)E<C!?+E-44D%34T4 <at> 87,@4U1205-313)?,E\L(&)E=')E:6)E<C!?+E1%
M3"!A<R!414PR7S)?+"!B971R96EB97(P7RY!3E)%1$5?240 <at> 87,@04Y2141%
M,35?,E\R7RP <at> 8V]D971A8C%?+D-/1$5?240 <at> 87,@0T]$13%?-%\P7RP <at> 8V]D
M971A8C%?+D-/1$4 <at> 87,@0T]$131?,%\L(&-O9&5T86(Q7RY#3T1%7T)%6B!A
M<R!#3T1%,U\T7S!?+"!C;V1E=&%B,5\N24Y!2U1)5E]*3B!A<R!)3D%+5$E6
M-%\T7S!?+"!C;V1E=&%B,5\N045.1%]$050 <at> 87,@045.1#5?-%\P7RP <at> 8V]D
M971A8C%?+D%%3D1?3E546D52(&%S($%%3D0V7S1?,%\L(&-O9&5T86(Q7RY3
M5$%.1"!A<R!35$%.1#1?,%\L(&-O9&5T86(Q7RY33U)424521D5,1"!A<R!3
M3U)424521CA?-%\P7RP <at> 8V]D971A8C%?+D-/1$5?5%E07TE$(&%S($-/1$4Y
M7S1?,%\L(&-O9&5T>7 R7RY#3T1%7U194%])1"!A<R!#3T1%,5\U7S%?+"!C
M;V1E='EP,E\N0D5-15)+1R!A<R!"14U%4DM'-5\Q7RP <at> 8V]D971Y<#)?+D-/
M1$5?0D5:7TQ!14Y'12!A<R!#3T1%,U\U7S%?+"!C;V1E='EP,E\N0T]$15],
M045.1T4 <at> 87,@0T]$131?-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?5%E0(&%S($-/
M1$4U7S5?,5\L(&-O9&5T>7 R7RY01DQ%1T)!4E]*3B!A<R!01DQ%1T)!4C9?
M-5\Q7RP <at> 8V]D971Y<#)?+E-404Y$(&%S(%-404Y$-5\Q7RP <at> 8V]D971Y<#)?
M+D)%6B!A<R!"15HU7S%?(&9R;VT <at> 0D544D5)0D52(&)E=')E:6)E<C!?(&QE
M9G0@;W5T97(@:F]I;B!#3T1%7U1!0B!C;V1E=&%B,5\@;VX <at> 8F5T<F5I8F5R
M,%\N04Y2141%7TE$/6-O9&5T86(Q7RY#3T1%7TE$(&QE9G0@;W5T97(@:F]I
M;B!#3T1%7U194"!C;V1E='EP,E\@;VX <at> 8V]D971A8C%?+D-/1$5?5%E07TE$
M/6-O9&5T>7 R7RY#3T1%7U194%])1"!W:&5R92!B971R96EB97(P7RY"1512
M14E?240]/PT*2&EB97)N871E.B!S96QE8W0 <at> 8F5T<F5I8F5R,%\N0D544D5)
M7TE$(&%S($)%5%)%23%?,E\R7RP <at> 8F5T<F5I8F5R,%\N041215-3050 <at> 87,@
M041215-3050R7S)?+"!B971R96EB97(P7RY!3E)%1$4 <at> 87,@04Y2141%,E\R
M7RP <at> 8F5T<F5I8F5R,%\N15]-04E,(&%S($4T7S)?,E\L(&)E=')E:6)E<C!?
M+D%20D5)5%-:14E414X <at> 87,@05)"14E44UHU7S)?,E\L(&)E=')E:6)E<C!?
M+D9!6"!A<R!&05 <at> R7S)?+"!B971R96EB97(P7RY.04U%(&%S($Y!344R7S)?
M+"!B971R96EB97(P7RY/4E135$5)3%]"15H <at> 87,@3U)44U1%24PX7S)?,E\L
M(&)E=')E:6)E<C!?+D]25%-?0D5:(&%S($]25%,Y7S)?,E\L(&)E=')E:6)E
M<C!?+E!,6B!A<R!03%HR7S)?+"!B971R96EB97(P7RY03U-41D%#2"!A<R!0
M3U-41D%#2#)?,E\L(&)E=')E:6)E<C!?+E-404Y$(&%S(%-404Y$,E\R7RP@
M8F5T<F5I8F5R,%\N4U1205-312!A<R!35%)!4U-%,E\R7RP <at> 8F5T<F5I8F5R
M,%\N5$5,(&%S(%1%3#)?,E\L(&)E=')E:6)E<C!?+D%.4D5$15])1"!A<R!!
M3E)%1$4Q-5\R7S)?+"!C;V1E=&%B,5\N0T]$15])1"!A<R!#3T1%,5\T7S!?
M+"!C;V1E=&%B,5\N0T]$12!A<R!#3T1%-%\P7RP <at> 8V]D971A8C%?+D-/1$5?
M0D5:(&%S($-/1$4S7S1?,%\L(&-O9&5T86(Q7RY)3D%+5$E67TI.(&%S($E.
M04M4258T7S1?,%\L(&-O9&5T86(Q7RY!14Y$7T1!5"!A<R!!14Y$-5\T7S!?
M+"!C;V1E=&%B,5\N045.1%].551:15(@87,@045.1#9?-%\P7RP <at> 8V]D971A
M8C%?+E-404Y$(&%S(%-404Y$-%\P7RP <at> 8V]D971A8C%?+E-/4E1)15)&14Q$
M(&%S(%-/4E1)15)&.%\T7S!?+"!C;V1E=&%B,5\N0T]$15]465!?240 <at> 87,@
M0T]$13E?-%\P7RP <at> 8V]D971Y<#)?+D-/1$5?5%E07TE$(&%S($-/1$4Q7S5?
M,5\L(&-O9&5T>7 R7RY"14U%4DM'(&%S($)%34522T<U7S%?+"!C;V1E='EP
M,E\N0T]$15]"15I?3$%%3D=%(&%S($-/1$4S7S5?,5\L(&-O9&5T>7 R7RY#
M3T1%7TQ!14Y'12!A<R!#3T1%-%\U7S%?+"!C;V1E='EP,E\N0T]$15]465 @
M87,@0T]$135?-5\Q7RP <at> 8V]D971Y<#)?+E!&3$5'0D%27TI.(&%S(%!&3$5'
M0D%2-E\U7S%?+"!C;V1E='EP,E\N4U1!3D0 <at> 87,@4U1!3D0U7S%?+"!C;V1E
M='EP,E\N0D5:(&%S($)%6C5?,5\@9G)O;2!"151214E"15(@8F5T<F5I8F5R
M,%\@;&5F="!O=71E<B!J;VEN($-/1$5?5$%"(&-O9&5T86(Q7R!O;B!B971R
M96EB97(P7RY!3E)%1$5?240]8V]D971A8C%?+D-/1$5?240@;&5F="!O=71E
M<B!J;VEN($-/1$5?5%E0(&-O9&5T>7 R7R!O;B!C;V1E=&%B,5\N0T]$15]4
M65!?240]8V]D971Y<#)?+D-/1$5?5%E07TE$('=H97)E(&)E=')E:6)E<C!?
M+D)%5%)%25])1#T_#0I(:6)E<FYA=&4Z('-E;&5C="!B971R96EB97(P7RY"
M151214E?240 <at> 87,@0D544D5),5\R7S)?+"!B971R96EB97(P7RY!1%)%4U-!
M5"!A<R!!1%)%4U-!5#)?,E\L(&)E=')E:6)E<C!?+D%.4D5$12!A<R!!3E)%
M1$4R7S)?+"!B971R96EB97(P7RY%7TU!24P <at> 87,@131?,E\R7RP <at> 8F5T<F5I
M8F5R,%\N05)"14E44UI%251%3B!A<R!!4D)%25136C5?,E\R7RP <at> 8F5T<F5I
M8F5R,%\N1D%8(&%S($9!6#)?,E\L(&)E=')E:6)E<C!?+DY!344 <at> 87,@3D%-
M13)?,E\L(&)E=')E:6)E<C!?+D]25%-414E,7T)%6B!A<R!/4E135$5)3#A?
M,E\R7RP <at> 8F5T<F5I8F5R,%\N3U)44U]"15H <at> 87,@3U)44SE?,E\R7RP <at> 8F5T
M<F5I8F5R,%\N4$Q:(&%S(%!,6C)?,E\L(&)E=')E:6)E<C!?+E!/4U1&04-(
M(&%S(%!/4U1&04-(,E\R7RP <at> 8F5T<F5I8F5R,%\N4U1!3D0 <at> 87,@4U1!3D0R
M7S)?+"!B971R96EB97(P7RY35%)!4U-%(&%S(%-44D%34T4R7S)?+"!B971R
M96EB97(P7RY414P <at> 87,@5$5,,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%7TE$
M(&%S($%.4D5$13$U7S)?,E\L(&-O9&5T86(Q7RY#3T1%7TE$(&%S($-/1$4Q
M7S1?,%\L(&-O9&5T86(Q7RY#3T1%(&%S($-/1$4T7S!?+"!C;V1E=&%B,5\N
M0T]$15]"15H <at> 87,@0T]$13-?-%\P7RP <at> 8V]D971A8C%?+DE.04M4259?2DX@
M87,@24Y!2U1)5C1?-%\P7RP <at> 8V]D971A8C%?+D%%3D1?1$%4(&%S($%%3D0U
M7S1?,%\L(&-O9&5T86(Q7RY!14Y$7TY55%I%4B!A<R!!14Y$-E\T7S!?+"!C
M;V1E=&%B,5\N4U1!3D0 <at> 87,@4U1!3D0T7S!?+"!C;V1E=&%B,5\N4T]25$E%
M4D9%3$0 <at> 87,@4T]25$E%4D8X7S1?,%\L(&-O9&5T86(Q7RY#3T1%7U194%])
M1"!A<R!#3T1%.5\T7S!?+"!C;V1E='EP,E\N0T]$15]465!?240 <at> 87,@0T]$
M13%?-5\Q7RP <at> 8V]D971Y<#)?+D)%34522T<@87,@0D5-15)+1S5?,5\L(&-O
M9&5T>7 R7RY#3T1%7T)%6E],045.1T4 <at> 87,@0T]$13-?-5\Q7RP <at> 8V]D971Y
M<#)?+D-/1$5?3$%%3D=%(&%S($-/1$4T7S5?,5\L(&-O9&5T>7 R7RY#3T1%
M7U194"!A<R!#3T1%-5\U7S%?+"!C;V1E='EP,E\N4$9,14="05)?2DX <at> 87,@
M4$9,14="05(V7S5?,5\L(&-O9&5T>7 R7RY35$%.1"!A<R!35$%.1#5?,5\L
M(&-O9&5T>7 R7RY"15H <at> 87,@0D5:-5\Q7R!F<F]M($)%5%)%24)%4B!B971R
M96EB97(P7R!L969T(&]U=&5R(&IO:6X <at> 0T]$15]404(@8V]D971A8C%?(&]N
M(&)E=')E:6)E<C!?+D%.4D5$15])1#UC;V1E=&%B,5\N0T]$15])1"!L969T
M(&]U=&5R(&IO:6X <at> 0T]$15]465 @8V]D971Y<#)?(&]N(&-O9&5T86(Q7RY#
M3T1%7U194%])1#UC;V1E='EP,E\N0T]$15]465!?240@=VAE<F4 <at> 8F5T<F5I
M8F5R,%\N0D544D5)7TE$/3\-"DAI8F5R;F%T93H@<V5L96-T(&)E=')E:6)E
M<C!?+D)%5%)%25])1"!A<R!"151214DQ7S)?,E\L(&)E=')E:6)E<C!?+D%$
M4D534T%4(&%S($%$4D534T%4,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%(&%S
M($%.4D5$13)?,E\L(&)E=')E:6)E<C!?+D5?34%)3"!A<R!%-%\R7S)?+"!B
M971R96EB97(P7RY!4D)%25136D5)5$5.(&%S($%20D5)5%-:-5\R7S)?+"!B
M971R96EB97(P7RY&05@@87,@1D%8,E\R7RP <at> 8F5T<F5I8F5R,%\N3D%-12!A
M<R!.04U%,E\R7RP <at> 8F5T<F5I8F5R,%\N3U)44U1%24Q?0D5:(&%S($]25%-4
M14E,.%\R7S)?+"!B971R96EB97(P7RY/4E137T)%6B!A<R!/4E13.5\R7S)?
M+"!B971R96EB97(P7RY03%H <at> 87,@4$Q:,E\R7RP <at> 8F5T<F5I8F5R,%\N4$]3
M5$9!0T@@87,@4$]35$9!0T <at> R7S)?+"!B971R96EB97(P7RY35$%.1"!A<R!3
M5$%.1#)?,E\L(&)E=')E:6)E<C!?+E-44D%34T4 <at> 87,@4U1205-313)?,E\L
M(&)E=')E:6)E<C!?+E1%3"!A<R!414PR7S)?+"!B971R96EB97(P7RY!3E)%
M1$5?240 <at> 87,@04Y2141%,35?,E\R7RP <at> 8V]D971A8C%?+D-/1$5?240 <at> 87,@
M0T]$13%?-%\P7RP <at> 8V]D971A8C%?+D-/1$4 <at> 87,@0T]$131?,%\L(&-O9&5T
M86(Q7RY#3T1%7T)%6B!A<R!#3T1%,U\T7S!?+"!C;V1E=&%B,5\N24Y!2U1)
M5E]*3B!A<R!)3D%+5$E6-%\T7S!?+"!C;V1E=&%B,5\N045.1%]$050 <at> 87,@
M045.1#5?-%\P7RP <at> 8V]D971A8C%?+D%%3D1?3E546D52(&%S($%%3D0V7S1?
M,%\L(&-O9&5T86(Q7RY35$%.1"!A<R!35$%.1#1?,%\L(&-O9&5T86(Q7RY3
M3U)424521D5,1"!A<R!33U)424521CA?-%\P7RP <at> 8V]D971A8C%?+D-/1$5?
M5%E07TE$(&%S($-/1$4Y7S1?,%\L(&-O9&5T>7 R7RY#3T1%7U194%])1"!A
M<R!#3T1%,5\U7S%?+"!C;V1E='EP,E\N0D5-15)+1R!A<R!"14U%4DM'-5\Q
M7RP <at> 8V]D971Y<#)?+D-/1$5?0D5:7TQ!14Y'12!A<R!#3T1%,U\U7S%?+"!C
M;V1E='EP,E\N0T]$15],045.1T4 <at> 87,@0T]$131?-5\Q7RP <at> 8V]D971Y<#)?
M+D-/1$5?5%E0(&%S($-/1$4U7S5?,5\L(&-O9&5T>7 R7RY01DQ%1T)!4E]*
M3B!A<R!01DQ%1T)!4C9?-5\Q7RP <at> 8V]D971Y<#)?+E-404Y$(&%S(%-404Y$
M-5\Q7RP <at> 8V]D971Y<#)?+D)%6B!A<R!"15HU7S%?(&9R;VT <at> 0D544D5)0D52
M(&)E=')E:6)E<C!?(&QE9G0@;W5T97(@:F]I;B!#3T1%7U1!0B!C;V1E=&%B
M,5\@;VX <at> 8F5T<F5I8F5R,%\N04Y2141%7TE$/6-O9&5T86(Q7RY#3T1%7TE$
M(&QE9G0@;W5T97(@:F]I;B!#3T1%7U194"!C;V1E='EP,E\@;VX <at> 8V]D971A
M8C%?+D-/1$5?5%E07TE$/6-O9&5T>7 R7RY#3T1%7U194%])1"!W:&5R92!B
M971R96EB97(P7RY"151214E?240]/PT*2&EB97)N871E.B!S96QE8W0 <at> 8F5T
M<F5I8F5R,%\N0D544D5)7TE$(&%S($)%5%)%23%?,E\R7RP <at> 8F5T<F5I8F5R
M,%\N041215-3050 <at> 87,@041215-3050R7S)?+"!B971R96EB97(P7RY!3E)%
M1$4 <at> 87,@04Y2141%,E\R7RP <at> 8F5T<F5I8F5R,%\N15]-04E,(&%S($4T7S)?
M,E\L(&)E=')E:6)E<C!?+D%20D5)5%-:14E414X <at> 87,@05)"14E44UHU7S)?
M,E\L(&)E=')E:6)E<C!?+D9!6"!A<R!&05 <at> R7S)?+"!B971R96EB97(P7RY.
M04U%(&%S($Y!344R7S)?+"!B971R96EB97(P7RY/4E135$5)3%]"15H <at> 87,@
M3U)44U1%24PX7S)?,E\L(&)E=')E:6)E<C!?+D]25%-?0D5:(&%S($]25%,Y
M7S)?,E\L(&)E=')E:6)E<C!?+E!,6B!A<R!03%HR7S)?+"!B971R96EB97(P
M7RY03U-41D%#2"!A<R!03U-41D%#2#)?,E\L(&)E=')E:6)E<C!?+E-404Y$
M(&%S(%-404Y$,E\R7RP <at> 8F5T<F5I8F5R,%\N4U1205-312!A<R!35%)!4U-%
M,E\R7RP <at> 8F5T<F5I8F5R,%\N5$5,(&%S(%1%3#)?,E\L(&)E=')E:6)E<C!?
M+D%.4D5$15])1"!A<R!!3E)%1$4Q-5\R7S)?+"!C;V1E=&%B,5\N0T]$15])
M1"!A<R!#3T1%,5\T7S!?+"!C;V1E=&%B,5\N0T]$12!A<R!#3T1%-%\P7RP@
M8V]D971A8C%?+D-/1$5?0D5:(&%S($-/1$4S7S1?,%\L(&-O9&5T86(Q7RY)
M3D%+5$E67TI.(&%S($E.04M4258T7S1?,%\L(&-O9&5T86(Q7RY!14Y$7T1!
M5"!A<R!!14Y$-5\T7S!?+"!C;V1E=&%B,5\N045.1%].551:15(@87,@045.
M1#9?-%\P7RP <at> 8V]D971A8C%?+E-404Y$(&%S(%-404Y$-%\P7RP <at> 8V]D971A
M8C%?+E-/4E1)15)&14Q$(&%S(%-/4E1)15)&.%\T7S!?+"!C;V1E=&%B,5\N
M0T]$15]465!?240 <at> 87,@0T]$13E?-%\P7RP <at> 8V]D971Y<#)?+D-/1$5?5%E0
M7TE$(&%S($-/1$4Q7S5?,5\L(&-O9&5T>7 R7RY"14U%4DM'(&%S($)%3452
M2T<U7S%?+"!C;V1E='EP,E\N0T]$15]"15I?3$%%3D=%(&%S($-/1$4S7S5?
M,5\L(&-O9&5T>7 R7RY#3T1%7TQ!14Y'12!A<R!#3T1%-%\U7S%?+"!C;V1E
M='EP,E\N0T]$15]465 @87,@0T]$135?-5\Q7RP <at> 8V]D971Y<#)?+E!&3$5'
M0D%27TI.(&%S(%!&3$5'0D%2-E\U7S%?+"!C;V1E='EP,E\N4U1!3D0 <at> 87,@
M4U1!3D0U7S%?+"!C;V1E='EP,E\N0D5:(&%S($)%6C5?,5\@9G)O;2!"1512
M14E"15(@8F5T<F5I8F5R,%\@;&5F="!O=71E<B!J;VEN($-/1$5?5$%"(&-O
M9&5T86(Q7R!O;B!B971R96EB97(P7RY!3E)%1$5?240]8V]D971A8C%?+D-/
M1$5?240@;&5F="!O=71E<B!J;VEN($-/1$5?5%E0(&-O9&5T>7 R7R!O;B!C
M;V1E=&%B,5\N0T]$15]465!?240]8V]D971Y<#)?+D-/1$5?5%E07TE$('=H
M97)E(&)E=')E:6)E<C!?+D)%5%)%25])1#T_#0I(:6)E<FYA=&4Z('-E;&5C
M="!B971R96EB97(P7RY"151214E?240 <at> 87,@0D544D5),5\R7S)?+"!B971R
M96EB97(P7RY!1%)%4U-!5"!A<R!!1%)%4U-!5#)?,E\L(&)E=')E:6)E<C!?
M+D%.4D5$12!A<R!!3E)%1$4R7S)?+"!B971R96EB97(P7RY%7TU!24P <at> 87,@
M131?,E\R7RP <at> 8F5T<F5I8F5R,%\N05)"14E44UI%251%3B!A<R!!4D)%2513
M6C5?,E\R7RP <at> 8F5T<F5I8F5R,%\N1D%8(&%S($9!6#)?,E\L(&)E=')E:6)E
M<C!?+DY!344 <at> 87,@3D%-13)?,E\L(&)E=')E:6)E<C!?+D]25%-414E,7T)%
M6B!A<R!/4E135$5)3#A?,E\R7RP <at> 8F5T<F5I8F5R,%\N3U)44U]"15H <at> 87,@
M3U)44SE?,E\R7RP <at> 8F5T<F5I8F5R,%\N4$Q:(&%S(%!,6C)?,E\L(&)E=')E
M:6)E<C!?+E!/4U1&04-((&%S(%!/4U1&04-(,E\R7RP <at> 8F5T<F5I8F5R,%\N
M4U1!3D0 <at> 87,@4U1!3D0R7S)?+"!B971R96EB97(P7RY35%)!4U-%(&%S(%-4
M4D%34T4R7S)?+"!B971R96EB97(P7RY414P <at> 87,@5$5,,E\R7RP <at> 8F5T<F5I
M8F5R,%\N04Y2141%7TE$(&%S($%.4D5$13$U7S)?,E\L(&-O9&5T86(Q7RY#
M3T1%7TE$(&%S($-/1$4Q7S1?,%\L(&-O9&5T86(Q7RY#3T1%(&%S($-/1$4T
M7S!?+"!C;V1E=&%B,5\N0T]$15]"15H <at> 87,@0T]$13-?-%\P7RP <at> 8V]D971A
M8C%?+DE.04M4259?2DX <at> 87,@24Y!2U1)5C1?-%\P7RP <at> 8V]D971A8C%?+D%%
M3D1?1$%4(&%S($%%3D0U7S1?,%\L(&-O9&5T86(Q7RY!14Y$7TY55%I%4B!A
M<R!!14Y$-E\T7S!?+"!C;V1E=&%B,5\N4U1!3D0 <at> 87,@4U1!3D0T7S!?+"!C
M;V1E=&%B,5\N4T]25$E%4D9%3$0 <at> 87,@4T]25$E%4D8X7S1?,%\L(&-O9&5T
M86(Q7RY#3T1%7U194%])1"!A<R!#3T1%.5\T7S!?+"!C;V1E='EP,E\N0T]$
M15]465!?240 <at> 87,@0T]$13%?-5\Q7RP <at> 8V]D971Y<#)?+D)%34522T<@87,@
M0D5-15)+1S5?,5\L(&-O9&5T>7 R7RY#3T1%7T)%6E],045.1T4 <at> 87,@0T]$
M13-?-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?3$%%3D=%(&%S($-/1$4T7S5?,5\L
M(&-O9&5T>7 R7RY#3T1%7U194"!A<R!#3T1%-5\U7S%?+"!C;V1E='EP,E\N
M4$9,14="05)?2DX <at> 87,@4$9,14="05(V7S5?,5\L(&-O9&5T>7 R7RY35$%.
M1"!A<R!35$%.1#5?,5\L(&-O9&5T>7 R7RY"15H <at> 87,@0D5:-5\Q7R!F<F]M
M($)%5%)%24)%4B!B971R96EB97(P7R!L969T(&]U=&5R(&IO:6X <at> 0T]$15]4
M04(@8V]D971A8C%?(&]N(&)E=')E:6)E<C!?+D%.4D5$15])1#UC;V1E=&%B
M,5\N0T]$15])1"!L969T(&]U=&5R(&IO:6X <at> 0T]$15]465 @8V]D971Y<#)?
M(&]N(&-O9&5T86(Q7RY#3T1%7U194%])1#UC;V1E='EP,E\N0T]$15]465!?
M240@=VAE<F4 <at> 8F5T<F5I8F5R,%\N0D544D5)7TE$/3\-"DAI8F5R;F%T93H@
M<V5L96-T(&)E=')E:6)E<C!?+D)%5%)%25])1"!A<R!"151214DQ7S)?,E\L
M(&)E=')E:6)E<C!?+D%$4D534T%4(&%S($%$4D534T%4,E\R7RP <at> 8F5T<F5I
M8F5R,%\N04Y2141%(&%S($%.4D5$13)?,E\L(&)E=')E:6)E<C!?+D5?34%)
M3"!A<R!%-%\R7S)?+"!B971R96EB97(P7RY!4D)%25136D5)5$5.(&%S($%2
M0D5)5%-:-5\R7S)?+"!B971R96EB97(P7RY&05@@87,@1D%8,E\R7RP <at> 8F5T
M<F5I8F5R,%\N3D%-12!A<R!.04U%,E\R7RP <at> 8F5T<F5I8F5R,%\N3U)44U1%
M24Q?0D5:(&%S($]25%-414E,.%\R7S)?+"!B971R96EB97(P7RY/4E137T)%
M6B!A<R!/4E13.5\R7S)?+"!B971R96EB97(P7RY03%H <at> 87,@4$Q:,E\R7RP@
M8F5T<F5I8F5R,%\N4$]35$9!0T@@87,@4$]35$9!0T <at> R7S)?+"!B971R96EB
M97(P7RY35$%.1"!A<R!35$%.1#)?,E\L(&)E=')E:6)E<C!?+E-44D%34T4@
M87,@4U1205-313)?,E\L(&)E=')E:6)E<C!?+E1%3"!A<R!414PR7S)?+"!B
M971R96EB97(P7RY!3E)%1$5?240 <at> 87,@04Y2141%,35?,E\R7RP <at> 8V]D971A
M8C%?+D-/1$5?240 <at> 87,@0T]$13%?-%\P7RP <at> 8V]D971A8C%?+D-/1$4 <at> 87,@
M0T]$131?,%\L(&-O9&5T86(Q7RY#3T1%7T)%6B!A<R!#3T1%,U\T7S!?+"!C
M;V1E=&%B,5\N24Y!2U1)5E]*3B!A<R!)3D%+5$E6-%\T7S!?+"!C;V1E=&%B
M,5\N045.1%]$050 <at> 87,@045.1#5?-%\P7RP <at> 8V]D971A8C%?+D%%3D1?3E54
M6D52(&%S($%%3D0V7S1?,%\L(&-O9&5T86(Q7RY35$%.1"!A<R!35$%.1#1?
M,%\L(&-O9&5T86(Q7RY33U)424521D5,1"!A<R!33U)424521CA?-%\P7RP@
M8V]D971A8C%?+D-/1$5?5%E07TE$(&%S($-/1$4Y7S1?,%\L(&-O9&5T>7 R
M7RY#3T1%7U194%])1"!A<R!#3T1%,5\U7S%?+"!C;V1E='EP,E\N0D5-15)+
M1R!A<R!"14U%4DM'-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?0D5:7TQ!14Y'12!A
M<R!#3T1%,U\U7S%?+"!C;V1E='EP,E\N0T]$15],045.1T4 <at> 87,@0T]$131?
M-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?5%E0(&%S($-/1$4U7S5?,5\L(&-O9&5T
M>7 R7RY01DQ%1T)!4E]*3B!A<R!01DQ%1T)!4C9?-5\Q7RP <at> 8V]D971Y<#)?
M+E-404Y$(&%S(%-404Y$-5\Q7RP <at> 8V]D971Y<#)?+D)%6B!A<R!"15HU7S%?
M(&9R;VT <at> 0D544D5)0D52(&)E=')E:6)E<C!?(&QE9G0@;W5T97(@:F]I;B!#
M3T1%7U1!0B!C;V1E=&%B,5\@;VX <at> 8F5T<F5I8F5R,%\N04Y2141%7TE$/6-O
M9&5T86(Q7RY#3T1%7TE$(&QE9G0@;W5T97(@:F]I;B!#3T1%7U194"!C;V1E
M='EP,E\@;VX <at> 8V]D971A8C%?+D-/1$5?5%E07TE$/6-O9&5T>7 R7RY#3T1%
M7U194%])1"!W:&5R92!B971R96EB97(P7RY"151214E?240]/PT*2&EB97)N
M871E.B!S96QE8W0 <at> 8F5T<F5I8F5R,%\N0D544D5)7TE$(&%S($)%5%)%23%?
M,E\R7RP <at> 8F5T<F5I8F5R,%\N041215-3050 <at> 87,@041215-3050R7S)?+"!B
M971R96EB97(P7RY!3E)%1$4 <at> 87,@04Y2141%,E\R7RP <at> 8F5T<F5I8F5R,%\N
M15]-04E,(&%S($4T7S)?,E\L(&)E=')E:6)E<C!?+D%20D5)5%-:14E414X@
M87,@05)"14E44UHU7S)?,E\L(&)E=')E:6)E<C!?+D9!6"!A<R!&05 <at> R7S)?
M+"!B971R96EB97(P7RY.04U%(&%S($Y!344R7S)?+"!B971R96EB97(P7RY/
M4E135$5)3%]"15H <at> 87,@3U)44U1%24PX7S)?,E\L(&)E=')E:6)E<C!?+D]2
M5%-?0D5:(&%S($]25%,Y7S)?,E\L(&)E=')E:6)E<C!?+E!,6B!A<R!03%HR
M7S)?+"!B971R96EB97(P7RY03U-41D%#2"!A<R!03U-41D%#2#)?,E\L(&)E
M=')E:6)E<C!?+E-404Y$(&%S(%-404Y$,E\R7RP <at> 8F5T<F5I8F5R,%\N4U12
M05-312!A<R!35%)!4U-%,E\R7RP <at> 8F5T<F5I8F5R,%\N5$5,(&%S(%1%3#)?
M,E\L(&)E=')E:6)E<C!?+D%.4D5$15])1"!A<R!!3E)%1$4Q-5\R7S)?+"!C
M;V1E=&%B,5\N0T]$15])1"!A<R!#3T1%,5\T7S!?+"!C;V1E=&%B,5\N0T]$
M12!A<R!#3T1%-%\P7RP <at> 8V]D971A8C%?+D-/1$5?0D5:(&%S($-/1$4S7S1?
M,%\L(&-O9&5T86(Q7RY)3D%+5$E67TI.(&%S($E.04M4258T7S1?,%\L(&-O
M9&5T86(Q7RY!14Y$7T1!5"!A<R!!14Y$-5\T7S!?+"!C;V1E=&%B,5\N045.
M1%].551:15(@87,@045.1#9?-%\P7RP <at> 8V]D971A8C%?+E-404Y$(&%S(%-4
M04Y$-%\P7RP <at> 8V]D971A8C%?+E-/4E1)15)&14Q$(&%S(%-/4E1)15)&.%\T
M7S!?+"!C;V1E=&%B,5\N0T]$15]465!?240 <at> 87,@0T]$13E?-%\P7RP <at> 8V]D
M971Y<#)?+D-/1$5?5%E07TE$(&%S($-/1$4Q7S5?,5\L(&-O9&5T>7 R7RY"
M14U%4DM'(&%S($)%34522T<U7S%?+"!C;V1E='EP,E\N0T]$15]"15I?3$%%
M3D=%(&%S($-/1$4S7S5?,5\L(&-O9&5T>7 R7RY#3T1%7TQ!14Y'12!A<R!#
M3T1%-%\U7S%?+"!C;V1E='EP,E\N0T]$15]465 @87,@0T]$135?-5\Q7RP@
M8V]D971Y<#)?+E!&3$5'0D%27TI.(&%S(%!&3$5'0D%2-E\U7S%?+"!C;V1E
M='EP,E\N4U1!3D0 <at> 87,@4U1!3D0U7S%?+"!C;V1E='EP,E\N0D5:(&%S($)%
M6C5?,5\@9G)O;2!"151214E"15(@8F5T<F5I8F5R,%\@;&5F="!O=71E<B!J
M;VEN($-/1$5?5$%"(&-O9&5T86(Q7R!O;B!B971R96EB97(P7RY!3E)%1$5?
M240]8V]D971A8C%?+D-/1$5?240@;&5F="!O=71E<B!J;VEN($-/1$5?5%E0
M(&-O9&5T>7 R7R!O;B!C;V1E=&%B,5\N0T]$15]465!?240]8V]D971Y<#)?
M+D-/1$5?5%E07TE$('=H97)E(&)E=')E:6)E<C!?+D)%5%)%25])1#T_#0I(
M:6)E<FYA=&4Z('-E;&5C="!B971R96EB97(P7RY"151214E?240 <at> 87,@0D54
M4D5),5\R7S)?+"!B971R96EB97(P7RY!1%)%4U-!5"!A<R!!1%)%4U-!5#)?
M,E\L(&)E=')E:6)E<C!?+D%.4D5$12!A<R!!3E)%1$4R7S)?+"!B971R96EB
M97(P7RY%7TU!24P <at> 87,@131?,E\R7RP <at> 8F5T<F5I8F5R,%\N05)"14E44UI%
M251%3B!A<R!!4D)%25136C5?,E\R7RP <at> 8F5T<F5I8F5R,%\N1D%8(&%S($9!
M6#)?,E\L(&)E=')E:6)E<C!?+DY!344 <at> 87,@3D%-13)?,E\L(&)E=')E:6)E
M<C!?+D]25%-414E,7T)%6B!A<R!/4E135$5)3#A?,E\R7RP <at> 8F5T<F5I8F5R
M,%\N3U)44U]"15H <at> 87,@3U)44SE?,E\R7RP <at> 8F5T<F5I8F5R,%\N4$Q:(&%S
M(%!,6C)?,E\L(&)E=')E:6)E<C!?+E!/4U1&04-((&%S(%!/4U1&04-(,E\R
M7RP <at> 8F5T<F5I8F5R,%\N4U1!3D0 <at> 87,@4U1!3D0R7S)?+"!B971R96EB97(P
M7RY35%)!4U-%(&%S(%-44D%34T4R7S)?+"!B971R96EB97(P7RY414P <at> 87,@
M5$5,,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%7TE$(&%S($%.4D5$13$U7S)?
M,E\L(&-O9&5T86(Q7RY#3T1%7TE$(&%S($-/1$4Q7S1?,%\L(&-O9&5T86(Q
M7RY#3T1%(&%S($-/1$4T7S!?+"!C;V1E=&%B,5\N0T]$15]"15H <at> 87,@0T]$
M13-?-%\P7RP <at> 8V]D971A8C%?+DE.04M4259?2DX <at> 87,@24Y!2U1)5C1?-%\P
M7RP <at> 8V]D971A8C%?+D%%3D1?1$%4(&%S($%%3D0U7S1?,%\L(&-O9&5T86(Q
M7RY!14Y$7TY55%I%4B!A<R!!14Y$-E\T7S!?+"!C;V1E=&%B,5\N4U1!3D0@
M87,@4U1!3D0T7S!?+"!C;V1E=&%B,5\N4T]25$E%4D9%3$0 <at> 87,@4T]25$E%
M4D8X7S1?,%\L(&-O9&5T86(Q7RY#3T1%7U194%])1"!A<R!#3T1%.5\T7S!?
M+"!C;V1E='EP,E\N0T]$15]465!?240 <at> 87,@0T]$13%?-5\Q7RP <at> 8V]D971Y
M<#)?+D)%34522T<@87,@0D5-15)+1S5?,5\L(&-O9&5T>7 R7RY#3T1%7T)%
M6E],045.1T4 <at> 87,@0T]$13-?-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?3$%%3D=%
M(&%S($-/1$4T7S5?,5\L(&-O9&5T>7 R7RY#3T1%7U194"!A<R!#3T1%-5\U
M7S%?+"!C;V1E='EP,E\N4$9,14="05)?2DX <at> 87,@4$9,14="05(V7S5?,5\L
M(&-O9&5T>7 R7RY35$%.1"!A<R!35$%.1#5?,5\L(&-O9&5T>7 R7RY"15H@
M87,@0D5:-5\Q7R!F<F]M($)%5%)%24)%4B!B971R96EB97(P7R!L969T(&]U
M=&5R(&IO:6X <at> 0T]$15]404(@8V]D971A8C%?(&]N(&)E=')E:6)E<C!?+D%.
M4D5$15])1#UC;V1E=&%B,5\N0T]$15])1"!L969T(&]U=&5R(&IO:6X <at> 0T]$
M15]465 @8V]D971Y<#)?(&]N(&-O9&5T86(Q7RY#3T1%7U194%])1#UC;V1E
M='EP,E\N0T]$15]465!?240@=VAE<F4 <at> 8F5T<F5I8F5R,%\N0D544D5)7TE$
M/3\-"DAI8F5R;F%T93H@<V5L96-T(&)E=')E:6)E<C!?+D)%5%)%25])1"!A
M<R!"151214DQ7S)?,E\L(&)E=')E:6)E<C!?+D%$4D534T%4(&%S($%$4D53
M4T%4,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%(&%S($%.4D5$13)?,E\L(&)E
M=')E:6)E<C!?+D5?34%)3"!A<R!%-%\R7S)?+"!B971R96EB97(P7RY!4D)%
M25136D5)5$5.(&%S($%20D5)5%-:-5\R7S)?+"!B971R96EB97(P7RY&05@@
M87,@1D%8,E\R7RP <at> 8F5T<F5I8F5R,%\N3D%-12!A<R!.04U%,E\R7RP <at> 8F5T
M<F5I8F5R,%\N3U)44U1%24Q?0D5:(&%S($]25%-414E,.%\R7S)?+"!B971R
M96EB97(P7RY/4E137T)%6B!A<R!/4E13.5\R7S)?+"!B971R96EB97(P7RY0
M3%H <at> 87,@4$Q:,E\R7RP <at> 8F5T<F5I8F5R,%\N4$]35$9!0T@@87,@4$]35$9!
M0T <at> R7S)?+"!B971R96EB97(P7RY35$%.1"!A<R!35$%.1#)?,E\L(&)E=')E
M:6)E<C!?+E-44D%34T4 <at> 87,@4U1205-313)?,E\L(&)E=')E:6)E<C!?+E1%
M3"!A<R!414PR7S)?+"!B971R96EB97(P7RY!3E)%1$5?240 <at> 87,@04Y2141%
M,35?,E\R7RP <at> 8V]D971A8C%?+D-/1$5?240 <at> 87,@0T]$13%?-%\P7RP <at> 8V]D
M971A8C%?+D-/1$4 <at> 87,@0T]$131?,%\L(&-O9&5T86(Q7RY#3T1%7T)%6B!A
M<R!#3T1%,U\T7S!?+"!C;V1E=&%B,5\N24Y!2U1)5E]*3B!A<R!)3D%+5$E6
M-%\T7S!?+"!C;V1E=&%B,5\N045.1%]$050 <at> 87,@045.1#5?-%\P7RP <at> 8V]D
M971A8C%?+D%%3D1?3E546D52(&%S($%%3D0V7S1?,%\L(&-O9&5T86(Q7RY3
M5$%.1"!A<R!35$%.1#1?,%\L(&-O9&5T86(Q7RY33U)424521D5,1"!A<R!3
M3U)424521CA?-%\P7RP <at> 8V]D971A8C%?+D-/1$5?5%E07TE$(&%S($-/1$4Y
M7S1?,%\L(&-O9&5T>7 R7RY#3T1%7U194%])1"!A<R!#3T1%,5\U7S%?+"!C
M;V1E='EP,E\N0D5-15)+1R!A<R!"14U%4DM'-5\Q7RP <at> 8V]D971Y<#)?+D-/
M1$5?0D5:7TQ!14Y'12!A<R!#3T1%,U\U7S%?+"!C;V1E='EP,E\N0T]$15],
M045.1T4 <at> 87,@0T]$131?-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?5%E0(&%S($-/
M1$4U7S5?,5\L(&-O9&5T>7 R7RY01DQ%1T)!4E]*3B!A<R!01DQ%1T)!4C9?
M-5\Q7RP <at> 8V]D971Y<#)?+E-404Y$(&%S(%-404Y$-5\Q7RP <at> 8V]D971Y<#)?
M+D)%6B!A<R!"15HU7S%?(&9R;VT <at> 0D544D5)0D52(&)E=')E:6)E<C!?(&QE
M9G0@;W5T97(@:F]I;B!#3T1%7U1!0B!C;V1E=&%B,5\@;VX <at> 8F5T<F5I8F5R
M,%\N04Y2141%7TE$/6-O9&5T86(Q7RY#3T1%7TE$(&QE9G0@;W5T97(@:F]I
M;B!#3T1%7U194"!C;V1E='EP,E\@;VX <at> 8V]D971A8C%?+D-/1$5?5%E07TE$
M/6-O9&5T>7 R7RY#3T1%7U194%])1"!W:&5R92!B971R96EB97(P7RY"1512
M14E?240]/PT*2&EB97)N871E.B!S96QE8W0 <at> 8F5T<F5I8F5R,%\N0D544D5)
M7TE$(&%S($)%5%)%23%?,E\R7RP <at> 8F5T<F5I8F5R,%\N041215-3050 <at> 87,@
M041215-3050R7S)?+"!B971R96EB97(P7RY!3E)%1$4 <at> 87,@04Y2141%,E\R
M7RP <at> 8F5T<F5I8F5R,%\N15]-04E,(&%S($4T7S)?,E\L(&)E=')E:6)E<C!?
M+D%20D5)5%-:14E414X <at> 87,@05)"14E44UHU7S)?,E\L(&)E=')E:6)E<C!?
M+D9!6"!A<R!&05 <at> R7S)?+"!B971R96EB97(P7RY.04U%(&%S($Y!344R7S)?
M+"!B971R96EB97(P7RY/4E135$5)3%]"15H <at> 87,@3U)44U1%24PX7S)?,E\L
M(&)E=')E:6)E<C!?+D]25%-?0D5:(&%S($]25%,Y7S)?,E\L(&)E=')E:6)E
M<C!?+E!,6B!A<R!03%HR7S)?+"!B971R96EB97(P7RY03U-41D%#2"!A<R!0
M3U-41D%#2#)?,E\L(&)E=')E:6)E<C!?+E-404Y$(&%S(%-404Y$,E\R7RP@
M8F5T<F5I8F5R,%\N4U1205-312!A<R!35%)!4U-%,E\R7RP <at> 8F5T<F5I8F5R
M,%\N5$5,(&%S(%1%3#)?,E\L(&)E=')E:6)E<C!?+D%.4D5$15])1"!A<R!!
M3E)%1$4Q-5\R7S)?+"!C;V1E=&%B,5\N0T]$15])1"!A<R!#3T1%,5\T7S!?
M+"!C;V1E=&%B,5\N0T]$12!A<R!#3T1%-%\P7RP <at> 8V]D971A8C%?+D-/1$5?
M0D5:(&%S($-/1$4S7S1?,%\L(&-O9&5T86(Q7RY)3D%+5$E67TI.(&%S($E.
M04M4258T7S1?,%\L(&-O9&5T86(Q7RY!14Y$7T1!5"!A<R!!14Y$-5\T7S!?
M+"!C;V1E=&%B,5\N045.1%].551:15(@87,@045.1#9?-%\P7RP <at> 8V]D971A
M8C%?+E-404Y$(&%S(%-404Y$-%\P7RP <at> 8V]D971A8C%?+E-/4E1)15)&14Q$
M(&%S(%-/4E1)15)&.%\T7S!?+"!C;V1E=&%B,5\N0T]$15]465!?240 <at> 87,@
M0T]$13E?-%\P7RP <at> 8V]D971Y<#)?+D-/1$5?5%E07TE$(&%S($-/1$4Q7S5?
M,5\L(&-O9&5T>7 R7RY"14U%4DM'(&%S($)%34522T<U7S%?+"!C;V1E='EP
M,E\N0T]$15]"15I?3$%%3D=%(&%S($-/1$4S7S5?,5\L(&-O9&5T>7 R7RY#
M3T1%7TQ!14Y'12!A<R!#3T1%-%\U7S%?+"!C;V1E='EP,E\N0T]$15]465 @
M87,@0T]$135?-5\Q7RP <at> 8V]D971Y<#)?+E!&3$5'0D%27TI.(&%S(%!&3$5'
M0D%2-E\U7S%?+"!C;V1E='EP,E\N4U1!3D0 <at> 87,@4U1!3D0U7S%?+"!C;V1E
M='EP,E\N0D5:(&%S($)%6C5?,5\@9G)O;2!"151214E"15(@8F5T<F5I8F5R
M,%\@;&5F="!O=71E<B!J;VEN($-/1$5?5$%"(&-O9&5T86(Q7R!O;B!B971R
M96EB97(P7RY!3E)%1$5?240]8V]D971A8C%?+D-/1$5?240@;&5F="!O=71E
M<B!J;VEN($-/1$5?5%E0(&-O9&5T>7 R7R!O;B!C;V1E=&%B,5\N0T]$15]4
M65!?240]8V]D971Y<#)?+D-/1$5?5%E07TE$('=H97)E(&)E=')E:6)E<C!?
M+D)%5%)%25])1#T_#0I(:6)E<FYA=&4Z('-E;&5C="!B971R96EB97(P7RY"
M151214E?240 <at> 87,@0D544D5),5\R7S)?+"!B971R96EB97(P7RY!1%)%4U-!
M5"!A<R!!1%)%4U-!5#)?,E\L(&)E=')E:6)E<C!?+D%.4D5$12!A<R!!3E)%
M1$4R7S)?+"!B971R96EB97(P7RY%7TU!24P <at> 87,@131?,E\R7RP <at> 8F5T<F5I
M8F5R,%\N05)"14E44UI%251%3B!A<R!!4D)%25136C5?,E\R7RP <at> 8F5T<F5I
M8F5R,%\N1D%8(&%S($9!6#)?,E\L(&)E=')E:6)E<C!?+DY!344 <at> 87,@3D%-
M13)?,E\L(&)E=')E:6)E<C!?+D]25%-414E,7T)%6B!A<R!/4E135$5)3#A?
M,E\R7RP <at> 8F5T<F5I8F5R,%\N3U)44U]"15H <at> 87,@3U)44SE?,E\R7RP <at> 8F5T
M<F5I8F5R,%\N4$Q:(&%S(%!,6C)?,E\L(&)E=')E:6)E<C!?+E!/4U1&04-(
M(&%S(%!/4U1&04-(,E\R7RP <at> 8F5T<F5I8F5R,%\N4U1!3D0 <at> 87,@4U1!3D0R
M7S)?+"!B971R96EB97(P7RY35%)!4U-%(&%S(%-44D%34T4R7S)?+"!B971R
M96EB97(P7RY414P <at> 87,@5$5,,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%7TE$
M(&%S($%.4D5$13$U7S)?,E\L(&-O9&5T86(Q7RY#3T1%7TE$(&%S($-/1$4Q
M7S1?,%\L(&-O9&5T86(Q7RY#3T1%(&%S($-/1$4T7S!?+"!C;V1E=&%B,5\N
M0T]$15]"15H <at> 87,@0T]$13-?-%\P7RP <at> 8V]D971A8C%?+DE.04M4259?2DX@
M87,@24Y!2U1)5C1?-%\P7RP <at> 8V]D971A8C%?+D%%3D1?1$%4(&%S($%%3D0U
M7S1?,%\L(&-O9&5T86(Q7RY!14Y$7TY55%I%4B!A<R!!14Y$-E\T7S!?+"!C
M;V1E=&%B,5\N4U1!3D0 <at> 87,@4U1!3D0T7S!?+"!C;V1E=&%B,5\N4T]25$E%
M4D9%3$0 <at> 87,@4T]25$E%4D8X7S1?,%\L(&-O9&5T86(Q7RY#3T1%7U194%])
M1"!A<R!#3T1%.5\T7S!?+"!C;V1E='EP,E\N0T]$15]465!?240 <at> 87,@0T]$
M13%?-5\Q7RP <at> 8V]D971Y<#)?+D)%34522T<@87,@0D5-15)+1S5?,5\L(&-O
M9&5T>7 R7RY#3T1%7T)%6E],045.1T4 <at> 87,@0T]$13-?-5\Q7RP <at> 8V]D971Y
M<#)?+D-/1$5?3$%%3D=%(&%S($-/1$4T7S5?,5\L(&-O9&5T>7 R7RY#3T1%
M7U194"!A<R!#3T1%-5\U7S%?+"!C;V1E='EP,E\N4$9,14="05)?2DX <at> 87,@
M4$9,14="05(V7S5?,5\L(&-O9&5T>7 R7RY35$%.1"!A<R!35$%.1#5?,5\L
M(&-O9&5T>7 R7RY"15H <at> 87,@0D5:-5\Q7R!F<F]M($)%5%)%24)%4B!B971R
M96EB97(P7R!L969T(&]U=&5R(&IO:6X <at> 0T]$15]404(@8V]D971A8C%?(&]N
M(&)E=')E:6)E<C!?+D%.4D5$15])1#UC;V1E=&%B,5\N0T]$15])1"!L969T
M(&]U=&5R(&IO:6X <at> 0T]$15]465 @8V]D971Y<#)?(&]N(&-O9&5T86(Q7RY#
M3T1%7U194%])1#UC;V1E='EP,E\N0T]$15]465!?240@=VAE<F4 <at> 8F5T<F5I
M8F5R,%\N0D544D5)7TE$/3\-"DAI8F5R;F%T93H@<V5L96-T(&)E=')E:6)E
M<C!?+D)%5%)%25])1"!A<R!"151214DQ7S)?,E\L(&)E=')E:6)E<C!?+D%$
M4D534T%4(&%S($%$4D534T%4,E\R7RP <at> 8F5T<F5I8F5R,%\N04Y2141%(&%S
M($%.4D5$13)?,E\L(&)E=')E:6)E<C!?+D5?34%)3"!A<R!%-%\R7S)?+"!B
M971R96EB97(P7RY!4D)%25136D5)5$5.(&%S($%20D5)5%-:-5\R7S)?+"!B
M971R96EB97(P7RY&05@@87,@1D%8,E\R7RP <at> 8F5T<F5I8F5R,%\N3D%-12!A
M<R!.04U%,E\R7RP <at> 8F5T<F5I8F5R,%\N3U)44U1%24Q?0D5:(&%S($]25%-4
M14E,.%\R7S)?+"!B971R96EB97(P7RY/4E137T)%6B!A<R!/4E13.5\R7S)?
M+"!B971R96EB97(P7RY03%H <at> 87,@4$Q:,E\R7RP <at> 8F5T<F5I8F5R,%\N4$]3
M5$9!0T@@87,@4$]35$9!0T <at> R7S)?+"!B971R96EB97(P7RY35$%.1"!A<R!3
M5$%.1#)?,E\L(&)E=')E:6)E<C!?+E-44D%34T4 <at> 87,@4U1205-313)?,E\L
M(&)E=')E:6)E<C!?+E1%3"!A<R!414PR7S)?+"!B971R96EB97(P7RY!3E)%
M1$5?240 <at> 87,@04Y2141%,35?,E\R7RP <at> 8V]D971A8C%?+D-/1$5?240 <at> 87,@
M0T]$13%?-%\P7RP <at> 8V]D971A8C%?+D-/1$4 <at> 87,@0T]$131?,%\L(&-O9&5T
M86(Q7RY#3T1%7T)%6B!A<R!#3T1%,U\T7S!?+"!C;V1E=&%B,5\N24Y!2U1)
M5E]*3B!A<R!)3D%+5$E6-%\T7S!?+"!C;V1E=&%B,5\N045.1%]$050 <at> 87,@
M045.1#5?-%\P7RP <at> 8V]D971A8C%?+D%%3D1?3E546D52(&%S($%%3D0V7S1?
M,%\L(&-O9&5T86(Q7RY35$%.1"!A<R!35$%.1#1?,%\L(&-O9&5T86(Q7RY3
M3U)424521D5,1"!A<R!33U)424521CA?-%\P7RP <at> 8V]D971A8C%?+D-/1$5?
M5%E07TE$(&%S($-/1$4Y7S1?,%\L(&-O9&5T>7 R7RY#3T1%7U194%])1"!A
M<R!#3T1%,5\U7S%?+"!C;V1E='EP,E\N0D5-15)+1R!A<R!"14U%4DM'-5\Q
M7RP <at> 8V]D971Y<#)?+D-/1$5?0D5:7TQ!14Y'12!A<R!#3T1%,U\U7S%?+"!C
M;V1E='EP,E\N0T]$15],045.1T4 <at> 87,@0T]$131?-5\Q7RP <at> 8V]D971Y<#)?
M+D-/1$5?5%E0(&%S($-/1$4U7S5?,5\L(&-O9&5T>7 R7RY01DQ%1T)!4E]*
M3B!A<R!01DQ%1T)!4C9?-5\Q7RP <at> 8V]D971Y<#)?+E-404Y$(&%S(%-404Y$
M-5\Q7RP <at> 8V]D971Y<#)?+D)%6B!A<R!"15HU7S%?(&9R;VT <at> 0D544D5)0D52
M(&)E=')E:6)E<C!?(&QE9G0@;W5T97(@:F]I;B!#3T1%7U1!0B!C;V1E=&%B
M,5\@;VX <at> 8F5T<F5I8F5R,%\N04Y2141%7TE$/6-O9&5T86(Q7RY#3T1%7TE$
M(&QE9G0@;W5T97(@:F]I;B!#3T1%7U194"!C;V1E='EP,E\@;VX <at> 8V]D971A
M8C%?+D-/1$5?5%E07TE$/6-O9&5T>7 R7RY#3T1%7U194%])1"!W:&5R92!B
M971R96EB97(P7RY"151214E?240]/PT*2&EB97)N871E.B!S96QE8W0 <at> 8F5T
M<F5I8F5R,%\N0D544D5)7TE$(&%S($)%5%)%23%?,E\R7RP <at> 8F5T<F5I8F5R
M,%\N041215-3050 <at> 87,@041215-3050R7S)?+"!B971R96EB97(P7RY!3E)%
M1$4 <at> 87,@04Y2141%,E\R7RP <at> 8F5T<F5I8F5R,%\N15]-04E,(&%S($4T7S)?
M,E\L(&)E=')E:6)E<C!?+D%20D5)5%-:14E414X <at> 87,@05)"14E44UHU7S)?
M,E\L(&)E=')E:6)E<C!?+D9!6"!A<R!&05 <at> R7S)?+"!B971R96EB97(P7RY.
M04U%(&%S($Y!344R7S)?+"!B971R96EB97(P7RY/4E135$5)3%]"15H <at> 87,@
M3U)44U1%24PX7S)?,E\L(&)E=')E:6)E<C!?+D]25%-?0D5:(&%S($]25%,Y
M7S)?,E\L(&)E=')E:6)E<C!?+E!,6B!A<R!03%HR7S)?+"!B971R96EB97(P
M7RY03U-41D%#2"!A<R!03U-41D%#2#)?,E\L(&)E=')E:6)E<C!?+E-404Y$
M(&%S(%-404Y$,E\R7RP <at> 8F5T<F5I8F5R,%\N4U1205-312!A<R!35%)!4U-%
M,E\R7RP <at> 8F5T<F5I8F5R,%\N5$5,(&%S(%1%3#)?,E\L(&)E=')E:6)E<C!?
M+D%.4D5$15])1"!A<R!!3E)%1$4Q-5\R7S)?+"!C;V1E=&%B,5\N0T]$15])
M1"!A<R!#3T1%,5\T7S!?+"!C;V1E=&%B,5\N0T]$12!A<R!#3T1%-%\P7RP@
M8V]D971A8C%?+D-/1$5?0D5:(&%S($-/1$4S7S1?,%\L(&-O9&5T86(Q7RY)
M3D%+5$E67TI.(&%S($E.04M4258T7S1?,%\L(&-O9&5T86(Q7RY!14Y$7T1!
M5"!A<R!!14Y$-5\T7S!?+"!C;V1E=&%B,5\N045.1%].551:15(@87,@045.
M1#9?-%\P7RP <at> 8V]D971A8C%?+E-404Y$(&%S(%-404Y$-%\P7RP <at> 8V]D971A
M8C%?+E-/4E1)15)&14Q$(&%S(%-/4E1)15)&.%\T7S!?+"!C;V1E=&%B,5\N
M0T]$15]465!?240 <at> 87,@0T]$13E?-%\P7RP <at> 8V]D971Y<#)?+D-/1$5?5%E0
M7TE$(&%S($-/1$4Q7S5?,5\L(&-O9&5T>7 R7RY"14U%4DM'(&%S($)%3452
M2T<U7S%?+"!C;V1E='EP,E\N0T]$15]"15I?3$%%3D=%(&%S($-/1$4S7S5?
M,5\L(&-O9&5T>7 R7RY#3T1%7TQ!14Y'12!A<R!#3T1%-%\U7S%?+"!C;V1E
M='EP,E\N0T]$15]465 @87,@0T]$135?-5\Q7RP <at> 8V]D971Y<#)?+E!&3$5'
M0D%27TI.(&%S(%!&3$5'0D%2-E\U7S%?+"!C;V1E='EP,E\N4U1!3D0 <at> 87,@
M4U1!3D0U7S%?+"!C;V1E='EP,E\N0D5:(&%S($)%6C5?,5\@9G)O;2!"1512
M14E"15(@8F5T<F5I8F5R,%\@;&5F="!O=71E<B!J;VEN($-/1$5?5$%"(&-O
M9&5T86(Q7R!O;B!B971R96EB97(P7RY!3E)%1$5?240]8V]D971A8C%?+D-/
M1$5?240@;&5F="!O=71E<B!J;VEN($-/1$5?5%E0(&-O9&5T>7 R7R!O;B!C
M;V1E=&%B,5\N0T]$15]465!?240]8V]D971Y<#)?+D-/1$5?5%E07TE$('=H
M97)E(&)E=')E:6)E<C!?+D)%5%)%25])1#T_#0I(:6)E<FYA=&4Z('-E;&5C
M="!B971R96EB97(P7RY"151214E?240 <at> 87,@0D544D5),5\R7S)?+"!B971R
M96EB97(P7RY!1%)%4U-!5"!A<R!!1%)%4U-!5#)?,E\L(&)E=')E:6)E<C!?
M+D%.4D5$12!A<R!!3E)%1$4R7S)?+"!B971R96EB97(P7RY%7TU!24P <at> 87,@
M131?,E\R7RP <at> 8F5T<F5I8F5R,%\N05)"14E44UI%251%3B!A<R!!4D)%2513
M6C5?,E\R7RP <at> 8F5T<F5I8F5R,%\N1D%8(&%S($9!6#)?,E\L(&)E=')E:6)E
M<C!?+DY!344 <at> 87,@3D%-13)?,E\L(&)E=')E:6)E<C!?+D]25%-414E,7T)%
M6B!A<R!/4E135$5)3#A?,E\R7RP <at> 8F5T<F5I8F5R,%\N3U)44U]"15H <at> 87,@
M3U)44SE?,E\R7RP <at> 8F5T<F5I8F5R,%\N4$Q:(&%S(%!,6C)?,E\L(&)E=')E
M:6)E<C!?+E!/4U1&04-((&%S(%!/4U1&04-(,E\R7RP <at> 8F5T<F5I8F5R,%\N
M4U1!3D0 <at> 87,@4U1!3D0R7S)?+"!B971R96EB97(P7RY35%)!4U-%(&%S(%-4
M4D%34T4R7S)?+"!B971R96EB97(P7RY414P <at> 87,@5$5,,E\R7RP <at> 8F5T<F5I
M8F5R,%\N04Y2141%7TE$(&%S($%.4D5$13$U7S)?,E\L(&-O9&5T86(Q7RY#
M3T1%7TE$(&%S($-/1$4Q7S1?,%\L(&-O9&5T86(Q7RY#3T1%(&%S($-/1$4T
M7S!?+"!C;V1E=&%B,5\N0T]$15]"15H <at> 87,@0T]$13-?-%\P7RP <at> 8V]D971A
M8C%?+DE.04M4259?2DX <at> 87,@24Y!2U1)5C1?-%\P7RP <at> 8V]D971A8C%?+D%%
M3D1?1$%4(&%S($%%3D0U7S1?,%\L(&-O9&5T86(Q7RY!14Y$7TY55%I%4B!A
M<R!!14Y$-E\T7S!?+"!C;V1E=&%B,5\N4U1!3D0 <at> 87,@4U1!3D0T7S!?+"!C
M;V1E=&%B,5\N4T]25$E%4D9%3$0 <at> 87,@4T]25$E%4D8X7S1?,%\L(&-O9&5T
M86(Q7RY#3T1%7U194%])1"!A<R!#3T1%.5\T7S!?+"!C;V1E='EP,E\N0T]$
M15]465!?240 <at> 87,@0T]$13%?-5\Q7RP <at> 8V]D971Y<#)?+D)%34522T<@87,@
M0D5-15)+1S5?,5\L(&-O9&5T>7 R7RY#3T1%7T)%6E],045.1T4 <at> 87,@0T]$
M13-?-5\Q7RP <at> 8V]D971Y<#)?+D-/1$5?3$%%3D=%(&%S($-/1$4T7S5?,5\L
M(&-O9&5T>7 R7RY#3T1%7U194"!A<R!#3T1%-5\U7S%?+"!C;V1E='EP,E\N
M4$9,14="05)?2DX <at> 87,@4$9,14="05(V7S5?,5\L(&-O9&5T>7 R7RY35$%.
M1"!A<R!35$%.1#5?,5\L(&-O9&5T>7 R7RY"15H <at> 87,@0D5:-5\Q7R!F<F]M
M($)%5%)%24)%4B!B971R96EB97(P7R!L969T(&]U=&5R(&IO:6X <at> 0T]$15]4
M04(@8V]D971A8C%?(&]N(&)E=')E:6)E<C!?+D%.4D5$15])1#UC;V1E=&%B
M,5\N0T]$15])1"!L969T(&]U=&5R(&IO:6X <at> 0T]$15]465 @8V]D971Y<#)?
M(&]N(&-O9&5T86(Q7RY#3T1%7U194%])1#UC;V1E='EP,E\N0T]$15]465!?
@240@=VAE<F4 <at> 8F5T<F5I8F5R,%\N0D544D5)7TE$/3\`
`
end
Permalink | Reply | 5 comments |
headers
Martin Taal | 2 Sep 13:01

Re: lazy = "true"

Hi Hui,
What you can is add the following to your many-to-one tags (to betreiber).
fetch="join"

this tells hibernate to do join fetching instead of select fetching (the default).

gr. Martin

Hui Gao wrote:
> Hi Martin,
> 
> thank you ver much for the soon answer.
> 
> The many selects are caused by the single association. The problem is: in a 
> query,  more than 7000 objects KomKa are fetched. KomKa has a FK to Object 
> Betreiber, so more than 7000 selects are created to select object Betreiber.
> 
> I attaced the part of the mapping file and the tracing
> 
> By the way: we must use old database and there is no column need by a list 
> for sorting. So I use bag and not list for the collection.
> 
> Best regards,
> 
> Hui 
> 
> 
> 
> Hibernate Mapping file:
> 
> <class entity-name="KomKa" lazy="false" table="KOM_KA">
> 
> <id name="abwAnlId" unsaved-value="0" column="ABW_ANL_ID" 
> 
> type="int"><generator class="native"/></id> 
> 
> .......
> <many-to-one name="abwBeseitPfliId" entity-name="Betreiber" 
> 
> cascade="persist, merge, save-update, lock, refresh" update="true" not-null="false"> 
> 
> <column name="ABW_BESEIT_PFLI_ID"/> 
> 
> </many-to-one>
> 
> ...
> 
> <many-to-one name="betreiId" entity-name="Betreiber" 
> 
> cascade="persist, merge, save-update, lock, refresh" update="true" not-null="false"> 
> 
> <column name="BETREI_ID"/> 
> 
> </many-to-one>
> 
> </class>
> 
> 
> 
> <class entity-name="Betreiber" lazy="false" table="BETREIBER">
> 
> <id name="betreiId" unsaved-value="0" column="BETREI_ID" 
> 
> type="int"><generator class="native"/></id>
> 
> ....
> 
> <bag name="komKalist" lazy="true"
> 
> cascade="persist, merge, save-update, lock" 
> 
> access="org.elver.store.hibernate.mapping.elist.EListPropertyAccessor">
> 
> <key column="ABW_BESEIT_PFLI_ID"/>
> 
> <one-to-many entity-name="KomKa"/> 
> 
> </bag>
> 
> 
> <bag name="komKas" lazy="true"
> 
> cascade="persist, merge, save-update, lock" 
> 
> access="org.elver.store.hibernate.mapping.elist.EListPropertyAccessor">
> 
> <key column="BETREI_ID"/>
> 
> <one-to-many entity-name="KomKa"/> 
> 
> </bag>
> 
> </class>
> 
> 
> 
> 
> Trace:
> 
> Hibernate: select distinct komka0_.ABW_ANL_ID as ABW1_15_, komka0_.NAME as NAME15_,
komka0_.BEMERKG as BEMERKG15_, komka0_.AEND_DAT as AEND4_15_, komka0_.AEND_NUTZER as AEND5_15_,
komka0_.ANREDE as ANREDE15_, komka0_.ADRESSAT as ADRESSAT15_, komka0_.STRASSE as STRASSE15_,
komka0_.PLZ as PLZ15_, komka0_.ORTS_BEZ as ORTS10_15_, komka0_.ORTSTEIL_BEZ as ORTSTEIL11_15_,
komka0_.POSTFACH as POSTFACH15_, komka0_.TEL as TEL15_, komka0_.FAX as FAX15_, komka0_.E_MAIL as
E15_15_, komka0_.ZUSATZNAME as ZUSATZNAME15_, komka0_.SON_KA_JN as SON17_15_, komka0_.ANREDE_ID
as ANREDE18_15_, komka0_.KA_NR as KA19_15_, komka0_.AUSSER_HESS_KA_JN as AUSSER20_15_,
komka0_.ANGE_AUSSER_HESS_GEM as ANGE21_15_, komka0_.AUSLEGG_ANGE_EW as AUSLEGG22_15_,
komka0_.CD_AUSLEGG_FRACHT as CD23_15_, komka0_.ABW_BESEIT_PFLI_ID as ABW24_15_,
komka0_.CD_BEH_NACH_REIN as CD25_15_, komka0_.CD_BEH_VOR_REIN as CD26_15_, komka0_.C
 D_AUSLEGG_ABW_MG as CD27_15_, komka0_.BETREI_ID as BETREI28_15_, komka0_.CD_BEH_HAUPT_REIN
 as CD29_15_ from KOM_KA komka0_, BERECHTIGUNGEN_V berechtigu1_ where
komka0_.ABW_ANL_ID=berechtigu1_.ABW_ANL_ID and (berechtigu1_.BEHOERDE_ID=? or
berechtigu1_.BEH_BEHOERDE_ID=?) and (berechtigu1_.CODE like 'EKVO_') and
(nvl(komka0_.SON_KA_JN, 0)=0 or nvl(komka0_.CD_AUSLEGG_ABW_MG, 0)=? and
nvl(komka0_.AUSLEGG_ANGE_EW, 0)>?) and  not (exists (select kazustand2_.ABW_ANL_ID from KA_ZUSTAND
kazustand2_ where kazustand2_.ABW_ANL_ID=komka0_.ABW_ANL_ID and kazustand2_.CD_KA_ZUSTAND=?))
and (komka0_.ABW_ANL_ID in (select komka3_.ABW_ANL_ID from KOM_KA komka3_, BETREIBER betreiber4_
where betreiber4_.BETREI_ID=komka3_.BETREI_ID and komka3_.SON_KA_JN=?)) order by komka0_.NAME, komka0_.ZUSATZNAME
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?
> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, betreiber0_.ADRESSAT as ADRESSAT2_2_,
betreiber0_.ANREDE as ANREDE2_2_, betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as
ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_,
betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as ORTS9_2_2_, betreiber0_.PLZ
as PLZ2_2_, betreiber0_.POSTFACH as POSTFACH2_2_, betreiber0_.STAND as STAND2_2_,
betreiber0_.STRASSE as STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as
ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as CODE4_0_, codetab1_.CODE_BEZ as
CODE3_4_0_, codetab1_.INAKTIV_JN as INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_,
codetab1_.AEND_NUTZER as AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as
SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
 etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, codetyp2_.CODE_LAE
NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN as PFLEGBAR6_5_1_,
codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ from BETREIBER betreiber0_ left outer join
CODE_TAB codetab1_ on betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_
on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where betreiber0_.BETREI_ID=?

--

-- 

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@... - mtaal@...
Web: www.springsite.com - www.elver.org
Permalink | Reply | 4 comments |
headers
Hui Gao | 2 Sep 15:27
Picon

Re: lazy = "true"

Hi Martin,

I try it and the mappingfile is :

<class entity-name="KomKa" lazy="false" table="KOM_KA">

<id name="abwAnlId" unsaved-value="0" column="ABW_ANL_ID"

type="int"><generator class="native"/></id>

......

<many-to-one name="betreiId" entity-name="Betreiber" fetch="join"

cascade="persist, merge, save-update, lock, refresh" update="true" 
not-null="false">

<column name="BETREI_ID"/>

</many-to-one>

<many-to-one name="abwBeseitPfliId" entity-name="Betreiber" fetch="join"

cascade="persist, merge, save-update, lock, refresh" update="true" 
not-null="false">

<column name="ABW_BESEIT_PFLI_ID"/>

</many-to-one>

But it does not chang the result. Is something wrong with my mapping 
mappingfile?

It is a serious problem for our application, it throws an exception and can 
not be started.

Best Regards,

Hui

"Martin Taal" <mtaal@...> schrieb im 
Newsbeitrag news:44F96492.3090300@...
> Hi Hui,
> What you can is add the following to your many-to-one tags (to betreiber).
> fetch="join"
>
> this tells hibernate to do join fetching instead of select fetching (the 
> default).
>
> gr. Martin
>
> Hui Gao wrote:
>> Hi Martin,
>>
>> thank you ver much for the soon answer.
>>
>> The many selects are caused by the single association. The problem is: in 
>> a query,  more than 7000 objects KomKa are fetched. KomKa has a FK to 
>> Object Betreiber, so more than 7000 selects are created to select object 
>> Betreiber.
>>
>> I attaced the part of the mapping file and the tracing
>>
>> By the way: we must use old database and there is no column need by a 
>> list for sorting. So I use bag and not list for the collection.
>>
>> Best regards,
>>
>> Hui Hibernate Mapping file:
>>
>> <class entity-name="KomKa" lazy="false" table="KOM_KA">
>>
>> <id name="abwAnlId" unsaved-value="0" column="ABW_ANL_ID" 
>> type="int"><generator class="native"/></id> .......
>> <many-to-one name="abwBeseitPfliId" entity-name="Betreiber" 
>> cascade="persist, merge, save-update, lock, refresh" update="true" 
>> not-null="false"> <column name="ABW_BESEIT_PFLI_ID"/> </many-to-one>
>>
>> ...
>>
>> <many-to-one name="betreiId" entity-name="Betreiber" cascade="persist, 
>> merge, save-update, lock, refresh" update="true" not-null="false"> 
>> <column name="BETREI_ID"/> </many-to-one>
>>
>> </class>
>>
>>
>>
>> <class entity-name="Betreiber" lazy="false" table="BETREIBER">
>>
>> <id name="betreiId" unsaved-value="0" column="BETREI_ID" 
>> type="int"><generator class="native"/></id>
>>
>> ....
>>
>> <bag name="komKalist" lazy="true"
>>
>> cascade="persist, merge, save-update, lock" 
>> access="org.elver.store.hibernate.mapping.elist.EListPropertyAccessor">
>>
>> <key column="ABW_BESEIT_PFLI_ID"/>
>>
>> <one-to-many entity-name="KomKa"/> </bag>
>>
>>
>> <bag name="komKas" lazy="true"
>>
>> cascade="persist, merge, save-update, lock" 
>> access="org.elver.store.hibernate.mapping.elist.EListPropertyAccessor">
>>
>> <key column="BETREI_ID"/>
>>
>> <one-to-many entity-name="KomKa"/> </bag>
>>
>> </class>
>>
>>
>>
>>
>> Trace:
>>
>> Hibernate: select distinct komka0_.ABW_ANL_ID as ABW1_15_, komka0_.NAME 
>> as NAME15_, komka0_.BEMERKG as BEMERKG15_, komka0_.AEND_DAT as AEND4_15_, 
>> komka0_.AEND_NUTZER as AEND5_15_, komka0_.ANREDE as ANREDE15_, 
>> komka0_.ADRESSAT as ADRESSAT15_, komka0_.STRASSE as STRASSE15_, 
>> komka0_.PLZ as PLZ15_, komka0_.ORTS_BEZ as ORTS10_15_, 
>> komka0_.ORTSTEIL_BEZ as ORTSTEIL11_15_, komka0_.POSTFACH as POSTFACH15_, 
>> komka0_.TEL as TEL15_, komka0_.FAX as FAX15_, komka0_.E_MAIL as E15_15_, 
>> komka0_.ZUSATZNAME as ZUSATZNAME15_, komka0_.SON_KA_JN as SON17_15_, 
>> komka0_.ANREDE_ID as ANREDE18_15_, komka0_.KA_NR as KA19_15_, 
>> komka0_.AUSSER_HESS_KA_JN as AUSSER20_15_, komka0_.ANGE_AUSSER_HESS_GEM 
>> as ANGE21_15_, komka0_.AUSLEGG_ANGE_EW as AUSLEGG22_15_, 
>> komka0_.CD_AUSLEGG_FRACHT as CD23_15_, komka0_.ABW_BESEIT_PFLI_ID as 
>> ABW24_15_, komka0_.CD_BEH_NACH_REIN as CD25_15_, komka0_.CD_BEH_VOR_REIN 
>> as CD26_15_, komka0_.C
> D_AUSLEGG_ABW_MG as CD27_15_, komka0_.BETREI_ID as BETREI28_15_, 
> komka0_.CD_BEH_HAUPT_REIN
> as CD29_15_ from KOM_KA komka0_, BERECHTIGUNGEN_V berechtigu1_ where 
> komka0_.ABW_ANL_ID=berechtigu1_.ABW_ANL_ID and (berechtigu1_.BEHOERDE_ID=? 
> or berechtigu1_.BEH_BEHOERDE_ID=?) and (berechtigu1_.CODE like 'EKVO_') 
> and (nvl(komka0_.SON_KA_JN, 0)=0 or nvl(komka0_.CD_AUSLEGG_ABW_MG, 0)=? 
> and nvl(komka0_.AUSLEGG_ANGE_EW, 0)>?) and  not (exists (select 
> kazustand2_.ABW_ANL_ID from KA_ZUSTAND kazustand2_ where 
> kazustand2_.ABW_ANL_ID=komka0_.ABW_ANL_ID and 
> kazustand2_.CD_KA_ZUSTAND=?)) and (komka0_.ABW_ANL_ID in (select 
> komka3_.ABW_ANL_ID from KOM_KA komka3_, BETREIBER betreiber4_ where 
> betreiber4_.BETREI_ID=komka3_.BETREI_ID and komka3_.SON_KA_JN=?)) order by 
> komka0_.NAME, komka0_.ZUSATZNAME
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
> codetyp2_.CODE_LAE
> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
> betreiber0_.BETREI_ID=?
>
> -- 
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal@... - 
> mtaal@...
> Web: www.springsite.com - www.elver.org
>
Permalink | Reply | 3 comments |
headers
Martin Taal | 2 Sep 16:00

Re: lazy = "true"

Hi Hui,
Your mapping seems fine to me. Elver does not influence this part of hibernate so if it does not do 
it the cause must be somewhere in hibernate.
Did you check the log to see if the selects for betreiber are the problem (or maybe something else)?
Does betreiber also have many-to-ones?

Another approach I was thinking of is to use a tupled query in which you join the betreibers 
yourselve. Hopefully hibernate will discover that the betreibers have already been loaded. You 
should maybe try to list the betreibers first in the query.

Hui Gao wrote:
> Hi Martin,
> 
> I try it and the mappingfile is :
> 
> <class entity-name="KomKa" lazy="false" table="KOM_KA">
> 
> <id name="abwAnlId" unsaved-value="0" column="ABW_ANL_ID"
> 
> type="int"><generator class="native"/></id>
> 
> ......
> 
> <many-to-one name="betreiId" entity-name="Betreiber" fetch="join"
> 
> cascade="persist, merge, save-update, lock, refresh" update="true" 
> not-null="false">
> 
> <column name="BETREI_ID"/>
> 
> </many-to-one>
> 
> <many-to-one name="abwBeseitPfliId" entity-name="Betreiber" fetch="join"
> 
> cascade="persist, merge, save-update, lock, refresh" update="true" 
> not-null="false">
> 
> <column name="ABW_BESEIT_PFLI_ID"/>
> 
> </many-to-one>
> 
> But it does not chang the result. Is something wrong with my mapping 
> mappingfile?
> 
> It is a serious problem for our application, it throws an exception and can 
> not be started.
> 
> Best Regards,
> 
> Hui
> 
> 
> 
> "Martin Taal" <mtaal@...> schrieb im 
> Newsbeitrag news:44F96492.3090300@...
>> Hi Hui,
>> What you can is add the following to your many-to-one tags (to betreiber).
>> fetch="join"
>>
>> this tells hibernate to do join fetching instead of select fetching (the 
>> default).
>>
>> gr. Martin
>>
>> Hui Gao wrote:
>>> Hi Martin,
>>>
>>> thank you ver much for the soon answer.
>>>
>>> The many selects are caused by the single association. The problem is: in 
>>> a query,  more than 7000 objects KomKa are fetched. KomKa has a FK to 
>>> Object Betreiber, so more than 7000 selects are created to select object 
>>> Betreiber.
>>>
>>> I attaced the part of the mapping file and the tracing
>>>
>>> By the way: we must use old database and there is no column need by a 
>>> list for sorting. So I use bag and not list for the collection.
>>>
>>> Best regards,
>>>
>>> Hui Hibernate Mapping file:
>>>
>>> <class entity-name="KomKa" lazy="false" table="KOM_KA">
>>>
>>> <id name="abwAnlId" unsaved-value="0" column="ABW_ANL_ID" 
>>> type="int"><generator class="native"/></id> .......
>>> <many-to-one name="abwBeseitPfliId" entity-name="Betreiber" 
>>> cascade="persist, merge, save-update, lock, refresh" update="true" 
>>> not-null="false"> <column name="ABW_BESEIT_PFLI_ID"/> </many-to-one>
>>>
>>> ...
>>>
>>> <many-to-one name="betreiId" entity-name="Betreiber" cascade="persist, 
>>> merge, save-update, lock, refresh" update="true" not-null="false"> 
>>> <column name="BETREI_ID"/> </many-to-one>
>>>
>>> </class>
>>>
>>>
>>>
>>> <class entity-name="Betreiber" lazy="false" table="BETREIBER">
>>>
>>> <id name="betreiId" unsaved-value="0" column="BETREI_ID" 
>>> type="int"><generator class="native"/></id>
>>>
>>> ....
>>>
>>> <bag name="komKalist" lazy="true"
>>>
>>> cascade="persist, merge, save-update, lock" 
>>> access="org.elver.store.hibernate.mapping.elist.EListPropertyAccessor">
>>>
>>> <key column="ABW_BESEIT_PFLI_ID"/>
>>>
>>> <one-to-many entity-name="KomKa"/> </bag>
>>>
>>>
>>> <bag name="komKas" lazy="true"
>>>
>>> cascade="persist, merge, save-update, lock" 
>>> access="org.elver.store.hibernate.mapping.elist.EListPropertyAccessor">
>>>
>>> <key column="BETREI_ID"/>
>>>
>>> <one-to-many entity-name="KomKa"/> </bag>
>>>
>>> </class>
>>>
>>>
>>>
>>>
>>> Trace:
>>>
>>> Hibernate: select distinct komka0_.ABW_ANL_ID as ABW1_15_, komka0_.NAME 
>>> as NAME15_, komka0_.BEMERKG as BEMERKG15_, komka0_.AEND_DAT as AEND4_15_, 
>>> komka0_.AEND_NUTZER as AEND5_15_, komka0_.ANREDE as ANREDE15_, 
>>> komka0_.ADRESSAT as ADRESSAT15_, komka0_.STRASSE as STRASSE15_, 
>>> komka0_.PLZ as PLZ15_, komka0_.ORTS_BEZ as ORTS10_15_, 
>>> komka0_.ORTSTEIL_BEZ as ORTSTEIL11_15_, komka0_.POSTFACH as POSTFACH15_, 
>>> komka0_.TEL as TEL15_, komka0_.FAX as FAX15_, komka0_.E_MAIL as E15_15_, 
>>> komka0_.ZUSATZNAME as ZUSATZNAME15_, komka0_.SON_KA_JN as SON17_15_, 
>>> komka0_.ANREDE_ID as ANREDE18_15_, komka0_.KA_NR as KA19_15_, 
>>> komka0_.AUSSER_HESS_KA_JN as AUSSER20_15_, komka0_.ANGE_AUSSER_HESS_GEM 
>>> as ANGE21_15_, komka0_.AUSLEGG_ANGE_EW as AUSLEGG22_15_, 
>>> komka0_.CD_AUSLEGG_FRACHT as CD23_15_, komka0_.ABW_BESEIT_PFLI_ID as 
>>> ABW24_15_, komka0_.CD_BEH_NACH_REIN as CD25_15_, komka0_.CD_BEH_VOR_REIN 
>>> as CD26_15_, komka0_.C
>> D_AUSLEGG_ABW_MG as CD27_15_, komka0_.BETREI_ID as BETREI28_15_, 
>> komka0_.CD_BEH_HAUPT_REIN
>> as CD29_15_ from KOM_KA komka0_, BERECHTIGUNGEN_V berechtigu1_ where 
>> komka0_.ABW_ANL_ID=berechtigu1_.ABW_ANL_ID and (berechtigu1_.BEHOERDE_ID=? 
>> or berechtigu1_.BEH_BEHOERDE_ID=?) and (berechtigu1_.CODE like 'EKVO_') 
>> and (nvl(komka0_.SON_KA_JN, 0)=0 or nvl(komka0_.CD_AUSLEGG_ABW_MG, 0)=? 
>> and nvl(komka0_.AUSLEGG_ANGE_EW, 0)>?) and  not (exists (select 
>> kazustand2_.ABW_ANL_ID from KA_ZUSTAND kazustand2_ where 
>> kazustand2_.ABW_ANL_ID=komka0_.ABW_ANL_ID and 
>> kazustand2_.CD_KA_ZUSTAND=?)) and (komka0_.ABW_ANL_ID in (select 
>> komka3_.ABW_ANL_ID from KOM_KA komka3_, BETREIBER betreiber4_ where 
>> betreiber4_.BETREI_ID=komka3_.BETREI_ID and komka3_.SON_KA_JN=?)) order by 
>> komka0_.NAME, komka0_.ZUSATZNAME
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>> Hibernate: select betreiber0_.BETREI_ID as BETREI1_2_2_, 
>>> betreiber0_.ADRESSAT as ADRESSAT2_2_, betreiber0_.ANREDE as ANREDE2_2_, 
>>> betreiber0_.E_MAIL as E4_2_2_, betreiber0_.ARBEITSZEITEN as 
>>> ARBEITSZ5_2_2_, betreiber0_.FAX as FAX2_2_, betreiber0_.NAME as NAME2_2_, 
>>> betreiber0_.ORTSTEIL_BEZ as ORTSTEIL8_2_2_, betreiber0_.ORTS_BEZ as 
>>> ORTS9_2_2_, betreiber0_.PLZ as PLZ2_2_, betreiber0_.POSTFACH as 
>>> POSTFACH2_2_, betreiber0_.STAND as STAND2_2_, betreiber0_.STRASSE as 
>>> STRASSE2_2_, betreiber0_.TEL as TEL2_2_, betreiber0_.ANREDE_ID as 
>>> ANREDE15_2_2_, codetab1_.CODE_ID as CODE1_4_0_, codetab1_.CODE as 
>>> CODE4_0_, codetab1_.CODE_BEZ as CODE3_4_0_, codetab1_.INAKTIV_JN as 
>>> INAKTIV4_4_0_, codetab1_.AEND_DAT as AEND5_4_0_, codetab1_.AEND_NUTZER as 
>>> AEND6_4_0_, codetab1_.STAND as STAND4_0_, codetab1_.SORTIERFELD as 
>>> SORTIERF8_4_0_, codetab1_.CODE_TYP_ID as CODE9_4_0_, 
>>> codetyp2_.CODE_TYP_ID as CODE1_5_1_, cod
>> etyp2_.BEMERKG as BEMERKG5_1_, codetyp2_.CODE_BEZ_LAENGE as CODE3_5_1_, 
>> codetyp2_.CODE_LAE
>> NGE as CODE4_5_1_, codetyp2_.CODE_TYP as CODE5_5_1_, codetyp2_.PFLEGBAR_JN 
>> as PFLEGBAR6_5_1_, codetyp2_.STAND as STAND5_1_, codetyp2_.BEZ as BEZ5_1_ 
>> from BETREIBER betreiber0_ left outer join CODE_TAB codetab1_ on 
>> betreiber0_.ANREDE_ID=codetab1_.CODE_ID left outer join CODE_TYP codetyp2_ 
>> on codetab1_.CODE_TYP_ID=codetyp2_.CODE_TYP_ID where 
>> betreiber0_.BETREI_ID=?
>>
>> -- 
>>
>> With Regards, Martin Taal
>>
>> Springsite/Elver.org
>> Office: Hardwareweg 4, 3821 BV Amersfoort
>> Postal: Nassaulaan 7, 3941 EC Doorn
>> The Netherlands
>> Tel: +31 (0)84 420 2397
>> Fax: +31 (0)84 225 9307
>> Mail: mtaal@... - 
>> mtaal@...
>> Web: www.springsite.com - www.elver.org
>>
> 
> 
> 
> 
> 

--

-- 

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@... - mtaal@...
Web: www.springsite.com - www.elver.org
Permalink | Reply | 2 comments |

Gmane