From: JDW at Fodoze.com (John D. West)
Date: Wed, 4 Aug 2010 13:20:37 -0700
Subject: [Pljava-dev] problem implementing with ResultSetProvider
In-Reply-To: <AANLkTi=FgMGHQ9ww7ePuye6kE63_2ovYABT3RsAM0KGB@mail.gmail.com>
References: <AANLkTim79vppDSncs9Rju0DKSue_wygqRg+MZiE=qHRP@mail.gmail.com>
	<201008040859.17264.fluca1978@infinito.it>
	<AANLkTi=FgMGHQ9ww7ePuye6kE63_2ovYABT3RsAM0KGB@mail.gmail.com>
Message-ID: <AANLkTik0VFeNXGS_vg-vdToQc=4kxy13YOexGK0BoBib@mail.gmail.com>

This seems to have been caused by my not installing into the database
(using sqlj.install_jar()) the external jar files this function
depends on.  It mostly works now.

thanks!

? ?? -- John



On Wed, Aug 4, 2010 at 9:32 AM, John D. West <JDW at fodoze.com> wrote:
> I set the logging levels to Debug5, and this is what I got when trying
> to run the function:
> 2010-08-04 09:22:04 PDT DEBUG: ?00000: 04 Aug 10 09:22:04
> org.postgresql.pljava.internal.Backend Using SecurityManager for
> trusted language
> 2010-08-04 09:22:04 PDT LOCATION:
> Java_org_postgresql_pljava_internal_Backend__1log,
> /usr/share/pljava/src/C/pljava/Backend.c:890
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
> 2010-08-04 09:22:04 PDT DEBUG: ?00000: className = 'emTauP',
> methodName = 'TTimes', parameters =
> 'java.lang.String,java.lang.String,double,double', returnType = 'null'
> 2010-08-04 09:22:04 PDT LOCATION: ?parseFunction,
> /usr/share/pljava/src/C/pljava/Function.c:400
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
> 2010-08-04 09:22:04 PDT DEBUG: ?00000: 04 Aug 10 09:22:04
> org.postgresql.pljava.sqlj.Loader Creating typeMappings for schema
> public
> 2010-08-04 09:22:04 PDT LOCATION:
> Java_org_postgresql_pljava_internal_Backend__1log,
> /usr/share/pljava/src/C/pljava/Backend.c:890
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
> 2010-08-04 09:22:04 PDT DEBUG: ?00000: Loading class emTauP
> 2010-08-04 09:22:04 PDT LOCATION: ?Function_init,
> /usr/share/pljava/src/C/pljava/Function.c:539
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
> 2010-08-04 09:22:04 PDT DEBUG: ?00000: Obtaining method emTauP.TTimes
> (Ljava/lang/String;Ljava/lang/String;DD)Lorg/postgresql/pljava/ResultSetProvider;
> 2010-08-04 09:22:04 PDT LOCATION: ?Function_init,
> /usr/share/pljava/src/C/pljava/Function.c:569
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
> 2010-08-04 09:22:04 PDT DEBUG: ?00000: Method emTauP.TTimes
> (Ljava/lang/String;Ljava/lang/String;DD)Lorg/postgresql/pljava/ResultSetProvider;
> not found
> 2010-08-04 09:22:04 PDT LOCATION: ?Function_init,
> /usr/share/pljava/src/C/pljava/Function.c:578
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
> 2010-08-04 09:22:04 PDT DEBUG: ?00000: Obtaining method emTauP.TTimes
> (Ljava/lang/String;Ljava/lang/String;DD)Lorg/postgresql/pljava/ResultSetHandle;
> 2010-08-04 09:22:04 PDT LOCATION: ?Function_init,
> /usr/share/pljava/src/C/pljava/Function.c:608
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
> 2010-08-04 09:22:04 PDT ERROR: ?XX000: Unable to find static method
> emTauP.TTimes with signature
> (Ljava/lang/String;Ljava/lang/String;DD)Lorg/postgresql/pljava/ResultSetProvider;
> 2010-08-04 09:22:04 PDT LOCATION: ?PgObject_throwMemberError,
> /usr/share/pljava/src/C/pljava/PgObject.c:101
> 2010-08-04 09:22:04 PDT STATEMENT: ?select * from em_ttimes('PREM',
> 'SKS', 50, 99);
>
> Does that cast light on anything?
>
> Thanks!
>
> ? ? -- John
>
> On Wed, Aug 4, 2010 at 12:59 AM, Luca Ferrari <fluca1978 at infinito.it> wrote:
>> On Wednesday, August 04, 2010 04:05:05 am John D. West's cat walking on the
>> keyboard wrote:
>>
>>> Then when I run it, I get the following error:
>>> ERROR: Unable to find static method emTauP.TTimes with signature
>>> (Ljava/lang/String;Ljava/lang/String;DD)Lorg/postgresql/pljava/ResultSetPro
>>> vider;
>>>
>>> I can create and run functions which do not implement
>>> ResultSetProvider, no problem. ?Can anyone see something I'm doing
>>> wrong, or is this a bug?
>>>
>>
>> I have recreated it on my system and I can invoke the function. It should not
>> be a classpath problem, since that will lead to a class not found exception.
>> Could you post the log to see if there is an hint?
>>
>> Luca
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>>
>