db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeffrey Lichtman <swa...@rcn.com>
Subject Re: Stored function problems
Date Thu, 23 Sep 2004 01:40:24 GMT

>I'm trying to create a stored function in Derby and call it from either ij 
>or Java.  The class I created is:
>package oi;
>import java.sql.*;
>public class Derby

. . .

>ij> create function earthlings.build_email (firstname varchar(20), 
>lastname varchar(30))
>returns varchar(8)
>language java
>external name 'oi.derby.buildEmail'

. . .

>ij> values earthlings.build_email('John', 'Smith');
>ERROR 42X51: The class 'oi.derby' does not exist or is inaccessible. This 
>can ha
>ppen if the class is not public. (errorCode = 30000)

. . .

>What have I misunderstood or missed?

I notice that "Derby" is capitalized in the class definition but not in the 
"create function" statement. That's probably the source of the problem.

                        -        Jeff Lichtman
                                 Check out Swazoo Koolak's Web Jukebox at

View raw message