Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 35668 invoked from network); 16 Aug 2005 20:33:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Aug 2005 20:33:25 -0000 Received: (qmail 61135 invoked by uid 500); 16 Aug 2005 20:33:22 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 61115 invoked by uid 500); 16 Aug 2005 20:33:22 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 61102 invoked by uid 99); 16 Aug 2005 20:33:22 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Aug 2005 13:33:22 -0700 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=HTML_50_60,HTML_MESSAGE,HTML_TITLE_EMPTY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [12.109.131.140] (HELO stealth2.atpco.net) (12.109.131.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Aug 2005 13:33:42 -0700 X-SEF-Processed: 5_0_0_713__2005_08_16_16_29_58 X-SEF-A0BC20AB-BE41-465E-90F0-2CB35A79A117: 1 Received: from Unknown [172.16.104.121] by stealth2.atpco.net - SurfControl E-mail Filter (5.0); Tue, 16 Aug 2005 16:29:56 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----_=_NextPart_001_01C5A2A1.BADF77ED" Subject: RE: Error when running a delete all a 2nd time Date: Tue, 16 Aug 2005 16:33:15 -0400 Message-ID: <8FA12926CCB8EC4CB47333C9B65F95D3015EDF07@EMAIL.atpiad1.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Error when running a delete all a 2nd time Thread-Index: AcWihxhIOyoiDKLpRjqPXu0GkQ685QAGqtTQ From: "Peart, David E." To: "Derby Discussion" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C5A2A1.BADF77ED Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C5A2A1.BADF77ED" ------_=_NextPart_002_01C5A2A1.BADF77ED Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable find attached the derby.log I don't know if this will offer any additional insight. ________________________________ From: Satheesh Bandaram [mailto:satheesh@Sourcery.Org]=20 Sent: Tuesday, August 16, 2005 1:19 PM To: Derby Discussion Subject: Re: Error when running a delete all a 2nd time I think Army has already answered this question...Since there is a primary key on the column, Derby would have created an unique index on it, so attempting to create another unique index on the same column would raise the warning. Why it is a warning and not an error, I don't know :-) (since it doesn't actually create the second index...) So your first problem is not related to this one... Satheesh Peart, David E. wrote:=20 Satheesh =20 when you say a complete reproduction you mean all code, etc? =20 Anyway, I'm also getting this error on creating indexes, may be it is related. So I'd like to see if this was resolved then see if the other problem goes away. The problem is: =20 WARNING 01504: The new index is a duplicate of an existing index: SQL050816084652910. =20 But its not a duplicate. It creates this warning on the 2nd index PARGRP.X2FTNRC2 Additionally, although its a warning it does not create the 2nd index !!!!! I checked the system tables for which indexes are created. Let me know if you need the ddl on the table again, and may be you can try creating the table with the three indexes and see if you get the same error. Note: we are loading the tables onto DB2 and have no issues there. =20 Here is the ddl script for creating the indexes =20 CREATE UNIQUE INDEX PARGRP.X1FTNRC2 ON PARGRP.FTNREC2_CATCTRL (CARRIER_CD ASC ,TARIFF_CD ASC ,FOOTNOTE_CD ASC ,CATEGORY_NO ASC ,SEQUENCE_NO ASC ,CREATE_TS ASC ); =20 CREATE UNIQUE INDEX PARGRP.X2FTNRC2 ON PARGRP.FTNREC2_CATCTRL (FTNREC2_SG ASC ); =20 CREATE=20 INDEX PARGRP.X3FTNRC2 ON PARGRP.FTNREC2_CATCTRL (BATCH_CI ASC ,BATCH_NO ASC ); =20 David ________________________________ From: Satheesh Bandaram [mailto:satheesh@Sourcery.Org]=20 Sent: Friday, August 12, 2005 3:20 PM To: Derby Discussion Subject: Re: Error when running a delete all a 2nd time =09 =09 Hi Peart, =09 The error is really strange... I can't spot what could be causing the problem here. Would it be possible for you to make a complete reproduction? =09 Satheesh =09 Peart, David E. wrote: =09 I'm getting the following internalError when I try and delete from a table after I have populated it. Has anybody seen this error or know whats causing it. It only happens with this table (find the ddl attached), other tables are fine I've using this to do some TDD.=20 a) So I delete the contents of the table in a class setup b) load the data c) after all tests have run, delete the contents of the table =20 It's during the 'c' step this occurs, and after I get this any attempt to delete from the table produces this error. =20 Any help would be appreciated as this is driving me crazy. =20 MessageID =3D "XJ001.U" SQLState =3D "XJ001" =20 =09 net.atpco.common.dataaccess.errors.DataAccessApplicationException: unexpected error occurred in attempt to execute SQL: Java exception: 'No run method: java.lang.InternalError'.;=20 Caused by -->=20 java.lang.InternalError: No run method at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.open(DeleteCasc adeResultSet.java) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPrepar edStatement.java) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatemen t.java) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Embed PreparedStatement.java) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPre paredStatement.java) at net.atpco.rules.footnotes.server.dataaccess.MockJDBCDAO.createUpdateDele te(MockJDBCDAO.java:393) at net.atpco.rules.footnotes.server.dataaccess.MockJDBCDAO.delete(MockJDBCD AO.java:442) at net.atpco.rules.footnotes.server.dataaccess.FootNotesJDBCDAOFake.delete( FootNotesJDBCDAOFake.java:93) at net.atpco.rules.footnotes.server.dataaccess.GenericFootNotesJDBCDAO.dele te(GenericFootNotesJDBCDAO.java:208) at net.atpco.rules.footnotes.server.dataaccess.GenericFootNotesDaSvc.delete (GenericFootNotesDaSvc.java:148) at net.atpco.rules.footnotes.server.dataaccess.GenericFootNotesDaSvc.delete (GenericFootNotesDaSvc.java:152) at net.atpco.rules.footnotes.server.dataaccess.FootNotesDaSvcTest.deleteSee dData(FootNotesDaSvcTest.java:207) at net.atpco.rules.footnotes.server.dataaccess.FootNotesDaSvcTest$1.setUp(F ootNotesDaSvcTest.java:41) at junit.extensions.TestSetup$1.protect(TestSetup.java:18) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTe stRunner.java:329) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRun ner.java:218) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRu nner.java:151) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRu nner.java:151) =20 =20 ------_=_NextPart_002_01C5A2A1.BADF77ED Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
find attached the derby.log I don't know if = this will offer=20 any additional insight.

From: Satheesh Bandaram=20 [mailto:satheesh@Sourcery.Org]
Sent: Tuesday, August 16, 2005 = 1:19=20 PM
To: Derby Discussion
Subject: Re: Error when = running a=20 delete all a 2nd time

I think Army has already answered this question...Since there = is a=20 primary key on the column, Derby would have created an unique index on = it, so=20 attempting to create another unique index on the same column would raise = the=20 warning. Why it is a warning and not an error, I don't know :-)  (since it doesn't = actually=20 create the second index...)

So your first problem is not related = to this=20 one...

Satheesh

Peart, David E. wrote:=20
Satheesh
 
when you say a complete reproduction you mean = all code,=20 etc?
 
Anyway, I'm also getting this error on = creating indexes,=20 may be it is related.  So I'd like to see if this was resolved = then see=20 if the other problem goes away.
The problem is:
 
WARNING 01504: The new index is a duplicate = of an=20 existing index: SQL050816084652910.
 
But its not a duplicate.  It creates = this warning on=20 the 2nd index PARGRP.X2FTNRC2
Additionally, although its a warning it does = not create=20 the 2nd index !!!!!  I checked the system tables for which = indexes are=20 created.
Let me know if you need the ddl on the table = again, and=20 may be you can try creating the table with the three indexes and see = if you=20 get the same error.
Note: we are loading the tables onto DB2 and = have no=20 issues there.
 
Here is the ddl script for creating the=20 indexes
 
  CREATE=20 UNIQUE
        =20 INDEX     =20 PARGRP.X1FTNRC2
        =20 ON        =20 PARGRP.FTNREC2_CATCTRL
      =20 (CARRIER_CD        =20 ASC
      =20 ,TARIFF_CD         =20 ASC
      =20 ,FOOTNOTE_CD       =20 ASC
      =20 ,CATEGORY_NO       =20 ASC
      =20 ,SEQUENCE_NO       =20 ASC
      =20 ,CREATE_TS         =20 = ASC
           = =20 );
 
  CREATE=20 UNIQUE
        =20 INDEX     =20 PARGRP.X2FTNRC2
        =20 ON        =20 PARGRP.FTNREC2_CATCTRL
      =20 (FTNREC2_SG        =20 = ASC
           = =20 );
 
  CREATE=20
        =20 INDEX     =20 PARGRP.X3FTNRC2
        =20 ON        =20 PARGRP.FTNREC2_CATCTRL
      =20 (BATCH_CI          =20 ASC
      =20 ,BATCH_NO          =20 = ASC
           = =20 );
 
David

From: Satheesh Bandaram [mailto:satheesh@Sourcery.Org]=20
Sent: Friday, August 12, 2005 3:20 PM
To: Derby=20 Discussion
Subject: Re: Error when running a delete all a = 2nd=20 time

Hi Peart,

The error is really = strange... I=20 can't spot what could be causing the problem here. Would it be = possible for=20 you to make a complete reproduction?

Satheesh

Peart, = David E.=20 wrote:
I'm getting the=20 following internalError when I try and delete from a table after I = have=20 populated it.  Has anybody seen this error or know whats = causing=20 it.  It only happens with this table (find the ddl attached), = other=20 tables are fine
I've using this=20 to do some TDD.
a) = So I delete=20 the contents of the table in a class setup
b) = load the=20 data
c) = after all=20 tests have run, delete the contents of the table
 
It's during the=20 'c' step this occurs, and after I get this any attempt to delete = from the=20 table produces this error.
 
Any help would=20 be appreciated as this is driving me crazy.
 
MessageID =3D=20 "XJ001.U"
SQLState =3D=20 "XJ001"
 
net.atpco.common.dataaccess.errors.DataAccessApplicationExceptio= n:=20 unexpected error occurred in attempt to execute SQL: Java exception: = 'No run=20 method: java.lang.InternalError'.;
Caused by -->=20
java.lang.InternalError: No run method
 at=20 = org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.open(DeleteCasca= deResultSet.java)
 at=20 = org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPrepare= dStatement.java)
 at=20 = org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement= .java)
 at=20 = org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedP= reparedStatement.java)
 at=20 = org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPrep= aredStatement.java)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.MockJDBCDAO.createUpdateDelet= e(MockJDBCDAO.java:393)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.MockJDBCDAO.delete(MockJDBCDA= O.java:442)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.FootNotesJDBCDAOFake.delete(F= ootNotesJDBCDAOFake.java:93)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.GenericFootNotesJDBCDAO.delet= e(GenericFootNotesJDBCDAO.java:208)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.GenericFootNotesDaSvc.delete(= GenericFootNotesDaSvc.java:148)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.GenericFootNotesDaSvc.delete(= GenericFootNotesDaSvc.java:152)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.FootNotesDaSvcTest.deleteSeed= Data(FootNotesDaSvcTest.java:207)
 at=20 = net.atpco.rules.footnotes.server.dataaccess.FootNotesDaSvcTest$1.setUp(Fo= otNotesDaSvcTest.java:41)
 at=20 junit.extensions.TestSetup$1.protect(TestSetup.java:18)
 at=20 = junit.framework.TestResult.runProtected(TestResult.java:124)
 at = junit.extensions.TestSetup.run(TestSetup.java:23)
 at=20 = org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes= tRunner.java:329)
 at=20 = org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunn= er.java:218)
 at=20 = org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRun= ner.java:151)
 at=20 = org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRun= ner.java:151)
 
 
------_=_NextPart_002_01C5A2A1.BADF77ED-- ------_=_NextPart_001_01C5A2A1.BADF77ED Content-Type: application/octet-stream; name="derby.log" Content-Transfer-Encoding: base64 Content-Description: derby.log Content-Disposition: attachment; filename="derby.log" MjAwNS0wOC0xMSAxMjo1ODoyNC4zMTIgR01UIFRocmVhZFttYWluLDUsbWFpbl0gQ2xhc3Mgb3Jn LmFwYWNoZS5kZXJieS5pbXBsLnNlcnZpY2VzLmpjZS5KQ0VDaXBoZXJGYWN0b3J5IGphdmEubGFu Zy5Ob0NsYXNzRGVmRm91bmRFcnJvcjogamF2YXgvY3J5cHRvL1NlY3JldEtleSwgbW9kdWxlIGln bm9yZWQuDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tDQoyMDA1LTA4LTExIDEyOjU4OjI0LjM5MCBHTVQ6CiBCb290aW5nIERl cmJ5IHZlcnNpb24gSUJNIENvcnAuIC0gQXBhY2hlIERlcmJ5IC0gMTAuMC4yLjAgLSAoMzAzMDEp OiBpbnN0YW5jZSBjMDEzODAwZC0wMTA1LWE1OWUtYWViOC0wMDAwMDExZjc1NzAKb24gZGF0YWJh c2UgZGlyZWN0b3J5IEM6XGRhdGFiYXNlXGZvb3Rub3RlcyAKDQpEYXRhYmFzZSBDbGFzcyBMb2Fk ZXIgc3RhcnRlZCAtIGRlcmJ5LmRhdGFiYXNlLmNsYXNzcGF0aD0nJw0KMjAwNS0wOC0xMSAxMjo1 ODoyNS40OTkgR01UIFRocmVhZFttYWluLDUsbWFpbl0gKFhJRCA9IDMxMyksIChTRVNTSU9OSUQg PSAwKSwgKERBVEFCQVNFID0gQzpcZGF0YWJhc2VcZm9vdG5vdGVzKSwgKERSREFJRCA9IG51bGwp LCBDbGVhbnVwIGFjdGlvbiBzdGFydGluZw0KMjAwNS0wOC0xMSAxMjo1ODoyNS40OTkgR01UIFRo cmVhZFttYWluLDUsbWFpbl0gKFhJRCA9IDMxMyksIChTRVNTSU9OSUQgPSAwKSwgKERBVEFCQVNF ID0gQzpcZGF0YWJhc2VcZm9vdG5vdGVzKSwgKERSREFJRCA9IG51bGwpLCBGYWlsZWQgU3RhdGVt ZW50IGlzOiBERUxFVEUgRlJPTSBQQVJHUlAuRlROUkVDMl9DQVRDVFJMDQpqYXZhLmxhbmcuSW50 ZXJuYWxFcnJvcjogTm8gcnVuIG1ldGhvZA0KCWF0IGphdmEuc2VjdXJpdHkuQWNjZXNzQ29udHJv bGxlci5kb1ByaXZpbGVnZWQoTmF0aXZlIE1ldGhvZCkNCglhdCBvcmcuYXBhY2hlLmRlcmJ5Lmlt cGwuc3RvcmUucmF3LmRhdGEuUkFGQ29udGFpbmVyLmNyZWF0ZUNvbnRhaW5lcihSQUZDb250YWlu ZXIuamF2YSkNCglhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3RvcmUucmF3LmRhdGEuRmlsZUNv bnRhaW5lci5jcmVhdGVJZGVudChGaWxlQ29udGFpbmVyLmphdmEpDQoJYXQgb3JnLmFwYWNoZS5k ZXJieS5pbXBsLnN0b3JlLnJhdy5kYXRhLlJBRkNvbnRhaW5lci5jcmVhdGVJZGVudGl0eShSQUZD b250YWluZXIuamF2YSkNCglhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc2VydmljZXMuY2FjaGUu Q2FjaGVkSXRlbS50YWtlT25JZGVudGl0eShDYWNoZWRJdGVtLmphdmEpDQoJYXQgb3JnLmFwYWNo ZS5kZXJieS5pbXBsLnNlcnZpY2VzLmNhY2hlLkNsb2NrLmFkZEVudHJ5KENsb2NrLmphdmEpDQoJ YXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnNlcnZpY2VzLmNhY2hlLkNsb2NrLmNyZWF0ZShDbG9j ay5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zdG9yZS5yYXcuZGF0YS5CYXNlRGF0 YUZpbGVGYWN0b3J5LmFkZENvbnRhaW5lcihCYXNlRGF0YUZpbGVGYWN0b3J5LmphdmEpDQoJYXQg b3JnLmFwYWNoZS5kZXJieS5pbXBsLnN0b3JlLnJhdy54YWN0LlhhY3QuYWRkQ29udGFpbmVyKFhh Y3QuamF2YSkNCglhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3RvcmUuYWNjZXNzLmhlYXAuSGVh cC5jcmVhdGUoSGVhcC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zdG9yZS5hY2Nl c3MuaGVhcC5IZWFwQ29uZ2xvbWVyYXRlRmFjdG9yeS5jcmVhdGVDb25nbG9tZXJhdGUoSGVhcENv bmdsb21lcmF0ZUZhY3RvcnkuamF2YSkNCglhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3RvcmUu YWNjZXNzLlJBTVRyYW5zYWN0aW9uLmNyZWF0ZUNvbmdsb21lcmF0ZShSQU1UcmFuc2FjdGlvbi5q YXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zcWwuZXhlY3V0ZS5UZW1wb3JhcnlSb3dI b2xkZXJJbXBsLmluc2VydChUZW1wb3JhcnlSb3dIb2xkZXJJbXBsLmphdmEpDQoJYXQgb3JnLmFw YWNoZS5kZXJieS5pbXBsLnNxbC5leGVjdXRlLkRlbGV0ZVJlc3VsdFNldC5jb2xsZWN0QWZmZWN0 ZWRSb3dzKERlbGV0ZVJlc3VsdFNldC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5z cWwuZXhlY3V0ZS5EZWxldGVDYXNjYWRlUmVzdWx0U2V0LmNvbGxlY3RBZmZlY3RlZFJvd3MoRGVs ZXRlQ2FzY2FkZVJlc3VsdFNldC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zcWwu ZXhlY3V0ZS5EZWxldGVDYXNjYWRlUmVzdWx0U2V0Lm9wZW4oRGVsZXRlQ2FzY2FkZVJlc3VsdFNl dC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zcWwuR2VuZXJpY1ByZXBhcmVkU3Rh dGVtZW50LmV4ZWN1dGUoR2VuZXJpY1ByZXBhcmVkU3RhdGVtZW50LmphdmEpDQoJYXQgb3JnLmFw YWNoZS5kZXJieS5pbXBsLmpkYmMuRW1iZWRTdGF0ZW1lbnQuZXhlY3V0ZVN0YXRlbWVudChFbWJl ZFN0YXRlbWVudC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLkVtYmVkUHJl cGFyZWRTdGF0ZW1lbnQuZXhlY3V0ZVN0YXRlbWVudChFbWJlZFByZXBhcmVkU3RhdGVtZW50Lmph dmEpDQoJYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuRW1iZWRQcmVwYXJlZFN0YXRlbWVu dC5leGVjdXRlVXBkYXRlKEVtYmVkUHJlcGFyZWRTdGF0ZW1lbnQuamF2YSkNCglhdCBuZXQuYXRw Y28ucnVsZXMuZm9vdG5vdGVzLnNlcnZlci5kYXRhYWNjZXNzLk1vY2tKREJDREFPLmNyZWF0ZVVw ZGF0ZURlbGV0ZShNb2NrSkRCQ0RBTy5qYXZhOjM5MykNCglhdCBuZXQuYXRwY28ucnVsZXMuZm9v dG5vdGVzLnNlcnZlci5kYXRhYWNjZXNzLk1vY2tKREJDREFPLmRlbGV0ZShNb2NrSkRCQ0RBTy5q YXZhOjQ0MikNCglhdCBuZXQuYXRwY28ucnVsZXMuZm9vdG5vdGVzLnNlcnZlci5kYXRhYWNjZXNz LkZvb3ROb3Rlc0pEQkNEQU9GYWtlLmRlbGV0ZShGb290Tm90ZXNKREJDREFPRmFrZS5qYXZhOjg5 KQ0KCWF0IG5ldC5hdHBjby5ydWxlcy5mb290bm90ZXMuc2VydmVyLmRhdGFhY2Nlc3MuR2VuZXJp Y0Zvb3ROb3Rlc0pEQkNEQU8uZGVsZXRlKEdlbmVyaWNGb290Tm90ZXNKREJDREFPLmphdmE6MjA4 KQ0KCWF0IG5ldC5hdHBjby5ydWxlcy5mb290bm90ZXMuc2VydmVyLmRhdGFhY2Nlc3MuR2VuZXJp Y0Zvb3ROb3Rlc0RhU3ZjLmRlbGV0ZShHZW5lcmljRm9vdE5vdGVzRGFTdmMuamF2YToxNDgpDQoJ YXQgbmV0LmF0cGNvLnJ1bGVzLmZvb3Rub3Rlcy5zZXJ2ZXIuZGF0YWFjY2Vzcy5HZW5lcmljRm9v dE5vdGVzRGFTdmMuZGVsZXRlKEdlbmVyaWNGb290Tm90ZXNEYVN2Yy5qYXZhOjE1MikNCglhdCBu ZXQuYXRwY28ucnVsZXMuZm9vdG5vdGVzLnNlcnZlci5kYXRhYWNjZXNzLkZvb3ROb3Rlc0RhU3Zj VGVzdCQxLnNldFVwKEZvb3ROb3Rlc0RhU3ZjVGVzdC5qYXZhOjQzKQ0KCWF0IGp1bml0LmV4dGVu c2lvbnMuVGVzdFNldHVwJDEucHJvdGVjdChUZXN0U2V0dXAuamF2YToxOCkNCglhdCBqdW5pdC5m cmFtZXdvcmsuVGVzdFJlc3VsdC5ydW5Qcm90ZWN0ZWQoVGVzdFJlc3VsdC5qYXZhOjEyNCkNCglh dCBqdW5pdC5leHRlbnNpb25zLlRlc3RTZXR1cC5ydW4oVGVzdFNldHVwLmphdmE6MjMpDQoJYXQg anVuaXQuZnJhbWV3b3JrLlRlc3RTdWl0ZS5ydW5UZXN0KFRlc3RTdWl0ZS5qYXZhOjIwOCkNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1bihUZXN0U3VpdGUuamF2YToyMDMpDQoJYXQg anVuaXQuZnJhbWV3b3JrLlRlc3RTdWl0ZS5ydW5UZXN0KFRlc3RTdWl0ZS5qYXZhOjIwOCkNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1bihUZXN0U3VpdGUuamF2YToyMDMpDQoJYXQg anVuaXQuZnJhbWV3b3JrLlRlc3RTdWl0ZS5ydW5UZXN0KFRlc3RTdWl0ZS5qYXZhOjIwOCkNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1bihUZXN0U3VpdGUuamF2YToyMDMpDQoJYXQg anVuaXQuZnJhbWV3b3JrLlRlc3RTdWl0ZS5ydW5UZXN0KFRlc3RTdWl0ZS5qYXZhOjIwOCkNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1bihUZXN0U3VpdGUuamF2YToyMDMpDQoJYXQg b3JnLmVjbGlwc2UuamR0LmludGVybmFsLmp1bml0LnJ1bm5lci5SZW1vdGVUZXN0UnVubmVyLnJ1 blRlc3RzKFJlbW90ZVRlc3RSdW5uZXIuamF2YTozMjkpDQoJYXQgb3JnLmVjbGlwc2UuamR0Lmlu dGVybmFsLmp1bml0LnJ1bm5lci5SZW1vdGVUZXN0UnVubmVyLnJ1bihSZW1vdGVUZXN0UnVubmVy LmphdmE6MjE4KQ0KCWF0IG9yZy5lY2xpcHNlLmpkdC5pbnRlcm5hbC5qdW5pdC5ydW5uZXIuUmVt b3RlVGVzdFJ1bm5lci5tYWluKFJlbW90ZVRlc3RSdW5uZXIuamF2YToxNTEpDQpDbGVhbnVwIGFj dGlvbiBjb21wbGV0ZWQNCjIwMDUtMDgtMTEgMTI6NTg6MjUuODI4IEdNVCBUaHJlYWRbbWFpbiw1 LG1haW5dIChYSUQgPSAzMTgpLCAoU0VTU0lPTklEID0gMiksIChEQVRBQkFTRSA9IEM6XGRhdGFi YXNlXGZvb3Rub3RlcyksIChEUkRBSUQgPSBudWxsKSwgQ2xlYW51cCBhY3Rpb24gc3RhcnRpbmcN CjIwMDUtMDgtMTEgMTI6NTg6MjUuODI4IEdNVCBUaHJlYWRbbWFpbiw1LG1haW5dIChYSUQgPSAz MTgpLCAoU0VTU0lPTklEID0gMiksIChEQVRBQkFTRSA9IEM6XGRhdGFiYXNlXGZvb3Rub3Rlcyks IChEUkRBSUQgPSBudWxsKSwgRmFpbGVkIFN0YXRlbWVudCBpczogREVMRVRFIEZST00gUEFSR1JQ LkZUTlJFQzJfQ0FUQ1RSTA0KamF2YS5sYW5nLkludGVybmFsRXJyb3I6IE5vIHJ1biBtZXRob2QN CglhdCBqYXZhLnNlY3VyaXR5LkFjY2Vzc0NvbnRyb2xsZXIuZG9Qcml2aWxlZ2VkKE5hdGl2ZSBN ZXRob2QpDQoJYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnN0b3JlLnJhdy5kYXRhLlJBRkNvbnRh aW5lci5jcmVhdGVDb250YWluZXIoUkFGQ29udGFpbmVyLmphdmEpDQoJYXQgb3JnLmFwYWNoZS5k ZXJieS5pbXBsLnN0b3JlLnJhdy5kYXRhLkZpbGVDb250YWluZXIuY3JlYXRlSWRlbnQoRmlsZUNv bnRhaW5lci5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zdG9yZS5yYXcuZGF0YS5S QUZDb250YWluZXIuY3JlYXRlSWRlbnRpdHkoUkFGQ29udGFpbmVyLmphdmEpDQoJYXQgb3JnLmFw YWNoZS5kZXJieS5pbXBsLnNlcnZpY2VzLmNhY2hlLkNhY2hlZEl0ZW0udGFrZU9uSWRlbnRpdHko Q2FjaGVkSXRlbS5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zZXJ2aWNlcy5jYWNo ZS5DbG9jay5hZGRFbnRyeShDbG9jay5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5z ZXJ2aWNlcy5jYWNoZS5DbG9jay5jcmVhdGUoQ2xvY2suamF2YSkNCglhdCBvcmcuYXBhY2hlLmRl cmJ5LmltcGwuc3RvcmUucmF3LmRhdGEuQmFzZURhdGFGaWxlRmFjdG9yeS5hZGRDb250YWluZXIo QmFzZURhdGFGaWxlRmFjdG9yeS5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zdG9y ZS5yYXcueGFjdC5YYWN0LmFkZENvbnRhaW5lcihYYWN0LmphdmEpDQoJYXQgb3JnLmFwYWNoZS5k ZXJieS5pbXBsLnN0b3JlLmFjY2Vzcy5oZWFwLkhlYXAuY3JlYXRlKEhlYXAuamF2YSkNCglhdCBv cmcuYXBhY2hlLmRlcmJ5LmltcGwuc3RvcmUuYWNjZXNzLmhlYXAuSGVhcENvbmdsb21lcmF0ZUZh Y3RvcnkuY3JlYXRlQ29uZ2xvbWVyYXRlKEhlYXBDb25nbG9tZXJhdGVGYWN0b3J5LmphdmEpDQoJ YXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnN0b3JlLmFjY2Vzcy5SQU1UcmFuc2FjdGlvbi5jcmVh dGVDb25nbG9tZXJhdGUoUkFNVHJhbnNhY3Rpb24uamF2YSkNCglhdCBvcmcuYXBhY2hlLmRlcmJ5 LmltcGwuc3FsLmV4ZWN1dGUuVGVtcG9yYXJ5Um93SG9sZGVySW1wbC5pbnNlcnQoVGVtcG9yYXJ5 Um93SG9sZGVySW1wbC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zcWwuZXhlY3V0 ZS5EZWxldGVSZXN1bHRTZXQuY29sbGVjdEFmZmVjdGVkUm93cyhEZWxldGVSZXN1bHRTZXQuamF2 YSkNCglhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3FsLmV4ZWN1dGUuRGVsZXRlQ2FzY2FkZVJl c3VsdFNldC5jb2xsZWN0QWZmZWN0ZWRSb3dzKERlbGV0ZUNhc2NhZGVSZXN1bHRTZXQuamF2YSkN CglhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3FsLmV4ZWN1dGUuRGVsZXRlQ2FzY2FkZVJlc3Vs dFNldC5vcGVuKERlbGV0ZUNhc2NhZGVSZXN1bHRTZXQuamF2YSkNCglhdCBvcmcuYXBhY2hlLmRl cmJ5LmltcGwuc3FsLkdlbmVyaWNQcmVwYXJlZFN0YXRlbWVudC5leGVjdXRlKEdlbmVyaWNQcmVw YXJlZFN0YXRlbWVudC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLkVtYmVk U3RhdGVtZW50LmV4ZWN1dGVTdGF0ZW1lbnQoRW1iZWRTdGF0ZW1lbnQuamF2YSkNCglhdCBvcmcu YXBhY2hlLmRlcmJ5LmltcGwuamRiYy5FbWJlZFByZXBhcmVkU3RhdGVtZW50LmV4ZWN1dGVTdGF0 ZW1lbnQoRW1iZWRQcmVwYXJlZFN0YXRlbWVudC5qYXZhKQ0KCWF0IG9yZy5hcGFjaGUuZGVyYnku aW1wbC5qZGJjLkVtYmVkUHJlcGFyZWRTdGF0ZW1lbnQuZXhlY3V0ZVVwZGF0ZShFbWJlZFByZXBh cmVkU3RhdGVtZW50LmphdmEpDQoJYXQgbmV0LmF0cGNvLnJ1bGVzLmZvb3Rub3Rlcy5zZXJ2ZXIu ZGF0YWFjY2Vzcy5Nb2NrSkRCQ0RBTy5jcmVhdGVVcGRhdGVEZWxldGUoTW9ja0pEQkNEQU8uamF2 YTozOTMpDQoJYXQgbmV0LmF0cGNvLnJ1bGVzLmZvb3Rub3Rlcy5zZXJ2ZXIuZGF0YWFjY2Vzcy5N b2NrSkRCQ0RBTy5kZWxldGUoTW9ja0pEQkNEQU8uamF2YTo0NDIpDQoJYXQgbmV0LmF0cGNvLnJ1 bGVzLmZvb3Rub3Rlcy5zZXJ2ZXIuZGF0YWFjY2Vzcy5Gb290Tm90ZXNKREJDREFPRmFrZS5kZWxl dGUoRm9vdE5vdGVzSkRCQ0RBT0Zha2UuamF2YTo4OSkNCglhdCBuZXQuYXRwY28ucnVsZXMuZm9v dG5vdGVzLnNlcnZlci5kYXRhYWNjZXNzLkdlbmVyaWNGb290Tm90ZXNKREJDREFPLmRlbGV0ZShH ZW5lcmljRm9vdE5vdGVzSkRCQ0RBTy5qYXZhOjIwOCkNCglhdCBuZXQuYXRwY28ucnVsZXMuZm9v dG5vdGVzLnNlcnZlci5kYXRhYWNjZXNzLkdlbmVyaWNGb290Tm90ZXNEYVN2Yy5kZWxldGUoR2Vu ZXJpY0Zvb3ROb3Rlc0RhU3ZjLmphdmE6MTQ4KQ0KCWF0IG5ldC5hdHBjby5ydWxlcy5mb290bm90 ZXMuc2VydmVyLmRhdGFhY2Nlc3MuTW9ja0RhU3ZjLmRlbGV0ZShNb2NrRGFTdmMuamF2YToyNykN CglhdCBuZXQuYXRwY28ucnVsZXMuZm9vdG5vdGVzLnNlcnZlci5kYXRhYWNjZXNzLkdlbmVyaWNG b290Tm90ZXNEYVN2Yy5kZWxldGUoR2VuZXJpY0Zvb3ROb3Rlc0RhU3ZjLmphdmE6MTUyKQ0KCWF0 IG5ldC5hdHBjby5ydWxlcy5mb290bm90ZXMuc2VydmVyLmRhdGFhY2Nlc3MuTW9ja0RhU3ZjLmRl bGV0ZShNb2NrRGFTdmMuamF2YToyMykNCglhdCBuZXQuYXRwY28ucnVsZXMuZm9vdG5vdGVzLnNl cnZlci5kYXRhYWNjZXNzLmNhdHMuc3Zjcy5Gb290Tm90ZXNDYXQxMUJsY2tPdXREYXRlc0RBU3Zj VGVzdC5kZWxldGVTZWVkRGF0YShGb290Tm90ZXNDYXQxMUJsY2tPdXREYXRlc0RBU3ZjVGVzdC5q YXZhOjEyOSkNCglhdCBuZXQuYXRwY28ucnVsZXMuZm9vdG5vdGVzLnNlcnZlci5kYXRhYWNjZXNz LmNhdHMuc3Zjcy5Gb290Tm90ZXNDYXQxMUJsY2tPdXREYXRlc0RBU3ZjVGVzdCQxLnNldFVwKEZv b3ROb3Rlc0NhdDExQmxja091dERhdGVzREFTdmNUZXN0LmphdmE6NjApDQoJYXQganVuaXQuZXh0 ZW5zaW9ucy5UZXN0U2V0dXAkMS5wcm90ZWN0KFRlc3RTZXR1cC5qYXZhOjE4KQ0KCWF0IGp1bml0 LmZyYW1ld29yay5UZXN0UmVzdWx0LnJ1blByb3RlY3RlZChUZXN0UmVzdWx0LmphdmE6MTI0KQ0K CWF0IGp1bml0LmV4dGVuc2lvbnMuVGVzdFNldHVwLnJ1bihUZXN0U2V0dXAuamF2YToyMykNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1blRlc3QoVGVzdFN1aXRlLmphdmE6MjA4KQ0K CWF0IGp1bml0LmZyYW1ld29yay5UZXN0U3VpdGUucnVuKFRlc3RTdWl0ZS5qYXZhOjIwMykNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1blRlc3QoVGVzdFN1aXRlLmphdmE6MjA4KQ0K CWF0IGp1bml0LmZyYW1ld29yay5UZXN0U3VpdGUucnVuKFRlc3RTdWl0ZS5qYXZhOjIwMykNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1blRlc3QoVGVzdFN1aXRlLmphdmE6MjA4KQ0K CWF0IGp1bml0LmZyYW1ld29yay5UZXN0U3VpdGUucnVuKFRlc3RTdWl0ZS5qYXZhOjIwMykNCglh dCBqdW5pdC5mcmFtZXdvcmsuVGVzdFN1aXRlLnJ1blRlc3QoVGVzdFN1aXRlLmphdmE6MjA4KQ0K CWF0IGp1bml0LmZyYW1ld29yay5UZXN0U3VpdGUucnVuKFRlc3RTdWl0ZS5qYXZhOjIwMykNCglh dCBvcmcuZWNsaXBzZS5qZHQuaW50ZXJuYWwuanVuaXQucnVubmVyLlJlbW90ZVRlc3RSdW5uZXIu cnVuVGVzdHMoUmVtb3RlVGVzdFJ1bm5lci5qYXZhOjMyOSkNCglhdCBvcmcuZWNsaXBzZS5qZHQu aW50ZXJuYWwuanVuaXQucnVubmVyLlJlbW90ZVRlc3RSdW5uZXIucnVuKFJlbW90ZVRlc3RSdW5u ZXIuamF2YToyMTgpDQoJYXQgb3JnLmVjbGlwc2UuamR0LmludGVybmFsLmp1bml0LnJ1bm5lci5S ZW1vdGVUZXN0UnVubmVyLm1haW4oUmVtb3RlVGVzdFJ1bm5lci5qYXZhOjE1MSkNCkNsZWFudXAg YWN0aW9uIGNvbXBsZXRlZA0K ------_=_NextPart_001_01C5A2A1.BADF77ED--