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 D68F91857B for ; Sun, 6 Dec 2015 19:17:37 +0000 (UTC) Received: (qmail 14278 invoked by uid 500); 6 Dec 2015 19:17:31 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 14251 invoked by uid 500); 6 Dec 2015 19:17:31 -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 14240 invoked by uid 99); 6 Dec 2015 19:17:31 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Dec 2015 19:17:31 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id CEF961A0BA1 for ; Sun, 6 Dec 2015 19:17:30 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-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-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 141PmWZkIRyw for ; Sun, 6 Dec 2015 19:17:18 +0000 (UTC) Received: from eu-smtp-delivery-106.mimecast.com (eu-smtp-delivery-106.mimecast.com [207.82.80.106]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id A43F02059B for ; Sun, 6 Dec 2015 19:17:17 +0000 (UTC) Received: from na01-by2-obe.outbound.protection.outlook.com (mail-by2lp0241.outbound.protection.outlook.com [207.46.163.241]) (Using TLS) by eu-smtp-1.mimecast.com with ESMTP id uk-mta-4-2lJ3Uzh9Ri-cqURvFgglIw-1; Sun, 06 Dec 2015 19:17:07 +0000 Received: from SN1PR0601MB1614.namprd06.prod.outlook.com (10.163.202.28) by SN1PR0601MB1615.namprd06.prod.outlook.com (10.163.202.29) with Microsoft SMTP Server (TLS) id 15.1.331.20; Sun, 6 Dec 2015 19:17:03 +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.0331.023; Sun, 6 Dec 2015 19:17:03 +0000 From: Anjana Prakash To: Rick Hillegas , "derby-dev@db.apache.org" Subject: RE: Writing user defined System procedure Thread-Topic: Writing user defined System procedure Thread-Index: AdEvBb25hTU37hlNRC2ZRVSj/4DS+QAbiOwAADmEdUA= Date: Sun, 6 Dec 2015 19:17:03 +0000 Message-ID: References: <56630674.8070403@gmail.com> In-Reply-To: <56630674.8070403@gmail.com> Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [122.171.199.209] x-microsoft-exchange-diagnostics: 1;SN1PR0601MB1615;5:V1/rhe8vF8NTXmOgS4zXsT9y05Zb+V0E6KBgzRHvnim4J4AcM5d464Z7Z9DUSbBh2Jn5OcoiqEVIOjYeZjqORzOm9RLo0lVT1Ky/B/R+dB/x6DloM8HO+x2zR2IGGKn7OcBI4p6FzzC2HxtzykPngQ==;24:uMmmXee4qcXaCgWuMl5CC6jfVW2jPe/K1+8U+Ho84B9YofZN7m/SvyN/BZpGffvpB8DTbBLuRZhVgOzrWCA+KN1sZbjh2/NKz4yEQFU6CJ8=;20:6XL4FpXA9zCbqeF7UvUPRPiHp0gvNPDU8p5JvN13V7YPS0Qtq5m+X0KOiUx+TSRObEG+ghXm4SEUXctujUp7fr2Pr1P1hqAjfXScrRy696Zq2+NjKZem1aPP4dHEMstzJyQ+48YUNUn5YudMIssqroRiMmFNog8cEwrr174iTQI= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:SN1PR0601MB1615; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(56277945015701); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(2401047)(5005006)(520078)(8121501046)(3002001)(10201501046);SRVR:SN1PR0601MB1615;BCL:0;PCL:0;RULEID:;SRVR:SN1PR0601MB1615; x-forefront-prvs: 0782EC617F x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(189002)(199003)(129404003)(24454002)(164054003)(377454003)(479174004)(122556002)(10400500002)(19300405004)(586003)(92566002)(11100500001)(2501003)(1096002)(1220700001)(102836003)(790700001)(74316001)(76176999)(19617315012)(54356999)(5004730100002)(19625215002)(107886002)(101416001)(5001960100002)(81156007)(105586002)(99286002)(33656002)(87936001)(97736004)(5001770100001)(16236675004)(189998001)(5008740100001)(40100003)(6116002)(3846002)(86362001)(5002640100001)(19580405001)(2950100001)(19580395003)(2900100001)(50986999)(15975445007)(77096005)(5003600100002)(76576001)(106356001)(66066001);DIR:OUT;SFP:1102;SCL:1;SRVR:SN1PR0601MB1615;H:SN1PR0601MB1614.namprd06.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM MIME-Version: 1.0 X-OriginatorOrg: actian.com X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Dec 2015 19:17:03.5429 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 20057ce9-1386-4770-8b04-e7824ef632be X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1PR0601MB1615 X-MC-Unique: 2lJ3Uzh9Ri-cqURvFgglIw-1 Content-Type: multipart/alternative; boundary="_000_SN1PR0601MB1614BF73EE8CF601B9300C16F20A0SN1PR0601MB1614_" --_000_SN1PR0601MB1614BF73EE8CF601B9300C16F20A0SN1PR0601MB1614_ Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Hi Rick, Thanks for follow up. I am able to create the system procedure following th= e based on below links. Quick question My system procedure is accessing some of the derby utility function. At ru= n time of the procedure (in ij) it fails with exception ERROR XJ001: Java exception: 'org/apache/derby/impl/load/Import: java.lang.= NoClassDefFoundError'. In my stored procedure jar the manifest file has class-path reference as de= rby.jar. However still it fails. I start the ij tool as java -Dderby.system.home=3DD:\derby\data -jar %DERBY_INSTALL%\lib\derbyrun.= jar ij Appreciate help on same. Thanks, Anjana. From: Rick Hillegas [mailto:rick.hillegas@gmail.com] Sent: Saturday, December 05, 2015 9:15 PM To: derby-dev@db.apache.org Cc: Anjana Prakash Subject: Re: Writing user defined System procedure On 12/4/15 6:38 PM, Anjana Prakash wrote: Hi, Is it possible to write user define System Procedure . I know user define f= unction are possible however we are looking for calling our procedure in sa= me way as Existing system procedure. Any doc or any other reference would be useful. Thanks, Anjana A Derby user-defined procedure is just a public static void Java method. Th= e syntax for declaring a user-defined procedure may be found here: http://d= b.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html More in= formation on writing, calling, and deploying user-defined procedures may be= found here: http://db.apache.org/derby/docs/10.12/devguide/cdevspecial.htm= l Hope this helps, -Rick --_000_SN1PR0601MB1614BF73EE8CF601B9300C16F20A0SN1PR0601MB1614_ Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable

Hi Rick,

 

Thanks for follow up. = I am able to create the system procedure following the based on below links= . Quick question

 

My system procedure is= accessing some of  the derby utility function. At run time of the pro= cedure (in ij) it fails with exception

ERROR XJ001: Java exce= ption: 'org/apache/derby/impl/load/Import: java.lang.NoClassDefFoundError'.=

 

In my stored procedure= jar the manifest file has class-path reference as derby.jar.

However still it fails= .

I start the ij tool as=

java -Dderby.system.ho= me=3DD:\derby\data -jar %DERBY_INSTALL%\lib\derbyrun.jar ij

 

Appreciate help on sam= e.

 

 

Thanks,

Anjana.

 

From: Rick Hillegas [mailto:rick.hille= gas@gmail.com]
Sent: Saturday, December 05, 2015 9:15 PM
To: derby-dev@db.apache.org
Cc: Anjana Prakash <anjana.prakash@actian.com>
Subject: Re: Writing user defined System procedure=

 

On 12/4/15 6:38 PM, Anjana Prakash wrote:

 

Hi,

 

Is it possible to write user define System Procedure= . I know user define function are possible however we are looking for call= ing our procedure in same way as

Existing system procedure.

 

Any doc or any other reference would be useful.

 

Thanks,

Anjana

A Derby user-defined = procedure is just a public static void Java method. The syntax for declarin= g a user-defined procedure may be found here: http://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html= More information on writing, calling, and deploying user-defined proce= dures may be found here: http://db.apache.org/derby/docs/10.12/devguide/cdevspecial.html

Hope this helps,
-Rick

--_000_SN1PR0601MB1614BF73EE8CF601B9300C16F20A0SN1PR0601MB1614_--