From: JDW at Fodoze.com (John D. West) Date: Wed, 4 Aug 2010 10:32:56 -0600 Subject: [Pljava-dev] problem implementing with ResultSetProvider In-Reply-To: <201008040859.17264.fluca1978@infinito.it> References: <201008040859.17264.fluca1978@infinito.it> Message-ID: 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 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 >