db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anjana Prakash <anjana.prak...@actian.com>
Subject RE: Writing user defined System procedure
Date Tue, 08 Dec 2015 05:54:33 GMT
Hi Rick, 

Thanks for follow-up. Please let me know the process of raising an enhancement request. 


-----Original Message-----
From: Rick Hillegas [mailto:rick.hillegas@gmail.com] 
Sent: Monday, December 07, 2015 8:39 PM
To: derby-dev@db.apache.org
Cc: Anjana Prakash <anjana.prakash@actian.com>
Subject: Re: Writing user defined System procedure

Hi Anjana,

For the moment, your best workaround would be to clone the derby code and put the cloned code
into packages outside the org.apache.derby namespace. For security reasons, user code may
not call Derby code when running inside the Derby engine.

Exceptions are allowed for code which is in the
org.apache.derby.optional.* and org.apache.derby.vti packages of Derby's public api: 
http://db.apache.org/derby/docs/10.12/publishedapi/index.html. This policy is enforced by

The DERBY-PROPERTIES error you are seeing is related to a special bulk-import optimization.
That optimization can't be invoked from user code either. So you may need to adjust your cloned

You are welcome to log an enhancement request for moving the code you need into the public

Hope this helps,

On 12/6/15 11:25 PM, Anjana Prakash wrote:
> More analysis indicates that
> In scenario where a user defined system procedure calls derby class 
> org/apache/derby/imp l/load/Import. It fails with Class Not found 
> exception Because the Jarloader.java restricts only certain package to 
> be accessible and raises class not found exception for package 
> org/apache/derby/imp l *
> I tried another alternative where in system procedure are not registered using  install_jar
instead define as classpath.
> However this fails with exception " ERROR 42X01: Syntax error: DERBY-PROPERTIES"
> Need ability where in user defined function can call derby class and reuse the existing
> Thanks,
> Anjana.
> -----Original Message-----
> From: Anjana Prakash
> Sent: Monday, December 07, 2015 9:23 AM
> To: derby-dev@db.apache.org
> Subject: RE: Writing user defined System procedure
> Hi,
> I verified the version of derby.jar that is used to compiled the 
> stored procedure and used at runtime by ij they both refer the same 
> lib folder. Below is the error I am getting
> ERROR 38000: The exception 'java.lang.NoClassDefFoundError: org/apache/derby/imp l/load/Import'
was thrown while evaluating an expression.
> ERROR XJ001: Java exception: 'org/apache/derby/impl/load/Import: java.lang.NoCla ssDefFoundError'.
> ERROR XJ001: Java exception: 'org.apache.derby.impl.load.Import: java.lang.Class NotFoundException'.
> Thanks
> Anjana.
> -----Original Message-----
> From: Bryan Pendleton [mailto:bpendleton.derby@gmail.com]
> Sent: Monday, December 07, 2015 7:34 AM
> To: derby-dev@db.apache.org
> Subject: Re: Writing user defined System procedure
>> 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

View raw message