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>
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 |