[Pljava-dev] Deployment Descriptor Problem

[Joshua Ross]

Hi,
    I cannot get install_jar() to read/execute by Deployment Descriptor.  I
have tried many different ways to get this to work and all have failed.  I
am using:
PL/Java 1.3.0
PostGreSQL 8.1.0.
Java 1.5.07

My jar contains the following files:
---------------------------------------------------------------------------
> jar -tvf VinDecoder.jar
     0 Fri Oct 06 15:27:56 EDT 2006 META-INF/
   137 Fri Oct 06 15:27:58 EDT 2006 META-INF/MANIFEST.MF
     0 Fri Oct 06 15:27:34 EDT 2006 com/
     0 Fri Oct 06 15:27:34 EDT 2006 com/sg/
     0 Fri Oct 06 15:27:36 EDT 2006 com/sg/vin/
   536 Fri Oct 06 15:27:36 EDT 2006 com/sg/vin/VinDecoderTest.java
   448 Fri Oct 06 15:27:36 EDT 2006 com/sg/vin/VinDecoderException.class
  1160 Fri Oct 06 15:27:36 EDT 2006 com/sg/vin/VinDecoder.class
   374 Fri Oct 06 15:27:36 EDT 2006 com/sg/vin/VinDecoderException.java
   828 Fri Oct 06 15:27:36 EDT 2006 com/sg/vin/VinDecoder.java
  1078 Fri Oct 06 15:27:36 EDT 2006 com/sg/vin/VinDecoderTest.class
     0 Fri Oct 06 15:27:36 EDT 2006 deployment/
   268 Fri Oct 06 15:27:36 EDT 2006 deployment/VinDecoder.ddr


My manifest looks like this:
---------------------------------------------------------------------------
Name: deployment/VinDecoder.ddr
SQLJDeploymentDescriptor: TRUE

My VinDecoder.ddr file contains:
---------------------------------------------------------------------------
SQLActions[] = {
  "BEGIN INSTALL
    CREATE FUNCTION getVinInfo(VARCHAR)
      RETURNS VARCHAR
      AS 'com.sg.vin.VinDecoder.getVinInfo(java.lang.String)'
      LANGUAGE java;
  END INSTALL",
  "BEGIN REMOVE
    DROP FUNCTION getVinInfo();
  END REMOVE"
}


When I install using the following command:
---------------------------------------------------------------------------
select sqlj.install_jar('file:/my/dir/VinDecoder.jar', 'VinDecoder', true);

The result is:
---------------------------------------------------------------------------
-- Executing query:
select sqlj.install_jar('file:/home/jross/VinDecoder.jar', 'VinDecoder',
true);

Total query runtime: 32 ms.
1 rows retrieved.


I see no errors in the postgres log file.  Please help!!  I have no idea why
this will not read/use my Deployment Descriptor.
Thanks!
-Joshua-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pljava-dev/attachments/20061006/b3dce190/attachment.html