From: joshualross at gmail.com (Joshua Ross) Date: Fri, 6 Oct 2006 15:48:04 -0400 Subject: [Pljava-dev] Deployment Descriptor Problem In-Reply-To: <341b9b540610061244h263a4476rd192479c475645ad@mail.gmail.com> References: <341b9b540610061244h263a4476rd192479c475645ad@mail.gmail.com> Message-ID: <341b9b540610061248x222a42cg82fe7c15db14cb1b@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: