[Pljava-dev] Deployment Descriptor Problem

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>