Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 63458 invoked from network); 10 Nov 2006 06:59:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 10 Nov 2006 06:59:24 -0000 Received: (qmail 88717 invoked by uid 500); 10 Nov 2006 06:59:33 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 88690 invoked by uid 500); 10 Nov 2006 06:59:32 -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 Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 17222 invoked by uid 99); 10 Nov 2006 05:48:21 -0000 X-ASF-Spam-Status: No, hits=2.5 required=10.0 tests=ADVANCE_FEE_1,DNS_FROM_RFC_ABUSE,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) X-VirusChecked: Checked X-Env-Sender: Sridharsingh.Inder@lntinfotech.com X-Msg-Ref: server-16.tower-42.messagelabs.com!1163137658!20945578!1 X-StarScan-Version: 5.5.10.7; banners=lntinfotech.com,-,- X-Originating-IP: [203.199.54.34] In-Reply-To: <45533DA4.9050401@Sun.COM> To: derby-user@db.apache.org Cc: derby-user@db.apache.org, Julius.Stroffek@Sun.COM Subject: Re: Query regarding derby MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.3 September 14, 2004 Message-ID: From: Sridharsingh Inder Date: Fri, 10 Nov 2006 11:17:36 +0530 X-MIMETrack: Serialize by Router on POWAI/LNTINFOTECH(Release 6.5.5 HF316|April 20, 2006) at 11/10/2006 11:17:37 AM, Itemize by SMTP Server on MAILRELAY2/LNTINFOTECH(Release 6.5.5|November 30, 2005) at 11/10/2006 11:18:54 AM, Serialize by Router on MAILRELAY2/LNTINFOTECH(Release 6.5.5|November 30, 2005) at 11/10/2006 11:18:56 AM Content-Type: multipart/mixed; boundary="=_mixed 001FD27565257222_=" X-Virus-Checked: Checked by ClamAV on apache.org --=_mixed 001FD27565257222_= Content-Type: multipart/alternative; boundary="=_alternative 001FD27565257222_=" --=_alternative 001FD27565257222_= Content-Type: text/plain; charset="US-ASCII" Hi Derby User Team, Thanks for your immediate response. The derby version is mentioned below Bundle-Name: Apache Derby 10.0 Bundle-Version: 10.0.2000001 DERBY_DRIVER = org.apache.derby.jdbc.EmbeddedDriver DERBY_PROTOCOL = jdbc:derby: We dont have multiple instance of derby. We are attaching the AccessDB and DatabaseConnectionManager class for your reference. Best Regards, Sridhar Software Engineer, Eurogiro Team, L&T Infotech, Phone: +9122-67768201 This Mail is classified as [ ] L&T Infotech Proprietary [ ] L&T Infotech Internal Use [x] L&T Infotech Confidential [ ] L&T Infotech General Business "Julius.Stroffek" Sent by: Julius.Stroffek@Sun.COM 11/09/2006 08:09 PM Please respond to derby-user@db.apache.org To derby-user@db.apache.org cc derby-dev@db.apache.org, Sridharsingh.Inder@lntinfotech.com Subject Re: Query regarding derby Hi Sridharsingh, Please describe more your running configuration. This kind of error may occur if you are running different instances of derby to access a same database. Which version of derby are you running? Do you have more instances of derby on the same machine? What exactly are you doing? I have posted the reply to derby-user mailing list since I think it is related more to the user issue. Cheers Julo Sridharsingh Inder wrote: Hi Derby Team, We are using derby database in our application. While updating the table, we are getting "A lock could not be obtained within the time requested " this exception. My queries are as follows 1. Why I am getting this exception? 2. What I should do to avoid this error? 3. How the locking mechanism working in Derby Database? Thanks in Advance . Best Regards, Sridhar Software Engineer, Eurogiro Team, L&T Infotech, Phone: +9122-67768201 This Mail is classified as [ ] L&T Infotech Proprietary [ ] L&T Infotech Internal Use [x] L&T Infotech Confidential [ ] L&T Infotech General Business ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ --=_alternative 001FD27565257222_= Content-Type: text/html; charset="US-ASCII"
Hi Derby User Team,

Thanks for your immediate response.

The derby version is mentioned below
Bundle-Name: Apache Derby 10.0
Bundle-Version: 10.0.2000001
DERBY_DRIVER = org.apache.derby.jdbc.EmbeddedDriver
DERBY_PROTOCOL = jdbc:derby:

We dont have multiple instance of derby. We are attaching the AccessDB and DatabaseConnectionManager class for your reference.


Best Regards,
Sridhar
Software Engineer,
Eurogiro Team,
L&T Infotech,
Phone: +9122-67768201

This Mail is classified as
[  ] L&T Infotech Proprietary
[  ] L&T Infotech Internal Use
[x] L&T Infotech Confidential
[  ] L&T Infotech General Business


"Julius.Stroffek" <Julius.Stroffek@Sun.COM>
Sent by: Julius.Stroffek@Sun.COM

11/09/2006 08:09 PM
Please respond to
derby-user@db.apache.org
To
derby-user@db.apache.org
cc
derby-dev@db.apache.org, Sridharsingh.Inder@lntinfotech.com
Subject
Re: Query regarding derby





Hi Sridharsingh,

Please describe more your running configuration. This kind of error may occur if you are running different instances of derby to access a same database.

Which version of derby are you running? Do you have more instances of derby on the same machine? What exactly are you doing?

I have posted the reply to derby-user mailing list since I think it is related more to the user issue.

Cheers

Julo

Sridharsingh Inder wrote:

Hi Derby Team,

We are using derby database in our application. While updating the table, we are getting
"A lock could not be obtained within the time requested " this exception.

My queries are as follows

1. Why I am getting this exception?
2. What I should do to avoid this error?
3. How the locking mechanism working in Derby Database?


Thanks in Advance .

Best Regards,
Sridhar
Software Engineer,
Eurogiro Team,
L&T Infotech,
Phone: +9122-67768201

This Mail is classified as
[  ] L&T Infotech Proprietary
[  ] L&T Infotech Internal Use
[x] L&T Infotech Confidential
[  ] L&T Infotech General Business
______________________________________________________________________


______________________________________________________________________

______________________________________________________________________
--=_alternative 001FD27565257222_=-- --=_mixed 001FD27565257222_= Content-Type: application/octet-stream; name="DatabaseConnectionManager.java" Content-Disposition: attachment; filename="DatabaseConnectionManager.java" Content-Transfer-Encoding: base64 aW1wb3J0IGphdmEuc3FsLkNvbm5lY3Rpb247DQppbXBvcnQgamF2YS5zcWwuRHJpdmVyTWFuYWdl cjsNCmltcG9ydCBqYXZhLnNxbC5TUUxFeGNlcHRpb247DQppbXBvcnQgamF2YS51dGlsLlByb3Bl cnRpZXM7DQppbXBvcnQgamF2YS51dGlsLmxvZ2dpbmcuTG9nZ2VyOw0KDQppbXBvcnQgb3JnLmFw YWNoZS5jb21tb25zLmRiY3AuQmFzaWNEYXRhU291cmNlOw0KDQppbXBvcnQgY29tLmV1cm9naXJv LmNvbW1vbi5leGNlcHRpb24uQnVzaW5lc3NFeGNlcHRpb247DQppbXBvcnQgY29tLmV1cm9naXJv LmNvbW1vbi5leGNlcHRpb24uREJFeGNlcHRpb247DQppbXBvcnQgY29tLmV1cm9naXJvLmNvbW1v bi5leGNlcHRpb24uU3VwZXJFeGNlcHRpb247DQppbXBvcnQgY29tLmV1cm9naXJvLmNvbW1vbi5z ZXJ2ZXIudXRpbC5Db21tb25Db25zdGFudHNJRjsNCmltcG9ydCBjb20uZXVyb2dpcm8uY29tbW9u LnNlcnZlci51dGlsLkVuY3J5cHREZWNyeXB0VXRpbDsNCmltcG9ydCBjb20uZXVyb2dpcm8uY29t bW9uLnV0aWwuQ29uc3RhbnRzSUY7DQppbXBvcnQgY29tLmV1cm9naXJvLmVscy5zZXJ2ZXIuRUxT QXBwbG5Db25maWc7DQoNCnB1YmxpYyBjbGFzcyBEYXRhYmFzZUNvbm5lY3Rpb25NYW5hZ2VyIHsN Cg0KICAgIHByaXZhdGUgc3RhdGljIERhdGFiYXNlQ29ubmVjdGlvbk1hbmFnZXIgZGJNZ3IgPSBu dWxsOw0KICAgIHByaXZhdGUgQmFzaWNEYXRhU291cmNlIGRhdGFzb3VyY2U7DQogICAgcHJpdmF0 ZSBzdGF0aWMgTG9nZ2VyIGxvZ2dlciA9IExvZ2dlci4NCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBnZXRMb2dnZXIoRGF0YWJhc2VCYWNrdXBNYW5hZ2VyLg0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY2xhc3MuZ2V0UGFja2Fn ZSgpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg LmdldE5hbWUoKSk7DQoNCiAgICAvKioNCiAgICAgKiBDb25zdHJ1Y3RvciB0byBjcmVhdGUgYW5k IGluaXRpYWxpemUgbmV3IERhdGFTb3VyY2UuDQogICAgICoNCiAgICAgKiBAdGhyb3dzIEJ1c2lu ZXNzRXhjZXB0aW9uICAgICAgICAgICAgRXJyb3Igd2hpbGUgRGVjcnlwdGluZyBQYXNzd29yZA0K ICAgICAqLw0KICAgIHByaXZhdGUgRGF0YWJhc2VDb25uZWN0aW9uTWFuYWdlcigpIHRocm93cyBC dXNpbmVzc0V4Y2VwdGlvbiB7DQogICAgICAgIGRhdGFzb3VyY2UgPSBuZXcgQmFzaWNEYXRhU291 cmNlKCk7DQogICAgICAgIGluaXRpYWxpemVQb29sKCk7DQogICAgfQ0KDQogICAgLyoqDQogICAg ICogVGhpcyBtZXRob2QgcmV0dXJucyB0aGUgU2luZ2xldG9uIGluc3RhbmNlIG9mIERhdGFiYXNl Q29ubmVjdGlvbk1hbmFnZXINCiAgICAgKg0KICAgICAqIEByZXR1cm4gRGF0YWJhc2VDb25uZWN0 aW9uTWFuYWdlciAgIFNpbmdsZXRvbiBpbnN0YW5jZSBvZg0KICAgICAqICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIERhdGFiYXNlQ29ubmVjdGlvbk1hbmFnZXINCiAgICAgKiBA dGhyb3dzIEJ1c2luZXNzRXhjZXB0aW9uICAgICAgICAgICBFcnJvciB3aGlsZSBEZWNyeXB0aW5n IFBhc3N3b3JkDQogICAgICovDQogICAgcHVibGljIHN0YXRpYyBEYXRhYmFzZUNvbm5lY3Rpb25N YW5hZ2VyIGdldEluc3RhbmNlKCkNCiAgICAgICAgdGhyb3dzIEJ1c2luZXNzRXhjZXB0aW9uIHsN CiAgICAgICAgaWYgKGRiTWdyID09IG51bGwpIHsNCiAgICAgICAgICAgIGRiTWdyID0gbmV3IERh dGFiYXNlQ29ubmVjdGlvbk1hbmFnZXIoKTsNCiAgICAgICAgfQ0KICAgICAgICByZXR1cm4gZGJN Z3I7DQogICAgfQ0KDQogICAgLyoqDQogICAgICogVGhpcyBtZXRob2QgcmV0cmlldmVzIENvbm5l Y3Rpb24gdG8gdGhlIERhdGFiYXNlIGZyb20gdGhlIFBvb2wuDQogICAgICoNCiAgICAgKiBAcmV0 dXJuIENvbm5lY3Rpb24gICAgICAgICAgICAgICAgICBUaGUgQ29ubmVjdGlvbiBmcm9tIHRoZSBQ b29sDQogICAgICogQHRocm93cyBTUUxFeGNlcHRpb24gICAgICAgICAgICAgICAgRXJyb3Igb2Nj dXJyZWQgd2hpbGUgcmV0cmlldmluZyB0aGUNCiAgICAgKiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBDb25uZWN0aW9uLg0KICAgICAqLw0KICAgIHB1YmxpYyBDb25uZWN0aW9u IGdldENvbm5lY3Rpb24oKSB0aHJvd3MgU1FMRXhjZXB0aW9uIHsNCiAgICAgICAgcmV0dXJuIGRh dGFzb3VyY2UuZ2V0Q29ubmVjdGlvbigpOw0KICAgIH0NCg0KICAgIC8qKg0KICAgICAqIFRoaXMg bWV0aG9kIGluaXRpYWxpemVzIHRoZSBEYXRhYmFzZSBDb25uZWN0aW9uIFBvb2wNCiAgICAgKg0K ICAgICAqIEB0aHJvd3MgQnVzaW5lc3NFeGNlcHRpb24gICAgICAgICAgICBFcnJvciB3aGlsZSBE ZWNyeXB0aW5nIFBhc3N3b3JkDQogICAgICovDQogICAgcHJpdmF0ZSB2b2lkIGluaXRpYWxpemVQ b29sKCkgdGhyb3dzIEJ1c2luZXNzRXhjZXB0aW9uIHsNCiAgICAgICAgLy8gU2V0IHRoZSBEYXRh YmFzZSBob21lIGFzIFN5c3RlbSBQcm9wZXJ0eQ0KICAgICAgICBTdHJpbmcgc3RyREJQYXRoID0g U3lzdGVtLmdldFByb3BlcnR5KENvbnN0YW50c0lGLkVMU19IT01FKQ0KICAgICAgICArIENvbW1v bkNvbnN0YW50c0lGLkRCX1BBVEg7DQogICAgICAgIFN5c3RlbS5zZXRQcm9wZXJ0eShDb21tb25D b25zdGFudHNJRi5ERVJCWV9TWVNURU1fUFJPUEVSVFksIHN0ckRCUGF0aCk7DQoNCiAgICAgICAg Ly8gU2V0IHRoZSBJbnRpYWwgUG9vbCBTaXplIGFuZCBNYXhpbXVtIEFjdGl2ZSBDb25uZWN0aW9u cyBpbiB0aGUgcG9vbA0KICAgICAgICBkYXRhc291cmNlLnNldEluaXRpYWxTaXplKENvbW1vbkNv bnN0YW50c0lGLkRCX0lOSVRJQUxfQ09OTl9QT09MKTsNCiAgICAgICAgZGF0YXNvdXJjZS5zZXRN YXhBY3RpdmUoQ29tbW9uQ29uc3RhbnRzSUYuREJfTUFYX0FDVElWRV9DT05OX1BPT0wpOw0KDQog ICAgICAgIC8vIEdldCB0aGUgQ29ubmVjdGlvbiBQcm9wZXJ0aWVzIGZyb20gdGhlIEVMUyBBcHBs aWNhdGlvbiBDb25maWd1cmF0aW9uDQogICAgICAgIFN0cmluZyBzdHJCb290UHdkID0gRUxTQXBw bG5Db25maWcuZ2V0SW5zdGFuY2UoKS5nZXRFbHNDb25maWcoKS4NCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgZ2V0S2V5VmFsdWUoQ29tbW9uQ29uc3RhbnRzSUYuREJfQk9PVF9QV0Qp Ow0KICAgICAgICBzdHJCb290UHdkID0gRW5jcnlwdERlY3J5cHRVdGlsLmdldERlY3J5cHRlZChz dHJCb290UHdkKTsNCg0KICAgICAgICBTdHJpbmcgc3RyUHdkID0gRUxTQXBwbG5Db25maWcuZ2V0 SW5zdGFuY2UoKS5nZXRFbHNDb25maWcoKS4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgZ2V0S2V5VmFsdWUoQ29tbW9uQ29uc3RhbnRzSUYuREJfUFdEKTsNCiAgICAgICAgc3RyUHdk ID0gRW5jcnlwdERlY3J5cHRVdGlsLmdldERlY3J5cHRlZChzdHJQd2QpOw0KICAgICAgICAvLyBT ZXQgdGhlIERyaXZlcg0KICAgICAgICBkYXRhc291cmNlLnNldERyaXZlckNsYXNzTmFtZShDb21t b25Db25zdGFudHNJRi5ERVJCWV9EUklWRVIpOw0KICAgICAgICAvLyBTZXQgdGhlIFVSTA0KICAg ICAgICBkYXRhc291cmNlLnNldFVybChDb21tb25Db25zdGFudHNJRi5ERVJCWV9QUk9UT0NPTA0K ICAgICAgICAgICAgICAgICsgQ29tbW9uQ29uc3RhbnRzSUYuREJfTkFNRSk7DQogICAgICAgIC8v IFNldCB0aGUgQ29ubmVjdGlvbiBQcm9wZXJ0aWVzDQogICAgICAgIGRhdGFzb3VyY2UuYWRkQ29u bmVjdGlvblByb3BlcnR5KENvbW1vbkNvbnN0YW50c0lGLkNPTk5FQ1RJT05fQk9PVF9QV0QsDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgc3RyQm9vdFB3ZCk7DQogICAgICAgIGRhdGFzb3VyY2UuYWRkQ29ubmVjdGlvblByb3Bl cnR5KENvbW1vbkNvbnN0YW50c0lGLkNPTk5FQ1RJT05fVVNFUiwNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgQ29tbW9uQ29uc3RhbnRzSUYuREJfVVNFUik7DQog ICAgICAgIGRhdGFzb3VyY2UuYWRkQ29ubmVjdGlvblByb3BlcnR5KENvbW1vbkNvbnN0YW50c0lG LkNPTk5FQ1RJT05fUFdELA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIHN0clB3ZCk7DQogICAgfSAvLyBFbmQgb2YgaW5pdGlh bGl6ZVBvb2wNCg0KICAgIC8qKg0KICAgICAqIFRoaXMgbWV0aG9kIHNodXRzIGRvd24gdGhlIEVt YmVkZGVkIERhdGFiYXNlLg0KICAgICAqDQogICAgICogQHRocm93cyBTdXBlckV4Y2VwdGlvbiAg ICAgICAgICAgICAgRXJyb3Igb2NjdXJyZWQgd2hpbGUgc2h1dHRpbmcgZG93bg0KICAgICAqICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEVtYmVkZGVkIERhdGFiYXNlDQogICAg ICovDQogICAgcHVibGljIHZvaWQgc2h1dERvd25EYXRhYmFzZSgpIHRocm93cyBTdXBlckV4Y2Vw dGlvbiB7DQogICAgICAgIENvbm5lY3Rpb24gY29ubmVjdGlvbiA9IG51bGw7DQogICAgICAgIHRy eSB7DQoNCiAgICAgICAgICAgIC8vIExvYWQgdGhlIERhdGFiYXNlIERyaXZlcg0KICAgICAgICAg ICAgQ2xhc3MuZm9yTmFtZShDb21tb25Db25zdGFudHNJRi5ERVJCWV9EUklWRVIpLm5ld0luc3Rh bmNlKCk7DQogICAgICAgICAgICBsb2dnZXIuZmluZSgiRGF0YWJhc2UgRHJpdmVyIGxvYWRlZCBz dWNjZXNzZnVsbHkuIik7DQogICAgICAgICAgICBTdHJpbmcgc3RyRGJOYW1lID0gQ29tbW9uQ29u c3RhbnRzSUYuREJfTkFNRTsNCiAgICAgICAgICAgIFN0cmluZyBzdHJQd2QgPSBFTFNBcHBsbkNv bmZpZy5nZXRJbnN0YW5jZSgpLg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg Z2V0RWxzQ29uZmlnKCkuDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg Z2V0S2V5VmFsdWUoQ29tbW9uQ29uc3RhbnRzSUYuREJfUFdEKTsNCiAgICAgICAgICAgIC8vIERl Y3J5cHQgdGhlIFVzZXIgUGFzc3dvcmQNCiAgICAgICAgICAgIHN0clB3ZCA9IEVuY3J5cHREZWNy eXB0VXRpbC5nZXREZWNyeXB0ZWQoc3RyUHdkKTsNCiAgICAgICAgICAgIFN0cmluZyBzdHJCb290 UHdkID0gRUxTQXBwbG5Db25maWcuZ2V0SW5zdGFuY2UoKS4NCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIGdldEVsc0NvbmZpZygpLg0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgZ2V0S2V5VmFsdWUoQ29tbW9uQ29uc3RhbnRzSUYuREJfQk9PVF9QV0QpOw0K ICAgICAgICAgICAgLy8gRGVjcnlwdCB0aGUgQm9vdCBQYXNzd29yZA0KICAgICAgICAgICAgc3Ry Qm9vdFB3ZCA9IEVuY3J5cHREZWNyeXB0VXRpbC5nZXREZWNyeXB0ZWQoc3RyQm9vdFB3ZCk7DQog ICAgICAgICAgICAvLyBTZXQgQ29ubmVjdGlvbiBQcm9wZXJ0aWVzDQogICAgICAgICAgICBQcm9w ZXJ0aWVzIHByb3BzID0gbmV3IFByb3BlcnRpZXMoKTsNCiAgICAgICAgICAgIHByb3BzLnB1dChD b21tb25Db25zdGFudHNJRi5DT05ORUNUSU9OX1VTRVIsDQogICAgICAgICAgICAgICAgQ29tbW9u Q29uc3RhbnRzSUYuREJfVVNFUik7DQogICAgICAgICAgICBwcm9wcy5wdXQoQ29tbW9uQ29uc3Rh bnRzSUYuQ09OTkVDVElPTl9QV0QsIHN0clB3ZCk7DQogICAgICAgICAgICAvLyBGb3JtIHRoZSBD b25uZWN0aW9uIFVSTA0KICAgICAgICAgICAgU3RyaW5nIHN0clVybCA9IENvbW1vbkNvbnN0YW50 c0lGLkRFUkJZX1BST1RPQ09MDQogICAgICAgICAgICAgICAgKyBzdHJEYk5hbWUNCiAgICAgICAg ICAgICAgICAgICAgICAgICsgIjsiICsgQ29tbW9uQ29uc3RhbnRzSUYuDQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBDT05ORUNUSU9OX0JPT1RfUFdEDQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgKyAiPSIgKyBzdHJCb290UHdkICsgIjtzaHV0ZG93 bj10cnVlIjsNCiAgICAgICAgICAgIHRyeSB7DQogICAgICAgICAgICAgICAgY29ubmVjdGlvbiA9 IERyaXZlck1hbmFnZXINCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAuZ2V0Q29ubmVjdGlv bihzdHJVcmwsIHByb3BzKTsNCiAgICAgICAgICAgIH0gY2F0Y2ggKFNRTEV4Y2VwdGlvbiBleCkg ew0KICAgICAgICAgICAgICAgIGxvZ2dlci53YXJuaW5nKCJEYXRhYmFzZSBTdWNjZXNzZnVsIFNo dXREb3duIEV4Y2VwdGlvbiIpOw0KICAgICAgICAgICAgfQ0KICAgICAgICAgICAgbG9nZ2VyLmlu Zm8oIkRhdGFiYXNlIFNodXREb3duIHN1Y2Nlc3NmdWxseSIpOw0KICAgICAgICB9IGNhdGNoIChC dXNpbmVzc0V4Y2VwdGlvbiBleCkgew0KICAgICAgICAgICAgbG9nZ2VyLnNldmVyZSgiRXJyb3Ig b2NjdXJlZCB3aGlsZSBzaHV0dGluZyBkb3duIERhdGFiYXNlLiAiDQogICAgICAgICAgICAgICAg ICAgICsgIlJlYXNvbjogIiArIGV4LmdldEVycm9yQ29kZSgpKTsNCiAgICAgICAgICAgIGV4LnNl dE1lc3NhZ2UoIkVycm9yIG9jY3VyZWQgd2hpbGUgc2h1dHRpbmcgZG93biBEYXRhYmFzZS4gIg0K ICAgICAgICAgICAgICAgICAgICArICJSZWFzb246ICIgKyBleC5nZXRFcnJvckNvZGUoKSk7DQog ICAgICAgICAgICB0aHJvdyBleDsNCiAgICAgICAgfSBjYXRjaCAoRXhjZXB0aW9uIGV4KSB7DQog ICAgICAgICAgICBTdHJpbmcgc3RyTWVzc2FnZSA9ICJFcnJvciBvY2N1cmVkIHdoaWxlIHNodXR0 aW5nIGRvd24gRGF0YWJhc2UuICI7DQogICAgICAgICAgICBpZiAobnVsbCAhPSBleC5nZXRNZXNz YWdlKCkpIHsNCiAgICAgICAgICAgICAgICBzdHJNZXNzYWdlID0gc3RyTWVzc2FnZSArICJSZWFz b246ICIgKyBleC5nZXRNZXNzYWdlKCk7DQogICAgICAgICAgICB9DQogICAgICAgICAgICBsb2dn ZXIuc2V2ZXJlKHN0ck1lc3NhZ2UpOw0KICAgICAgICAgICAgREJFeGNlcHRpb24gZGJFeGNlcHRp b24gPSBuZXcgREJFeGNlcHRpb24oKTsNCiAgICAgICAgICAgIGRiRXhjZXB0aW9uLnNldE1lc3Nh Z2UoIkVycm9yIG9jY3VyZWQgd2hpbGUgc2h1dHRpbmcgIg0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICArICJkb3duIERhdGFiYXNlLiIpOw0KICAgICAgICAgICAgdGhy b3cgZGJFeGNlcHRpb247DQogICAgICAgIH0NCiAgICB9IC8vIEVuZCBvZiBzaHV0RG93bkRhdGFi YXNlDQp9DQo= --=_mixed 001FD27565257222_= Content-Type: application/octet-stream; name="AccessDB.java" Content-Disposition: attachment; filename="AccessDB.java" Content-Transfer-Encoding: base64 aW1wb3J0IGphdmEuc3FsLkNvbm5lY3Rpb247DQppbXBvcnQgamF2YS5zcWwuU1FMRXhjZXB0aW9u Ow0KaW1wb3J0IGphdmEudXRpbC5sb2dnaW5nLkxvZ2dlcjsNCg0KaW1wb3J0IGNvbS5ldXJvZ2ly by5jb21tb24uZXhjZXB0aW9uLkJ1c2luZXNzRXhjZXB0aW9uOw0KaW1wb3J0IGNvbS5ldXJvZ2ly by5jb21tb24uZXhjZXB0aW9uLkRCRXhjZXB0aW9uOw0KDQoNCnB1YmxpYyBjbGFzcyBBY2Nlc3NE QiB7DQogICAgcHJpdmF0ZSBDb25uZWN0aW9uIGNvbm5lY3Rpb24gPSBudWxsOw0KICAgIHByaXZh dGUgTG9nZ2VyIGxvZ2dlciA9IExvZ2dlci5nZXRMb2dnZXIodGhpcy5nZXRDbGFzcygpLmdldFBh Y2thZ2UoKQ0KICAgICAgICAuZ2V0TmFtZSgpKTsNCg0KICAgIC8qKg0KICAgICAqIENvbnN0cnVj dG9yIHdoaWNoIGludGVybmFsbHkgZ2V0cyBhIG5ldyBjb25uZWN0aW9uLg0KICAgICAqIA0KICAg ICAqIEB0aHJvd3MgREJFeGNlcHRpb24gdGhyb3duIHdoZW4gYW55IGRiIGVycm9yIG9jY3Vycy4N CiAgICAgKiBAdGhyb3dzIEJ1c2luZXNzRXhjZXB0aW9uIHRocm93biB3aGVuIGFueSBidXNpbmVz cyBlcnJvciBvY2N1cnMgd2hpbGUNCiAgICAgKiAgICAgICAgICAgICAgICAgICAgICAgICAgIGdl dHRpbmcgY29ubmVjdGlvbi5lLmcuIEVycm9yIGluIGRlY3J5cHRpbmcNCiAgICAgKiAgICAgICAg ICAgICAgICAgICAgICAgICAgIHBhc3N3b3JkIHVzZWQgdG8gY29ubmVjdCB0byBkYi4gDQogICAg ICovDQogICAgcHVibGljIEFjY2Vzc0RCKCkgdGhyb3dzIERCRXhjZXB0aW9uLCBCdXNpbmVzc0V4 Y2VwdGlvbiB7DQogICAgICAgIGlmIChudWxsID09IGNvbm5lY3Rpb24pIHsNCiAgICAgICAgICAg IHRyeSB7DQogICAgICAgICAgICAgICAgY29ubmVjdGlvbiA9IERhdGFiYXNlQ29ubmVjdGlvbk1h bmFnZXIuZ2V0SW5zdGFuY2UoKQ0KICAgICAgICAgICAgICAgICAgICAgICAgLmdldENvbm5lY3Rp b24oKTsNCiAgICAgICAgICAgIH0gY2F0Y2ggKFNRTEV4Y2VwdGlvbiBzcWxFeCkgew0KICAgICAg ICAgICAgICAgIGxvZ2dlci5zZXZlcmUoIlNRTEV4Y2VwdGlvbiB3aGlsZSBnZXR0aW5nIHRoZSBj b25uZWN0aW9uIik7DQogICAgICAgICAgICAgICAgREJFeGNlcHRpb24gZGJFeCA9IG5ldyBEQkV4 Y2VwdGlvbihzcWxFeCk7DQogICAgICAgICAgICAgICAgZGJFeC5zZXRNZXNzYWdlKCJFcnJvciBn ZXR0aW5nIGRiIGNvbm5lY3Rpb24iKTsNCiAgICAgICAgICAgICAgICBkYkV4LnNldEVycm9yQ29k ZSgiREJFUlJPUi01MSIpOw0KICAgICAgICAgICAgICAgIHRocm93IGRiRXg7DQogICAgICAgICAg ICB9DQogICAgICAgIH0NCiAgICB9DQoNCiAgICAvKioNCiAgICAgKiBUaGlzIG1ldGhvZCByZXR1 cm5zIHRoZSBjb25uZWN0aW9uLg0KICAgICAqDQogICAgICogQHJldHVybiBSZXR1cm5zIHRoZSBj b25uZWN0aW9uLg0KICAgICAqLw0KICAgIHB1YmxpYyBDb25uZWN0aW9uIGdldENvbm5lY3Rpb24o KSB7DQogICAgICAgIHJldHVybiBjb25uZWN0aW9uOw0KICAgIH0NCg0KICAgIC8qKg0KICAgICAq IFRoaXMgbWV0aG9kIHNldHMgdGhlIGNvbm5lY2l0b24uDQogICAgICoNCiAgICAgKiBAcGFyYW0g c3RyQ29ubmVjdGlvbiBUaGUgY29ubmVjdGlvbiB0byBzZXQuDQogICAgICovDQogICAgcHVibGlj IHZvaWQgc2V0Q29ubmVjdGlvbihDb25uZWN0aW9uIHN0ckNvbm5lY3Rpb24pIHsNCiAgICAgICAg Y29ubmVjdGlvbiA9IHN0ckNvbm5lY3Rpb247DQogICAgfQ0KDQogICAgLyoqDQogICAgICogQ29t bWl0IHRoZSBleGlzdGluZyBUcmFuc2FjdGlvbi4NCiAgICAgKg0KICAgICAqIEB0aHJvd3MgREJF eGNlcHRpb24gdGhyb3duIHdoZW4gZXJyb3IgaW4gY29tbWl0aW5nIGEgdHJhbnNhY3Rpb24uDQog ICAgICovDQogICAgcHVibGljIHZvaWQgY29tbWl0KCkgdGhyb3dzIERCRXhjZXB0aW9uIHsNCiAg ICAgICAgdHJ5IHsNCiAgICAgICAgICAgIC8vIFRyeSBjb21taXQgdGhlIHRyYW5zYWN0aW9uIA0K ICAgICAgICAgICAgY29ubmVjdGlvbi5jb21taXQoKTsNCiAgICAgICAgfSBjYXRjaCAoU1FMRXhj ZXB0aW9uIHNxbEV4Y2VwdGlvbikgew0KICAgICAgICAgICAgREJFeGNlcHRpb24gZGJFeCA9IG5l dyBEQkV4Y2VwdGlvbihzcWxFeGNlcHRpb24pOw0KICAgICAgICAgICAgZGJFeC5zZXRNZXNzYWdl KCJFcnJvciB3aGlsZSBkYXRhYmFzZSBjb21taXQiKTsNCiAgICAgICAgICAgIGRiRXguc2V0RXJy b3JDb2RlKCJEQkVSUk9SLTU2Iik7DQogICAgICAgICAgICB0aHJvdyBkYkV4Ow0KICAgICAgICB9 DQogICAgfQ0KDQogICAgLyoqDQogICAgICogVGhpcyBtZXRob2Qgc2V0cyB0aGUgYXV0byBjb21t aXQgZmxhZyB0byBmYWxzZS4NCiAgICAgKg0KICAgICAqIEBwYXJhbSBiSXNBdXRvQ29tbWl0IGJv b2xlYW4gdHJ1ZTtPTiBmYWxzZTtPRkYNCiAgICAgKiBAdGhyb3dzIERCRXhjZXB0aW9uIGlzIHRo cm93biB3aGVuIGVycm9yIG9jY3VycyB3aGlsZSBzZXR0aW5nIGF1dG8NCiAgICAgKiAgICAgICAg ICAgICAgICAgICAgIGNvbW1pdCBmbGFnLg0KICAgICAqLw0KICAgIHB1YmxpYyB2b2lkIHNldEF1 dG9Db21taXQoYm9vbGVhbiBiSXNBdXRvQ29tbWl0KSB0aHJvd3MgREJFeGNlcHRpb24gew0KICAg ICAgICB0cnkgew0KICAgICAgICAgICAgY29ubmVjdGlvbi5zZXRBdXRvQ29tbWl0KGJJc0F1dG9D b21taXQpOw0KICAgICAgICB9IGNhdGNoIChTUUxFeGNlcHRpb24gc3FsRXhjZXB0aW9uKSB7DQog ICAgICAgICAgICBsb2dnZXIuc2V2ZXJlKCJTUUxFeGNlcHRpb24gd2hpbGUgc2V0dGluZyBhdXRv IGNvbW1pdCIpOw0KICAgICAgICAgICAgREJFeGNlcHRpb24gZGJFeCA9IG5ldyBEQkV4Y2VwdGlv bihzcWxFeGNlcHRpb24pOw0KICAgICAgICAgICAgZGJFeC5zZXRNZXNzYWdlKCJFcnJvciB3aGls ZSBzZXR0aW5nIGF1dG8gY29tbWl0IGZsYWcgdG86ICINCiAgICAgICAgICAgICAgICAgICAgKyBi SXNBdXRvQ29tbWl0KTsNCiAgICAgICAgICAgIGRiRXguc2V0RXJyb3JDb2RlKCJEQkVSUk9SLTU4 Iik7DQogICAgICAgICAgICB0aHJvdyBkYkV4Ow0KICAgICAgICB9DQogICAgICAgIHJldHVybjsN CiAgICB9DQoNCiAgICAvKioNCiAgICAgKiByb2xsYmFjayAtIHJvbGxiYWNrIHRoZSBjdXJyZW50 IHRyYW5zYWN0aW9uDQogICAgICoNCiAgICAgKiBAdGhyb3dzIERCRXhjZXB0aW9uIHRocm93biB3 aGVuIGVycm9yIGluIHJvbGxiYWNraW5nIGEgdHJhbnNhY3Rpb24uDQogICAgICovDQogICAgcHVi bGljIHZvaWQgcm9sbGJhY2soKSB0aHJvd3MgREJFeGNlcHRpb24gew0KICAgICAgICB0cnkgew0K ICAgICAgICAgICAgY29ubmVjdGlvbi5yb2xsYmFjaygpOw0KICAgICAgICB9IGNhdGNoIChTUUxF eGNlcHRpb24gc3FsRXhjZXB0aW9uKSB7DQogICAgICAgICAgICBsb2dnZXIuc2V2ZXJlKCJTUUxF eGNlcHRpb24gd2hpbGUgcGVyZm9ybWluZyByb2xsYmFjayIpOw0KICAgICAgICAgICAgREJFeGNl cHRpb24gZGJFeCA9IG5ldyBEQkV4Y2VwdGlvbihzcWxFeGNlcHRpb24pOw0KICAgICAgICAgICAg ZGJFeC5zZXRNZXNzYWdlKCJFcnJvciB3aGlsZSBkYXRhYmFzZSByb2xsYmFjayIpOw0KICAgICAg ICAgICAgZGJFeC5zZXRFcnJvckNvZGUoIkRCRVJST1ItNTciKTsNCiAgICAgICAgICAgIHRocm93 IGRiRXg7DQogICAgICAgIH0NCiAgICAgICAgcmV0dXJuOw0KICAgIH0NCg0KICAgIC8qKg0KICAg ICAqIENvbm5lY3Rpb24gY2xvc2UgbWV0aG9kDQogICAgICoNCiAgICAgKiBAdGhyb3dzIERCRXhj ZXB0aW9uIHRocm93biB3aGVuIGVycm9yIGluIGNsb3NpbmcgY29ubmVjdGlvbi4NCiAgICAgKi8N CiAgICBwdWJsaWMgdm9pZCBjbG9zZSgpIHRocm93cyBEQkV4Y2VwdGlvbiB7DQogICAgICAgIC8v IGNsb3NlIE1ldGhvZCBmb3IgY2xvc2luZyB0aGUgY29ubmVjdGlvbg0KICAgICAgICB0cnkgew0K ICAgICAgICAgICAgaWYgKGNvbm5lY3Rpb24gIT0gbnVsbCAmJiAhKGNvbm5lY3Rpb24uaXNDbG9z ZWQoKSkpIHsNCiAgICAgICAgICAgICAgICAvLyBDbG9zZSB0aGUgY29ubmVjdGlvbg0KICAgICAg ICAgICAgICAgIGlmICghY29ubmVjdGlvbi5nZXRBdXRvQ29tbWl0KCkpIHsNCiAgICAgICAgICAg ICAgICAgICAgY29ubmVjdGlvbi5yb2xsYmFjaygpOw0KICAgICAgICAgICAgICAgIH0NCiAgICAg ICAgICAgICAgICBjb25uZWN0aW9uLmNsb3NlKCk7DQogICAgICAgICAgICB9DQogICAgICAgIH0g Y2F0Y2ggKFNRTEV4Y2VwdGlvbiBzcWxFeCkgew0KICAgICAgICAgICAgREJFeGNlcHRpb24gZGJF eCA9IG5ldyBEQkV4Y2VwdGlvbihzcWxFeCk7DQogICAgICAgICAgICB0aHJvdyBkYkV4Ow0KICAg ICAgICB9DQogICAgfQ0KICAgIA0KICAgIC8qKg0KICAgICAqIFRoaXMgbWV0aG9kIHNldHMgdGhl IElzb2xhdGlvbiBsZXZlbCBvZiB0aGUgdHJhbnNhY3Rpb24uDQogICAgICogDQogICAgICogQHBh cmFtIG5Jc29MZXZlbCBJc29sYXRpb24gbGV2ZWwNCiAgICAgKiBAdGhyb3dzIERCRXhjZXB0aW9u IA0KICAgICAqLw0KICAgIHB1YmxpYyB2b2lkIHNldElzb2xhdGlvbmxldmVsKGludCBuSXNvTGV2 ZWwpIHRocm93cyBEQkV4Y2VwdGlvbiB7DQogICAgICAgIGlmIChjb25uZWN0aW9uICE9IG51bGwp IHsNCiAgICAgICAgICAgIHRyeSB7DQogICAgICAgICAgICAgICAgbG9nZ2VyLmluZm8oIlNldHRp bmcgdHggbGV2ZWwgdG8gOiAgIiArIG5Jc29MZXZlbCk7DQogICAgICAgICAgICAgICAgY29ubmVj dGlvbi5zZXRUcmFuc2FjdGlvbklzb2xhdGlvbihuSXNvTGV2ZWwpOw0KICAgICAgICAgICAgfSBj YXRjaCAoRXhjZXB0aW9uIGV4KSB7DQogICAgICAgICAgICAgICAgREJFeGNlcHRpb24gZGJFeCA9 IG5ldyBEQkV4Y2VwdGlvbigpOw0KICAgICAgICAgICAgICAgIGRiRXguc2V0RXJyb3JDb2RlKCJE QkVSUk9SLTU5Iik7DQogICAgICAgICAgICAgICAgZGJFeC5zZXRNZXNzYWdlKCJFcnJvciBzZXR0 aW5nIHR4IGlzb2xhdGlvbiBsZXZlbCIpOw0KICAgICAgICAgICAgICAgIHRocm93IGRiRXg7DQog ICAgICAgICAgICB9DQogICAgICAgIH0NCiAgICB9DQp9 --=_mixed 001FD27565257222_=--