Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Subject: Re: Writing user defined System procedure
To: derby-dev@db.apache.org
References: 
 <SN1PR0601MB161403A43F6DC464208B3F9CF20B0@SN1PR0601MB1614.namprd06.prod.outlook.com>
 <56630674.8070403@gmail.com>
 <SN1PR0601MB1614BF73EE8CF601B9300C16F20A0@SN1PR0601MB1614.namprd06.prod.outlook.com>
From: Bryan Pendleton <bpendleton.derby@gmail.com>
Message-ID: <5664E92B.8020109@gmail.com>
Date: Sun, 6 Dec 2015 18:04:27 -0800
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
In-Reply-To: 
 <SN1PR0601MB1614BF73EE8CF601B9300C16F20A0@SN1PR0601MB1614.namprd06.prod.outlook.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit

> My system procedure is accessing some of  the derby utility function. At run 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 derby.jar.

Can you post the full stack trace?

NoClassDefFoundError is a fairly unusual failure. In my experience,
it generally has to do with CLASSPATH issues, and specifically with
cases where there is a subtle difference between the classes that
you compiled against, and the classes that you are running with.

For example, maybe you compiled your system procedure against a0
new version of Derby, but somehow when you are running you
are running with an older version of derby.jar.

bryan