[Pljava-dev] I: ERROR: Unable to find static method

From: stefano(dot)bianchi at iskranet(dot)net (stefano bianchi)
To:
Subject: [Pljava-dev] I: ERROR: Unable to find static method
Date: 2007-02-25 17:39:00
Message-ID: 000401c75903$d5d1f830$0fc7a8c0@thinkstefano
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Hi,

I'm try to load a class on db, but something go wrong.

net.gesttec.gbedidi.storedP.yate.ldapGetSeatInfo.searchSeatPass with
signature (Ljava/lang/String;)Ljava/lang/String;

My class :

package net.gesttec.gbedidi.storedP.yate; public class ldapGetSeatInfo {

public static java.lang.String searchSeatPass(
java.lang.String seatId
) throws SQLException {
String gkPassS = "-";
<..snip>
return gkPassS;
}

...

Etc

I loat it

SELECT * from sqlj.install_jar('file:///temp/SPyate.jar', 'SPYATE_jar',
false); SELECT sqlj.set_classpath('public','SPYATE_jar');

CREATE OR REPLACE FUNCTION user_check(character varying)
RETURNS character varying AS
'net.gesttec.gbedidi.storedP.yate.ldapGetSeatInfo.searchSeatPass(java.lang.S
tring)'
LANGUAGE 'javaU' VOLATILE;

Butr when i call the function

select * from user_check('alllsoi'),
I got
ERROR: Unable to find static method
net.gesttec.gbedidi.storedP.yate.ldapGetSeatInfo.searchSeatPass with
signature (Ljava/lang/String;)Ljava/lang/String;
Stato SQL: XX000

Under winXP

Please note, in the same jar, a different class work fine.

PS
Since in this week eclipse IDE was update, now the pljava souce fail in
compile, I don't know if are you inform about.

By & thanks in advace

Stefano Bianchi

Browse pljava-dev by date

  From Date Subject
Next Message Eugen Ermantraut 2007-02-27 16:17:35 [Pljava-dev] PL/JAVA Installation
Previous Message Nick Snellock 2007-02-20 19:57:51 [Pljava-dev] pljava and openjms