From: | Jon(dot)Roberts at asurion(dot)com (Roberts, Jon) |
---|---|
To: | |
Subject: | [Pljava-dev] Function Error |
Date: | 2010-03-24 16:01:30 |
Message-ID: | 8661B041D452404E8088FBD47D2443BE2532EF@NDCEXCUS703.int.asurion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
I believe the problem is the classpath. You are putting the jar in the
public schema but your function is in the sim schema. Try this:
select sqlj.remove_jar('sim', true);
select * from
sqlj.install_jar('file:///D:/workspace/SimplePrediction/sim.jar','sim_ja
r',true);
select sqlj.set_classpath('sim', 'sim_jar');
CREATE OR REPLACE FUNCTION sim.chi2cdf(double precision)
RETURNS double precision
AS 'simpleMonteCarlo.sim.chi2cdf'
LANGUAGE java;
If that isn't it, try changing the Java method to return a
java.lang.String and then have your PostgreSQL function return a
character varying. That will eliminate the possibility of a signature
problem.
Jon
-----Original Message-----
From: pljava-dev-bounces at pgfoundry.org
[mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of Susan M Farley
Sent: Wednesday, March 24, 2010 10:34 AM
To: pljava-dev at pgfoundry.org
Subject: [Pljava-dev] Function Error
I'm trying to import a function in Java, but am having problems with it.
The java function is
public static double chi2cdf (double x)
{
return chi.cdf(x);
}
I copied the sim.class file to the Postgres data directory and I added
it to Postgres with the following
select
sqlj.replace_jar('file:///D:/workspace/SimplePrediction/sim.jar','sim',t
rue);
SELECT sqlj.set_classpath('public', 'sim');
CREATE OR REPLACE FUNCTION sim.chi2cdf(double precision)
RETURNS double precision
AS 'simpleMonteCarlo.sim.chi2cdf'
LANGUAGE java;
When I try to run it, I get the following error:
ERROR: Unable to find static method simpleMonteCarlo.sim.chi2cdf with
signature (D)D
I thought it was the signature of double precision, but then tried it
with two other functions, one a float and one a int and get similar
errors. Does anyone have any ideas?
Thank you,
Susan
--
Sent via pgsql-novice mailing list (pgsql-novice at postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Clarke | 2010-03-24 16:07:41 | [Pljava-dev] Function Error |
Previous Message | Susan M Farley | 2010-03-24 15:34:28 | [Pljava-dev] Function Error |