db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hk <hyunkich...@yahoo.com>
Subject Re: can't call a stored procedure
Date Mon, 21 May 2007 07:30:00 GMT

My sample program is the one from the
http://wiki.apache.org/db-derby/DerbySQLroutines. Additionally, I tried to
create and install a jar file to a database.

By the way, what is the correct format of external name in "create
procedure"? does the external name include class and method only, or need a
jar file name also?

And, I wonder if there is a necessary setting, such classpath, indicating
the location of the jar file or the class. Because I'm working on the

Jean T. Anderson-3 wrote:
> hk wrote:
>> I tried to call a sampe stored procedure, but I got an error message
>> saying 
>> " Error code -1, SQL state 42X51: The class 'routines_jar:store' does not
>> exist or is inaccessible. This can happen if the class is not public.
>> SQLSTATE: XJ001: Java exception: 'routines_jar:store:
>> java.lang.ClassNotFoundException'.
>> Line 3, column 1."
>> I had made a public class and a public static method, which is called
>> "store" and "dropTable" respectively, 
>> made a jar file, which is called "Javalibrary1.jar",
>> and installed the jar file with the sqlj.install_jar using a jar name
>> "routines_jar" into a database.
>> And, then I had createad a  stored procedure with external name
>> "routines_jar:store.dropTable", which is called "DROP_TABLE",
>> and called the stored procedure Drop_TABLE with a parameter.
>> Then, I got an error message above, which basically is saying "The class
>> 'routines_jar:store' does not exist or is inaccessible." I was trying to
>> figure out the problem, but stiil I coudn't.
>> What would be the problem? help me, please.
> This page on the wiki points to some working examples:
>    http://wiki.apache.org/db-derby/DerbySQLroutines
> I wonder if one of them in particular might help -- it's a pointer to a
> post that shows how to drop table in a procedure [1].
> If not, I suggest you post your java code, if that's possible (but don't
> post anything proprietary), and the SQL statements you use to create the
> procedure and install the jar file in the database.
> regards,
>  -jean
> [1]
> http://mail-archives.apache.org/mod_mbox/db-derby-user/200510.mbox/%3C43415F06.3040601@sun.com%3E

View this message in context: http://www.nabble.com/can%27t-call-a-stored-procedure-tf3783664.html#a10714299
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message