[Pljava-dev] Deployment Descriptor Problem

From: joshualross at gmail(dot)com (Joshua Ross)
To:
Subject: [Pljava-dev] Deployment Descriptor Problem
Date: 2006-10-06 19:48:04
Message-ID: 341b9b540610061248x222a42cg82fe7c15db14cb1b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20061006/b3dce190/attachment.html>

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2006-10-09 06:36:24 [Pljava-dev] Savepoints and PL/Java
Previous Message Thomas Hallgren 2006-10-06 05:11:57 [Pljava-dev] Savepoints and PL/Java