From: thomas at tada.se (Thomas Hallgren)
Date: Mon, 03 Dec 2012 09:21:08 +0100
Subject: [Pljava-dev] Unable to find static method.
In-Reply-To: 
 <5E7E4A8EDF91DC4D8EE408A8A243778A18A2E9B607@DFW1MBX23.mex07a.mlsrvr.com>
References: 
 <5E7E4A8EDF91DC4D8EE408A8A243778A18A2E9B607@DFW1MBX23.mex07a.mlsrvr.com>
Message-ID: <50BC60F4.5050701@tada.se>

When you say "jar files are in the right place", do you then mean that 
you have loaded them into the database with the 'install_jar' command? 
Did you set the classpath using 'set_classpath' command?

http://wiki.tada.se/index.php?title=SQLJ_functions

- thomas

On 2012-11-28 03:02, Brian Yan wrote:
> Hi,
>
> I am running into a very basic error that  I can not seem the find the solution for. I have gotten this to work before but somehow it no longer does. Jar files are in the right place with the class path defined.
>
> Below is the function definition, class and the error it throws:
> Function Def:
>
> CREATE OR REPLACE FUNCTION pxexists()
>    RETURNS boolean AS
> 'px.StoredProcedures.PredictionProviderExists'
>    LANGUAGE java;
>
> Class:
>
> package px;
>
> public class StoredProcedures {
>
>         public static boolean PredictionProviderExists()
>         {
>                return true;
>         }
> }
>
> Query:
> select pxexists();
> Unable to find static method px.StoredProcedures.PredictionProviderExists with signature ()Z (PgObject.c:101)
>
> Does anyone have any suggestions?
>
> Thank you for your help!
> Brian
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20121203/fcdbe68c/attachment.html>