[Pljava-dev] Unable to find static method.

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20121127/9cf29ae2/attachment.html>

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>