agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Deployment Descriptor Problem
Date: Fri, 6 Oct 2006 15:48:04 -0400
Message-ID: <341b9b540610061248x222a42cg82fe7c15db14cb1b@mail.gmail.com> (raw)
In-Reply-To: <341b9b540610061244h263a4476rd192479c475645ad@mail.gmail.com>
References: <341b9b540610061244h263a4476rd192479c475645ad@mail.gmail.com>
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;
view thread (9+ messages) latest in thread
Message-ID: <341b9b540610061248x222a42cg82fe7c15db14cb1b@mail.gmail.com>
Permalink: ../341b9b540610061248x222a42cg82fe7c15db14cb1b@mail.gmail.com/
Also on: postgresql.org/message-id/341b9b540610061248x222a42cg82fe7c15db14cb1b@mail.gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Deployment Descriptor Problem
In-Reply-To: <341b9b540610061248x222a42cg82fe7c15db14cb1b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox