From: joshualross at gmail.com (Joshua Ross)
Date: Mon, 16 Oct 2006 15:00:35 -0400
Subject: [Pljava-dev] Deployment Descriptor Problem
In-Reply-To: <4531F39F.7080900@logix-tt.com>
References: <341b9b540610061244h263a4476rd192479c475645ad@mail.gmail.com>
	<341b9b540610061248x222a42cg82fe7c15db14cb1b@mail.gmail.com>
	<4529EE42.2090207@logix-tt.com> <4529EFCC.3020309@logix-tt.com>
	<341b9b540610090818w1046f69ct664ca03d8c85dbab@mail.gmail.com>
	<452B56A1.7020102@tada.se> <4531F39F.7080900@logix-tt.com>
Message-ID: <341b9b540610161200p575192f5o7d5e5f143d11bcbc@mail.gmail.com>

Ok, not ommitting the empty line corrected the manifest "reorganization"
that I was seeing when creating the jar.  My manifest before jar creation:
> cat mainClass
-------------------------------------------------------------------------------------------
Manifest-Version: 1.0

Name: deployment/VinDecoder.ddr
SQLJDeploymentDescriptor: TRUE


And inside the jar it is:
-------------------------------------------------------------------------------------------
> jar xvf VinDecoder.jar META-INF/MANIFEST.MF
 inflated: META-INF/MANIFEST.MF
> cat META-INF/MANIFEST.MF
Manifest-Version: 1.0
Created-By: 1.5.0_07 (Sun Microsystems Inc.)

Name: deployment/VinDecoder.ddr
SQLJDeploymentDescriptor: TRUE



However, my deployment descriptor still was not read/executed during
install.  My deployment descriptor is:
> cat deployment/VinDecoder.ddr
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(VARCHAR);
  END REMOVE"
}



I am expecting to see something about it in the console when I install the
jar but I don't.  The results of the installation are shown below:

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

Total query runtime: 297 ms.
1 rows retrieved.


After adding the classpath if I try to execute the function it does not
exist and I get this error message.

ERROR: function getvininfo(character varying) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You may need to
add explicit type casts.


I think I have everything correct per our previous emails so I am still
confused why this deployment descriptor will not work.  Do I need to use a
different jar creator?

Thanks!
-Joshua-

On 10/15/06, Markus Schaber <schabi at logix-tt.com> wrote:
>
> Hi, Joshua,
>
> Thomas Hallgren wrote:
>
> > The order of your entries is wrong. The 'Name' entry must come before
> the entries that
> > applies to that named entry (in this case the SQLJDeploymentDescriptor).
> The MANIFEST.MF
> > suggested by Markus is correct:
> >
> >>      > ----
> >>      > Manifest-Version: 1.0
> >>      >
> >>      > Name: deployment/examples.ddr
> >>      > SQLJDeploymentDescriptor: TRUE
> >>      > ----
>
> Also, don't omit the empty line, which divides Header and Body.
> HTH,
> Markus
> --
> Markus Schaber | Logical Tracking&Tracing International AG
> Dipl. Inf.     | Software Development GIS
>
> Fight against software patents in Europe! www.ffii.org
> www.nosoftwarepatents.org
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20061016/38994b88/attachment.html>