agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] Unable to find static method.
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] Unable to find static method.
@ 2012-11-28 02:02  
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2012-11-28 02:02 UTC (permalink / raw)

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;



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] Unable to find static method.
@ 2012-12-03 08:21  
  parent: 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2012-12-03 08:21 UTC (permalink / raw)

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;



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2012-12-03 08:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-11-28 02:02 [Pljava-dev] Unable to find static method. 
2012-12-03 08:21 ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox