Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » (no subject)
(no subject) [message #727689] Wed, 21 September 2011 20:01 Go to next message
Mike is currently offline Mike
Messages: 49
Registered: July 2009
Member
Hey all

I wrote an own java CRUD application, using PostgreSQL. I have now two serious problem and I cannot find a solution for them :( Both problems has todo with the database

connection.

But let me introduce shortly my application: It's a simple customer/contract management system (nothing special). It's possible to manage customers and related contracts.

A customer has several sub-objects like ID (I mean ID such as a passport), official documents (Permits) and the result is a contract document.

Now what is the problem? In my application there is a use-case that requires to search for customers and display their information (like address, name, ...) and also some

information from their sub-objects like ID-Number, Validity of e.g. the passport, and the validity of the official document attached to the customer. On the database

there are 3 tables for that (Person, Identification, Permit) and a fourth table that stores the contracts. I use the following code to search customers returning a result

set in the form of a List<Person>. It seems that when I iterate through these list, a "layer" in my whole stack tries to reload data from database (I thinks it's the

EclipseLink that tries to load additional information of a person).

And then it happens: exception-2.txt occures ([...]DatasourceAccessor.java:309[...])
The line of code that causes the problem can be found in DatasourceAccessor.java in the EclipseLink-Source! It's (wow what a surprise...):

throw DatabaseException.databaseAccessorNotConnected();

because the "if (this.usesExternalConnectionPooling)" seems to be false!

But why this is, I don't know and I was unable to find till now a solution.

The exception in the file exception-1.txt happens not often and also random! Also for this I have no solution. A lot of forum entries on the Internet I found that says

there is something wrong with the network, but since the Postgresql-Database is installed on my local PC I think it's not that problem. Also firewalls (windows and other

firewall-software) should not be an issue, since I deactivated them. What I found is a strange entry in the logfile of postgresqs says:

2011-09-21 20:52:42 CEST LOG: unerwartetes EOF auf Client-Verbindung
2011-09-21 20:52:42 CEST LOG: konnte Daten vom Client nicht empfangen: No connection could be made because the target machine actively refused it.

But why the target machine actively should refuse it? I don't know

Let me show also show you some code that selects the List of customers that I iterate:

@Override
public List<Person> searchCustomer(String[] searchItems, ECustomerSearchCriterion searchCriterion) throws SQLException
{
List<Person> returnListPerson = new ArrayList<Person>();
Query query = null;
int ctr = 0;

try {
entityManager = DBHelper.getInstance().getMainEntityManager(connectionProperties);
// Compose the Select Statement the old fashioned way:
// SELECT p FROM Person p WHERE p.personState = 1 AND p.personType = 'C'
// ... some Code with error handlings about the parameter
@SuppressWarnings("unchecked") List<Person> resultListPersons = query.getResultList(); //NOI18N
returnListPerson = resultListPersons;
}
catch (Exception e) {
throw new SQLException(e);
}
finally {
if (entityManager != null && entityManager.isOpen()) {
entityManager.close();
}
}

if (returnListPerson.isEmpty()) {
return null;
}
else {
return returnListPerson;
}
}

As you can see, nothing special! When this function returns there is no further database-access (from my side, like using EntityManager or something like that, ...). The

code happens after the call of this function is simply iterate through the returnListPerson and access the database objects in it (to display them).

A word about versions and libraries:

- Operating System: Windows 7 Ultimate English, 64bit
- Java-Version: 1.6.0_26 Java(TM) Runtime Environment (build 1.6.0_26-b03), Java HotSpot (TM) 64-Bit Server VM (build 20.1-b02, mixed mode)
- NetBeans Development Environment 7.0 (Build 201104080000)
- Postgres-Java-Driver: postgresql-9.0-801.jdbc4.jar
- Javax-Persistence (JPA): javax.persistence_2.0.3v201010191057.jar
- Eclipselink: ecliselink.jar (MANIFEST.MF says "Implementation-Version: 2.3.0.v20110604-r9504
- Postgresql: select version(); says PostgreSQL 9.0.3, compiled by Visual C++ build 1500, 64-bit

So, that's what I can give you for information. I'm looking since a couple of weeks through the internet about this problem and haven't found a solution till now :( I

start to dispair about this problem :(

Hope you can help!
Greetings, Mike

begin 644 files.zip
M4$L#!!0``@`(`&IK93Z7>O'-P!8``%U(```3````<&]S=&=R97-Q;"YC;VYF
M+G1X=,U<7W,;-Y)_3JKR'1!I5;3W2)J2[23E/>>.EAB;&_V+2-F;?9D"9T`2
MJYG!>("11#_L9]_N!C"#H2B;3H57IZ3*%M!H`(U&]Z\;/=YGO<_]?/?M/KM4
MVBQ*,?GME,4JG\M%57(C5<[F,A5(\"4.2#-=2DT#D(>6VFBFYBR5N:"_F*5@
M<U5FKQPY8SG/!'O-;GE:"=?X9`I4>Z_W&+!2!2Z!I_VGC'U82B-TP6/!,KYB
M,\$J+9(^8\<JRT0.4_%2,)F;4B55+!)V)\T2&>[M[S&>K^Z6`OIA0YP6!`-Q
MHEAE12J,@#9M<(T%+V%-1I2T-F":)XRGJ;H3"3*CE6H6\QQ7,%<5=,N<=A9(
M,%%QA6LB"?9KX=!TV"Z2GJH,T\(8F2\TTTMUEUL^7H"E*$JA@99X)V+.J]2X
MZ9$CNQ(]QPU8P*8<,Q3;^<64Z6H^E[$D!@JXW8K2,$F_/&#X-^2W4A7+!<B-
MR%/%$R+4HH2A_0<'#'^6`FA`H):$:<-+4Q4D,1!V'@P'TEC(6Q0GFXS?OKN^
M1&9:+O!L&1O/:7:12+M;FH!.JJSR'#>E5]J(K$MD2WXK<)&6$0X@9G8B4"]B
M$2]YOH#Y<+O\1C`QGXO8=!ET@]JPO6(1Q29U&]V#-4Q41GSJ\]==V(6,EZ16
M&2]O0#0S(+_KPJB/E8167F]]69D$CQ#W#L>&DH"ID5\PNQ?B,%\%:H:JQ%.M
M4)\6("/X#<6$9PO<>JBK[A[XL[.3=IGH+_I=TO#"JIYFO9BE"K:F\APFA#'Z
MM<K]]H*]>06V8@(--RAJ9J05`EX=FFIO,IKN,6L4:#U^#V<B4^6*5;DT^A5C
M-V_@%M_(5,U6<$F9^YD"NYHD@^;7+),IW#0!"TRT-0&MGS/DDXD%;_%I_6#K
M:_8XB[?(8B$_QR*#FX9+R2N@V,!BBY\EK6*IJO(/,DB(0<)7,![_V^_]J3^X
MJ%_&IR-V>G$\G(XOSB<[F,);M;9U<I8>;MDM+R6?I<*:YJ0D[9Z7*B/=ZIVT
ME!R9.3V'2WKY]F0X'3*1W\I2Y6CE:F[=QC:"YI)5AQMS3$[K1**I`E8)-SQ*
MX)+&!O7T->O4!)UOOMDG(X`T:'1YKF`]):O)O_OV&_P!7V3OA[_PVM_MIS##
M<L8C,E0A[V=@5Z"CCRZT`PR6<#%[,Z[QBE4P"1CK.'2K6\PC$QBU>2;JJN>B
MWS8Z[R_/@L('*RSNP3B`38X*F43>S(-TH*-(P9N8=(5^I@MM2%MR=CD^J?W!
M72F-$>3O'C*"M3_)52Z>DOB1%(XM7^.RW5)W<EF.+\[/1\=T4]CP_(0-KZ?O
M1N?3L;T].[H\/51;9ZG9Q*,!ZD0\(O*()PEL78,$0(!_M;);@K4>7S+7]43H
MI^@9[`!PFW^KI4C7JZ<%VGV\*Q[CU$P;4G>%R6%V4A7S%%6WT\5)86I`0-N<
M3:'`[[UF+U\\/_HB;<;O0S\%PPX'@R_>!G:NC`!O,LYC@!\:L<$ZHU@A[OSW
MB\&`61<`.]9+L$`)>!;R6@5<=N35C&(Z5:#615II<*#Q#;-`\XD6@OACFXY@
M7`3JFFM.@YZBINL*6L&:E!&:)'#,R=JNGG]A1^`?[R,-_(5I&ZS.-U\Q<E$J
M@%YVU%<,@[5G4FNWU,&//_Z(HV=B`6:10,``%0*-I8H-3]$6D&'9RG+-5/XO
M<)#`6,WGEIPGB$,!`'CD="LY>V/IOH9GY`('M]U0>XU#]97'\-O:OQ[<P+@"
MP[0B&#=LVVM[8]M&/$*\A$`>=!?0!,YQJ'L_#`:(";1.PYU_;E-`&L6R6"(P
M@ST-3T]??3\\>??J^].+#Z^^'_WC\M7W9R<O7_WO9'HU.G\[?8?6WL4D;#(!
M;&;';B5`G*L4N5@H(^TF4IE)NK6'1V=OD',&40W9"7*0,V'N!!B6UB#<8,&U
MOE-E$@FXBROKN6'#.7K?6417@D(HNDDD"2OG7T4Y$Z6RH=7;R61X.8;FFW(6
M69V(;L3*NXR.[REO_8E[K&NO1\U,Y>GJJ:..P>'*7-,:=#AUCTV/+V$!8!%3
M"D=Z-G0`H`LXA/W(3%SL40R1",-E2MAL'QIA37X,>%U:VP#G!W;1KZ,1^*_3
M41>QA,.EC6$=0%,*EUI;Z$YQC-?7#;P!TY0`HQ[P/Y^^/_TS)HCI;->X'Y]/
MM^6W(^][-9I<7%\=C]CU9/AVQ)Z(^U@4AGT8GC[=F>MU(0S];OU#-(.@V:K,
M<[P+*`Z,%0Z/?KIYL]7M`ED5`9>?`B8_#0;(9!_="<#7@B8,O(GVI_()]!FP
MJ+;(F>)AP4U5;@<7'W&0FV=TKO*'1UTE1<1@1X-1?]Q5LK'Q>!+\@-T@6FQ`
ME)]9(X!&DDB5@S@T9@"0%?;>"H"C>&/RQ'LISR)<,*5+P%#=1+`G--5T*.Y4
M?GCA#H7X\#P644CZ`](Z)3CSIP>RCF^B!!1T"30M1;%G;/4+3%,N4G8E-#@L
MD-"UYG!F5OV0#=HX*ZBB5#'NC2#0P#,[>KF=0;>J6]A4!ECS60F!D@6,G:W<
MWC$&*6\H2'G/XZK*V(E(N;L9^[?4%*&JP)ZQ'?0TTV0J>K#>]9`^I"]@Q]&2
MO,MA/0"&@&HFTFRD1CA"@MB2'B"3P24=;3'`>[HC*^3#=6(KCC=PN@BG0*L^
M8)A2.D',%A2UE+44@`W*`3FY>3/=N$MDH,-A:5E%<.ZXZAKM^A6C_C-O-UP<
M]8Q8/.``9EA","805QWU:QY]X&&[H`=NJ6>F8PYH-/',[!:'>I7'2PBL%5SB
M-V+);Z7RV[2Y*KA<D50(90$2@>N/5_X,K=3ZX"=J&P6Z-Q<F7H*QV9F'^'`U
MGH[8\-UH>,).+][NS"NTH[#].XAA4P&6QB:,9,93?]OQ[UW&2]CWK:#,XE(9
M-`YY,MLNA3#'8R#,9&G!R(/!`_B!Z6M_1/*3!:`V+T)09C\XO@B#/-)J10!4
M9AEH,X1[S'+GAED*MQEL!.MFEBJ!,41#4P=I'.F\CBPQ7+3`KMX/Q#L8Y6$R
M=$5D"BP8-TV2]E5-RK`OCQ!%XC1!^]RWL2=^4ICC5.;5_=.0;'T8+9XN@X'M
M5XOE^EQVP/Z\2E-K'HA8>QGO8R):49X8LU#@*@#/I@PI;4I".RDU+AP=1&W?
MGQ]MB0.0QV9KT9B=MMV$0?:<&B-K%TQS./LR(`B8R1@0;VUPW3`M9RDI+B#Y
M8*2=K3;U2Q'?%$KB<XE5\+AN`?B]L`\I&+2B*N683"8H[KNZULUUR3,RP>-E
MFT43$+UT`9%=Q?.![AVNT;JG%XJC>+D0!$O[+S%O41,QUY.XA%:7H:'KL</^
MH,WLCI?T4/`:I[(PUINGVNC1344B%\O9FQME*A$^4G-QE7;7&HD-9>83E3O\
M]?F#]TQ=9K-VPOYWAU/@#T>)SU%M(0=<&G&2G2?+\'``TQ"JXT/%')T5/B'Y
ME>95-D-W,*_#A@URF1@`BAEN]4I@EB^,=Q&GD-4`C&7O@X4GX*T:WD!@^YD#
M,D)O(ZJ&[]H=V0\XQJL802+(H?O(Q2$^&.&$^CMX5']KQ6V+PN,$,$>P'IB3
MYU41H5U`9J$D[SG&1F#\[.N0(T6C2;L022-7\@3@43"J]?<M\!%U>F"?[:E\
MSZO>QTH0?@.=QT-Q%FL[C^+@*7*/O!)YX>+%L$=G6V8"]$G@2U`LT'+XB>N)
MZ!$/'_FP$T(Q:S0=VR9@[!WZE4LXLCDX1B/L%&L+TE[1_J0EU?QP<=NM9T?@
MY+?KT=7O;'I]/C[?'3*Y3!')E1"WDO,^;B7Z'7;+49VCF309+Q#Y^82,ZUAR
MB!86BPVM_U)RG1BE=[^!20;@HI24HV@U"[#4&]CDH)VI4L5:LQ8?-_#6-H$<
M-AF9!(1M46#D@H)`#:L]&G"VOA\Q/Z+6OO6D&83#%<:&^+(,_Y<@)@B55@B1
MJ<0!7%6BLM;8%VZLQN03T='K[`QN)/J?HHI,!4[,DX-S.OP"/4GUP:C!R\^/
MLB!+E>&0H\^,:4!\#*8.Y"H_H24[//KIK(Y/WXH<O&_,?H,[MF(7@/,RH/)A
MP$)\5/XD\.\1("ZAERI-B(]OA8E<SG\-<WB"0JG43^]DZ=)+'OG9YS$X%,O+
M#US`\JQRZZ\=:LD06,PDUTV<Y%;7?]D[Z@\:8I%8B89XJP^(JU_#I@MZ'_1:
M=U'855E!N;6@E3-2@T!U`V<PQFL#,8(MJ+`E9APB<1^GE;:94T*CR!F&(-(!
MWT!11=V.0ZL2KHA3GWGI,C*X^L,-B]]'@PTJDZ9@#40=_OX$/7A1-_00/FT"
M.T>`)E;-ZT?`)ACX^\7X'#P@K[38W3/VZ.KJXHI=C2XOKJ9@7^EU#B+`M[NT
MM1_H61E0VJER<!'+*A(P93+G3N8=;0"AV.?D]SR5B7__QL=NP'LS1XI9M29\
MHC%=%NM;X-C%F(G^1&P(869N\+?@50Z"&O)U,&.1<H/54WWF1M=D-1*`Q@7Z
M5SPW>DARZ)6*D.KZ'?@?2Z>L,W5#*`]':WM%>UUCXZ/+$=ED<-"%L>@$H24-
MHQVLK0LT7.$$]+:K^X`O:9U)O2I$M,UK)0W&;-UV[S53JC'@5-25KNR6Y'R#
M#+"0+,>:,SK#\(FM6$301B?8M-M"L7K9-(-+R30GX^IG^$RKM`)\H;#&"0Y(
MVMHD6[[@ID0VZZ\7']/>P>^]@ZQWD$0'[P[.#B9]6LE^/;&MC2NXP9?T]L0R
M!ZL!00M8D3E"XR=/F0`74!"0Q1E-6>6`XT4$)K!T3W9-B#.>DWVAUW>T6'",
M]:2V=J-15UP#+83;I$`N[AKB.P#B((6:VD^;@"$BBVF6Z&@+5&(Z]>9LWV#Y
M6P7XV8VQ&0XX1A6CC6/!$R/NL.>*1_QFNI1%5KE7B08APD&@MUD?`)?FI$YO
M-,1H8@$74.AHUXFG5XN%%"!09P26#%^7**>,DO;\7:APF!#EL#(*8!(XUUKZ
M:NZ#$4URJ[DN:=XZ>..&-@SK;<*3!Y-Y=SZPZ>DMIF.?F2_#<\!#A5"SJ$P_
M>`H*5M"^<J#LXA9`UT,C0@;M%26I-&D_CV4J*4?;P6*DTT&GZ;0U*^&KGH5P
M>&-,*S*'Y5Q53:TA$:2K9JTG%U3V>#T9T<,UE5?2'"PP,0]LP]8%)]8GY"V7
ML!^GDI8)KC2#L-<E=D$S92R0J?,'$C-WB8T>$U$_R]@GQC!=EHA9M7BYWO!B
MO>'Y>L/1>L-AT!`:9.86%S2XQ$G0`L8<!>-T;FUSCOS_S>YD/E=_:'N/R&?.
M#4^#WPNP#7%+&#2>T)[(K/)2R]<)A.U$(NS_3B3L21UBH-&>SY^VA.3S=2TY
M]0YM=(ZI$FM7DB[8&'3Z9%AKVL;D4LIL*6199P!UE_WL!Z'#")"5'UU7#8-M
M2T'ZQI95VQ1.8/L?9&#]/>>F?<])QE%1(F('-*[K<H963RD<2MC8"^CM88<P
M9F7[?:A%U;M!DM:/6*OJ;;6#,!_M\OF!L-%J,)C1F=+6,+L8AKRM@/UU?0L%
M()92,&\&'!LL$'.PAGAC&Q9RXK[F\AZM^H%AMD!'%R+&E(&](J%5..!87E8T
MB<=6R0[T5]"/A1P/.A*JGS4<@\`'G0A92Y$I@&:X3E*D@D+$AF;9I@F[,%OA
M7V7')V$/GA0Z:%"WK*A=35N3&NKL`?6CI!)(ZRPQ#R_@`8H8:[!)Q<..F"JA
MJ7YK;9EIT$,EY&O:#R0Z('$5ZWZE(=DM?I\A2U/!\85E`.WY\+C;O>S)`.$X
MU7R&E!]Q6J,*6[D+QA(H>FX=`1W]K.63+8,#TJQ.W81E\*SSWP?5P<%!\C/K
M./7$.H3HCDM_B3P`L$4+MN-G5'V>$*G+M;O1H=WJX!ZL'N/?X'(D*<!&!=:+
MZB(MY,;*#XNWR-+YV;!=49K)=@*^`$'"K4HQ2=`<"$%EJKC!JS*7^`*(*`\$
M5-?5MW*<'IJU3"C.YE&K71;LZA,L&B]1?I.K._L,!J<$RTA7W5;IW/2?8<%U
M8UGMD^CNBG^NSZ?CLQ&;3(?3\60Z/I[L+*ZG7->S,>;@,#_O$C;LN(X5+25H
M,F@$U9A((]W[8=U.-51K;7.(8KSY124)M*5(O9ZTV*XB3&ZO&BQ_]()]J7*S
M2#"H<[<"SM90)1HM`Q566RU<#W&Q*S)9T6E\7+#W,Y5+(&[>Q5!MR,M9E--V
M*(7-@6WH$?<BKHS:U%5?IG;?CM1I>#V]>#\\OKX^8Y?#J^'9:#JZVI%&<=BP
M?3AJ7IA=BB3HTM7,'=G_,-91>8<]S-RT-`M?!]T70?;S,11BP["%L`)<M=$B
M^#(JCM4?M:W9"E'YH7\$3O5;THGH'5&5-ZZX[N$;XD9QB>U*6H-Y<HYI;!$4
MY-*OOB@GF`4VI=MCW1]AGOOEP#W\-PLMU1VS]U"[YZIZC99!FRG/>;KZ)+Z>
M*PLP,+'8N%A*_&.(;9-T@_X1/A/[O#`F<T@9R<8XOI];Y0-VAU]DMW%U\U*(
M3X).W>9%C@;NQQZ\S.`$_@$8`7L=(U?VXI?W=>>^J4CMR+XE-Q\GT;G3`XHE
M"9./#2]78M&H<LOK8K*(TJ?LP92/K\BGU^FB;EJ/)7AL/>&T:\H6\-_=ES&G
MX]'Y-/A`AIV,?AE>GTYWYZ8G-?I:*T[3`I^?P3U1Z65G[R\8&>QUBVH&\0/E
M<35$3QFW'^\&KS.DN+X4W99D<!8T(GT7.E#&.JR&\D6]#:UNOCO@]2<U:ZQT
MS:LQD)C=](??D/LREAI!1#.5!)"CWD`#KB.I55J_0M!7N+8&R(BD\\@0I(IH
M"=XQ.\@-/77L%97*EMT#'%C(O.-@A77=K5H4FPT-;PDZG2"P;RHJO"V0/D?Z
MTIF"!R0D%)](#:@0^_+()B=Q=4MQ;\4/?^FZS#>0W6<I/KE8V(-!X0\O.K99
M^8\3.K!4"-!-QRO:J;(OIQ!S_:+*C-M/J$G7R!B;E14(2!R@<K9"AKY&O^X,
M<I?[?RK>KKE%?#8KQ:VLGT,[+IG=H3!IGTWHQ=-]'6R_\;KE,K45UN@!/]7U
M2[B:D!M^04\EG@:79^SWE&489I[XFU"W#"M\P$PE#]H`5`>__ZXJ>JK`]!?$
MURO\#@@_D+;?"C:!'E4O/_/[A+7K9^[[P9)'\U1Q_"AJ(4WS!HR.LW?XLDL`
MXGF3A15YK!);`J8_IA'7L92/B]XG#IHHT@T/$]WU]_GV7Q:06"P(KH]*'_'7
M9-9ELXK$OEK[HAHVD<9AXK3S5H!^Y5TVN9/FDR@!1R<=%R62#N)7)^YK"TK0
M^'1+D.!"D*XM8Q"6<:J^#>.:?EYK.?$!!")*&6_+Q@&6-28.<3W&H<V"B$,&
M*&YO%M<^7D5RT`1FK3Y<26_8H#%RKL`.<9%.C*E*M>AKB:6%G?;S_8D_?I?4
M6X&AEK$KF%_5/N4OT``1E$TCQ/@)Z\;*^IVYV].+XU_9V?!\^'9T!GYW-SYV
M/>N!%E>[<JV-'W!0)6SSF<-7?8HRXO2^%-]X^)@J8_WLOX]^?.S+DZ[/_7IS
MM/_XUR7LK^S)^E>@__7X)R6TMK7UV!>NG1SH>P@_`34]NSP=3G^YN#H#)'5V
M.9R.WXQ/Q]/?=U<NAB8>Z_N#?Y?D/<1?0>D*+TN^`AN0IC7<F$$8JE.NE]''
M"A.C8$SY7-3&=:TTI=47(`],=$9*)DT:P'KIR-JPH%K7);VI&!AL?5'*6_`0
MUF0ZG`+&7.:@!])@66"0[\@37M+7MFA.D*VSD,W0NH2^KC?3K3JRNJZ'"BOL
M%XG'Y$YTDPG*-7:2F"+*WNTZ@7%\/9E>G(W_.3IA%Y<[_+<;8O#B"B,5^^\J
M1#&<NPX^'/+8UM+5__X"(SJ/L+_[]C]02P,$%``"``@`-0(H/J`2NY2<'0``
M@(H``!L```!$871A<V]U<F-E06-C97-S;W(N:F%V82YT>'3M/6MS&\>1G^.J
M_(>Q/D2@0X*2D[@<T4R%HNB$CDPI!!4G=76G6BX&P%J+77AG00KG\+]?/^:U
MNS.+!47YSG5FY2$`.S,]_>Z>GM[#SQ[V[]>?B,_$:;G:5-E\48M1NB>>_O&/
M7^Z+SY\\?2I>54F:R[$XR7-!#RA1226K&SD=T\BK1:;$JBKG5;(423$5]4**
M)$W+Y2HI-EDQ%\NDEE66Y$HDE81/4_C])LGRY#J78EU,945C:#9X<JE$.:-O
MSM(\6RDI7J^O\RP5+[-4%O#QYNGX":UD?G^1J;K*KM=U5A;NJ;'`YVC6VT66
M+BQ0F50P/4`]]<:-A=Y-=%D8X,!.:K&HZ]6SP\/;V]NQY!'CLIH?YG*>Y(=R
ME1_</'TR7M3+G"8VF.F%N;T$C8RL@_^=ENEZ*8M:'<HIK[=:K(@LFJ@%KU%6
MZAE]@W],47$@LB*K@2SBY/4Y@9<M5[G$Z1(":E:52_/P5;EZF17O[!Q_^5=9
MO<,YBK(XN%[/Q7HU!2J+NA1*UHAIJ519P1(B36!C0-"T+`J9\LRPQ74%3(7,
M8^>T?[<9\%J2Y^4M8:R2=;6!X5.:?K8N:!+:Y8/^'0K`]RI)WR5S`+B:6VRO
M9*6`6K)(Y3@K@$.+)!_#=I-KV!IO]>C7G_SZ$\!?6=7B>R#A&.B:CS\[LE_&
MYI/O4[G"_:@A3RM8BIY]6<ZS8OOS/ZQ!\*0:GP(VMS]M]Z8D#"Q2D-WQQ/X3
MY[@&[#S4/%\G*?#E9J?I].Y/KD%V8/BE3,MJ^B$S3/B+[5/DY7S.^Z`!@/\=
MJ*4'O:[*69;+:H>1I&BK\:F5G==EF1.S'6K%?7YQ=79Y<?*2Y?LK%),_O0#>
M5.6Z2N6)%L2O#ND'4C"%2/3N6Q)/,VC5RQ-UAB,B9TDJ4>'?9%/4[J!3ERC3
M6BZ3/*LW**@X"\A\"N(KA9$65MOG$ZLA%!N1\QI!`\.R@EUGJ/UF946_&+51
MS/?90%1)H1):2O$W*3"4D.]ENC:;H*__K*04R&SN$TF->R!9UPO04=\D2ZGT
M0QE@7^N\DXG1>N+IDZ^R/\V_.LS^)$:@8Y^,?[='S]/_//G#X>=?'G[^Y,F7
M!V!OOOU2G!332F;B'!"1+N2--BP"E.7GG__^CU_\_IEX3<B30JU7Q`:P5_SN
M_4:<`$A`CBQE%5POJG(]7XAO7I^,K9X\F4[E5#B6.%VKNEQF_RVK?=":"E1D
M]AX>$*M2U?JIPU4EP>!H7(JS]RP/;@Y"HA(*R09V!X#8T%<PCZ?"*YE,U3X0
MMR1H#D%=LHFT#)7FB5*BRW^.TY2PW_V(?(P[`EX6$U`&4NO[F:Q0#`P73:L,
MA$#D\D;FGAD9$P0X'IBQAN\`V%?7W^,&IQ8`M\6C\&HY\@1L$FBP-$@'#.AE
MY)0]!<.NH36)JW@>?PW^!]#L;U*ND&W3=T:XBO7R&C;$1C%=5[!;M)DU;),)
M,;:#R;N"_ZP5K(1\XIG1%>@"E$#\.B^3Z762)Z1B2<KP6ZD)'1AEE^CL!X2<
MH#@MUT5]Q+_NMBO\I!##4Y@UE5.P]?`9_`-D`,;OM40X66K9DVP`PVR%D/`\
MK\T\$S.-\L';!3!DXGM#@X/#(.P.R&V5U??'"XWN!>60F%RU5C93,QXF?W_I
M(%"-1?!K^+]9AOPS`3\2X+H\.WGQ=G)U<G7V[=G%U>3MZ:LW%U=O7U^^>GUV
M>?4O<2P>7<*L;QU8;PFNMT`^,&_UYI$3D"W0,7)V!.^[R_.KLW[XOL-Y^P$<
MCD+B31'@\>V@3JY>79Z]`,A.SUZ\N=P"]*0I`T/`=ZK.8\-L9H(SK905^-J@
MW\`C\.TJ:HL:5$=`-UR#\I#@063JO+AR(XXB"P*R;A<2UJPZ"S^R&O;1N'>A
M4_-<8Q'`S=?/P+R#A16K/*E1?:.]2&[*;"KF$NS,2"W1,X#P!]09;'$ZA2AE
MSRV&TQCU2G:S`A\UJU#EEP+",:0H3F!=%5*IB=#.&06S:X7$)'T'7H2%)+0C
M9Q1?&WC-XU$5PO`E-4=QTAH"`'`J,53."FFHZJEXM2C7.>"08J=U5?`(?`B5
MOR#/2B]0R65Y@Z8%@SW[!-J/-"]A*8C1P#>CB`RFP]@.8S!`%ZT+:+4!C"A3
M,&405*^1P=T*IPWW+&YV',7_`3[D-(Z3%[2`&!5E;0W<GL^_^\)%&]\F!81S
ME5@F&X*^&X<(,OF..?=][+,]QL<>*W@PWX@EL',Y14IH_P@8O&A)SW*9U<J;
M)YG5*`'>,SB\1)>(/0RWC."T1)I4TX#ZM\BBN3*T&H$-J5#,%D'F&V0GVEA6
M6&PVPPUR\L$#'(OS8HJ>*2A$3J@82<#=L!<#\[!(>&Z:6^P$8WJ%'%1E&`NL
M8$.K*L/$@9X*L`Q>'IHWQ*K'TB2C:+(VAZKF_`!X2][<9S?D7!I.Q04*GN4T
M1T3I&`R8GR01@Q'S59*2W*O&>LP4UQ*\NJ+!SR@;E0165<$1$GY&`^\1>X0*
M%EG@E$FNG_Z^3@BO>]XNSK6S31I%@Z?5DD)1RP&[-PU9'YV9;\]5"?I$3AO[
MW6.@;IQ1PF6:6()?*PC9LF5S78L60%EHPP?>?,0.2"-1H5ID&AZT]1(\\`Z4
M!>E1<NS7%;O<@##$AB_#;>EI_=Z5H$+>MADFU?H<-P/FMU*UP(S(IA$M>F0E
MX,">9KF>\7W-''#EBS?(5)-BF`,SQ`QLV8*!VW9\GF<SZ3,32^'UQGM$_^*M
M=E%BDDV':$W#4*QSF#+SQ+DLR"*EF*>#>4FA>R$?:[(A.J:5+3'"[I(G7<7B
MV^=0R)(G\^VF`&R=.HOII*A.>PX*[V!:(H^5.HUHO0@!\*3OO/AJ0A'_+1`;
M'K/Q>)+E!R7&G$R?NMKLLZ5$V,M\ZKLE`"4F#%D$P-&P4Z<)P`^&YWN`!+PS
M"C!QL4RI-4C2"-`QV:`>VMNG=<"8PY-`-(7$F\M"5DD>B0"T2VD0Q0;_%/?F
M$?B8#74445H=:WX[4"N9`@.E/KU2G5M(^FUW*!EAQU+"*SX"R4E\$3=28//E
M+%GG-0X#5EQCYC""F6[N8;2'F0:37,9P?MQR7UN8LH_9*!@>>'+4F<.Q0&2\
M=F7@9X#9_'H7$I?3'(75=T,BV],)CA2?;VT,])KWD;#6S<-8%_Q8C+H_[X$$
MR&JL9S]JSI;-1A8X1UOQZ3&IGKWVXO@7>'X,7IBEC/F]O=1=\R-[L78V[^$[
MD+(:Y&Y$"`3M.&$1EM,SZY=:#[4#(J;7;LEPG.L,\5E5`5B/"`$"'4QEYGOD
MPWC71TIV"\FAOI8@]=(S^S8AXYLRM2E2@*308@:6`=/`*$':?;-S@T(C+<Y&
M/9#<2<N*DZB4FK596%Z?$@O=]9TR_)HB5/5#KM.!J0DC%.<G.!G9LG!@62A%
MQN;$SL5;%UG-$*O6L`A[4_1&`[ZYFC@=T>1T"#Q&OFGP))E.O$H@`$A]@-R#
M1-\L08_WFJ`@S[?,[*B'M_O8:"+9QON,TF`:L`!KY9):J<0D:5Q%$V9!]LZ;
M^Q\9$W*3Y&O91','4_1,GQJC<-5%GYUPD6*C=6'2V_H<D"-'])`X=L3GFD&C
ML0IX4E#H>(E3TA@P%C>D9:UJP]^MPB-7%R4Y$@WW,2*ABU3XJ!6=[OT85?7-
M^/4N9M0N6:>U23R0K`QD)!O3E!:M/+L9FR@5&31%1HNS"YF7M<=<"B:(LF)-
M&?IK23F)L4Y6F-`B1G2[R@[$WY'F=HE[TKY%Z]%>%YL^S8=26F-3E4L93<RC
M(Y^1X[L%MEZ]%&2`(<YTD!W@[SD&0:TDH4Z;F).]L3B?$:XY_E]2WF7:&'&M
M9\G+-&*!`C+8CK]&[6!$N4"W0G?61/?.`7@`TX'C]$)`=AMR.SQ>ZMPAH/XW
MOQ&?!DT-_/#Q;4J/H?.<T"9O-#T;]\'L."_G(W?P/?[Z_.+L$I-L]INKRY.+
MR<GIU?FKBWWQB$CVUJ/OHWTQ8L?U/_YS#YW%?0)Q[\A?+."_FO5!*5;U*_!,
M28/H8_11ZU1][&VVX[KB,30FS$^-1V^HV7X2."=+G[=Y+O+P,#S?<>8_[VQO
M*CM0M5<P&)#%]+[[[W,R6*X[9ZQ]HFD="GOFRV(:Q%M,5H,I@U/*FSX<-#S?
MO<&Y+'4Z]<$`,C/>&Z0WYA`83WM%\[C76I38^:Y.'-A8P_B$(2YLJ$P\#M9!
M<#,J]ICL\%"<-&?C)#`.0Q^`4[<"XK\2=($Q_29&,-)I,Z%:X_+XKR#X[FC%
MD.(*Q^X'!T?-6;?K8-34HZ`.)^T^:N:_Q#%'P.+?_Q:?-G_:9BOT=(S=8_$T
M$+-TM>(@@V#BXJXUS.8%(#UH9H"*+\KB<:VS9E1!@`&QTG[>,E'O,#VWH2,*
M7GU\K^CFHW!R0,M'G84?8^SRV]\VK))E&"\7A(1JHP]0=S[S"THX(8N&3A;-
M&A*Q2.!'3+H#3MTIASON:2_-,Q[WY%DXD=&AM2U2-)[Q15G;I%7(B8CMJ9G0
M+DK89(&G:A;T?0ST\8QMD=Q(.DJ8BG)=QW84JL_I3221_Q5,<J*WY:7B`KY;
M9_6.3$<&/!AFG51*#(IZEH.`CV>)N1P1CR_P57PQIFM<^^E3YOTVZ3'RHTCJ
M0()'!D*H%AVF_<#DR4XX,,X1%KJ=\"&+IQ*-AQD:V5;@9JK`X_TT>S#VN+N7
M&KV4F&)Q)41D2?JB*2S=KP,)\4!=4RCG'2HZ"CW77[3EC0AG4/59C2G_,Q&F
M?<#BF6\4I,D:+R[P6<T!D03"3&5*[:F$TZNS[D^1:=XS">&15]VW+SXH]@13
M'DI(!G7A,:\XUM!<E2Y73XR]+_I#$O]H(A#V93-MU(:E\;WLO?UG;UXSZGS(
M]WL=PVDRG2Z78\MO6N7_:#A!!Y64DE\7NM"8'FBI(?F^<<X0T@4LNO+]T?!\
M;+"6B8#RU:1FVT=(6"X1>S0D+>OT0Z#V*72$Y=.X62;U<=RN#LS.S6J4C/8X
M5P!I.WKX6.XA@C27L:!&Y\0&`:/CTNW9+\Y\835`*/N5NO!VIP18.CB,_:@9
M,'`:N-"LDMH'M(2X^B<EA'FH]7@3<`B!BQ4>KI.6MA5"=*[F>>^=A;`H$?`]
MSTL@O?CF:M+`E<X'4P66DOL:IEL*7*ZQI&(C'K?*;1YWEC!':U3S?BNUWUK:
M8HR6ZX-+<"D<7G8K%=]1&'WW<B+^,(9H``_F%B7$9)V%'F]%]F/#3-K(8,&B
MKG%BIP90L::[4(#2[UY=/+Z";7;6:81#301>_3/@AW_JTID3;VC$?][AZ.P!
M/$"D3[!8A9+8;>]-WZQ#.:@5QB%`##1EXP_V_89$VOW.VT?+L;)6^#DG6;OI
MN4[NRW-7NC6-O1Y+]_&Q40FP:-`?N+O787$TN1L`F.$]^K^6!`ZXV^QITI$>
MG_FS:4O$Z>FY5[JCK_"-O=H']/NDYYY[/OD.+GG#_'$L^'!^^&X,[W;+I<24
MISSJSF:Y?\M$VP72/VOBG,?+IFXX?77Q]?E?&LH!OKHX(]V`^MMF8U=5QIG8
M;,99&[K$:`O=QR'!":JCWB7W;3$_3`YJ"`MJC"82/^J$V)U31SU2!RJ<"#VB
M0<'@!A[IEM*/1MWO]LQ>YOX(GGZO^:6=9J^])!`58E=7U18]"HKD:5O1I.;?
MGL3&#I;6)GDOL69U*8>4//DT7H!TYG*"F4@Y<D/Z*>1S)X0^5':MB^PCOH-'
MAN;38^^&XA"5/-S`1*AQO<[RJ5X092HR.JK3!^KKNT'F8;A.WZ:"[OH+"[O>
M;.A>I:?V!YYID6?T(I"]&(5/K\[XVI2][D"W6.X-@BZ$)%="SXP4&=%U$YS>
M60F^)B[`,L0M1Q#BY\@O5+`P!X^<JE.H_&1CX`:O-*$PG^^,<GZTO*Z3K.B[
MO=$Z&VQQY6ZGE*Z,*->WFP.6E(WGW"C74"AL[J_&$R!GIV\NSY[9STK6\64[
MN0)>V#/BW2R!/N9H0&)_[#^O,^DR-I=OT/!'2V..S+P]>_7N2MN+43W<Z;DK
M[F!L]"!.RHYVV"T_*!SH/Y")G3CUG;T.=H<<BE7(G7H8YRQ@!W2`[UGTCLGO
MU6M#\[<!5_\#RT5^>I-A<IR/5?`^5^-N.ETZV7+GW!7F8;B>U5SM5L.&=+JO
M:Z?HO,E=QM?5*K,U<*#<6D,<*R"..-WW/YK,5(=?MAQ%MFL(^E8(9R[&JTI>
M:F8>=NIUUP-,^QP`SU6]M'^F3J@]0<^>V@<%`%DUVA&4X:(7F61'B;P+W"0(
M'5K$O&D\2:5RBGOKA:BT=])4[8$]$MSVM)S(_EE;^ZE<2;XCH"N-Z\U*"IG9
MXPV,U^DT<9_^";)Y(S'8IS8@8+WZKZ?(00X9):]RTF.7?;[9((/YP`48`XLO
M/OC\]ZYMCGLC?\P*-HS_Y.\O=<`/VN"`+K>AULR6V)]'^M?.PK8DWS[_/K,0
M.X_<O8"U3-C!V.=0-;I'S2&55'B?Z[CKP#.KM'DCF!O4S,QS]?FNK]\\?WE^
M^LSSFM/(&;.N8M>N/%FV[OWZVT1YCAX:OXIK7KR2%VT>^2!3N3N;"G9:X<DE
MKH+TPGA`:6/(4C3VZC/Y$B$.7`(&P)(S;'7R3E)@@K=\Z.)NR7&$NS?K&,(<
M6]H9W`T-S`A%VXSHB@%;[.&IXP\^@OJ)$ER_^E63[VU:*JGF"KCO1S\HNCL:
M)"3;?'#KKW`V#%?JYK[N?"YV&`Y[I;T5,;M<:`Q>2-P]JW._C$Z?Q3JI:[E<
MD3@J/(FC2Q*E$3Q5@XBH,L5.`?IP"Y:N.24]`_%:!/W3$Z76^DZ[X<<7'+>C
M`6#5CQ>4L7IMYG<C<%/@?>MG7L9;"S*>9ZX@0,G2;)4P_S5N9ZG6U1."$=CQ
MO[[M#Y0=H3]&\(C:?7(UC''?UN5;X\F_=<A]BY[\HY\T8&NG4)U5#N91_]?#
M)R\C8]O!;+NJ;#O"1++2@7Q-JW=,[QW"#AR1BWI>]P<(^<RH?>+CI@E47BB'
M]]ZQ]%-S.SPTR^9KO-%%MU'3.M]LN607V')/MYQNYL@V`#H>A!:/0K'6<KW>
M;8-(L1C3.-KA3G11V/XJ\Q4G%O&XFZN;#+#?O'A^VFBCZO4R.6E?&Q??@8Z;
ME_H:,/C[0`GJT$H^&M484.N#)6K7E%J&<#4=K5*[T'ZVCMV3HT:GZH?<$Q<J
MN>G'R"@P;"\:,0V@8UKFZV6SA9_))>B6!M)=2[:-*$NB92R.^0<'.[0;G/T<
M)A_IUEV`Q@3TS[YIY:7`A"P3^Q%-N;Q(EM)^PP#R5Q^DUS4&\7R-`;1>PC8^
M=\W+FNWO5'_UU&6W+#1(TWA;O"'W7QUPK99X6Z#[+E"-&@2OIU?><,1Q3:O7
M[:T160<!G/26P09!'=3N<"M2J7_T1Q*(*YS\0^0!O&_,-JB?5AC.9UK+N7Y*
MH!<A-%Z3LX`6T,\\<@-4NC7;COZXN&_`5?N@D3`-/)SNZYBS2.8H':84_6MK
MD8I%4]ZQ]<9NY4^V4]5BM<-=MU_J%G^I6_RE;O'_1]VBT0L_Y\K%T#W>72+1
M'9CRYU-%V-OEHM'A1%8W&;5!L]J7W`0O>[)#[XN(&6A;CI\HE1_J$A*I3(@`
M?C0<Q>V.NLY0><W+2U"G?!&E6;I@)N,V+27:HMML:]>1QD7+-HZ'5!+@=><`
M+2(E!MUJVUUO<L<FIO0G9I$YG9[DM\E&N?3;N.>`YK[U$J'-!+KT!`^2!W"%
M9HA(0D-+6_.8JZ<PR1$\!D\@ATOO):#;4/IT!Z*FY^NY^/S+)[__XHO?B0.A
M0.NHV:;9H<F^5,+.U'PM19^;.<O7:C$!WR<ES:<&7?@&NC_?@,KDEH+3$AV[
MA;M)%.]LI8VY:7&D&P!S?U+L"XWO6K%AK&+?C-+,U/(1I='.MTPJ.I@A+XE3
MR>L\J2@.\6?PNIPV6S'SXJZ;$I8I=:X*<5_)9.-!2P_2]*>+I)A+!=/"O+"Y
MQ)5Q`8ZK5<DO)/)OX^DSK&L\*9=^&L';J^F.WD,UWMVIV=A`HIF<5`+T.BA7
M7`OBJ)*0Q\[49`C9/_4.?K=+D;.WUM..L%^@[S)&_)UO1]$WWP2,N_ZEI5I#
MEQ]BNB;H,$07&G-Y<P#J?L,6[3#==[A#K,0+!AN&4CS*O^N>V*XJA8(FXKGK
M3;A-INF[J'\O;PM.VU@+.6JU?48G%5^N8YC.M#=LVI`]\3U``9R40L3F^C!N
M5EE*KAV_,TTW^&X;9-[+V(T[P3;SJ06TV9G:%$79OLN<#>ON]-S;E>FLHF^A
M.HRA(L$EFGU6ZTY#;*SMLJ-<[UI\45IE(C+N-IDI.NG"SICTMK`99TDP1J96
M[#^LP=,;32F>!9,R7:.3-^6WV>3-3K)[#I,<=.OVS4WPP2TJ75MV8@#3;1][
M\/I/Z_?69+7K60D8Y(P=-L6N>FO%VC7^0_11L.4M;,)]:A6:=DNM8C(,]NF4
MQ21IH65,+>GM<8?6[%2OU78(@2&0$!MD@V:1B^A<KK(3]E6A-?;FG;1H'1+"
M1_]5]7AGA?92PV]W>!<Y[@]7!S\M>'J0!*2[T%54R*+8T!DI2,*CZ'5Y]<(<
MR93C'1IVO&HR_+241%Z:&.8E)64JLG%%D-+@[9[:PT)C6[V7&$*``5!TMI@H
M+)(Q3>/I9'V=Y75(3''_`!W')52NT@-O0U;&9%MI"0@\CH^#(AE-7`2H^HN,
M_;QE[+9/&C`3:=@/S17^'NQ3,]JMQ'50>>M=$&+D*2J1!H0I?2"C=`T+.D>;
MEK<#`K+2[UEE,:OD35:N`\:ZN0Z_O:!;Y&[EQ;VXY$#'']Y;/`AI!=<#X/M`
M6H"-@TO^-5FM).;+T90W?2J(L;)"JJ;Q)_(T71_Y?@76.,/<Q50NP;N@1'VP
M^7P/"P>=2N;0,]S)]EM\G5GQMN%K0+TW-(VJ3,.<3L?1-2<[`..1LS:M#]!I
M009M1:%AOL/L7\/'V,&$/(?Y2230>VOJ/,6B$Y:1)D+(S5,^%OK2X<CV-`(K
M'O%]=]Z2?,K")VT61<T7JLCW"9:/N!<LW2:;<=]B%7<4).D,^8KF-!3[V[$/
M#LR;FW[4YC5M;(^\]N?O,F#QZ;/HRF1^W]%[KSI6+PYOC^`@B9HBPJ*$R,QN
MDIR:/3E<CG?M6V4T4LN-7H/CF]7T;C-S8AQW)NZE0A_BE@#)F/\>%*/G7928
M%0U*(CKM.V]T7!"=F\@1U:"CG31H-[(9R`Y-XGLTPM>25!!6J2;'-,*XR!H?
MIMEV]!^W-#436RH9L'3-P;/O:8AV/\(9*-#'WGNS!_0M<EO8'L4%NAD-T<8@
M&/$RL9@+N+7/UIV'M=#%+1"FAA]A<,.O%D4I(+[L'#6VLR>D:[D@A*6,$I$Z
M->,MT,VIM+,GR,Q^L(_1>,TNCFLC:<JU][W$BNX-RW)H5'D@%T+7;Z;VC/]Q
MPW-`;[ZWMKUS%["5>1O0(&TG%;A5]=W%.*+O!I"1(,L,AA>X_0:^X:_#%JJM
MM8CFB?*#.E!D1V9"\QK@54-GF,A6LQ4EH8+ZSG)80+O9EXLU$U[/[-*S=CKP
MUF-'S;+-*8GM];L-Z>U*9JZ(+XW'.DG=SI8M$A(8<IJO*3N(F66;[/S,G9NU
M`1QYT+5%0K\%S2)F*`MK#NYGX`&IJT%L?>_H>U>/8(@S<+=EE7G'E.WU1I!;
M!&N(!]4T(_VP;-V1^\3_<OK=DVC_!,JY(->;\`T=RUT7.N.$(8GIXSPE9TD+
MM+.LI)/MBZA'39]9YSHHST$^,RR^`=FPW,E52*LDJURNV,,RI\C]]P;)%#6.
M?I.'A?>OX)C?L)+RZYCLA0TS(]?.>"JB>=C)A4A<8H5:<"KE4N>=I.!WAQQP
MF!`,,S\3KZQHCTJ&AA[&UN5J+Z!4G7%5;1T9T(K[GCY"!7B@ST6\"5NOEK5O
M9=0^9I7-Z6U-SC<W^J%]I21XNVB;/AA\_Q=&V_>DA(1-IPDUX\(FP7']^TNO
M';E[O7QBW@DS;B3-!RJ*J+CBS5#R@MQK8_RW6`H^L;@N^>YKM='YV3AS>'_=
M-R,:(%V=5ELG[T44ZU$(<LXDT&V-T@4\K<.21>*9\"[S>2'2N`>M6&+:J\>"
M`'KC*VFLW@$;X+9;X3,MUPLZ?1.`K'TLTT%NFP.Z:K2M1+W*;N]&6?LE/%RD
MV;SO:;JZT`'Z.&216\X#(A#^OR%JYNZ.?=MA`$3;#O>AX3/A#T$5>/^B#RA?
MJ\%?CIO0PG_^!U!+`P04``(`"`"`I34_N<)#%'0'```C)```#P```&5X8V5P
M=&EO;BTQ+G1X=-U9;6_;.!+^?`'R'X2B'U2@E?7J-R!W2!-GFR+9>./N!8?%
MHJ`EVF8JB5J2<FP<[K_OD)1MR99?DL:]O?N2F)R9YR&'0W*&NJ$ABHW>+,29
M(#0U!@*%W[K&Z<FJZ[=>&).,XQN2?OO@V[;[NV$6748?,TZXP&F(C0%F4Q)B
M;GPP7,NS;&OJVHYC-VW_`^L$MO^N:U`VMK`VM;*5J8479-RZ1`(-$<=+_M.3
MZU1@EI:'J9$RRL688?Y';.6"Q%9_\,M-2:5'TC$:XL9YSN7_#U=X$F-F_-O^
MCS'$)('QIA%.#90:$>+&1Y@W=%@P<\8H,RYHA+N&?7IR@>*X:PQZ-[V++P8!
M"T%&)$22(R?1>R.D20*=\(-AU2M(@HL69>^-*,<C1A/U0]#W:Q!IG@PQ6^_E
M`@F\WBGF&?0E-((>::)^S35;%J,0TQ'A/)<M<*T:G7%U?W>[!F,\?.K=]PQS
MI71F_./=Z<G?AB2%WW\W?G.,##&48/"Z,:1Y&OU^>O)+CMF\:]QC%)W'L6J9
M*>B<O1F1&'<;E]T&GZ;_`FTB<'@[[S,:Y:%H"):GWQJ<A8UEWWF6-88YB:-&
M&.<0`*P!,\ECS!MX)AH_#2YI@DAZ"_Z/;Y7`>D3L:TU__]>O.8O/'J-AV%W%
M0K?1B&503Z"G&_B>NV+^FG/,SF:SV1N#X1%F,O8N8L3YV77510!S]N;_?<G?
MR$5'XD6;T@(/+1OFIO@135'7\[P]%*38V594(*`0#I`5W[EJ4F9!@X2]&0YS
M@>6&-#<T%&/3]U^+$>\E"[S@4#(.9LJ1YT,N&`K%0'=LSFM=03$Y+=O=0[5D
M@`B?8F8-U+\%2GDR58F>2;/Y3/B+F$"`U<%7)0K>M5N'.NH/.%@(ULO!:<Y"
M!:J.FUL<3E!*>+*Q-%L5_P+L3L<[!OL`QS@4AWJ@Z;_J&+@BAVO@GC[Q`_B;
M?O.Y_+U9QG0([>*^@D/V"QK&V-RJKQT0=-SCC&`O<>#L(5[PE6_6Q2K?#1^!
MZ@9/<2S%^M:M*"H6WVD?2%('N"!;''*:I5931[3=:1U(5X%<\)C57H79=CNO
M,(.=@PZ:W[$0-4[W.O8K#/DZ_142IKO1`V7?=@W?.?QB6Q[5*^3K)(N7"L5M
MHY=Y34<';;OI???%ALLL]9=:8#L_@L9O'SP;2(`)@R60Q@KR(X1I]$\4Y_@3
MC2.X]XC,TR"S@ES-K-=0I)WV#Z=LOXARL1?+<&,L5-.L$WX'URK6MDQ/AJ!9
MKZ67LND<A7<7I^NZ?RF_KBBNB]\W(+14/74)-]-8SJ<BTM/P7@P-P]X![-LO
M!B:\EV1B7@>ZW++AQ(I4V6=ENH0KFHFL`JV^JF?D",]#D:.X6L69A5BGN+:_
M%9*.P`1;(=1;\OC@NARU<@)=N5Q=*(=%AE)@O%AUZ!0,>/I*$N8,ZDE14KB`
M3&",(W.[37%`V<<=F:YPWMJVO6\HWG%]]-:1<!`;8JY]L]<USL(ULFD-,8(K
MH%^!&.191IFP1A!"58E9KUA4IIUCS?02"T1B]4H!UU8Y'LQ]ZD6Y$APW'!X_
MYD+05+YW/2$6G6L19B/*DOW1&@3N#XG6X+\?K3Z,Y5F^\3RG%*XSBS^1=+Q,
M6;3;5:"N^WQ-I2@<.\%>M+>?4!K%<'V@`Q!=;UDGE!$O\0CE<:&I`[%NC#5J
M>M+MUF&@L!GZLE3:@>7Z;@U6%J.1?BBQ/LJ_VNQ&W2\P]83F'-_#<LBTR*S3
M*&;?+)\EZ$G`TB<93>'0EG$CH^Y60O6FT&.N9+J$==MUOON\"^+S&H;G-EM[
MAU#/;@?>IF4*)X><WIKEHKLX37QG.V=$>(9$.%&F*OM:(_:;@;.=N,Y\C;W3
M.9!]@]EO;S#?D/%$/&'Y][*P!28&)RB#%*"R>)5A^$&K=1A671Q4H5:)U!ZH
M]=E589QF^[O\V@[6S1\@SZ)/-;:%H-A@K?8K+HA2A)HDQS6\)6'Q"N3ML"\E
M*>N&;7^[':04+$\WN6SW!3:59(-#8<F(F%OZT5>N`*.Q/&LCVF=D2B`EAO/F
M9T@UI]BXQ6)"H_WV\A^>"1A"1-5G+5[<(@M$LTZ]\$/KN/B=]@Z?N?4^<YHO
ML/'_E_R\*\YKYE9^:TBQT"EK2!FVOI!$/E5NQ=J4+]XO:H>S.&J^3!A&D97E
M27:7:NLKRJY(+"=MUJD6;\*=0V%5/U^";L=TMNS479B?"&:(A9/Y#MC6,V%W
M0#UWUKN@G$.@ECN@%D,]+EP@N&TB8S@_ZE?M15"6X%583CW][J2?!2E3[X"+
M9\]-2?%"6`[S$J+\%.LN<]3/LC60WS7EU](EZ!:Q+B\<]^7(#T1,KF(TYCLI
MO,HKRS,IJ@^-=?!NRWOE3Y"ZU-CR$;+C.3_Z&ZO^GF99EM'RC01BJ!+":C<0
M:EW?E8)V("#H$R.,*:CIX?(\M5+0"[FEI;TTI/(E#*<\9_@NPZE9%13GUKL]
M]J,XYY,Z4\>M[%BPO<M%E@NM^@"7R-*Z1J#9MX6GVDK]G[1%`;)LZLAV=YG6
M[D(..W<P3\-MV]!Q?._=*^]L_9E$+6ZG6-P_`5!+`P04``(`"`!OJS4_`9'?
M$;(%```6'P``#P```&5X8V5P=&EO;BTR+G1X=-59SW?:.!`^;]_K_\`A!_=0
M/__&SHV0Y#6[29LM[?:P;P]"%J#&2%Y))N&_KV39Q(`PAH1V]Y+$FIGOTXQ&
MTHQR2R'(>E=/$.4"4](;"0`?SGMOWSP/_7T%,YQS=(O)P_O`<<)_>E8UU+M'
MC&,N$(&H-T)L@2'BO?<]S_9MQUYXCNLZD1.\9TGH!._.>Y1-;:1-[?S9U$8U
M&;<O@0!CP-&*OSF52\0AP^7?Y[U:<P`E*:>L1ZCH04H(@@*E]MLWOP%Q%*.=
M;B!_I&)8XUK;ZM_!`IR[;O2NG1(3@1@!V0H>E/`E/Z<%@RL^J0H9FB,BAB#+
MAK0@PC)HE;R^D[R`M^FE+3\PO'I"L!!($5M;&B5CV'\U1K2?S`^[DG%I5B[H
M8,P%`U",],"V7YL*>@'[CK>':L7`9:HC9H_*7S5*TYEUB?8DZIP@_Q:(8=3,
M#`7ZIQQ=WB$X`P3S^5;L=BJ6[)[3_X7L;N*?@GV$,KDGNT8@"EYU#KPD'V39
M9_K(._!'P<'K?_64,YU";=S7C,Z_@'&&K)WZ.@!AXIUF!GN)0W</<<WW&8%T
M4,6O7N5/X^^2ZA8M4*;$I<Q:4RQ9`C?N2&("K,GJ4TBS&#5U1CM)OR/=&F3-
M8ZV/EIBQE[R"!ZV3#J,7+(0AZ'[BO/AXKC6J$UI'WGA$>W'W2W8G'=I+XX:.
M^S-H@KCSJ8A)BIE<565<0E[(U$G_`EF!/M`L1:IDX`(0@8%<)[-&29K$/YTR
M/HJRWA]-N"D2Y:=E$KZ`ZRO!XM/D&V4/.]R[F>>99=;22QFY)^%MX_0\[S\5
MUV>*F^KO6RFTQP7.TDMY6TR5/VLB[89_-+2<=@MPX!P-C/G5/!=+$^AJR\*9
MG=(YP,3.&4T+**K/.4U19JN^2*+*&0Z@*$!VD\IB'D\P!(K-JL2Z+G2"G9!T
M(DV0+9N:\OC@$KS(D%U@.52HU<T!$SD@DG'X/*#+(LES7TI@P9AJ)9X5AO)V
MGLI69K=-=4`YIYV9;@O.',?9-Q7_M#$Z<Q6<S`VQU+'9&QJW#HWZM,<(R"O@
M?@UB5.0Y9<*>R!1:EUAF1>VHGYS*TTLD`,[NROSDJ)D/UC[UJH4(3YL.WR\*
M(2BY`/#A$;!TH$6(32B;[\_6,/1^2K:&OSY;`SF7@V+C^VXC79]L_HC)=%6R
MZ+"7B;H9\PV5JIE+PKUH9Q\`23-Y?8`.B)Z_JMV;B)=H`HJLTM2):)JC04T[
M'?>[@<K-<*_:EQ8L+_#V!S"EPPS#!Z.+?FB:3)Z!B7Z>L"_4S\^4"K5L7V_.
MM)=\*WX;>O62F-9WI'Y^%3C#0I7TA,H;:*EQK0U95<6L#I\FS.]#.L\ID5>(
MRF*U!_Y`RPMU>9*IU1!6)7IHFHJT&%.YI^\``5.9%6H=:XA-6=6M]SO"U&.5
M8V:T5=_0U3%^3=E`O;U5&GS;T\2+#P4U@3A=0:X6\ML0<#=H7D7@4=A;UMIT
MPS)RHG#;DLA3G\BX;5C6P]5-$+B[.5/,<R#@K#0M*^<-XB`*W=W$)O,-]B3I
MR+[%',1;S'7"7%-8\#IK&%K',2KI31.'SB9D=8H8C6K<U8*V*9<,?=<[A"!G
MZ/)@CB0YR`FQS-%@IEX#Y*G)RH-J/T<<AL<$JJ,'43]Z24J&GO_**?E-[GGZ
M:+"M!-6]TH]?,9=+1=F*%\C`VQ!6#Y)^BWVC-M\TC(/==K*29@79YG*\(VS6
M<I(CV<A@L;3U/PC4"C":J1(CI?<,+[#L!.7]^%%V6`O4NT-B1M/]]NH7>A)R
M"BF]4244KXJG&M$RJ5=QZ)\6/XE;8N:98^9&1]@$_Z<XM^6YP;?F$QM!0G=J
MD#)D?\%S]6J^$VM;7C_;&:=3'[I?9DP>C'9>S/-/1%O+6N(:9\IIRZ1:%3Q)
M5]ARG*]`=V.Z.W9J&^8'C!A@<+9L@>T?"-L"=:C7;5!N%ZC5#C!BE&]J;]_\
M`%!+`P04``(`"``ZK34_)S0H%F@!``!_`P``$P```'!E<G-I<W1E;F-E+GAM
M;"YT>'2E4UUOPB`4??=7$-X+ZEX6T]8LZI8E-1J=R=X,`Z:8%CJ@'_[[0=MH
MW9/;7@C<>\X]]XMP6F<I*+DV0LD(CM`0`BZI8D(>(KA[>PX>X30>A+E'&.M<
M_(H>>[3C2Q/!H[7Y!.,3*0DRA4149=BYL#2XQ^W@D]J("Z6J*E0](*4/>#P<
MCO#[,MG2(\]((*2QI&49,3&-,5&4V$;]/D5P'ZQ_WX_W0U0;!N,!`/W*@T(*
M"R3)>`1?MG.5$2&7BO'4'47*USL(K";2$.HS#.PY=\#-8KO:;6:+?;*:/25-
M3!]5JU(PKF-7-N(T%;GAJ">%3CE!Z^M[W>%#?&&V@6A*C(GI$;$F'>3<K*"V
M>V8^.Q\G$S;$+?9^WBOCTHI/T7;\]_R9DJX?]`_*OO+_*.K\ENNPKKE6\,YP
M-9V[>?K]J&\GP#XH8EJX=8>@)&GA4'Y:N3+VH+GY2M&\]>).!=_*A/CG[KB/
MU+?%@V]02P$"%``4``(`"`!J:V4^EWKQS<`6``!=2```$P`````````!`"``
M````````<&]S=&=R97-Q;"YC;VYF+G1X=%!+`0(4`!0``@`(`#4"*#Z@$KN4
MG!T``("*```;``````````$`(````/$6``!$871A<V]U<F-E06-C97-S;W(N
M:F%V82YT>'102P$"%``4``(`"`"`I34_N<)#%'0'```C)```#P`````````!
M`"````#&-```97AC97!T:6]N+3$N='AT4$L!`A0`%``"``@`;ZLU/P&1WQ&R
M!0``%A\```\``````````0`@````9SP``&5X8V5P=&EO;BTR+G1X=%!+`0(4
M`!0``@`(`#JM-3\G-"@6:`$``'\#```3``````````$`(````$9"``!P97)S
E:7-T96YC92YX;6PN='AT4$L%!@`````%``4`10$``-]#````````
`
end
Re: DatabaseAccessor not connected and Eingabe/Ausgabe-Fehler [message #728101 is a reply to message #727689] Thu, 22 September 2011 14:20 Go to previous messageGo to next message
James is currently offline James
Messages: 272
Registered: July 2009
Senior Member
>> DBHelper.getInstance().getMainEntityManager(connectionProperties);

What does this do exactly and why? It seems you are getting a specific connection per request (not using a connection pool)??

Normally connection pooling is used.

You are also closing the EntityManager before returning the objects, as they have relationships that will need to be fetched, these will need to reconnect this closed entity manager.

Try using a connection pool, or use join fetching or a LoadGroup to instantiate everything you need before returning.

--
James : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/
Re: DatabaseAccessor not connected and Eingabe/Ausgabe-Fehler [message #728226 is a reply to message #728101] Thu, 22 September 2011 17:58 Go to previous message
Mike is currently offline Mike
Messages: 49
Registered: July 2009
Member
The line you asked for creates an EntityManager when it's not already created and stores in in a member variable.



public synchronized EntityManager getMainEntityManager(Properties connection) throws PersistenceException
{
if (mainEntityManager == null || !mainEntityManager.isOpen()) {
mainEntityManager = getNewEntityManager(connection);
}
return mainEntityManager;
}

public synchronized EntityManager getNewEntityManager(Properties connection) throws PersistenceException
{
EntityManager entity = Persistence.createEntityManagerFactory("GSDomainModelModulePU", connection).createEntityManager(); // NOI18N
if (entity == null) {
Logger.getLogger(DBHelper.class.getName()).log(Level.WARNING, "Creating entity manager has failed. I'll retry one time more!"); // NOI18N
entity = Persistence.createEntityManagerFactory("GSDomainModelModulePU", connection).createEntityManager(); // NOI18N
if (entity == null) {
Logger.getLogger(DBHelper.class.getName()).log(Level.SEVERE, "The entity manager can definitly not be created. This a fatal failure!"); // NOI18N
throw new PersistenceException("Unable to create an entity manager!"); // NOI18N
}
}
return entity;
}


Yes, I close the EntityManager before returning the list of objects. I thought that's correct since every example I found (also with sub-objects) do it so. So I think it's correct?

How do I use "connection pooling"? You mean just to write it by myself creating several entity managers using them or so?
Previous Topic:(no subject)
Next Topic:Update on a long property lost during a transaction with find with pessimistic read lock
Goto Forum:
  


Current Time: Tue Oct 21 02:31:23 GMT 2014

Powered by FUDForum. Page generated in 0.02111 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software