Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 300E118C5B for ; Tue, 22 Dec 2015 17:26:42 +0000 (UTC) Received: (qmail 94248 invoked by uid 500); 22 Dec 2015 17:26:42 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 94218 invoked by uid 500); 22 Dec 2015 17:26:42 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 94207 invoked by uid 99); 22 Dec 2015 17:26:41 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Dec 2015 17:26:41 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 56E54180477 for ; Tue, 22 Dec 2015 17:26:41 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.011 X-Spam-Level: *** X-Spam-Status: No, score=3.011 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=3, T_KAM_HTML_FONT_INVALID=0.01, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id pVA38O_qPlFw for ; Tue, 22 Dec 2015 17:26:30 +0000 (UTC) Received: from eu-smtp-delivery-106.mimecast.com (eu-smtp-delivery-106.mimecast.com [207.82.80.106]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 3A8C042BD8 for ; Tue, 22 Dec 2015 17:26:30 +0000 (UTC) Received: from na01-bn1-obe.outbound.protection.outlook.com (mail-bn1lp0145.outbound.protection.outlook.com [207.46.163.145]) (Using TLS) by eu-smtp-1.mimecast.com with ESMTP id uk-mta-10-LUCmsiK_T2qS8UjCdfUKgg-1; Tue, 22 Dec 2015 17:26:18 +0000 Received: from SN1PR0601MB1614.namprd06.prod.outlook.com (10.163.202.28) by SN1PR0601MB1613.namprd06.prod.outlook.com (10.163.202.27) with Microsoft SMTP Server (TLS) id 15.1.361.13; Tue, 22 Dec 2015 17:26:16 +0000 Received: from SN1PR0601MB1614.namprd06.prod.outlook.com ([10.163.202.28]) by SN1PR0601MB1614.namprd06.prod.outlook.com ([10.163.202.28]) with mapi id 15.01.0361.006; Tue, 22 Dec 2015 17:26:16 +0000 From: Anjana Prakash To: Rick Hillegas , "derby-dev@db.apache.org" Subject: RE: using log4j in user defined system procedure Thread-Topic: using log4j in user defined system procedure Thread-Index: AdE42I5QkGHYWO7yT82+m+7pLOvxCQAaUFWAAOaUwjA= Date: Tue, 22 Dec 2015 17:26:15 +0000 Message-ID: References: <5673796B.9020409@gmail.com> In-Reply-To: <5673796B.9020409@gmail.com> Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [122.167.158.37] x-microsoft-exchange-diagnostics: 1;SN1PR0601MB1613;5:llYiBdIEUc98FPaif9ejyVMeS66LEbv49fUWbSZcDDs9+pDtsZpQ1ZDppCqzDvBiC65Z7VBmbp41kHoLsLLsryWrklgr4M1UeTVW1x/8L6mhfstYgrBj7I8J5daLzmtb4f24F5fIquTZf587rU+3jA==;24:XufDCYbGz/1RisyNHTvV2VcHnj1rXXKGF6mJTroc6K/DWWGLMiwlpnv23ABjoIXVvE6/fRj5Nr1gwQuIZ6V/82ZsW4yIdBo1NyKjHUMe4LY=;20:XTqagyZC4+9BhLd4dWLVhQkvJ1bAaHdRfxRjGhpP9gb7ygrcsdmkd3XKW1wnqq3/7XV4TVi96RHv+xLu4kwgpw8hjz5V4XXBLWsTFT5ZlpkV+udqGCf9lz2Btnczu6Wh+BifopZYB/fxvemUe43jmMNioB0JeaXKchAhnJW1gNk= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:SN1PR0601MB1613; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(56277945015701); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(2401047)(8121501046)(520078)(5005006)(3002001)(10201501046);SRVR:SN1PR0601MB1613;BCL:0;PCL:0;RULEID:;SRVR:SN1PR0601MB1613; x-forefront-prvs: 0798146F16 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(377454003)(164054003)(199003)(189002)(24454002)(129404003)(479174004)(790700001)(92566002)(99286002)(2501003)(106356001)(5003600100002)(40100003)(86362001)(19580405001)(2900100001)(10400500002)(105586002)(2950100001)(19580395003)(19300405004)(11100500001)(87936001)(76176999)(77096005)(15975445007)(76576001)(5002640100001)(54356999)(50986999)(5004730100002)(189998001)(74316001)(5008740100001)(33656002)(122556002)(16236675004)(586003)(19617315012)(97736004)(6116002)(3846002)(1220700001)(1096002)(66066001)(5001770100001)(101416001)(5001960100002)(81156007)(102836003)(19625215002)(107886002)(42413003)(32563001);DIR:OUT;SFP:1102;SCL:1;SRVR:SN1PR0601MB1613;H:SN1PR0601MB1614.namprd06.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM MIME-Version: 1.0 X-OriginatorOrg: actian.com X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Dec 2015 17:26:15.9512 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 20057ce9-1386-4770-8b04-e7824ef632be X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1PR0601MB1613 X-MC-Unique: LUCmsiK_T2qS8UjCdfUKgg-1 Content-Type: multipart/alternative; boundary="_000_SN1PR0601MB16145EE7E3F64A5B8BB156F9F2E50SN1PR0601MB1614_" --_000_SN1PR0601MB16145EE7E3F64A5B8BB156F9F2E50SN1PR0601MB1614_ Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Hi Rick, Thanks for follow-up. I looked into the option of derby.stream.error.file. = However there is issue accessing this value of this in system procedure. My requirement is in system procedure I have implemented log4j. We want all= the logging from procedure and log level should be using derby.log. Question is 1. Is there any logger API existing in derby that can be used in syste= m procedure 2. Is there is way to log to derby.log using log4j from our system pro= cedure 3. We have not set derby.stream.error.file i.e. want the default derby= .log Then why is accessing value of derby.stream.error.file using system = property return null. 4. Also system procedure that refers log4j fail with classnotfound exc= eption. Is there is way to log4j in derby. Appreciate guidance on same. Thanks, Anjana From: Rick Hillegas [mailto:rick.hillegas@gmail.com] Sent: Friday, December 18, 2015 8:42 AM To: derby-dev@db.apache.org Cc: Anjana Prakash Subject: Re: using log4j in user defined system procedure On 12/17/15 6:39 AM, Anjana Prakash wrote: Hi , Does user defined system procedure enable logging using log4j. or using der= by.log for logging the output from system procedure. Appreciate any reference on same. Thanks Anjana Hi Anjana, Take a look at the derby.stream.error properties documented at http://db.ap= ache.org/derby/docs/10.12/ref/crefproper22250.html. Your procedure should b= e able share the diagnostic log with the engine by setting derby.stream.err= or.field or derby.stream.error.file or derby.stream.error.method. Hope this helps, -Rick --_000_SN1PR0601MB16145EE7E3F64A5B8BB156F9F2E50SN1PR0601MB1614_ Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable

Hi Rick,

 

Thanks for follow-up. = I looked into the option of derby.stream.error.file. However there is issue= accessing this value of this in system procedure.

My requirement is in s= ystem procedure I have implemented log4j. We want all the logging from proc= edure and log level should be using derby.log.

Question is

1.    &nbs= p; Is there any l= ogger API existing in derby that can be used in system procedure=

2.    &nbs= p; Is there is wa= y to log to derby.log using log4j from our system procedure

3.    &nbs= p; We have not se= t derby.stream.error.file i.e. want the default derby.log   Then = why is accessing value of derby.stream.error.file using system property ret= urn null.

4.    &nbs= p; Also system pr= ocedure that refers log4j fail with classnotfound exception. Is there is wa= y to log4j in derby.

 

Appreciate guidance on= same.

 

Thanks,

Anjana

 

 

From: Rick Hillegas [mailto:rick.hille= gas@gmail.com]
Sent: Friday, December 18, 2015 8:42 AM
To: derby-dev@db.apache.org
Cc: Anjana Prakash <anjana.prakash@actian.com>
Subject: Re: using log4j in user defined system procedure=

 

On 12/17/15 6:39 AM, Anjana Prakash wrote:

 

Hi ,

 

Does user defined system procedure enable logging us= ing log4j. or using derby.log for logging the output from system procedure.

 

Appreciate any reference on same.

 

Thanks

Anjana

Hi Anjana,

Take a look at the derby.stream.error properties documented at http://db.apache.org/derby/docs/10.12/ref/crefproper22250.html. Your pr= ocedure should be able share the diagnostic log with the engine by setting = derby.stream.error.field or derby.stream.error.file or derby.stream.error.m= ethod.

Hope this helps,
-Rick

--_000_SN1PR0601MB16145EE7E3F64A5B8BB156F9F2E50SN1PR0601MB1614_--