Hi

I need to create a function in java, that will run in oracle database
as database function. So I've downloaded barbecue - GPL java library
that allow me to create barcodes. I'm new at java so maybe my error is
trivial, maybe not - I can't find it neither in oracle docs nor in
java ones...

Now that's the problem:

I've loaded barbecue.jar to database using "loadjava" utility.
Creation of java function went well:

create or replace and compile java source named
hsljavabarcodegenerator as
import javax.swing.*;
import net.sourceforge.barbecue.BarcodeFactory;
import net.sourceforge.barbecue.Barcode;
import net.sourceforge.barbecue.BarcodeException;
import net.sourceforge.barbecue.BarcodeImageHandler;

import java.awt.image.BufferedImage;
import java.awt.*;
import java.io.FileOutputStream;
import java.io.IOException;

import oracle.sql.*;

public class HSLJavaBarcodeGenerator
{
 public static oracle.sql.BLOB CreateBarcode(String barText, int
barWidth, int barHeight) throws java.sql.SQLException,
java.io.IOException, java.lang.NullPointerException,
net.sourceforge.barbecue.BarcodeException
...
barcode = BarcodeFactory.createCode128B(barText);
...
return result;
}}

And it compiles well, no errors, no warnings. Next I have created
PL/SQL definition:

create or replace function CreateBarcode(barcode in varchar2, width in
number, height in number) return blob
as language java name
'HSLJavaBarcodeGenerator.CreateBarcode(java.lang.String, int, int)
return oracle.sql.BLOB';

And it also works well. No errors, no warnings.

Now when I try to use it, I've got error:

select createbarcode('aaa',1,1) from dual
                                    *
BŁĄD w linii 1:
ORA-29532: wywołanie Javy zatrzymane przez nieprzechwycony
wyjątek Javy:
java.lang.NoClassDefFoundError
(it means that execution of java is stopped by unhandled java
exception).

Help... if anyone knows what to do. Some user rights? Paths? Anything?
There are no warnings or errors during compilation, so why there's an
"NoClassDefFoundError" error during execution?

Thanks in advance,
Daniel Janczak
nospam.daniel.janczak@wp.pl